BCM Database and SQL Server Issues?

Status
Not open for further replies.
J

Jeff

Hi,

This is a follow-up question to one that I wrote last night concerning using

the .mdf and .ldf files from a previous installation of BCM to get most of my

data back.

I have received an error which states "Unable to open the physical file....

> .mdf. Operating system error 5: "5(Access is denied)" when I attempt to

troubleshoot the problem from within Outlook.

I remember when I logged on the backup image file to mount the backup on the

external hard drive, and then copy the two files above from the image file to

a location on the local hard drive, a window pops up that states that I will

need to provide administrator permission to copy each file. I click continue,

and it is copied.

If I look at the security section of the properties window for each file, I

see that there is an entry for

"SQLServer2005MSSQLUser$NewTechFX530$MSSMLB1(NewTech....)" on the files which

are part of the image backup file. But, when I copy the files over to my

current boot drive, there is no longer a reference to that group or user

name. (The groups and user names listed are: "SYSTEM", "NETWORK SERVICE",

"Jeff (NewTechFX530\Jeff)" and "Administrators (NewTechFX530\Administrators".

I am trying to muddle my way through this... so pardon my thought process if

it is wrong. Based upon the fact that SQL is not referenced in the copied

group or user names, should I be doing something with SQL to add it to get

these files to work on this system? (It is the same system, I just restored

the boot drive from a much older backup image. The computer name and the

permissions should all be the same.)

Thanks in advance for any help that can be offered.

Jeff
 
On Jul 5, 7:06 am, Jeff <J...> wrote:
> Hi,

> This is a follow-up question to one that I wrote last night concerning using
> the .mdf and .ldf files from a previous installation of BCM to get most of my
> data back.

> I have received an error which states "Unable to open the physical file.....
> .mdf. Operating system error 5: "5(Access is denied)" when I attempt to
> troubleshoot the problem from within Outlook.

> I remember when I logged on the backup image file to mount the backup on the
> external hard drive, and then copy the two files above from the image file to
> a location on the local hard drive, a window pops up that states that I will
> need to provide administrator permission to copy each file. I click continue,
> and it is copied.

> If I look at the security section of the properties window for each file,I
> see that there is an entry for
> "SQLServer2005MSSQLUser$NewTechFX530$MSSMLB1(NewTech....)" on the files which
> are part of the image backup file. But, when I copy the files over to my
> current boot drive, there is no longer a reference to that group or user
> name. (The groups and user names listed are: "SYSTEM", "NETWORK SERVICE",
> "Jeff (NewTechFX530\Jeff)" and "Administrators (NewTechFX530\Administrators".

> I am trying to muddle my way through this... so pardon my thought processif
> it is wrong. Based upon the fact that SQL is not referenced in the copied
> group or user names, should I be doing something with SQL to add it to get
> these files to work on this system? (It is the same system, I just restored
> the boot drive from a much older backup image. The computer name and the
> permissions should all be the same.)

> Thanks in advance for any help that can be offered.

> Jeff


Generally, with BCM 2007 and Sql Server 2005, the sql instance/bcm

database runs as built-in user Network Services, so user Network

Services needs to have permission (full control) to access the mdf

file.
 
Hi Luther,

I believe that your suggestion regarding permissions to the NETWORK

SERVICES, I changed the permissions on both the .mdf and .ldf files to allow

Full Control.

(In case anyone else is searching for an answer to this problem, the

following is the order in which I worked to restore this database:

1. Start Outlook

2. Open Business Contact Manager

3. Select Manage Databases

4. Create New Database

5. Close Out of Outlook

6. Stop the SQL Service for MSSMLBIZ

7. Change the permissions for NETWORK SERVICES on the .ldf and .mdf files

which have the data desired for access by BCM.

8. Rename the .ldf and .mdf files for the new database created in 4. above

to something different.

9. Rename the .ldf and .mdf files for the "good data" to the database name

created in 4. above.

10. Start the SQL Service for MSSMLBIZ.

11. Start Outlook

12. Click the Business Contact Manager Pull-Down

13. Select Manage Database

With everything above completed, the database should be listed. I hope this

helps. Also, please forgive me if it doesn't work exactly the same for

everyone. The NETWORK SERVICES that Luther mentioned are about the only thing

I didn't try... in the order listed above. I did change the permissions

earlier in my troubleshooting; but, I think it was after I had started the

SQL service.)

Once I confirmed the good contact information, the first thing I did was

generate a backup.

Thanks again for your help, and for taking the time to point me in the right

direction.

Take Care

Jeff

"Luther Blissett" wrote:


> On Jul 5, 7:06 am, Jeff <J...> wrote:
> > Hi,
> > This is a follow-up question to one that I wrote last night concerning using
> > the .mdf and .ldf files from a previous installation of BCM to get most of my
> > data back.
> > I have received an error which states "Unable to open the physical file.....
> > .mdf. Operating system error 5: "5(Access is denied)" when I attempt to
> > troubleshoot the problem from within Outlook.
> > I remember when I logged on the backup image file to mount the backup on the
> > external hard drive, and then copy the two files above from the image file to
> > a location on the local hard drive, a window pops up that states that I will
> > need to provide administrator permission to copy each file. I click continue,
> > and it is copied.
> > If I look at the security section of the properties window for each file, I
> > see that there is an entry for
> > "SQLServer2005MSSQLUser$NewTechFX530$MSSMLB1(NewTech....)" on the files which
> > are part of the image backup file. But, when I copy the files over to my
> > current boot drive, there is no longer a reference to that group or user
> > name. (The groups and user names listed are: "SYSTEM", "NETWORK SERVICE",
> > "Jeff (NewTechFX530\Jeff)" and "Administrators (NewTechFX530\Administrators".
> > I am trying to muddle my way through this... so pardon my thought process if
> > it is wrong. Based upon the fact that SQL is not referenced in the copied
> > group or user names, should I be doing something with SQL to add it to get
> > these files to work on this system? (It is the same system, I just restored
> > the boot drive from a much older backup image. The computer name and the
> > permissions should all be the same.)
> > Thanks in advance for any help that can be offered.
> > Jeff


> Generally, with BCM 2007 and Sql Server 2005, the sql instance/bcm
> database runs as built-in user Network Services, so user Network
> Services needs to have permission (full control) to access the mdf
> file.
>
 
Hi,

I encountered an almost identical scenario - i upgraded my box to windows 7

and forgot to backup my BCM db. Now, I have followed the instructions in

this thread - from my windows.old copy of the .mdf and .ldf.

However, the database still gives me permission issues (as the local user

with admin permissions).

Any futher thoughts on how to simply restore my previous .mdf and .ldf? My

new .mdf and .ldf are empty - i just want to populate the data.

"Jeff" wrote:


> Hi Luther,

> I believe that your suggestion regarding permissions to the NETWORK
> SERVICES, I changed the permissions on both the .mdf and .ldf files to allow
> Full Control.

> (In case anyone else is searching for an answer to this problem, the
> following is the order in which I worked to restore this database:

> 1. Start Outlook
> 2. Open Business Contact Manager
> 3. Select Manage Databases
> 4. Create New Database
> 5. Close Out of Outlook
> 6. Stop the SQL Service for MSSMLBIZ
> 7. Change the permissions for NETWORK SERVICES on the .ldf and .mdf files
> which have the data desired for access by BCM.
> 8. Rename the .ldf and .mdf files for the new database created in 4. above
> to something different.
> 9. Rename the .ldf and .mdf files for the "good data" to the database name
> created in 4. above.
> 10. Start the SQL Service for MSSMLBIZ.
> 11. Start Outlook
> 12. Click the Business Contact Manager Pull-Down
> 13. Select Manage Database

> With everything above completed, the database should be listed. I hope this
> helps. Also, please forgive me if it doesn't work exactly the same for
> everyone. The NETWORK SERVICES that Luther mentioned are about the only thing
> I didn't try... in the order listed above. I did change the permissions
> earlier in my troubleshooting; but, I think it was after I had started the
> SQL service.)

> Once I confirmed the good contact information, the first thing I did was
> generate a backup.

> Thanks again for your help, and for taking the time to point me in the right
> direction.

> Take Care

> Jeff

> "Luther Blissett" wrote:
>
> > On Jul 5, 7:06 am, Jeff <J...> wrote:
> > > Hi,
> > > > This is a follow-up question to one that I wrote last night concerning using
> > > the .mdf and .ldf files from a previous installation of BCM to get most of my
> > > data back.
> > > > I have received an error which states "Unable to open the physical file.....
> > > .mdf. Operating system error 5: "5(Access is denied)" when I attempt to
> > > troubleshoot the problem from within Outlook.
> > > > I remember when I logged on the backup image file to mount the backup on the
> > > external hard drive, and then copy the two files above from the image file to
> > > a location on the local hard drive, a window pops up that states that I will
> > > need to provide administrator permission to copy each file. I click continue,
> > > and it is copied.
> > > > If I look at the security section of the properties window for each file, I
> > > see that there is an entry for
> > > "SQLServer2005MSSQLUser$NewTechFX530$MSSMLB1(NewTech....)" on the files which
> > > are part of the image backup file. But, when I copy the files over to my
> > > current boot drive, there is no longer a reference to that group or user
> > > name. (The groups and user names listed are: "SYSTEM", "NETWORK SERVICE",
> > > "Jeff (NewTechFX530\Jeff)" and "Administrators (NewTechFX530\Administrators".
> > > > I am trying to muddle my way through this... so pardon my thought process if
> > > it is wrong. Based upon the fact that SQL is not referenced in the copied
> > > group or user names, should I be doing something with SQL to add it to get
> > > these files to work on this system? (It is the same system, I just restored
> > > the boot drive from a much older backup image. The computer name and the
> > > permissions should all be the same.)
> > > > Thanks in advance for any help that can be offered.
> > > > Jeff

> > Generally, with BCM 2007 and Sql Server 2005, the sql instance/bcm
> > database runs as built-in user Network Services, so user Network
> > Services needs to have permission (full control) to access the mdf
> > file.
> >
 
Hi Kurt,

The method that I described worked for me, although I still have an issue

with the installation.

One other factor that may have allowed BCM to work once the good data files

were renamed to the name of the newly created empty database, was that I

changed the permission for NETWORK SERVICES for the .ldf and .mdf files

BEFORE I renamed them and attempted to open them with BCM. I changed them to

"Full Control/Modify/Read/Execute". (Luther had previously suggested looking

at the permissions; I just wasn't sure what I was doing exactly.)

When I restart Vista, and then start Outlook with BCM, I get a message when

Vista starts stating the following: "Business Contact Manager for Outlook

could not connect to the shared database. Do you want to work offline." I

choose "No". Outlook then opens without a BCM drop-down.

I then shutdown Outlook and restart. When Outlook restarts, there are no

message windows, and the BCM database that I restored in the manner described

in my previous post works.

I hope this helps. It would be great if you could let me know, too.

"Kurt" wrote:


> Hi,

> I encountered an almost identical scenario - i upgraded my box to windows 7
> and forgot to backup my BCM db. Now, I have followed the instructions in
> this thread - from my windows.old copy of the .mdf and .ldf.

> However, the database still gives me permission issues (as the local user
> with admin permissions).

> Any futher thoughts on how to simply restore my previous .mdf and .ldf? My
> new .mdf and .ldf are empty - i just want to populate the data.

> "Jeff" wrote:
>
> > Hi Luther,
> > I believe that your suggestion regarding permissions to the NETWORK
> > SERVICES, I changed the permissions on both the .mdf and .ldf files to allow
> > Full Control.
> > (In case anyone else is searching for an answer to this problem, the
> > following is the order in which I worked to restore this database:
> > 1. Start Outlook
> > 2. Open Business Contact Manager
> > 3. Select Manage Databases
> > 4. Create New Database
> > 5. Close Out of Outlook
> > 6. Stop the SQL Service for MSSMLBIZ
> > 7. Change the permissions for NETWORK SERVICES on the .ldf and .mdf files
> > which have the data desired for access by BCM.
> > 8. Rename the .ldf and .mdf files for the new database created in 4. above
> > to something different.
> > 9. Rename the .ldf and .mdf files for the "good data" to the database name
> > created in 4. above.
> > 10. Start the SQL Service for MSSMLBIZ.
> > 11. Start Outlook
> > 12. Click the Business Contact Manager Pull-Down
> > 13. Select Manage Database
> > With everything above completed, the database should be listed. I hope this
> > helps. Also, please forgive me if it doesn't work exactly the same for
> > everyone. The NETWORK SERVICES that Luther mentioned are about the only thing
> > I didn't try... in the order listed above. I did change the permissions
> > earlier in my troubleshooting; but, I think it was after I had started the
> > SQL service.)
> > Once I confirmed the good contact information, the first thing I did was
> > generate a backup.
> > Thanks again for your help, and for taking the time to point me in the right
> > direction.
> > Take Care
> > Jeff
> > "Luther Blissett" wrote:
> >
> > > On Jul 5, 7:06 am, Jeff <J...> wrote:
> > > > Hi,
> > > > > > This is a follow-up question to one that I wrote last night concerning using
> > > > the .mdf and .ldf files from a previous installation of BCM to get most of my
> > > > data back.
> > > > > > I have received an error which states "Unable to open the physical file.....
> > > > .mdf. Operating system error 5: "5(Access is denied)" when I attempt to
> > > > troubleshoot the problem from within Outlook.
> > > > > > I remember when I logged on the backup image file to mount the backup on the
> > > > external hard drive, and then copy the two files above from the image file to
> > > > a location on the local hard drive, a window pops up that states that I will
> > > > need to provide administrator permission to copy each file. I click continue,
> > > > and it is copied.
> > > > > > If I look at the security section of the properties window for each file, I
> > > > see that there is an entry for
> > > > "SQLServer2005MSSQLUser$NewTechFX530$MSSMLB1(NewTech....)" on the files which
> > > > are part of the image backup file. But, when I copy the files over to my
> > > > current boot drive, there is no longer a reference to that group or user
> > > > name. (The groups and user names listed are: "SYSTEM", "NETWORK SERVICE",
> > > > "Jeff (NewTechFX530\Jeff)" and "Administrators (NewTechFX530\Administrators".
> > > > > > I am trying to muddle my way through this... so pardon my thought process if
> > > > it is wrong. Based upon the fact that SQL is not referenced in the copied
> > > > group or user names, should I be doing something with SQL to add it to get
> > > > these files to work on this system? (It is the same system, I just restored
> > > > the boot drive from a much older backup image. The computer name and the
> > > > permissions should all be the same.)
> > > > > > Thanks in advance for any help that can be offered.
> > > > > > Jeff
> > > > Generally, with BCM 2007 and Sql Server 2005, the sql instance/bcm
> > > database runs as built-in user Network Services, so user Network
> > > Services needs to have permission (full control) to access the mdf
> > > file.
> > >
 
hi Jeff,

Thanks for the note. I tried the additional instructions as well. I'll

admit - i'm not really sure why I'm changing all the permissions, nor, why

the permissions change automatically when i move or rename the files.

However, the error I'm getting now is "Business Contact Manager for Outlook

could not complete your last action or actions. Please try again."

Thoughts?

"Jeff" wrote:


> Hi Kurt,

> The method that I described worked for me, although I still have an issue
> with the installation.

> One other factor that may have allowed BCM to work once the good data files
> were renamed to the name of the newly created empty database, was that I
> changed the permission for NETWORK SERVICES for the .ldf and .mdf files
> BEFORE I renamed them and attempted to open them with BCM. I changed them to
> "Full Control/Modify/Read/Execute". (Luther had previously suggested looking
> at the permissions; I just wasn't sure what I was doing exactly.)

> When I restart Vista, and then start Outlook with BCM, I get a message when
> Vista starts stating the following: "Business Contact Manager for Outlook
> could not connect to the shared database. Do you want to work offline." I
> choose "No". Outlook then opens without a BCM drop-down.

> I then shutdown Outlook and restart. When Outlook restarts, there are no
> message windows, and the BCM database that I restored in the manner described
> in my previous post works.

> I hope this helps. It would be great if you could let me know, too.

> "Kurt" wrote:
>
> > Hi,
> > I encountered an almost identical scenario - i upgraded my box to windows 7
> > and forgot to backup my BCM db. Now, I have followed the instructions in
> > this thread - from my windows.old copy of the .mdf and .ldf.
> > However, the database still gives me permission issues (as the local user
> > with admin permissions).
> > Any futher thoughts on how to simply restore my previous .mdf and .ldf? My
> > new .mdf and .ldf are empty - i just want to populate the data.
> > "Jeff" wrote:
> >
> > > Hi Luther,
> > > > I believe that your suggestion regarding permissions to the NETWORK
> > > SERVICES, I changed the permissions on both the .mdf and .ldf files to allow
> > > Full Control.
> > > > (In case anyone else is searching for an answer to this problem, the
> > > following is the order in which I worked to restore this database:
> > > > 1. Start Outlook
> > > 2. Open Business Contact Manager
> > > 3. Select Manage Databases
> > > 4. Create New Database
> > > 5. Close Out of Outlook
> > > 6. Stop the SQL Service for MSSMLBIZ
> > > 7. Change the permissions for NETWORK SERVICES on the .ldf and .mdf files
> > > which have the data desired for access by BCM.
> > > 8. Rename the .ldf and .mdf files for the new database created in 4. above
> > > to something different.
> > > 9. Rename the .ldf and .mdf files for the "good data" to the database name
> > > created in 4. above.
> > > 10. Start the SQL Service for MSSMLBIZ.
> > > 11. Start Outlook
> > > 12. Click the Business Contact Manager Pull-Down
> > > 13. Select Manage Database
> > > > With everything above completed, the database should be listed. I hope this
> > > helps. Also, please forgive me if it doesn't work exactly the same for
> > > everyone. The NETWORK SERVICES that Luther mentioned are about the only thing
> > > I didn't try... in the order listed above. I did change the permissions
> > > earlier in my troubleshooting; but, I think it was after I had started the
> > > SQL service.)
> > > > Once I confirmed the good contact information, the first thing I did was
> > > generate a backup.
> > > > Thanks again for your help, and for taking the time to point me in the right
> > > direction.
> > > > Take Care
> > > > Jeff
> > > > "Luther Blissett" wrote:
> > > > > On Jul 5, 7:06 am, Jeff <J...> wrote:
> > > > > Hi,
> > > > > > > > This is a follow-up question to one that I wrote last night concerning using
> > > > > the .mdf and .ldf files from a previous installation of BCM to get most of my
> > > > > data back.
> > > > > > > > I have received an error which states "Unable to open the physical file.....
> > > > > .mdf. Operating system error 5: "5(Access is denied)" when I attempt to
> > > > > troubleshoot the problem from within Outlook.
> > > > > > > > I remember when I logged on the backup image file to mount the backup on the
> > > > > external hard drive, and then copy the two files above from the image file to
> > > > > a location on the local hard drive, a window pops up that states that I will
> > > > > need to provide administrator permission to copy each file. I click continue,
> > > > > and it is copied.
> > > > > > > > If I look at the security section of the properties window for each file, I
> > > > > see that there is an entry for
> > > > > "SQLServer2005MSSQLUser$NewTechFX530$MSSMLB1(NewTech....)" on the files which
> > > > > are part of the image backup file. But, when I copy the files over to my
> > > > > current boot drive, there is no longer a reference to that group or user
> > > > > name. (The groups and user names listed are: "SYSTEM", "NETWORK SERVICE",
> > > > > "Jeff (NewTechFX530\Jeff)" and "Administrators (NewTechFX530\Administrators".
> > > > > > > > I am trying to muddle my way through this... so pardon my thought process if
> > > > > it is wrong. Based upon the fact that SQL is not referenced in the copied
> > > > > group or user names, should I be doing something with SQL to add it to get
> > > > > these files to work on this system? (It is the same system, I just restored
> > > > > the boot drive from a much older backup image. The computer name and the
> > > > > permissions should all be the same.)
> > > > > > > > Thanks in advance for any help that can be offered.
> > > > > > > > Jeff
> > > > > > Generally, with BCM 2007 and Sql Server 2005, the sql instance/bcm
> > > > database runs as built-in user Network Services, so user Network
> > > > Services needs to have permission (full control) to access the mdf
> > > > file.
> > > >
 
I see an additional message when i try and look at other databases "A

network-related or instance-specific error occurred while establishing a

connection to SQL Server. The server was not found or was not accessible.

Verify that the instance name is correct and that SQL Server is configured to

allow remote connections. (Provider: Shared Memory provider, error: 40 -

Could not open a connection to SQL Server)

"Kurt" wrote:


> hi Jeff,

> Thanks for the note. I tried the additional instructions as well. I'll
> admit - i'm not really sure why I'm changing all the permissions, nor, why
> the permissions change automatically when i move or rename the files.

> However, the error I'm getting now is "Business Contact Manager for Outlook
> could not complete your last action or actions. Please try again."

> Thoughts?

> "Jeff" wrote:
>
> > Hi Kurt,
> > The method that I described worked for me, although I still have an issue
> > with the installation.
> > One other factor that may have allowed BCM to work once the good data files
> > were renamed to the name of the newly created empty database, was that I
> > changed the permission for NETWORK SERVICES for the .ldf and .mdf files
> > BEFORE I renamed them and attempted to open them with BCM. I changed them to
> > "Full Control/Modify/Read/Execute". (Luther had previously suggested looking
> > at the permissions; I just wasn't sure what I was doing exactly.)
> > When I restart Vista, and then start Outlook with BCM, I get a message when
> > Vista starts stating the following: "Business Contact Manager for Outlook
> > could not connect to the shared database. Do you want to work offline." I
> > choose "No". Outlook then opens without a BCM drop-down.
> > I then shutdown Outlook and restart. When Outlook restarts, there are no
> > message windows, and the BCM database that I restored in the manner described
> > in my previous post works.
> > I hope this helps. It would be great if you could let me know, too.
> > "Kurt" wrote:
> >
> > > Hi,
> > > > I encountered an almost identical scenario - i upgraded my box to windows 7
> > > and forgot to backup my BCM db. Now, I have followed the instructions in
> > > this thread - from my windows.old copy of the .mdf and .ldf.
> > > > However, the database still gives me permission issues (as the local user
> > > with admin permissions).
> > > > Any futher thoughts on how to simply restore my previous .mdf and .ldf? My
> > > new .mdf and .ldf are empty - i just want to populate the data.
> > > > "Jeff" wrote:
> > > > > Hi Luther,
> > > > > > I believe that your suggestion regarding permissions to the NETWORK
> > > > SERVICES, I changed the permissions on both the .mdf and .ldf files to allow
> > > > Full Control.
> > > > > > (In case anyone else is searching for an answer to this problem, the
> > > > following is the order in which I worked to restore this database:
> > > > > > 1. Start Outlook
> > > > 2. Open Business Contact Manager
> > > > 3. Select Manage Databases
> > > > 4. Create New Database
> > > > 5. Close Out of Outlook
> > > > 6. Stop the SQL Service for MSSMLBIZ
> > > > 7. Change the permissions for NETWORK SERVICES on the .ldf and .mdf files
> > > > which have the data desired for access by BCM.
> > > > 8. Rename the .ldf and .mdf files for the new database created in 4. above
> > > > to something different.
> > > > 9. Rename the .ldf and .mdf files for the "good data" to the database name
> > > > created in 4. above.
> > > > 10. Start the SQL Service for MSSMLBIZ.
> > > > 11. Start Outlook
> > > > 12. Click the Business Contact Manager Pull-Down
> > > > 13. Select Manage Database
> > > > > > With everything above completed, the database should be listed. I hope this
> > > > helps. Also, please forgive me if it doesn't work exactly the same for
> > > > everyone. The NETWORK SERVICES that Luther mentioned are about the only thing
> > > > I didn't try... in the order listed above. I did change the permissions
> > > > earlier in my troubleshooting; but, I think it was after I had started the
> > > > SQL service.)
> > > > > > Once I confirmed the good contact information, the first thing I did was
> > > > generate a backup.
> > > > > > Thanks again for your help, and for taking the time to point me in the right
> > > > direction.
> > > > > > Take Care
> > > > > > Jeff
> > > > > > "Luther Blissett" wrote:
> > > > > > > On Jul 5, 7:06 am, Jeff <J...> wrote:
> > > > > > Hi,
> > > > > > > > > > This is a follow-up question to one that I wrote last night concerning using
> > > > > > the .mdf and .ldf files from a previous installation of BCM to get most of my
> > > > > > data back.
> > > > > > > > > > I have received an error which states "Unable to open the physical file.....
> > > > > > .mdf. Operating system error 5: "5(Access is denied)" when I attempt to
> > > > > > troubleshoot the problem from within Outlook.
> > > > > > > > > > I remember when I logged on the backup image file to mount the backup on the
> > > > > > external hard drive, and then copy the two files above from the image file to
> > > > > > a location on the local hard drive, a window pops up that states that I will
> > > > > > need to provide administrator permission to copy each file. I click continue,
> > > > > > and it is copied.
> > > > > > > > > > If I look at the security section of the properties window for each file, I
> > > > > > see that there is an entry for
> > > > > > "SQLServer2005MSSQLUser$NewTechFX530$MSSMLB1(NewTech....)" on the files which
> > > > > > are part of the image backup file. But, when I copy the files over to my
> > > > > > current boot drive, there is no longer a reference to that group or user
> > > > > > name. (The groups and user names listed are: "SYSTEM", "NETWORK SERVICE",
> > > > > > "Jeff (NewTechFX530\Jeff)" and "Administrators (NewTechFX530\Administrators".
> > > > > > > > > > I am trying to muddle my way through this... so pardon my thought process if
> > > > > > it is wrong. Based upon the fact that SQL is not referenced in the copied
> > > > > > group or user names, should I be doing something with SQL to add it to get
> > > > > > these files to work on this system? (It is the same system, I just restored
> > > > > > the boot drive from a much older backup image. The computer name and the
> > > > > > permissions should all be the same.)
> > > > > > > > > > Thanks in advance for any help that can be offered.
> > > > > > > > > > Jeff
> > > > > > > > Generally, with BCM 2007 and Sql Server 2005, the sql instance/bcm
> > > > > database runs as built-in user Network Services, so user Network
> > > > > Services needs to have permission (full control) to access the mdf
> > > > > file.
> > > > >
 
Hi Kurt,

I can imagine you are as frustrated as I was... so I am happy to offer

whatever advice I can.

But, I am even less an SQL server expert than I am a BCM expert. I sure

don't want to mislead you, or recommend something that will make your

situation worse.

I know there are posts here which discuss making sure the SQL server service

is running; but, it sounds like you may have already been down that path.

It sure isn't the right way to do it; but, it took me three tries at

creating a new database and then renaming the .ldf and .mdf files from the

good BCM information before things "worked" for me. (It still isn't right

that I have to shut down Outlook and then restart it each time I restart my

system in order for BCM to work; but, that is the reality at the moment.)

I feel more than a little abandoned by those with much more experience in

both of these areas. There is very little help from those who I would suspect

are capable of sharing their expertise. I know it may not be their policy to

post here; but, I would expect some help from Microsoft. (Maybe BCM is a

product that won't be around much longer, or maybe the number of licensed

copies is so small that it doesn't matter to them.) I generally get much

better support on other software vendors' support forums than I do MS...

which really surprises me.

Good luck with your problem.

Take Care

Jeff

"Kurt" wrote:


> I see an additional message when i try and look at other databases "A
> network-related or instance-specific error occurred while establishing a
> connection to SQL Server. The server was not found or was not accessible.
> Verify that the instance name is correct and that SQL Server is configured to
> allow remote connections. (Provider: Shared Memory provider, error: 40 -
> Could not open a connection to SQL Server)

> "Kurt" wrote:
>
> > hi Jeff,
> > Thanks for the note. I tried the additional instructions as well. I'll
> > admit - i'm not really sure why I'm changing all the permissions, nor, why
> > the permissions change automatically when i move or rename the files.
> > However, the error I'm getting now is "Business Contact Manager for Outlook
> > could not complete your last action or actions. Please try again."
> > Thoughts?
> > "Jeff" wrote:
> >
> > > Hi Kurt,
> > > > The method that I described worked for me, although I still have an issue
> > > with the installation.
> > > > One other factor that may have allowed BCM to work once the good data files
> > > were renamed to the name of the newly created empty database, was that I
> > > changed the permission for NETWORK SERVICES for the .ldf and .mdf files
> > > BEFORE I renamed them and attempted to open them with BCM. I changed them to
> > > "Full Control/Modify/Read/Execute". (Luther had previously suggested looking
> > > at the permissions; I just wasn't sure what I was doing exactly.)
> > > > When I restart Vista, and then start Outlook with BCM, I get a message when
> > > Vista starts stating the following: "Business Contact Manager for Outlook
> > > could not connect to the shared database. Do you want to work offline." I
> > > choose "No". Outlook then opens without a BCM drop-down.
> > > > I then shutdown Outlook and restart. When Outlook restarts, there are no
> > > message windows, and the BCM database that I restored in the manner described
> > > in my previous post works.
> > > > I hope this helps. It would be great if you could let me know, too.
> > > > "Kurt" wrote:
> > > > > Hi,
> > > > > > I encountered an almost identical scenario - i upgraded my box to windows 7
> > > > and forgot to backup my BCM db. Now, I have followed the instructions in
> > > > this thread - from my windows.old copy of the .mdf and .ldf.
> > > > > > However, the database still gives me permission issues (as the local user
> > > > with admin permissions).
> > > > > > Any futher thoughts on how to simply restore my previous .mdf and .ldf? My
> > > > new .mdf and .ldf are empty - i just want to populate the data.
> > > > > > "Jeff" wrote:
> > > > > > > Hi Luther,
> > > > > > > > I believe that your suggestion regarding permissions to the NETWORK
> > > > > SERVICES, I changed the permissions on both the .mdf and .ldf files to allow
> > > > > Full Control.
> > > > > > > > (In case anyone else is searching for an answer to this problem, the
> > > > > following is the order in which I worked to restore this database:
> > > > > > > > 1. Start Outlook
> > > > > 2. Open Business Contact Manager
> > > > > 3. Select Manage Databases
> > > > > 4. Create New Database
> > > > > 5. Close Out of Outlook
> > > > > 6. Stop the SQL Service for MSSMLBIZ
> > > > > 7. Change the permissions for NETWORK SERVICES on the .ldf and .mdf files
> > > > > which have the data desired for access by BCM.
> > > > > 8. Rename the .ldf and .mdf files for the new database created in 4. above
> > > > > to something different.
> > > > > 9. Rename the .ldf and .mdf files for the "good data" to the database name
> > > > > created in 4. above.
> > > > > 10. Start the SQL Service for MSSMLBIZ.
> > > > > 11. Start Outlook
> > > > > 12. Click the Business Contact Manager Pull-Down
> > > > > 13. Select Manage Database
> > > > > > > > With everything above completed, the database should be listed. I hope this
> > > > > helps. Also, please forgive me if it doesn't work exactly the same for
> > > > > everyone. The NETWORK SERVICES that Luther mentioned are about the only thing
> > > > > I didn't try... in the order listed above. I did change the permissions
> > > > > earlier in my troubleshooting; but, I think it was after I had started the
> > > > > SQL service.)
> > > > > > > > Once I confirmed the good contact information, the first thing I did was
> > > > > generate a backup.
> > > > > > > > Thanks again for your help, and for taking the time to point me in the right
> > > > > direction.
> > > > > > > > Take Care
> > > > > > > > Jeff
> > > > > > > > "Luther Blissett" wrote:
> > > > > > > > > On Jul 5, 7:06 am, Jeff <J...> wrote:
> > > > > > > Hi,
> > > > > > > > > > > > This is a follow-up question to one that I wrote last night concerning using
> > > > > > > the .mdf and .ldf files from a previous installation of BCM to get most of my
> > > > > > > data back.
> > > > > > > > > > > > I have received an error which states "Unable to open the physical file.....
> > > > > > > .mdf. Operating system error 5: "5(Access is denied)" when I attempt to
> > > > > > > troubleshoot the problem from within Outlook.
> > > > > > > > > > > > I remember when I logged on the backup image file to mount the backup on the
> > > > > > > external hard drive, and then copy the two files above from the image file to
> > > > > > > a location on the local hard drive, a window pops up that states that I will
> > > > > > > need to provide administrator permission to copy each file. I click continue,
> > > > > > > and it is copied.
> > > > > > > > > > > > If I look at the security section of the properties window for each file, I
> > > > > > > see that there is an entry for
> > > > > > > "SQLServer2005MSSQLUser$NewTechFX530$MSSMLB1(NewTech....)" on the files which
> > > > > > > are part of the image backup file. But, when I copy the files over to my
> > > > > > > current boot drive, there is no longer a reference to that group or user
> > > > > > > name. (The groups and user names listed are: "SYSTEM", "NETWORK SERVICE",
> > > > > > > "Jeff (NewTechFX530\Jeff)" and "Administrators (NewTechFX530\Administrators".
> > > > > > > > > > > > I am trying to muddle my way through this... so pardon my thought process if
> > > > > > > it is wrong. Based upon the fact that SQL is not referenced in the copied
> > > > > > > group or user names, should I be doing something with SQL to add it to get
> > > > > > > these files to work on this system? (It is the same system, I just restored
> > > > > > > the boot drive from a much older backup image. The computer name and the
> > > > > > > permissions should all be the same.)
> > > > > > > > > > > > Thanks in advance for any help that can be offered.
> > > > > > > > > > > > Jeff
> > > > > > > > > > Generally, with BCM 2007 and Sql Server 2005, the sql instance/bcm
> > > > > > database runs as built-in user Network Services, so user Network
> > > > > > Services needs to have permission (full control) to access the mdf
> > > > > > file.
> > > > > >
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
J Install BCM Client without an local SQl Database BCM (Business Contact Manager) 6
P BCM 2013, Microsoft SQL Server 2008 R2 (SP2), attachment issue n database size BCM (Business Contact Manager) 2
M BCM in Outlook reports maximum database size to 4GB despite SQL Server 2008 R2 BCM (Business Contact Manager) 1
C Remote BCM database 2010 hosted via Godday SQL Server + access via PC Window 7 BCM (Business Contact Manager) 3
J Moving BCM 2007 Database to a SQL 2005 Server BCM (Business Contact Manager) 2
C Cannot seem to use BCM Database Tool on SQL Server 2008 BCM (Business Contact Manager) 4
M MSO OL sp2 for BCM broke SQL Database connection BCM (Business Contact Manager) 2
J No access to a Database BCM BCM (Business Contact Manager) 3
G Windows Update Causes BCM Database Access Problem? BCM (Business Contact Manager) 4
T Lost access to remote BCM database BCM (Business Contact Manager) 4
L Cannot Connect to BCM database BCM (Business Contact Manager) 9
A Cannot connect to BCM database BCM (Business Contact Manager) 3
Diane Poremsky Restoring BCM Database After Upgrading Windows Using Outlook 0
M Modifying BCM Database using Access BCM (Business Contact Manager) 1
crazyboy Copying BCM database from backed up mounted image to new drive BCM (Business Contact Manager) 2
M Sharing of BCM database across the internet BCM (Business Contact Manager) 2
Chris Grew Sharing BCM Database BCM (Business Contact Manager) 6
M BCM remote database connection issue BCM (Business Contact Manager) 1
J What exactly does the BCM Database tool actually do? BCM (Business Contact Manager) 3
C Moving BCM Database to Server Share BCM (Business Contact Manager) 1
K BCM - Connecting to Shared Database BCM (Business Contact Manager) 0
J Can the BCM Database tool be used over VPN? BCM (Business Contact Manager) 6
D can you share a bcm database with 2 different versions of windows? BCM (Business Contact Manager) 0
T BCM database scheme BCM (Business Contact Manager) 5
E BCM Database Tool Using Outlook 2
G "database is not compatible with BCM for Outlook 2013" & more BCM (Business Contact Manager) 0
L BCM database not listed BCM (Business Contact Manager) 0
J No errors from BCM 2007 but can't see database BCM (Business Contact Manager) 0
T BCM Cannot See Existing Database BCM (Business Contact Manager) 2
T Shared BCM database on remote server BCM (Business Contact Manager) 1
C My BCM Database is no longer available to be shared with the Database Tool BCM (Business Contact Manager) 3
wallisellener Server configuration for BCM 2013 shared database BCM (Business Contact Manager) 15
D BCM Database Protection BCM (Business Contact Manager) 3
M BCM 2010 Cannot Connect to Remote Database BCM (Business Contact Manager) 1
J Unable to view History items in BCM 2007 shared database BCM (Business Contact Manager) 3
E Accessing User Defined Fields in BCM Database part 2 BCM (Business Contact Manager) 0
E [SOLVED] Accessing User Defined Fields in BCM Database part 1 BCM (Business Contact Manager) 9
D Writing to BCM Database from VBA BCM (Business Contact Manager) 0
R Missing contacts and Opportunities in BCM 2010 Shared database BCM (Business Contact Manager) 1
R BCM 2010 error creating offline copy of shared database BCM (Business Contact Manager) 1
S Restoring Database to BCM BCM (Business Contact Manager) 2
C BCM database second user BCM (Business Contact Manager) 1
P Download BCM Database BCM (Business Contact Manager) 1
D Sharing BCM Database with other computers on a network BCM (Business Contact Manager) 1
A BCM 2007 restoring database BCM (Business Contact Manager) 1
A BCM database and Windows 7 BCM (Business Contact Manager) 1
I Can I share BCM V2 Database on 2003 by using BCM Data Admin Tool BCM (Business Contact Manager) 2
T Error 'Database msdb cannot be opened' when backing up BCM BCM (Business Contact Manager) 2
D Connecting BCM 2007 to a shared BCM 2003 Database BCM (Business Contact Manager) 3
E How to restore BCM Database after upgrade from Vista to Win7? BCM (Business Contact Manager) 1

Similar threads

Back
Top