Problem backing up BCM 2007 since upgraded to vista

[steveinhalifax]

I recieve the error message "Operating System error 5 (Access Denied)" when I
try to back up BCM since upgrading to Vista. Is there a solution?

 

[Luther]

I recieve the error message "Operating System error 5 (Access Denied)" when I
try to back up BCM since upgrading to Vista. Is there a solution?

My first guess is that the user, Network Services, that the
sqlserver.exe service is running under doesn't have permission to
write to the folder it is trying to write the backup file into.

 

[steveinhalifax]

I am a mouth breather when it comes to this stuff. How do I give that service
permission to do so? I am running it stand alone on a notebook. thanks

 

[mrtimpeterson via OfficeKB.com]

Don't you just love how MS designs these stupid user permission issues to
just pop up with no advanced awareness for the actual "user" to really
understand unless the "user" is an IT guy with advanced familiarity. I
really dig the messages that state "An error has occurred please refer to the
Administrator" which is just wonderful when "I" am the Administrator and
don't have a clue what to do! It's kind of like you are driving down the
road and your car suddenly comes to a stop (an obvious and diagnosable
problem to the driver). Suddenly an idiot light flashes stating: An error
has occurred, please refer to the driver! You are now thinking..."Hmm,
thanks for such a helpful message guys."

Why not just allow the Network Services running the sql server.exe service to
intially grant such permission by default? I am sure there are probably
hundreds of good reasons far beyond my level of expertise to understand for
this.

-THP

I am a mouth breather when it comes to this stuff. How do I give that service
permission to do so? I am running it stand alone on a notebook. thanks

On May 29, 7:30 am, steveinhalifax
<[email protected]> wrote:

[quoted text clipped - 6 lines]

sqlserver.exe service is running under doesn't have permission to
write to the folder it is trying to write the backup file into.

 

[mrtimpeterson via OfficeKB.com]

Steve,

An additional comment: I ran into a similiar mystery error message about a
month ago after upgrading to Vista. This may or may not apply to you but I
concluded that my db somehow became corrupted because I could not back up
either. I had to cut the anchor between my BCM db and my Outlook profile and
then create a fresh new BCM db. I then restored from my BCM back up and all
seemed to be well as I was allowed to do subsequent backups just fine without
issue. This was very annoying because I lost all changes to my db since my
previous back up and started to be a bit spooked whether BCM would be stable
under Vista. Thus far all has been well since so perhaps I can chalk it up
as just another hiccup along the joyous highway to Vista heaven. And MS
wonders why more folks are sticking with XP and not yet lining up for such
fun.

-THP

Don't you just love how MS designs these stupid user permission issues to
just pop up with no advanced awareness for the actual "user" to really
understand unless the "user" is an IT guy with advanced familiarity. I
really dig the messages that state "An error has occurred please refer to the
Administrator" which is just wonderful when "I" am the Administrator and
don't have a clue what to do! It's kind of like you are driving down the
road and your car suddenly comes to a stop (an obvious and diagnosable
problem to the driver). Suddenly an idiot light flashes stating: An error
has occurred, please refer to the driver! You are now thinking..."Hmm,
thanks for such a helpful message guys."

Why not just allow the Network Services running the sql server.exe service to
intially grant such permission by default? I am sure there are probably
hundreds of good reasons far beyond my level of expertise to understand for
this.

-THP

I am a mouth breather when it comes to this stuff. How do I give that service
permission to do so? I am running it stand alone on a notebook. thanks

[quoted text clipped - 3 lines]

 

[steveinhalifax]

Thank you for your response. I really can't afford to loose what I've got in
the database. What if I export the database and do what you suggest and then
import it? Any thoughts would be appreciated.
--
steve

Steve,

An additional comment: I ran into a similiar mystery error message about a
month ago after upgrading to Vista. This may or may not apply to you but I
concluded that my db somehow became corrupted because I could not back up
either. I had to cut the anchor between my BCM db and my Outlook profile and
then create a fresh new BCM db. I then restored from my BCM back up and all
seemed to be well as I was allowed to do subsequent backups just fine without
issue. This was very annoying because I lost all changes to my db since my
previous back up and started to be a bit spooked whether BCM would be stable
under Vista. Thus far all has been well since so perhaps I can chalk it up
as just another hiccup along the joyous highway to Vista heaven. And MS
wonders why more folks are sticking with XP and not yet lining up for such
fun.

-THP

Don't you just love how MS designs these stupid user permission issues to
just pop up with no advanced awareness for the actual "user" to really
understand unless the "user" is an IT guy with advanced familiarity. I
really dig the messages that state "An error has occurred please refer to the
Administrator" which is just wonderful when "I" am the Administrator and
don't have a clue what to do! It's kind of like you are driving down the
road and your car suddenly comes to a stop (an obvious and diagnosable
problem to the driver). Suddenly an idiot light flashes stating: An error
has occurred, please refer to the driver! You are now thinking..."Hmm,
thanks for such a helpful message guys."

Why not just allow the Network Services running the sql server.exe service to
intially grant such permission by default? I am sure there are probably
hundreds of good reasons far beyond my level of expertise to understand for
this.

-THP

I am a mouth breather when it comes to this stuff. How do I give that service
permission to do so? I am running it stand alone on a notebook. thanks

[quoted text clipped - 3 lines]

sqlserver.exe service is running under doesn't have permission to
write to the folder it is trying to write the backup file into.