December 14, 2005 at 11:54 am
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.
December 14, 2005 at 2:00 pm
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
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
December 14, 2005 at 2:26 pm
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.
December 14, 2005 at 3:20 pm
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy