Win7 first installed SQL2005 after installing SQL2000 correct connection method

  
Previously developed using WIN7 + VS + SQL2005 Now to do a project, they use the database is SQL2000, so no way can only install a SQL2000! > Install SQL2000 correctly (I installed a new instance when I installed it, it is best not to install it by default, because SQL2005 has been installed. This is found online, I don't want to reinstall the system, I have not tried the default instance installation, there is Interested friends can try).
After installing this, you will open the Query Analyzer directly and you will get an error! You should first open the Enterprise Manager. After opening it, you may see several instances. The instance of SQl2000 you just built is also inside,
You will find that it is not started by default and is manually turned on.

Now you can open the Query Analyzer, but you will find that it is connected to the SQL2005 server. To make it connect to the SQl2000 server

and how to find the name of this server??——>Open the SQL server Server Manager Select your database instance to copy the entire name and fill it in In the SQL server in the diagram, OK

This implements the connection query
The following is the implementation of the table in the database ——> In fact, there are many solutions for this on the Internet. Br> Below I will copy a paragraph of others!!

If you can build the table successfully in the above steps, you can not look down!!!!!!
The following are very good on the above Building a table can be a problem that cannot be saved.
The table is built but cannot be saved. I believe everyone feels willing to fall!!
——>Solutions
The first list in the design table Click on the column name of any row, and right click on the property
you will see a box like this

As long as you modify the table name in the table name, you can save it! (Default above Filled in Table1 and the like)
This will install the SQL2000 installation method and use in win7 after installing SQL2005. Law. !

Copyright © Windows knowledge All Rights Reserved