Cannot create a new database. The operation has been rolled back.


H

hammtech

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.

Does anyone know how to get this thing to work?
 
Ad

Advertisements

L

Luther

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.

Does anyone know how to get this thing to work?

Have you tried turning on BCM logging in the BCM About dialog?
Sometimes that log has an indication of what problem is.
 
Ad

Advertisements

H

hammtech

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 Setting database option RECOVERY to
RECMODEL_70BACKCOMP for database LocalCRM.
2008-09-03 17:34:47.64 spid51 Setting database option RECOVERY to
RECMODEL_70BACKCOMP for database LocalCRM.
2008-09-03 17:34:47.64 spid51 Setting database option
TORN_PAGE_DETECTION to ON for database LocalCRM.
2008-09-03 17:34:47.67 spid51 Setting database option READ_WRITE to ON
for database LocalCRM.
2008-09-03 17:34:47.67 spid51 Setting database option AUTO_SHRINK to
OFF for database LocalCRM.
2008-09-03 17:34:47.67 spid51 Setting database option ANSI_NULL_DEFAULT
to OFF for database LocalCRM.
2008-09-03 17:34:47.68 spid51 Setting database option
RECURSIVE_TRIGGERS to OFF for database LocalCRM.
2008-09-03 17:34:47.68 spid51 Setting database option ANSI_NULLS to OFF
for database LocalCRM.
2008-09-03 17:34:47.68 spid51 Setting database option
CONCAT_NULL_YIELDS_NULL to OFF for database LocalCRM.
2008-09-03 17:34:47.68 spid51 Setting database option
CURSOR_CLOSE_ON_COMMIT to OFF for database LocalCRM.
2008-09-03 17:34:47.68 spid51 Setting database option CURSOR_DEFAULT to
GLOBAL for database LocalCRM.
2008-09-03 17:34:47.70 spid51 Setting database option QUOTED_IDENTIFIER
to OFF for database LocalCRM.
2008-09-03 17:34:47.70 spid51 Setting database option ANSI_WARNINGS to
OFF for database LocalCRM.
2008-09-03 17:34:47.70 spid51 Setting database option
AUTO_CREATE_STATISTICS to ON for database LocalCRM.
2008-09-03 17:34:47.70 spid51 Setting database option
AUTO_UPDATE_STATISTICS to ON for database LocalCRM.
2008-09-03 17:34:55.85 spid52 Setting database option SINGLE_USER to ON
for database LocalCRM.


I am tempted to just create the database manually, but this will be a live
production environment as well as my first time using BCM, so I want to go
the approved Microsoft route - but for some reason it just doesn't work.

I've seen lots of people with this issue, just can't find a solution - could
it be that everyone just gives up and uses another product?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top