Use a domain account on MSSQLSERVER

We had some trouble running the full backup (both from CA and stsadm), we got error messages in CA that said “Error: Object SharePoint_Config failed in event OnBackup. For more information, see the error log located in the backup directory. SqlException: Cannot open backup device…” and in EventViewer it complained that we used a Bad username or password. Started to investigate that the app pools ran with the right userid = ok, services on the sharepoint server = ok, user account that initiated the backup = ok, network share had correct permissions and that it actually was a share = ok, the app pool account/service accounts/backup account had right permissions on the SQL server = ok, and then I thought everything was checked. But not. Turns out that the MSSQLSERVER service on the SQL server was running on a local account and that account tries to access the file share where you want your backup files and that share is of course not on the same machine so – access denied for that local account! It’s all so clear when you find the error, isn’t it? 🙂 So, we changed the MSSQLSERVER to a domain account which has all rights to the network share and the databases, and now our backup is up and running!

Leave a Reply

2 Comments on "Use a domain account on MSSQLSERVER"

avatar
  Subscribe  
newest oldest most voted
Notify of
Lise
Guest

Hi Heath!
Thank you so much 🙂
Yes that is another way to solve the issue. But this was for a production environment so we had to enter a domain account to keep it as safe as possible.
Take care,
/Lise

Heath Hopkins
Guest

I ran into this problem too when I changed the MSSQLSERVICE account to Local Service. I ended up adding the computer object to the file share permissions, and that solved the problem. It’s a little insecure, but it was only temporary. Great blog by the way. I just found it when searching for reviews of RadEditor Lite.