|
- Subject: RE: Outlook Business Contact Manager Database tool question
- Author: Richard Johansson, Parnasso
- Date: 20 Jul 2008
- References: 1 2
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!
"goughj" wrote:
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!
"goughj" wrote:
> 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" wrote:
>
> 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" wrote:
>
> > 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?
> > 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?
| 18 Jul 2008 | Outlook Business Contact Manager Database tool question | .Richard Johansson, Pa... |
| 20 Jul 2008 |  RE: Outlook Business Contact Manager Database tool question | .goughj |
| 20 Jul 2008 |  RE: Outlook Business Contact Manager Database tool question | .Richard Johansson, Pa... |
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)
All times are in (US) Eastern Daylight Time (GMT -4:00)