Home | Site Map | Cisco How ToNet How To | Wireless |Search | Forums | Services | Donations | Careers | About Us | Contact Us|

SQL Login failed state meanin

Network Sharing , TCP/IP, Internet, Wireless, Exchange, IIS, ISA and Print

SQL Login failed state meanin

Postby chicagotech » Tue Jul 11, 2017 4:09 pm

When access SQL database you may receive this error: Login failed for user 'username'. (Microsoft SQL Server, Error: 18456). If you open the error log from C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log, you may see State number. Here are the meaning of state.

State 1: Account is disabled.

State 5: Login is invalid.

State 6: Windows account used for SQL Authentication

State 7: This would appear if login is disabled AND incorrect password is provided.

State 58: SQL running under Windows only mode and SQL login is attempted.
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on http://www.HowToNetworking.com
chicagotech
Site Admin
 
Posts: 6934
Joined: Mon Nov 27, 2006 1:24 pm
Location: Chicago USA

Return to Networking

Your Ad Here

Who is online

Users browsing this forum: No registered users and 7 guests