Re: DataProtector 7.0 and SQL Server 2012 (1368 Views)
Reply
Occasional Advisor
coiter
Posts: 15
Registered: ‎10-31-2012
Message 1 of 4 (1,381 Views)
Accepted Solution

DataProtector 7.0 and SQL Server 2012

Im having a problem with trying to take backup of my SQL server 2012, running on a windows 2008 R2 server.

 

I can install the disk client and the SQL client package from my Manager console without problems.

 

I can create the job, and browse the SQL server and select all the databases there without any problems aswell.

 

There is nothing in the debug.log that indicates what is wrong, but the job fails all the time, with the error

 

"Error has occurred while opening database 'xxxxxx'. Check if the database exists on the server."

The backup users has full sysadmin access to the server and the SQL server.

Its only a problem with SQL 2012, as we have multiple sql 2008 servers that works just fine.

 

Running version A.07.00 Build 100

 

Any ideas why it keep failing?

 

 

Please use plain text.
Honored Contributor
JBasilio
Posts: 538
Registered: ‎11-25-2008
Message 2 of 4 (1,373 Views)

Re: DataProtector 7.0 and SQL Server 2012

Hello

 

Under which user is running DP inet service into SQl server? This is user must be SQl admin.

 

Please uploaded debug.log file from SQL server

Please use plain text.
Occasional Advisor
coiter
Posts: 15
Registered: ‎10-31-2012
Message 3 of 4 (1,372 Views)

Re: DataProtector 7.0 and SQL Server 2012

hmms, maybe thats why, its running on local system account.

 

and you are right, that is the reason why.

 

 

very strange, because this same server had sql 2008 running 2 weeks ago, and had no problems with that

 

stupid me, never checked that one:)

Please use plain text.
Honored Contributor
JBasilio
Posts: 538
Registered: ‎11-25-2008
Message 4 of 4 (1,368 Views)

Re: DataProtector 7.0 and SQL Server 2012

Hi

 

Always is better run DP inet under SQL admin user. Welcome

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation