Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error: 18456, Severity: 14, State: 58

Status
Not open for further replies.
Slimsteve

Slimsteve

Technical User
Jun 10, 2003
67
GB

Hi All

I have having issues connecting to a sql server and keep getting "Error: 18456, Severity: 14, State: 58" when trying to logon with a SQL login. The SQL login works ok when on the server itself, but when trying to connect to the sql server from a client I get the error message. I have already checked the followed:

1: SQL server is in mixed authentication mode.
2: The server is setup to allow remote connections.

Any ideas?

Thanks
 
Sort by date Sort by votes
Are you trying to connect with SQL Server Management Studio or is it a different application? Can you show the connection string you are using to connect?


-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Upvote 0 Downvote

I am trying to connect mainly from SQL Server Management and SQL cmd line, when using SQL cmd line I get asked for the user name and password but it still fails on the client computer. I will be using code in the future to query the database when I can establish a connection to the server.

 
Upvote 0 Downvote
According to this article, you may have the SQL Server configured to accept only Windows authenticated logins (default setup).
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

torquinian
  • Locked
  • Question
Error 0x80131904 when trying to connect to database
Replies
0
Views
537
torquinian
torquinian
DougNaf
  • Locked
  • Question
SQL 2016 - DB attachment and error 3415
Replies
1
Views
437
fredericofonseca
fredericofonseca
vba317
  • Locked
  • Question
SQL Server error 1801 on new PC
Replies
0
Views
395
vba317
vba317
anon1971
  • Locked
  • Question
State 28000 Error 18542
Replies
1
Views
242
anon1971
anon1971
djj55
  • Locked
  • Question
Unable to update the database IDs error.
Replies
5
Views
406
djj55
djj55

Part and Inventory Search

Sponsor

Back
Top