It seems I need to install a named instance of SQL (in addition to the default instance already installed) for Windows Server Update Services. But all the install instructions I have found are for using the SBS wizard during the original setup. How do I now install a second instance? do I just run the SETUP.BAT, or AUTORUN.EXE from the SQL2000 folder on SBS disk 2? And I assume that would give me an opportunity to name an instance. (It's been so long since I did the original install I don't even remember for sure how I did that.)

 

Thanks,

Dave

You should be able to install a second instance the way you describe.

OK, I've tried it twice and failed both times, but I can't figure out why. It seems to go through the whole process of installing successfully, then when it tries to start the database it fails, and then seems to uninstall itself. If someone can decipher these error logs better than I can, and tell me where I'm going wrong I would appreciate it. I tried once letting it install as the Local System account, and once with Administrator's credentials, but neither worked.

 

Also, in the process of Google-ing the SBS2k, SQL2k, and WSUS newsgroups, I found several accounts of successfully installing MSDE instance on SBS2k with SQL already installed, would it be easier to take that route to enable WSUS as to install another instance of the full SQL2k?

 

Thanks for any help anyone can provide

Dave

 

The MSSQL$WSUS\LOG\ERRORLOG ends with :

 

2006-04-16 23:52:34.98 server    SQL Server is ready for client connections
2006-04-16 23:52:35.14 spid5     Starting up database 'tempdb'.
2006-04-16 23:52:35.21 spid3     Recovery complete.
2006-04-16 23:52:35.25 spid3     Warning: override, autoexec procedures skipped.
2006-04-16 23:54:18.81 spid3     SQL Server is terminating due to 'stop' request from Service Control Manager.

and the WINNT\sqlstp.log ends with (sorry about taking up so much space, but I'm not sure how much of the info is relevant.)

 

###############################################################################

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=DUDE\WSUS;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][DBMSLPCN]SSL Security error

[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (SECDoClientHandshake()).

driver={sql server};server=DUDE\WSUS;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][DBMSLPCN]SSL Security error

[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (SECDoClientHandshake()).

driver={sql server};server=DUDE\WSUS;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][DBMSLPCN]SSL Security error

[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (SECDoClientHandshake()).

SQL Server configuration failed.

###############################################################################

23:54:33 Process Exit Code: (-1)
23:54:41 Setup failed to configure the server.   Refer to the server error logs and C:\WINNT\sqlstp.log for more information.
23:54:44 Action CleanUpInstall:
23:54:44 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe  -Silent 1 -Action 4 -Service SQLAgent$WSUS
23:54:44 Process Exit Code: (1060) The specified service does not exist as an installed service.

23:54:44 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe  -Silent 1 -Action 4 -Service MSSQL$WSUS
23:54:44 Process Exit Code: (0)
23:54:44 StatsGenerate returned: -1
23:54:44 StatsGenerate (0x88008225,0x1,0xf000,0x400,1033,303,0x0,0x1,0,0,0
23:54:44 StatsGenerate -1,administrator)
23:54:44 Installation Failed.

Hi Dave,

 

When you installed the instance for SQL 2000, did you also apply SP4 to it before installing WSUS?

Marina,

 

I never did get it installed. The installer appearantly deleted everything as it was shutting down, and left nothing but an empti directory. After the third failure and not being able to find out what was wrong, I finally decided to try MSDE. That was the one big issue I had heard of using WSUS on a SBS2k, was problems installing MSDE on a SBS with SQL running, but it worked for me the first time, and now WSUS is up and running just fine. And yes, I did upgrade MSDE to SP4.

 

Thanks,

Dave