BCM 2007: Cannot open local BCM database, but it is created fine .

[Paul @ Blue Ivy]

HI,

I previously had BCM running connected to a shared database on the SBS
server. It was causing Ootlook to freeze and was very slow, so I decided that
a local database would be better. I uninstalled BCM 2007 last week and left
it until today to prove that it was BCM causing the problem.

Today I decided to install BCM and create a local database. I also have
Microsoft SBA 2007 installed. The install went fine. I chose the Advanced
install and asked it to create a database locally. The progress bar went all
the way up and the dataqbase looked like it created fine, however teh wizard
then went back to te start. I chose Advanced again and created a database -
this time it was called MSSmallBusiness2. It did the same again (progress bar
tot he top and then went to the start of the wizard again).

I again chose the Advanced option, but this time I chose the local machine
and clicked Connect. It picked up the two previous databases created
(MSSmallBusiness and MSSmallBusiness2). I chose one of them and clicked Next
and got the error:

===
An unknown error occurred while connecting to the database. Please click
Retry. If the error recurs, click Help.
===

Help isn't any use.

I checked EventViewer on the local PC and there are a lot of entries in
there for BCM, but they are all informational and about the parameters it's
set on the created databases.

I also check SQL 2005 (it's installed for SBA 2007) and it looks like the
only instance is MSSMLBIZ and that's where it'll be creating the databases.
TCPIP wasn't enabled in the protocols so I did that just in case, but it's
the same problem.

Finally, I also checked that the SQL Service account for MSSMLBIZ had the
necessary permissions to the folder that the MSSmallBusiness databases are
stored in and it did.

I'm out of ideas. Anybody?

 

[Luther]

HI,

I previously had BCM running connected to a shared database on the SBS
server. It was causing Ootlook to freeze and was very slow, so I decided that
a local database would be better. I uninstalled BCM 2007 last week and left
it until today to prove that it was BCM causing the problem.

Today I decided to install BCM and create a local database. I also have
Microsoft SBA 2007 installed. The install went fine. I chose the Advanced
install and asked it to create a database locally. The progress bar went all
the way up and the dataqbase looked like it created fine, however teh wizard
then went back to te start. I chose Advanced again and created a database -
this time it was called MSSmallBusiness2. It did the same again (progress bar
tot he top and then went to the start of the wizard again).

I again chose the Advanced option, but this time I chose the local machine
and clicked Connect. It picked up the two previous databases created
(MSSmallBusiness and MSSmallBusiness2). I chose one of them and clicked Next
and got the error:

===
An unknown error occurred while connecting to the database. Please click
Retry. If the error recurs, click Help.
===

Help isn't any use.

I checked EventViewer on the local PC and there are a lot of entries in
there for BCM, but they are all informational and about the parameters it's
set on the created databases.

I also check SQL 2005 (it's installed for SBA 2007) and it looks like the
only instance is MSSMLBIZ and that's where it'll be creating the databases.
TCPIP wasn't enabled in the protocols so I did that just in case, but it's
the same problem.

Finally, I also checked that the SQL Service account for MSSMLBIZ had the
necessary permissions to the folder that the MSSmallBusiness databases are
stored in and it did.

I'm out of ideas. Anybody?

--
Kind regards,

Paul
Blue Ivy Ltd (http://www.blueivy.co.uk)

Can you connect to the new database outside of BCM?

Try running this command:
sqlcmd -E -S .\MSSMLBIZ -d MSSmallBusiness

If you get a prompt, type "exit" to get out.

If you get an error message, that might provide a clue.

 

[Paul @ Blue Ivy]

Thanks for that ... looks like we're making progress. Error is:

===
Msg 4060, Level 11, State 1, Server BLUWKSHIG002\MSSMLBIZ, Line 1
Cannot open database "MSSmallBusiness" requested by the login. The login
failed.

Msg 18456, Level 14, State 1, Server BLUWKSHIG002\MSSMLBIZ, Line 1
Login failed for user 'BLUEIVY\paul.broadwith'.
===

No I'm confused as the database was created okay, how did I have permission
to create but not to access the database.

I have checked the file permission on the 'Business Contact Manager' where
the databases re stored, however I think this error will be database
permissions rather than file permissions.

I don't know how to alter the database permissions in SQL.

Suggestions?

 

[Luther]

Thanks for that ... looks like we're making progress. Error is:

===
Msg 4060, Level 11, State 1, Server BLUWKSHIG002\MSSMLBIZ, Line 1
Cannot open database "MSSmallBusiness" requested by the login. The login
failed.

Msg 18456, Level 14, State 1, Server BLUWKSHIG002\MSSMLBIZ, Line 1
Login failed for user 'BLUEIVY\paul.broadwith'.
===

No I'm confused as the database was created okay, how did I have permission
to create but not to access the database.

I have checked the file permission on the 'Business Contact Manager' where
the databases re stored, however I think this error will be database
permissions rather than file permissions.

I don't know how to alter the database permissions in SQL.

Suggestions?
--
Kind regards,

Paul
Blue Ivy Ltd (http://www.blueivy.co.uk)









- Show quoted text -

There are several ways to proceed. Here's my suggestion:

Get Microsoft SQL Server Management Studio Express
http://www.microsoft.com/downloads/...AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

Once installed run it; on Vista run as administrator.
Connect to BLUWKSHIG002\MSMSLBIZ, using Windows Authentication.
Find database MSSmallBusiness and right click on it, Properties.
In the General folder, look at property Owner.

If it is not your login, that's your problem. Taking ownership of the
database should fix your problem. You need to run, in your database,
the sql command: sp_changedbowner 'paul.broadwith'. Right click on the
database and select New Query to enter and run the command.

If you already own the database, then further diagnostics are
necessary.

 

[Paul @ Blue Ivy]

Okay, installed Management Studio Express.

Tried to open the database and I was getting FILE access denied errors. I
went to the BCM folder and gave Network Service Full Control (everybody else
had Full Control so it was the only thing left to do).

I looked in the General tab under properties and I am the owner.

I was then able to view the database. Whenever I click on Database Diagrams
I get the error:

===
Database diagram support objects cannot be installed because this database
does not have a valid owner. To continue, first use the Files page of the
Database Properties dialog box or the ALTER AUTHORIZATION statement to set
the database owner to a valid login, then add the database diagram support
objects.
===

I know you didn't ask me to do this, however I thought it worth mentioning.
I have also done what the error said (in the Files tab) but it's not made any
difference.

I have also deleted the BCM folder and started again - still EXACTLY the
same error from BCM.

 

[Luther]

Okay, installed Management Studio Express.

Tried to open the database and I was getting FILE access denied errors. I
went to the BCM folder and gave Network Service Full Control (everybody else
had Full Control so it was the only thing left to do).

I looked in the General tab under properties and I am the owner.

I was then able to view the database. Whenever I click on Database Diagrams
I get the error:

===
Database diagram support objects cannot be installed because this database
does not have a valid owner. To continue, first use the Files page of the
Database Properties dialog box or the ALTER AUTHORIZATION statement to set
the database owner to a valid login, then add the database diagram support
objects.
===

I know you didn't ask me to do this, however I thought it worth mentioning.
I have also done what the error said (in the Files tab) but it's not made any
difference.

I have also deleted the BCM folder and started again - still EXACTLY the
same error from BCM.

--
Kind regards,

Paul
Blue Ivy Ltd (http://www.blueivy.co.uk)










- Show quoted text -

Tried to open the database and I was getting FILE access denied errors.

Did you run Sql Studio as admin? This only applies on Vista.

I looked in the General tab under properties and I am the owner.

Have you deleted and re-added your login recently?

The reason I ask is because windows uses a unique systen id for users,
and the name is just a display property.

A login may have:
sid: 1E623BFB-3C8B-4E5E-8F44-592BB3E94745
name: LutherB

I can delete that login, and add LutherB again, and Windows will
generate a new, different, id.

So, Sql Studio may show the database owner as: LutherB.

But under the covers Sql and Windows are using the id and not the name
to check for permissions, and the database may have the dbo set to the
old id.

Create a new database.
Run this command on the new database and your bcm database:
select sid from sysusers where name = 'dbo'

If they don't match, try updating the bcm database's sysusers table's
dbo record's sid field to the value in the new database.

If they do match, then I don't know why BCM won't recognize new
databases.

You could try turning on logging from the BCM About dialog box and
examining the log right after it fails to create and connect to a new
database.

As an alternative, create a new user. Login in as that user, run
Outlook (you don't need to connect it to an email system), and try to
create a new bcm database. If it creates and connect to a new
database, then the problem is related to your regular login. If it
also fails for the new user, then there's a problem with the way BCM
or Sql are installed.