Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
colep002
Starting Member
2 Posts |
 Posted - 2003-03-11 : 02:28:17
|
| At the moment i am trying to install service pack 3 on an Sql 2000 machine. I would like to do this using the unattended installation facility since this server cannot be stopped except at 3.00am and frankly i do not fancy coming to work at those hours.I have another sql2000 test machine and everything seems to be going quite well. I run the sql2kdef.bat which downs the service and re-runs it again but when the process ends except for finding the server in single mode nothing else happens and i am still stuck with sql2000 service pack 2. Underneath please find the command line found in sql2kdef.bat:start /wait x86\setup\setupsql.exe -s -sapwd mypassword -m -sms -f1 "sql2kdef.iss"There are no other instances of sql running on the test server so its not a case of using the sql2knm.bat utility. Any help please? |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2003-03-11 : 12:19:35
|
| I have similar problem with an instance.The batch file seems to do something for a few seconds and then just comes back to the command prompt. There is no log on C drive or any event in the event viewer to check what died.. |
 |
|
|
colep002
Starting Member
2 Posts |
Posted - 2003-03-12 : 03:44:21
|
| if it is doing something for a few secons check the iss file and check the following settings[ServerConnect-0]NTAuthentication=0SQLAuthentication=1Result=1[SdBlankPwdWarningDlg-0]AllowBlank=0EnterPwd=ur passwordConfirmPwd=ur passwordResult=1This is for authentication by the sa login, also check that all results parameters are set to 1 in succesion otherwise the program wont be able to continue. Good luck! |
|
|
|
|
|
|
Sql 2000 service pack 3 unattended installation