error 18456 : LUSENET : SQL Server Database Administration : One Thread

Thanks very much for all your helps.

I have this application that has SQL Server backend. The application is based on SQL Server authentication. After installing the said application for a user and granted the user the necessary permissions in the database but when the user tries to login into the application it comes up the error message 18456: You do not have permission to log in to the server. But the user has the permission.

Your comments is appreciated.

-- Anonymous, June 28, 2000



Double check the way that you are connecting to the backend. Since you are using standard security, make sure the SQL Server is not expecting NT security and that you pass the correct database, username, and password. If all else fails, try it with "sa" login. If the "sa" works, but the username does not, it may be a permissions issue.

Good Luck, Eric

-- Anonymous, June 28, 2000

Moderation questions? read the FAQ