Sql server 2005 installation

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » Sql server 2005 installation

Sql server 2005 installation

Rate Topic

Display Mode

Topic Options

Author

Message

sendtoibrahim

Posted Saturday, April 17, 2010 10:12 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, May 08, 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

Steve Jones - SSC Editor

Posted Saturday, April 17, 2010 10:29 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 9:03 PM
Points: 31,406, Visits: 13,723

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

sendtoibrahim

Posted Saturday, April 17, 2010 11:14 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, May 08, 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

Steve Jones - SSC Editor

Posted Saturday, April 17, 2010 11:30 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 9:03 PM
Points: 31,406, Visits: 13,723

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

Joie Andrew

Posted Saturday, April 17, 2010 8:00 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 06, 2013 5:58 AM
Points: 535, Visits: 1,010

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

sendtoibrahim

Posted Thursday, April 22, 2010 2:20 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, May 08, 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 »

Permissions