This tutorial is for some students who don't know how to install SQL Server 2005 or always make mistakes in installation.
First of all, open our Wusoft forum...
Microsoft SQL Server 2005 Chinese Simplified Edition.
http://www.itsvse.com/thread-9-1-1.html
(Source: IT Computer Forum)
Download sql server2005 address This is the version given by the teacher。。。。。
Talking nonsense, starting to install SQL Server 2005 during the installation process I may also get an error I will show how to fix it...
Just look at the operation。。。。。。
We just need to tick the first and the penultimate one.
Select window validation and sql validation...
Now start installing...
Wait patiently
The installation is complete, let's open it and try it.
Just said that using window system authentication will cause an error, let me demonstrate it again...
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
The main reason is that when installing the system, the administrative default account was changed to its own...
End of tutorial!!
Note: In the future, you need to uninstall and reinstall sql server2005, I recommend that you reinstall the system directly, because I have not uninstalled sql server2005 cleanly so far, including watching some uninstallation tutorials on the Internet, I have not uninstalled cleanly!
If you don't understand anything in the study of professional courses in the future, you can gowww.itsvse.comPost for help.
Video tutorial address:Tourists, if you want to see the hidden content of this post, please Reply
| 
Posted on 10/5/2014 9:43:01 PM
|
|
|
|
Posted on 7/29/2018 2:52:37 PM