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

MySQL Update Statement

UPDATE _vldmembers_data_membersSET data_gender2=3WHERE data_gender1=1;UPDATE _vldmembers_data_membersSET data_state=469WHERE data_city LIKE 'Kansas%';UPDATE _vldmembers_data_membersSET data_state=457WHERE data_city LIKE 'colorado%';UPDATE _vldmembers_data_membersSET…

MS SQL Maintenance

Below is a list of practical SQL snippets to administer Microsoft databases: -- Shrink Database:…

Microsoft SQL Server Replication Setup Error Number MSSQL_REPL2110 and Resolution

Symptom: The distribution agent failed to create temporary files in 'C:\Program Files\Microsoft SQL Server\130\COM' directory…