SQL server shows this 28000 error message

Asked By Scott P Daniels 50 points N/A Posted on - 01/18/2014

Hi,

When I try to log in to SQL server I have this 28000 error message. Also, recently I have made an update to my MAC and I think that’s may be the problem. I never experienced such problem before and I am a bit confused. Anyone here can help me with this error and tell me how can I solve it ?

Thanks !

C28000

[Open Link][ODBC][SQL Server][Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user ‘sa.’

• Status: Open
• Question Views: 678
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Tim Lahaye 10 points N/A #185905

SQL server shows this 28000 error message

You have to be sure that no other SQL instances running that might be using the localhost post. In such a case it would conflict with the login and turning it off solves the problem. You also need to supply a definite password for your user.  From the Server Management Studio select the radio button to make it accept both Windows and SQL Server mode of authentication. 

About Tim Lahaye

Questions
3

Answers
256

Best Answers
20

• Vote Up 0 Vote Down

• Posted on - 02/21/2014
• Question Category: MySQL Server