Start a Conversation

Unsolved

This post is more than 5 years old

2102

November 25th, 2008 05:00

Backing up SQL 2008 with UserAccountControl enabled in Windows Server 2008

Hi Guys,

I'm running Networker 7.4.3 on a Windows Server 2003 platform. I'm trying to backup a SQL 2008 Cluster running on Windows Server 2008. I can do the flat file backups without issue but when attempting a SQL backup i get the following error:

"39077 1227550082 0 0 2 1616 1804 0 backupebasql01 nsrexecd 11 error, %s%s 2 49 88 0 21 Could not run %s: %s 2 0 6 savefs 0 43 The requested operation requires elevation. 0 0"

The user attempting the backup has been given Domain Admin rights but I still receive the same error.

However, if I turn off the User Account Control in Control Panel, reboot the server and then attempt a backup it backs up SQL successfully.

My question is, how do I get Networker to backup SQL with User Account Control enabled?

Any help/advice would be appreciated.

Thanks,

Desigan

2 Intern

 • 

14.3K Posts

November 26th, 2008 00:00

Are you using 5.2 module? Also, are you using some user to make SQL backup? You may wish to try that too.

2 Posts

December 1st, 2008 22:00

Hi, thank you for the response.

I am using 5.2 and yes I have specified a Domain Admin user in the client resource.

Has I've said previously, with UAC enabled the backup will not start but with it disabled the backup works successfully.

Have you come across this before?

2 Intern

 • 

14.3K Posts

December 2nd, 2008 02:00

No, but I also never used SQL2k8 to be honest.

4 Posts

August 18th, 2009 02:00

Hi,

Did anyone find a sollution to this issue?
We have a 2008 SQL Cluster and would like to back up the cluster using a domain account.

Thanks in advance,

Adrian.

5 Practitioner

 • 

274.2K Posts

September 11th, 2009 13:00

Open up the local security policy (secpol.msc), navigate to Local Policies -> Security Options. Scroll to the bottom and change "User Account Control: Behavior of the elevation prompt for administrators in Admin Approval Mode" to Elevate without prompting. Reboot. Once done, specify an admin user that also has SQL priveleges in the remote user tab of the client.

If it doesn't work Disable "User Account Control: Run all administrators in Admin Approval Mode" and reboot. I believe the first one fixed my issue, but remember changing both during testing.
No Events found!

Top