SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Sql server 2005 installation


Sql server 2005 installation

Author
Message
sendtoibrahim
sendtoibrahim
SSC Rookie
SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)

Group: General Forum Members
Points: 33 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?
Steve Jones
Steve Jones
SSC Guru
SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)

Group: Administrators
Points: 140145 Visits: 19415
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
My Blog: www.voiceofthedba.com
sendtoibrahim
sendtoibrahim
SSC Rookie
SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)

Group: General Forum Members
Points: 33 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?
Steve Jones
Steve Jones
SSC Guru
SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)

Group: Administrators
Points: 140145 Visits: 19415
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
My Blog: www.voiceofthedba.com
Joie Andrew
Joie Andrew
SSCertifiable
SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)

Group: General Forum Members
Points: 6099 Visits: 2032
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"
sendtoibrahim
sendtoibrahim
SSC Rookie
SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)

Group: General Forum Members
Points: 33 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search