Post reply

Issues with revoking sysadmin role?

  • October 22, 2008 at 12:12 pm

    #194937

    Hi,

    we are using Biztalk application which is using sql server 2005 to store its databases.

    While installation we crated a login BTSAdmin with sysadmin previleges as it required to install Biztalk. After the installation is done they no longer need it. But the problem is there are some jobs created in sql server when they installed Biztalk and the owner for those jobs is BTSAdmin.

    My question is if I revoke the sysadmin previleges and give securityadmin previlege to BTSAdmin, will stop the jobs to run? For the jobs to run the owner should have sysadmin privileges?

    please advice me..

    we are doing all these to control the secuity..

    Thanks

  • October 22, 2008 at 2:19 pm

    #888343

    Change the owner of the job to a SQL service acct.

  • October 22, 2008 at 4:51 pm

    #888403

    Thank You,

    Here is the scenario. Biztalk databases are spread across multiple sql server 2005(3 instances)

    sql server instances

    1.Msg

    2.track

    3.data

    In all 3 instances BTSadmin has given sysadmin role while installation. So now we need revoke that previlege from all the instances. But In instance 2 there is a backup job, backsup all biztalk databases frequently,for that application user wants sysadmin role for BTSAdmin.The other two instances do not need sysadmin for BTSAdmin at all. So how can I acheive this?

    http://msdn.microsoft.com/en-us/library/aa577661.aspx

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply