SQL problem

5 pts.
Tags:
Microsoft SQL Server 2000
SQL Server
SQL Server 2005
SQL Server 2005 interoperability
Hi, Iam having two sql servers 2000 and 2005 are installed on the same server. When i run any application it is directily hitting the 2005 serve but i want the application to to hit sql 2000 server only and when i want to hit it to sql 2005 it should hit it means vice vers can some one help me in this.

Answer Wiki

Thanks. We'll let you know when a new response is added.

In order to have both SQL Server 2000 and SQL Server 2005 installed at the same time one will be a named instance and the other the default instance (or both are named instances but with different names).

In order to connect to the named instance you need to put the instance name in the connection string.

Default Instance = ServerName
Named Instance = ServerName\InstanceName

If you have SQL 2000 installed, then installed SQL 2005 but did not give it an instance name than the SQL Server will have been upgraded and you will no longer have SQL 2000 installed.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following