I have SQL 7.0 Server and SQL 2000 client tool installed on my machine. I have recently loaded SQL 2005 Standard version but when I open SSMS (Management studio) I get the fillowing error.

This version of Microsoft SQL Server Management Studio can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (ConnectionDlg)

Can any one suggest the solution.

Hi Anita
I have a solution for you.
Remove the SQL 7.0 and evryting will be ok because SQL 7.0 to old end is
incompatible with SSMS.
If i was on your place i will copy my databeses on secur place and uninstal all SQL's and instal
SQL 2005 ADV EXPRESS SERVER AND TOOLS NATURALLY, because you are really in big mess with these SQL's

Windows(R) server 2003 Standard Edition Operating System Installed on my Computer and Installation of SQL Server 2005 Enteprise Edition complited sucessfully but i couldn't acessing my SQL Server on my Network.When SSMS trying to connect the SQL server raise Error like this:

Cannot connect to MIS-D16\EXPRESS.

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)


Plz any one can suggest me for solution.

You need to go into the SQL Server 2005 Surface Area Configuration utility (found in Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools). When that opens up, click on the Surface Area configuration for Services and Connections link. This will open up another dialog. In this dialog, you should see a treeview on the left. Expand the node called Database Engine. Under that you will see two items. One of them is called Remote Connections. Select Remote Connections and on the right side of the form you will be able to configure this. By default, remote connections in SQL Server 2005 is turned off. You need to enable remote connnections but selecting "Local and remote connections".