When I want to start my application as a domain user, I get the following message
"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.
windows2012R2
SQL2008R2
Can anyone help me on this?
Thanks in advance
Solved
Can anyone help me with double backslash in domain username
- Sidekick
- 30 replies
Best answer by Marco Kleiweg
Adding a backslash to the names was no option. That's why I took a more radical way if refreshing the properties. I deleted the logins and created them again.
This solved the problem.
Thanks for helping.
View originalThis solved the problem.
Thanks for helping.
This topic has been closed for comments
+1Hi Marco, could you somehow add a screenshot of the error message? This may help with the analysis. Thanks in advance.
- Sidekick
- 30 replies
H
I hope you can help me and my client.
I hope you can help me and my client.
+1Hmm... what happens internally is that the Windows GUI uses the authentication method only for the connection string, like in this example:
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?
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?
- Sidekick
- 30 replies
- Answer
Adding a backslash to the names was no option. That's why I took a more radical way if refreshing the properties. I deleted the logins and created them again.
This solved the problem.
Thanks for helping.
This solved the problem.
Thanks for helping.
1 person likes this
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.