Outlook Business Contact Manager Database tool question

[Richard Johansson, Parnasso]

Hi!
I have a question regarding the sharing tool that can be used to share a SQL
or SQL Express database to be used with a BCM environment. I have got the SQL
Express Edition installed on an SBS. The SBS has been used for quite a while
with the BCM Database and has primarily been used by one user only.

In the situation being, there is now need to add yet another user to be able
to use the database. If I use the Business Contact Manager for Outlook 2007
Database Tool on the SBS to share the database in question, I get the
information that the user account does not have sufficient permissions to
grant a user login rights to the database. When logging in to the SBS over a
Remote Desktop, I have used the built in Administrator account and hence I
had hoped for such problems to disappear. Nevertheless when I try to use the
sharing function for a specific user in the AD, I get the error message as
follows:

The current user does not have permission to grant other users permission to
connect to the SQL Server. Please give the current user grantlogin privilege
on the SQL Server.

How do I work around this? Is there a way to give a SBS Mobile User access
to this database? If it is, then how do I do it?

 

[goughj]

You might check on where the database is located. I use a shared folder
created in the Server Management Wizard Shares as a sub folder to Users....
Add the user group or specific users and permissions to this location. Using
SQL Server detach the database and move it to the share folder and then
attach the database. Make sure you include the log file (.mdf and .ldf
files).

The message you are receiving has to do with the application permissions
versus the data permissions.

Contact me if you still have issues ...

Jody

 

[Richard Johansson, Parnasso]

Hi goughj!
I have tried to locate a way to see where I do have the database, but since
I am being quite new to all this "stuff" with database management, I would
very much appreciate some guidance as to how I:

1. Locate the files that you are talking about.
2. Detach and then re-attach the database
3. Make sure that I don't lose any data on the way.

Thank you!