Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2007-03-07 : 03:32:25
|
| Hello,This is the present setup.Server A --> sql server 2000Server B --> sql server 2005On my machine I point to an instance name of sql server 2000 to use. i.e.sqlserver2000Server\instance1On 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.Questions1) 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 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-07 : 03:45:36
|
1) just pop the SQL 2005 CD into your CD ROM Drive2) Yes. you have to install as a instance. You named it during installation. You are installing on your local machine. What does it got to do with the Server B ?
KH |
 |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2007-03-07 : 03:50:40
|
| Hi,Is this right: i.e "i install sql server 2005 on local machine as an instance name rather than the default instance." |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-07 : 03:56:54
|
yes
KH |
|
|
|
|
|
|
setup