Cannot create a new database. The operation has been rolled back. Please make
sure the database service is running.

I have been pulling my hair out trying to figure out how to get BCM for
Outlook 2007 Admin tool to create its database on a Windows 2003 Standard
Edition Server w SP 2 and all windows updates using SQL Server Express 2005 -
also patched to the latest level.

I have been able to find references to people who are having the same issue,
just have not been able to find a solution.

I have removed SQL Express and re-installed it with the istance name of
MSSMLBIZ. I have made sure that TCP is enables and set to port 5356 - there
is no firewall blocking the port. All services are running, and have been
restarted numerous times. The event log logs no errors when the BCM admin
tool fails and I can find no BCM log that tells me why it thinks it is
failing and rolling back. I can create a database using Managment Studio
Express with no problem at all.

I've looked for some sort of step by step instructions that I should be
following, but I've found nothing. I would have thrown in the towel a long
time ago, but I actually told my client that they can use this system after
verifying that they could run it from a server based database.

On Sep 1, 11:39 pm, hammtech discussions.microsoft.com>
wrote:

I don't have BCM installed on the Server, I have the BCM Database Admin Tool
on the server and it will not sucessfully create the database, no matter what
I do.

In the application log the last event I get when I try is :

Setting database option SINGLE_USER to ON for database localCRM.

This is just an information log, there are no errors or warnings logged. For
some reason it rolls back and removes the database - extreamly frustrating.

I do a search on all local drives for *.log and there is noting to be found
by name or date and time modified.

I did look at the SQL errorlog , and there is nothing reportrd as being an
error- the last entry is the same as the one in the event log. Here is the
contents from the error log at the time it was attempting to create the
database:

2008-09-03 17:34:47.31 spid51 Starting up database 'LocalCRM'.
2008-09-03 17:34:47.40 spid51 Setting database option AUTO_CLOSE to OFF
for database LocalCRM.
2008-09-03 17:34:47.62 spid51 ...