"Cannot open database "..._IAM" requested by the login. The login failed.
Login failed for user 'DOMAIN\\user'."
All the domain users work properly, only the users that has been set on "disabled" and later set back to "enabled" have the double backslashes.
When I start SSMS i can normally logon to the databases.
Can anyone help me on this?
Thanks in advance
Best answer by Marco KleiwegView original
ereby a screenshot. It's all I can offer you.
I hope you can help me and my client.
Data Source=myserver;Initial Catalog=MY_DATABASE;Integrated Security=True;Pooling=True;MultipleActiveResultSets=False;Application Name="Thinkwise Software Factory";Current Language=English
I don't know how SQL server handles this exactly, but if I look at Security -> Logins in SQL Server Management Studio all domain names there have one backslash only. Is it possible to change the login name of affected users by adding a backslash, or somehow refresh their properties? And would that fix the problem?
This solved the problem.
Thanks for helping.