After we have installed SQL Server, it may appear when connecting to the database with the local system.
Title: Connect to a server
------------------------------
Unable to connect to .
------------------------------
Additional information:
User 'lianxiang-PC\lianxiang' fails to log in. (Microsoft SQL Server, Error: 18456)
For help information, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
------------------------------
Button:
Are you sure
------------------------------
Authenticating with a local system will cause an error...
I have tried many solutions on Baidu, but none of them work, and all the nonsense I say on the Internet is nonsense
The solution depends on the operation...
First, log in with your SQL SA account...
My computer name is lianxiang, so I choose lianxiang Your own computer Choose your own computer name Do you understand???
We close the sql and reconnect to try using window authentication
This will succeed and there will be no errors
Video address:Tourists, if you want to see the hidden content of this post, please Reply
| 
Posted on 10/5/2014 9:46:42 PM
|
|
|
|
