Friday, March 30, 2012

instance name

Hello,
This is the present setup.
Server A --> sql server 2000
Server B --> sql server 2005

On my machine I point to an instance name of sql server 2000 to use. i.e.
sqlserver2000Server\instance1
On my local machine I have installed sql server 2000 and can use the enterprise manager. Have the Admin rights.
I have setup a daily backup job on sql 2000...

On server B, I installed sql 2005. Restored the sql 2000 backup onto sql 2005. And now I have the sql 2000 database in sql server 2005.

Now I can use the sql 2005 by refering to the serverB name (Not an instance).

In Server A, the applications are using a login name (sql authentication) i.e. username, password.

Questions
1) How do I install sql 2005 on my local machine (Remember that I have sql 2000)

2) If I should run the setup for sql 2005 on local machine, then during the installation, do I give it an instance name or should this instance name be done on the server i.e. server B ?

Thanks


1) How do I install sql 2005 on my local machine (Remember that I have sql 2000)

SQL Server 2000 and SQL Server 2005 can be installed side by side successfully on the same machine. You just need to run setup to install SQL Server 2005.

2) If I should run the setup for sql 2005 on local machine, then during the installation, do I give it an instance name or should this instance name be done on the server i.e. server B ?

Based on your scenario, I assume you install both SQL Server 2000 and 2005 as non-cluster installation. The instance name for SQL Server 2000 and 2005 should be unique on the same machine. So the instance names may be the same on different mahcines. But when we connect to an instance, we use machinename\instancename to specify which one to connect.

No comments:

Post a Comment