I
I
Igor Krivintsov2016-03-23 19:48:05
SQL
Igor Krivintsov, 2016-03-23 19:48:05

How to cure user sa?

Hello, I wanted to run the sql server on behalf of the sa user, and I came across an error, I ask for help, who came across?
Unable to connect to SQL1.
==================================
Login failed for user "sa". (.Net SqlClient Data Provider)
------------------------------
For help, click: go.microsoft.com/fwlink ?ProdName=Microsoft%20SQL%2...
------------------------------
Server Name: SQL1 Error
Number: 18456
Severity : 14
Condition: 1
Line number: 65536
c57a8c1bde744c54ac9a05a34e88ac0a.pngeb973990da7340ea9408172828859082.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexey, 2016-03-23
@k1lex

If a connection attempt is denied as a result of an authentication failure due to an invalid username or password, the client receives a message similar to the following: "Login failed for user <username>.(Microsoft SQL Server, Error: 18456)".
More details and how to search for the cause are described here: MSDN

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question