October 31, 2014 at 4:31 am
Hi All,
when i installed the sql server for SQL Agent Server i have selected account as SYSTEM ,After installing the Instance that SQL Agent server is showing "Agent XPS disabled",So for that i used Sp_Configure show advance option,1 ,Reconfigure i enabled XPS,Now its not showing that Agent XPS .
Sql server agent is not starting with the Local System login account,If i changed it to Administrator/Local Service it is getting start ,
My Question is ,My developers are using that server for connection string in the application ,So are they can able to create job/schedule the jobs by using their user logins.is there any issue with that,
If i want to change the Log on as LocalSystem what can i do....
Regards
Chowdary...
October 31, 2014 at 1:54 pm
Chowdary's (10/31/2014)
Hi All,when i installed the sql server for SQL Agent Server i have selected account as SYSTEM ,After installing the Instance that SQL Agent server is showing "Agent XPS disabled",So for that i used Sp_Configure show advance option,1 ,Reconfigure i enabled XPS,Now its not showing that Agent XPS .
Sql server agent is not starting with the Local System login account,If i changed it to Administrator/Local Service it is getting start ,
My Question is ,My developers are using that server for connection string in the application ,So are they can able to create job/schedule the jobs by using their user logins.is there any issue with that,
If i want to change the Log on as LocalSystem what can i do....
I don't think being able to create and run SQL Agent jobs is dependent on what the SQL Agent service logs in as. There are roles in the MSDB database you can grant to your developer's logins that will allow them to work with jobs:
http://msdn.microsoft.com/en-us/library/ms188283(v=sql.105).aspx
November 3, 2014 at 11:01 am
It is best practice that you use AD accounts specifically created as service accounts for the SQL server services.
Then grant these accounts the minimum rights on the box to run the services.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply