Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sql server 2005 installation Expand / Collapse
Author
Message
Posted Saturday, April 17, 2010 10:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, May 8, 2010 1:34 AM
Points: 11, Visits: 28
Hi, guys how are you doing?

i have windows server 2003 and recently, i installed SQL server 2000 in drive "D" because i don't have more space in drive "C". and right now, i also want to install SQL server 2005 for reporting services.
my question is, if i installed SQL server 2005, will it save with the same path of sql server 2000? because i like both sql server to be installed in " D" partition.

please i need your help?
Post #905431
Posted Saturday, April 17, 2010 10:29 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:32 AM
Points: 33,055, Visits: 15,165
You choose where you install each version. The named instance of 2005 will have nothing to do with the 2000 instance you have installed. If you upgrade, it will keep the settings.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #905435
Posted Saturday, April 17, 2010 11:14 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, May 8, 2010 1:34 AM
Points: 11, Visits: 28
thank you.

Actually, i want to install default instance so that all my databases will be installed automatically to SQL server 2005. so, you mean if i installed sql server 2005 default instance, it will hold the same path?
Post #905447
Posted Saturday, April 17, 2010 11:30 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:32 AM
Points: 33,055, Visits: 15,165
If you have SQL 2000 installed, you cannot install a default instance of SQL 2005. You would install a named instance, or upgrade your SQL 2000 instance to 2005.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #905453
Posted Saturday, April 17, 2010 8:00 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, July 18, 2014 11:32 AM
Points: 709, Visits: 1,410
Just specify the named instance when installing your databases and they will be on the 2005 instance. Now if you have an application that does not support named instances, that is an entirely different subject altogether...

Joie Andrew
"Since 1982"
Post #905513
Posted Thursday, April 22, 2010 2:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, May 8, 2010 1:34 AM
Points: 11, Visits: 28
Hi, guys how are you doing?

i have already tried with the installation of SQL server. as i said 1st i installed sql server 2000 sp3 to my "D" drive with the server name. and again i run sql server 2005 as default instance and then it holds the path of sql 2000 which is mssql. now, when i opened the Management studio, it is perfect because, i connected with my database and All my databases from sql 2000 are automatically installed in there and i think it is fixed.


thanks
Post #908387
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse