SQL login client not admin

40 pts.
Tags:
SQL
SQL performance
SQL Troubleshooting
it is payday and on the client side of our DB there are some login errors, where in SQL do you go to check points of failure?
ASKED: April 23, 2009  5:39 PM
UPDATED: April 24, 2009  3:46 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

In SQL Server 7.0 or later versions, you can maintain the mapping between the logins in the master database and the users in the user database by using the SIDs. This mapping is required to maintain correct permissions for the logins in the user databases. When this mapping is lost, the logins have permission issues that include but are not limited to the following:

* If the SQL Server login does not exist on the new server, and the user tries to log on, the user may receive the following error message:
Server: Msg 18456, Level 16, State 1
Login failed for user ‘%ls’.
* If the SQL Server login exists on the new server, but the SID in the master database differs from the SID in the user database, the user can log on to SQL Server successfully; however, when the user tries to access that database, the user may receive the following error message:
Server: Msg 916, Level 14, State 1, Line1
Server user ‘%.*ls’ is not a valid user in database ‘%.*ls’.
Note In SQL Server 2005, the user may receive the following error message:

Server user ‘%s’ is not a valid user in database ‘%s’.
Add the user account into the database first.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following