Database creation fails

[LionNet]

I've installed the Office 2007 beta fine and the Outlook/BCM too. Starting
Outlook brings up database creation but every attempt fails. It start up the
process (after selecting the express option) but fails with error "Database
creation unsuccessful." Any suggestions?

 

[SusanG]

I've had so many install and DB creation issues with Beta 2007, but this
might help -I think I had your issue (of the many I've experienced), and I
made a note to Self that this worked:
Assuming SQL installed OK and service MICROSOFTSMLBIZ instance is running,
and you have the BCM Folder structure installed (mine installed by default to
C:\Program Files\Microsoft Small Business\Business Contact Manager) -

I went into SQL Server and changed the service startup to use the same
account as I was logged in as when I installed the Beta (which is in Admin
group) then re-started service.

Went back to Outlook and attempted to create a DB and poof! it worked!
strange, but true!

 

[LionNet]

Thanks SO much! It was setup to log in under Network Service, and I actually
changed it to Local Service (rather than a specific admin user account) and
that took care of it.

 

[Luther]

These sound like symptoms of the security changes in sql server etc.

If changing the sql service user to yourself fixed the problems, then
there's a bug in the beta where the service cannot create the db file
in a user folder.

Changing user to Local Service will also work because Local Service is
effectively the same as administrator. That does present a security
risk in that if a user can take control of sql, they then have control
of the entire machine.

 

[LionNet]

All correct, Luther, and not a good/permanent fix. But I'll live with it
(just on my notebook) until MS fixes the problem.

 

[Clinton Ford [MSFT]]

Allowing SQL Server to run as ‘LOCAL SYSTEM’ is not recommended.

A better alternative is to use the following steps:

Windows XP
--------------
1.) Show hidden folders by doing the following:
a.) Open Windows Explorer and select "Tools | Folder Options..." from
the menu
b.) Click the "View" tab and make sure that "Show hidden files and
folders" is selected
c.) Click "OK"
2.) Click on the "My Computer" link in the left-hand navigation pane of
Windows Explorer
3.) Navigate to the following folder, where <user> is your XP user name:
C:\Documents and Settings\<user>\Local Settings\Application Data\Microsoft
4.) Right-click on the "Business Contact Manager" folder and select
"Properties"
5.) Select the "Security" tab
6.) If "NETWORK SERVICE" is not listed in the "Group or user names:" list,
click "Add..."
7.) Type "Network Service" and click "Check Names" to ensure the name
resolves correctly. If it resolves correctly, you'll see the text change to
all uppercase and underlined.
8.) Click "OK"
9.) Select "NETWORK SERVICE" from the list of users and check the following
permissions:
a.) Read
b.) Write

Windows Vista

 

[GGatWork]

Thanks - it worked. Running Outlook 2007 on Vista and couldn't get BCM to
install. But made changes you outlined and finally installed. Thanks for
the the detailed easy to follow info

 

[SLMilo]

I have followed these instructions, but there is NO "security" tab!
Running fresh WIN XP install with all updates
Downloaded trial Office 2007 SBE
Trying to install BCM but database creation fails

I cannot evaluate the product for purchase in our office if I can't even get
it to run!

 

[GolfGal]

This has not been answered, and I have the same issue. I am operating on
Windows XP Home Edition and not on a server. There is no security tab, and
BCM gets the 'can't create' error when trying to load.

Can someone help?

Thanks

 

[GolfGal]

I found my answer. Just in case some else has this issues, below is what I
found. I am on a local service and the properties listed network. I changed
and it works great!

The Microsoft SQL Server is not available

Your Business Contact Manager database uses Microsoft SQL Server Express, a
lightweight version of Microsoft SQL Server. If the SQL Server is not
available, you cannot create a database.

To start the SQL Server, do the following in Windows Vista:

Click the Start button, and then click All Programs.
Click Microsoft SQL Server 2005, point to Configuration Tools, and then
click SQL Server Configuration Manager.
In the SQL Server Configuration Manager, window, click SQL Server 2005
Services, right-click SQL Server (MSSMLBIZ), and then click Start.
Re-open Microsoft Office Outlook. You should now be able to connect to the
Business Contact Manager database.