Link to home
Start Free TrialLog in
Avatar of fntcl
fntcl

asked on

Unable To Log Into SQL Server--Error Message 18456

Greetings,

We have a client that can connect to MSSQL 2005 remotely using a sysadmin login--either the "sa" account or a "normal" login assigned to the sysadmin server role--and locally with any user login.  However, when trying to connect remotely with a non-admin account, error message 18456, State 8 (and then State 16) is reported.  However, using that same failed login and password locally on the server works as expected.  So, the problem can be sumnmarized as follows:

(1) Locally:  Any valid login/password works.
(2) Remotely: Only sysadmin logins work.

Please advise as I cannot seem to find anything on the Web pertaining to this issue.  Thanks in advance.
Avatar of DBAduck - Ben Miller
DBAduck - Ben Miller
Flag of United States of America image

You may want to look here first and then go from there.
http://msdn.microsoft.com/en-us/library/ms366351.aspx

Then you should check this:
http://support.microsoft.com/kb/925744/en-us
ASKER CERTIFIED SOLUTION
Avatar of fntcl
fntcl

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial