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

PowerShell: Get SQL Server Performance Counters

Version 2 # getSqlPerformanceCounter.ps1 # version 0.02 $computername='sql0003.kimconnect.com' function getSqlPerformanceCounter($server=$env:computername,$sampleInterval=10,$maxSamples=1){ $PerformanceCounterSampleSet=$result=@() $counters=@( '\Memory\Available MBytes', '\Memory\Pages/sec',…

Microsoft Dynamics Audit History Data Missing After Org Migration

Issue: We have recently moved some Orgs from CRM version 8.x to 9.x, and audit…

Microsoft SQL Server Connection Timeout

Error Message: Resolution: a. Check SQL Server's Query Execution Timeout: SSMS > Login > Tools…