October 26, 2005 at 2:37 pm
I had to change my Windows username this morning, and after that I could no longer connect to my sql server database using integrated windows authentication. How do I keep these guys in sync, or update sql server to use the correct password?
October 26, 2005 at 6:18 pm
Did you change your username or password? I am assuming you changed your domain logins password. Do you have a local account created on the host where MS SQL Server resides? If so, you must also change this password to match your domain password. Windows will cache your credentials and fail when using your domain password to authenticate to the local host.
October 27, 2005 at 10:41 am
Since you changed your Windows username, my guess is that you have to go in and add your nre Windows username to the SQL Server (and probably remove your old Windows username - gotta be neat about these things).
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
October 31, 2005 at 3:34 pm
Hi, I wound up going into the MSSQLServer service, and updating my password there. Then it worked.
October 31, 2005 at 3:52 pm
Did you use SQL Server Enterprise Manager or Services to change the password ?
If you used Services, then be aware that the installation of Service Pack 4 will fail.
You MUST use SQL Server Enterprise Manager to change the password of any and all SQL Server service.
SQL = Scarcely Qualifies as a Language
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply