Changed Windows Password, SSMS login problems
Question
Wednesday, September 11, 2019 12:31 PM
SSMS 2012
Problem: I changed my windows password today, now I am trying to login to SSMS with Windows Authentication. It gives me error message: Cannot Connect to the xxxxx server. Additional Information: The target name is incorrect. Cannot generate SSPI context (Microsoft Sql Server).
How do I enter my new windows password into SSMS login window?
Thanks for your help.
All replies (7)
Wednesday, September 11, 2019 12:39 PM
Windows auth to SQL Server don't require a Password in SSMS.
After changing Windows password, have you Log-out and re-login on the Windows machine, so that you get a new Windows auth token?
Olaf Helper
Wednesday, September 11, 2019 1:59 PM
Yes, I did.
Thanks.
Wednesday, September 11, 2019 2:04 PM
The error "The target name is incorrect." is not related to your password change.
Wednesday, September 11, 2019 2:06 PM
My two cents: Try to clear the cache and make sure you enter the new credentials in here, and also try restarting the machine once, and give it a shot. Control Panel\All Control Panel Items\Credential Manager Hope this might solve the issue.
Wednesday, September 11, 2019 3:05 PM
All,
Thanks for your kind replies and your help. I changed my windows login password back to my old password. I had to run some queries in SSMS. I will change the password again on Friday, Sept 13, and give you an update.
After reading everyone's replies, my understanding is that I don't need to do anything on the SSMS side after my windows password is changed to new password? It picks up the new credentials ?
Thanks.
Wednesday, September 11, 2019 3:21 PM | 1 vote
Exactly,
No change is required. You change the windows user password and login to Sql Server normally without problems.
Se esta resposta lhe ajudou, marque-a como útil para que outra pessoa com dúvida ou problema semelhante possa encontrar resposta ou ajuda mais facilmente. * Jefferson Clyton Pereira da Silva - [ MCSA | MCP | MCTS | MTA | Analista de Banco de Dados - Sql Server e Oracle ]
Thursday, September 12, 2019 9:55 AM
Hi AIM28256,
>>Cannot Connect to the xxxxx server. Additional Information: The target name is incorrect. Cannot generate SSPI context (Microsoft Sql Server).
I have test it in my machine. I can connect to the sql server without problems. It seems to be a issue of spn. Have you change the service account of sql server?
Best regards,
Dedmon Dai
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com