I have installed SQL Server 2000 standard version on a Win 2000 server. I have installed SP2. The SQL Server starts under a windows account 'databaseadmin'. This is included in the administrator group. The sql server was installed when I was logged in to the machine as 'databaseadmin'.
I stopped sql server and shut down the machine. Then I logged in as the domain administrator. I logged out and logged back in as 'databaseadmin'.
I tried to start sql server but got an error : Cannot start because login failed. I cannot even look at the properties for the database.
If I rebuild the registry and then try to start the server, it comes up.
Can anyone give me any ideas as to why this could be happening?