Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Backup failed. How to determine SQL Server service account

  Asked By: Tapasvi    Date: Mar 19    Category: Sharepoint    Views: 20863

I need to move a web application from a development farm to our
new production farm. I'm getting an error trying to backup the Web
Application in Central Administration.

Directory \\backup\Test does not exist or the SQL Server service
account and the domain\mylogin service account do not have permission
to read or write to the backup folder. Specify a different directory.

We've made sure that the directory exists and my domain account have
full access. I'm trying to figure out the actual name of the "SQL
Server service account" that's trying to access the backup folder. Is
it an account we created in SharePoint 2007 or is it an account in SQL
2005? How can I figure this out?



4 Answers Found

Answer #1    Answered By: Kedar Phule     Answered On: Mar 19

It is the account  the SQL services are running as on the SQL box.

Answer #2    Answered By: Chanel Gaines     Answered On: Mar 19

First can you confirm, is the sharepoint  installation and sql  instance or on
same box?

If the sql and sharepoint is on same box:
Try with the system account  to backup  the database. instead of network
location (\\backup\Test) try with local path C:\Backup (make sure backup folder
is there in c: drive).

If the SQL and sharepoint are in different boxes:
Try with the system account to backup the database, and make sure that network
location (\\backup\Test) are accessible from both the machine(sharepoint and

Answer #3    Answered By: Timmy Whitney     Answered On: Mar 19

SharePoint and SQL are on separate servers. The backup
folder is on the SharePoint server. We tried the system account  and
tried giving the folder  more permissions. We actually got a bit further
along. It backed up 15 files then error'd out. Looking in previous
threads I read  that the first half of the backup  was handled by MOSS and
the rest by SQL.

We are trying something else now. We placed the backup folder on the
SQL server, hoping that SQL could write  backup files to that folder. We
have the same problem, 15 files are created  then the process fails. The
error is: "SqlException: Cannot open backup device
'\\live\Tran$fer\spbr0005\00000016.bak'. Operating system error  5(Access
is denied.)" We don't know what account to grant access  to the backup
folder share. Do you know the specific name of a SQL account I need to
grant access? Is this a SQL machine account, a domain  account???

Answer #4    Answered By: Harihar Sonnad     Answered On: Mar 19

The account  authenticated to Central Administration

The farm  account (should be the Central Administration application  pool


The SQL Server instance account, if you are using SQL authentication

The SPTimer service  account, which should be the farm account in most


Didn't find what you were looking for? Find more on Backup failed. How to determine SQL Server service account Or get search suggestion and latest updates.

Related Topics:



Related Post