Thursday, 10 March 2016

SQL Error: Cannot connect to - Login failed for User ‘SA’ (Microsoft SQL Server, Error: 18456)

/
/
Error: Cannot connect to
Login failed for User ‘SA’ (Microsoft SQL Server, Error: 18456)





Issue occurred:
The login may be a SQL Server login but the server only accepts Windows Authentication

Tried lots of other solution available on google but below solution worked for me on my production environment.
To resolve this issue, configure SQL Server in Mixed Authentication Mode. To do this, follow these steps:

1)    Click Start à click All Programs à click Microsoft SQL Server 20xx (where xx is the version of SQL), and then click SQL Server Management Studio.

2)    Right-click the server, and then click Properties.





3)    On the Security page, under Server authentication, click the SQL Server and Windows Authentication mode option button, and then click OK.



4)    In the SQL Server Management Studio dialog box, click OK to restart SQL services and try again to login with ‘SA’ account.
Applies to:

SQL Server 2014, SQL Server 2012, SQL Server 2008, and SQL Server 2005

Thank You
Vikas Singh
/
/
Unknown Server Administrator

Microsoft Certified Professional, CCNA, Windows Server Administrator, VMWare Administrator, Hyper-V Administrator, Virtualization Administrator

1 comment:

  1. Anonymous11 April 2022 at 22:37

    Sql Error: Cannot Connect To - Login Failed For User ‘Sa’ (Microsoft Sql Server, Error: 18456) - Microsoftadmins >>>>> Download Now

    >>>>> Download Full

    Sql Error: Cannot Connect To - Login Failed For User ‘Sa’ (Microsoft Sql Server, Error: 18456) - Microsoftadmins >>>>> Download LINK

    >>>>> Download Now

    Sql Error: Cannot Connect To - Login Failed For User ‘Sa’ (Microsoft Sql Server, Error: 18456) - Microsoftadmins >>>>> Download Full

    >>>>> Download LINK 12

    ReplyDelete

Subscribe to: Post Comments (Atom)