We were trying to disable the sysadmin flag for the SQL Builtin\Administrators group on our SQL Server. I created the network account in SQL with sysadmin rights that Arcserve should connect with. Arcserve wouldn't connect to the database using the client agent or through the network tree unless the we gave Builtin\Administrators sysadmin rights (which we obviously don't want to do), even though the network account existed with sysadmin rights. What are we missing?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Arcserve SQL Agent & SQL security 1
- Thread starter mhavens
- Start date
-
1
- #2
Arcservebaba
Technical User
Always, its a good parctice to use "sa" account for backups and restores..
For security reasons, if you u do not want to use "sa" then
create a sql login and give him full rights, so that login can be used for backups and restores...
Baba says...
"Known is a drop, unknown is a ocean"
For security reasons, if you u do not want to use "sa" then
create a sql login and give him full rights, so that login can be used for backups and restores...
Baba says...
"Known is a drop, unknown is a ocean"
- Status