Question Locked

SBS03 SP2; SQL Server 2k upgrade to 05 SP2 help please

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Please advise how to get my sbs system updated to SQL Server 2005 SP2 so I can run the BCM Database Tool and get it setup for Outlook 2007 Business Contact Manager.

Details:
I have sbs03 which was automatically upgraded to SP2. I'm trying to install MS Outlook Business contact Manager 2007 on a client which requires SQL Server 2005 SP2 for the database. In the document I using to setup the database, "Depoloying Outlook w BCM in a Remote configuration (bcm_sql.doc)" it says it works with SBS 03 R2 Std or Prem. I think I understand from other reading that SBS SP2 was supposed to upgrade the instance of SQL sErver to 05
but it doesn't seem to have. I cannot upgrade it to 05 SP2, nor can I use the "BCM DataBase Tool" on the server as it says I don't have a valid version of the db.

Thanks,

Bryan

6 replies

by bulk3

Got it to download, but couldn't apply. I then installed from CD SQL 2005 and upgraded to SP2 no prob. Now I'm running the db tool and it can't create the db. "Cannot create a new database. The operation has been rolled back. Please make sure the database service is running". It appears to be running.

B.

by cg it

go into services find SQL DB service, check to make sure it's set to automatic. stop then restart the service.

by bulk3

Tried that but there isn't a service exactly named that. I also tried rebooting. I also started/stopped from the icon in the system tray. After restarting I tried the BCM db tool again and got the same error msg as before, in the title. I can connect to the instance using SQL Server Management Studio. I also can manually create a db in that tool.

The services I have listed that look like sql are:
MSSQL$SBSMONITORING Started Automatic
MSSQL$SHAREPOINT Started Automatic
MSSQLSERVER Started Automatic
MSSQLServerOLAPService Started Automatic
SQL Server (MSSMLBIZ) Started Automatic
SQL Server Active Directory Helper ... Manual
SQL Server Agent (MSSMLBIZ) Started (by me) Manual
SQL Server Analysis Services (MSSMLBIZ) Started Automatic
SQL Server Browser Started Automatic
SQL Server FullText Search Started Automatic
SQL Server Integration Services STarted Automaic
SQL Server Reporting services (MSSMLBIZ) Started Automatic
SQL server VSS Writer Started Automatic
SQLAgent$SBSMONITORING ... Automatic
SQLAgent$SHAREPOINT ... Manual
SQLSERVERAGENT ... Manual

by bulk3

Ok. Another idea. Someone else has suggested I might just rebuild and I'm thinking it might be a good idea anyway since I was given this box for one thing, Setup a shared BCM database. This now generates the question, "given this box with SBS on it that's not used for anything else. I ONLY want to share a BCM db. If I rebuild the box, what's my
best approach? Should I install SBS 03 R2 or Windows Server 2003 R2 &SQL Server 2005 SP2?

This discussion is closed to new replies.