October 19, 2009 at 9:43 am
I need to install 2nd instance of sql server 2005. I am using the installation CD but I get the warning regarding an edition change because sp2 has already been applied. Can I ignore the warning and proceed to install the named instance and then apply service pack 2 to the named instance afterwards?
October 19, 2009 at 9:45 am
You should be fine, but don't install any non-instance aware items, such as client tools or SSIS. They might overwrite what's there.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 19, 2009 at 9:49 am
So are you staying that all I need to install is sql 2005 database services and that is all? Then apply sp2 to that aftwards?
October 19, 2009 at 12:43 pm
Yes,
If you intend to use Database Engine only ( Not SSAS or SSRS) then install the SQL Database Engine not selecting the Client tools, workstation components and Development Tools.
And then Install the SP 2 or SP3 what ever you need it be.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
October 19, 2009 at 2:49 pm
Yes, Bru is correct.
If you are installing the core engine, database services, these are completely separate. Separate folder for files, dbs, separate registry and services. You can apply SPs to one instance, and not another.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 19, 2009 at 3:10 pm
Yes, Thank you. I was successful in doing this.
Thanks you all very much.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply