Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Can't connect, Login failed

Author  Topic 

skybvi
Posting Yak Master

193 Posts

Posted - 2011-10-06 : 10:14:18
Hi,
I am trying to enter an application on a client PC, (application is MS Dynamics GP which uses sql server logins)
When I try to enter the password, it says
Login failed. Contact your system adminsitrator.

I checked the sql logs which say
Error: 18456, Severity: 14, State: 8.

I checked and made sure that the password is correct from SSMS.

I dont have a clue why is it failing?


Regards,
Sushant
DBA
West Indies

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2011-10-06 : 12:04:42
check connection string on application side.
Go to Top of Page

DBA in the making
Aged Yak Warrior

638 Posts

Posted - 2011-10-12 : 06:41:10
This page describes how to find out more about the reason for the failure.

http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx

------------------------------------------------------------------------------------
Any and all code contained within this post comes with a 100% money back guarantee.
Go to Top of Page
   

- Advertisement -