Post reply

RE: SP3a unattended installation

  • December 18, 2003 at 7:48 am

    #65754

    Does anyone have any experience with SQL2K SP3a unattenede installation? I followed MS procedure, and it just didn't work.

    Thanks

  • December 18, 2003 at 9:04 am

    #486973

    Default Instance installation : setup.exe /qn /i sqlrun01.msi /l*v c:\msde2000_setup.log

    Named Instance Installation : setup.exe /qn /i sqlrun02.msi INSTANCENAME="MYMSDE" /l*v c:\msde2000_setup.log

  • December 18, 2003 at 9:11 am

    #486976

    What kind of problems are you having? It's been a while, but I installed SP3a on dozens of servers with unattended installs.

  • December 18, 2003 at 9:20 am

    #486979

    Is it for MSDE or not? cause I need to install SP3a on SQL server?

    I bascily tried the command from MS without luck.

    start /wait x86\setup\setupsql.exe -s -m -f1 "sql2kdef.iss"

  • December 18, 2003 at 9:23 am

    #486981

    I must look into other question regarding to MSDE and post reply here. Sorry for that.

  • December 18, 2003 at 10:47 am

    #487010

    I ran using the bat file, which has slightly different parameters. I believe the line is

    start /wait x86\setup\setupsql.exe -s -m -SMS -f1 "sql2kdef.iis"

    Also, are you running while logged onto the server with a Windows account that has sa rights?

    What are you getting in your setup log?

  • December 18, 2003 at 12:46 pm

    #487049

    I used a local admin account to run that bat file, which is sa by default. Also, since I don't have SMS, so I took the -SMS off command line.

    Thanks again.

  • December 18, 2003 at 1:05 pm

    #487054

    quote:

    Also, since I don't have SMS, so I took the -SMS off command line.

    I'm not sure what you mean when you say you don't have SMS. The -SMS option is used in conjunction with the start/wait command. It returns control to the command prompt only after setup finishes.

  • December 18, 2003 at 1:08 pm

    #487056

    I doubt "-SMS' here referring to SMS server. According to sp3 readme, The file Sms2kdef.bat is a batch file that starts an unattended setup using Systems Management Server. The command line looks like (start /wait x86\setup\setupsql.exe k=SMS -s -m -SMS -f1 "sql2kdef.iss").

    Type setupsql.exe /? in command prompt will give you explaination of '-SMS'.

  • December 19, 2003 at 12:34 pm

    #487282

    I tried it again with -sms, however, it still didn't work.

    Thanks again for your time.

  • December 19, 2003 at 2:18 pm

    #487301

    You should have a setup log. I don't remember exactly where it puts it, possibly in the Winnt or System32 directory. I believe it has a .log extension, so if you search by date, you should find it.

    What are the contents of the log file?

  • December 19, 2003 at 5:11 pm

    #487331

    sqlspN.log in c:\winnt directory. N is the number.

  • December 19, 2003 at 7:15 pm

    #487337

    I didn't see any errors in that log

    file. Here is the last portion of it, which might give you some clues? Thanks.

    14:35:33 Begin: SdShowSp3WrngDlg

    14:35:33 C:\SQL2KS~1\x86\BINN\osql.exe -Slpc:WTEATDBBOS01 -n -d master -o "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\sqlsp.out" -Q"Exit(declare @ret int if (select count(*) from msdb.dbo.systargetservers) = 0 Set @ret=0 else Set @ret=403 Select @ret)" -E

    14:35:33 Process Exit Code: (0)

    14:35:47 Action Exit Handler:

    14:35:49 Begin Action : LogEvent

    14:35:49 Could not report an event : [6]

    14:35:49 End Action : LogEvent

    14:35:49 Begin Action : CloseEventLog

    14:35:49 Could not de-register the event source : [6]

    14:35:49 End Action : CloseEventLog

Viewing 13 posts - 1 through 12 (of 12 total)

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