SQL Server and Local Account Login
I have a server with SQL Server 2000 installed on it that was installed under a local account. On installation I chose to use integrated security with my Windows account. I now need to change the password for that local account, however when I do the SQL server will not start up on boot. When I try to connect to the database to start it I get an error 1069 (logon failure) followed by "A connection could not be established to (LOCAL). Reason: SQL Server does not exist or access denied."
I thought that by right-clicking the server and going to "Edit SQL Server Registration Properties" and changing from window authentication to SQL server authentication this problem could be overcome, but apparently I'm looking in the wrong place as that does not solve the problem. What do I need to do here so that I can change the local account's password and be able to start SQL Server. Any help here is appreciated, thank you!
