January 22, 2004 at 12:41 am
SQL 7 sp4
Our DBA is trying to setup a backup of a DB. The backup fails with an access violation. This server is different from our other SQL servers because the application running on it won't allow us to change the account that the MSSQLServer service is running under. It uses the local system account. I think this is why the access is denied when it is pushed to the server where we store the backups. All of the other sql servers use a domain account for the sql service and they are able to push their backups to the storage place. Doing a local and moving it is also out due to disk space.
Anyone have an idea on how to get around this?
Alexzander N. Nepomnjashiy
Technical editor for Wrox Press:
"SQL Server 2000 Fast Answers"
Technical editor for Apress:
"Honeypot for Windows"
"SQL Server Yukon Revealed"
January 22, 2004 at 10:20 am
What is the application that prevents you from changing the MSSQLServer service account? That sounds weird because the only way you will get access to other servers/folders is by using a domain account with appropriate rights.
Jim.
January 23, 2004 at 10:09 am
You could use a Windows scheduled task to push the backups as well.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
January 24, 2004 at 4:22 am
Steve, thank you, but : "... Doing a local and moving it is also out due to disk space..."
Alexzander N. Nepomnjashiy
Technical editor for Wrox Press:
"SQL Server 2000 Fast Answers"
Technical editor for Apress:
"Honeypot for Windows"
"SQL Server Yukon Revealed"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply