roma_vt
asked on
MS SQL 2005 Shipping Log sysadmin role
I use MS SQL 2005
Security requirements - all jobs (steps inside jobs) are running with using special SQLProxyAccount.
This account have no sysadmin role granted.
LogShipping job failing with next errors:
Could not retrieve backup settings for primary ID
The specified login is not a member of the sysadmin fixed server role for server
How can I run Log Shipping without using sysadmin fixed role?
Security requirements - all jobs (steps inside jobs) are running with using special SQLProxyAccount.
This account have no sysadmin role granted.
LogShipping job failing with next errors:
Could not retrieve backup settings for primary ID
The specified login is not a member of the sysadmin fixed server role for server
How can I run Log Shipping without using sysadmin fixed role?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome, roma_vt :)
ASKER