Error: 18456, Severity: 14, State: 58
Error: 18456, Severity: 14, State: 58
(OP)
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
RE: Error: 18456, Severity: 14, State: 58
-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
RE: Error: 18456, Severity: 14, State: 58
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.
RE: Error: 18456, Severity: 14, State: 58
Bump, anyone have any ideas?
RE: Error: 18456, Severity: 14, State: 58
Regards
Frederico Fonseca
SysSoft Integrated Ltd
www.syssoft-int.com
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: Error: 18456, Severity: 14, State: 58