Backing up SQL 2008 with UserAccountControl enabled in Windows Server 2008

Question

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

ble1 · Answer

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

Des2 · Answer

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?

ble1 · Answer

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

Adrian4 · Answer

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.

PeterBen · Answer

https://solutions.emc.com/emcsolutionview.asp?id=esg114125

NetWorker

Was this post helpful?