Posted On March 25, 2021

Microsoft SQL: Login failed for user ‘sa’. (.Net SqlClient Data Provider)

kimconnect 0 comments
blog.KimConnect.com >> Database >> Microsoft SQL: Login failed for user ‘sa’. (.Net SqlClient Data Provider)
Error:
===================================
Cannot connect to SQL-SERVER
===================================
Login failed for user 'sa'. (.Net SqlClient Data Provider)
Resolution:

1. Ensure that the ‘sa’ account is enabled: security > right click user sa > Properties > Status > Enabled > save
2. Enable SQL Server & Windows authentication: right click on the server > Security > select radio button next to ‘SQL and Windows Mode’ > restart SQL or the OS

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post

ODBC Driver 32-bit & 64-bit

The 32-bit version: Run: odbcad32.exe > check the list of installed 32-bit drivers as illustrated…

How to Add Domain Admins to SQL Server

Step 1: Right-click Start > Search > type in 'ssms.exe' > right-click Microsoft SQL Server…

Latin1_General_CI_AI vs SQL_Latin1_General_CP1_CI_AS

The SQL_Latin1_General_CP1_CI_AS collation is a SQL collation and the rules around sorting data for unicode…
Other project: DragonCoin.com