Need to install 2nd instance of SQL server 2005 with sp2 already applied

Question

Need to install 2nd instance of SQL server 2005 with sp2 already applied

Patti Johnson

SSCertifiable

Points: 7054
More actions
October 19, 2009 at 9:43 am

#136619

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?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 1

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.

Patti Johnson SSCertifiable Points: 7054 More actions · Answer 2

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?

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 3

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.

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 4

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.

Patti Johnson SSCertifiable Points: 7054 More actions · Answer 5

Yes, Thank you. I was successful in doing this.

Thanks you all very much.