Unattended Install of Service Pack and Server Collation

Question

Post reply

Unattended Install of Service Pack and Server Collation

MG-148046

SSCrazy Eights

Points: 9946
More actions
December 14, 2005 at 11:54 am

#90172

I noticed that the iss file that is created for an unattended installation contains the default collation. Will using that iss file on a server with a different collation change the collation during the installation of SP4? Is it necessary to change the iss file to match the default collation of a server for each server?
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

Viewing 4 posts - 1 through 3 (of 3 total)

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

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 1

I would change. See

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_6nz9.asp

Read Unattened Installation Considerations for installing SP4 at

http://download.microsoft.com/download/1/b/d/1bdf5b78-584e-4de0-b36f-c44e06b0d2a3/ReadmeSql2k32sp4.htm#_unattended_installations

it says:

".......You must generate a separate setup.iss file for each combination of system configuration and installation settings on which you intend to run an unattended installation. To change the setup behavior, you must modify the setup.iss file. For more information, see the topic "Creating a Setup File Manually" in SQL Server 2000 Books Online. ....."

Yelena

Regards,Yelena Varsha

MG-148046 SSCrazy Eights Points: 9946 More actions · Answer 2

thanks for the response but from what I see, the documentation seems to apply only to the initial installation of SQL Server.

I did a manual installation on a server and the sqlstp.log has the collation I chose but the setup.iss and sqlsp.log (from the SP4 installation) have the MS default collation. I verified that the server was using the collation I chose in the setup screens - SQL_Latin1_General_CP850_CI_AI.

This all leads me to believe that the Service Pack installation ignores collation, which is what I am hoping for since I am trying to automate this for a large number of servers. Unfortunately , we haven't any servers for me to test this on.

MG

"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 3

Hi,

Use a workstation if you don't have servers!

Install Personal Edition or Developer Edition, select the appropriate collation, play with SP4 and uninstall whatever number of times you want!

Personal Edition is licensed as a client and comes with Standard Edition package (at least through our reseller)

You need to test. Otherwise backup all your databases really well.

Regards,Yelena Varsha