-3

I have Sql Server 2000 and Sql server 2005 installed on the Server. How do i set the default instance to 2005?

On Running this script

Select @@Version

i get:

Microsoft SQL Server  2000 - 8.00.194 (Intel X86)   Aug  6 2000 00:57:48   Copyright (c) 1988-2000 Microsoft Corporation  Personal Edition on Windows NT 6.0 (Build 6002: Service Pack 2)
longneck
  • 23,082
  • 4
  • 52
  • 86
George
  • 1
  • 1
  • 1

2 Answers2

3

The type and name of a SQL Server instance is defined during its setup; each system can have one default instance and as many named instances as you want; when multiple instances are installed on the same computer, they can use different product versions, as in your case. More details here.

The instance configuration can't be changed after installation; the only way to change this is by uninstalling and reinstalling the instance.

This is valid for all versions of SQL Server, including 2000 and 2005.

Massimo
  • 70,200
  • 57
  • 200
  • 323
2

What Massimo said; you can't rename instances without reinstalling. However, I read your question as, "How do I connect to 2005?"

You can connect to non-default instances by finding the instance name in Services (if you don't remember what you named them).

For example:

enter image description here

You'd connect to that one by putting YOURSERVERNAME\SQLEXPRESS in the connection dialog.

Katherine Villyard
  • 18,550
  • 4
  • 37
  • 59