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 Docker Container

################### Dockerfile Build Method ######################mkdir /var/lib/docker/mysql && cd /var/lib/docker/mysqlvim Dockerfile################## Dockerfile contents ###################### Derived from…

How to Setup Microsoft Failover Cluster with PowerShell

First-time Setup: New-Cluster -Name {CLUSTERNAME} -Node SERVER1,SERVER2 -NoStorage -StaticAddress IP1,IP2 # Add CLUSTERNAME$ into the…

Microsoft SQL: Shrink vs Truncate

Shrink The shrink command is to reduce the physical log file size of a database.…