Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
njvorhies
Starting Member
4 Posts |
Posted - 2007-03-28 : 12:34:35
|
I am unable to get SQL Agent service to run under the same domain name that my SQL Server service is running under. It will start and continue to run when Server and Agent are both ran under the Local Account. But once the services are switched over to the domain account, the Server starts, but the Agent fails. The domain user has administrative rights on the server, along with admin rights to the SQL instance.Here is the event log.Event Type: ErrorEvent Source: SQLSERVERAGENTEvent Category: Service ControlEvent ID: 103Date: 3/28/2007User: N/AComputer: SQL2Description: SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to the SQL Server as SysAdmin, but '(Unknown)' is not a member of the SysAdmin role).Any help would be greatly appreciated or links to threads with answers. |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-03-28 : 16:05:15
|
did you try using sqlserver service under domain account and sqlserveragent under a different account. I have had problems when your sql server runs out of licences. sometimes the Network folks who control domain accounts disable an account from being used in two different places at the same time.RegardsParesh MotiwalaBoston, USA |
|
|
njvorhies
Starting Member
4 Posts |
Posted - 2007-03-29 : 14:53:44
|
It still will not start when run under another user. It will also NOT run when run under Local System while the other is run under the domain account. The only way it will run is when both are run under Local System. I have also tried adding the domain user to all of the SQL user groups, thinking that if it worked, I would go through, delete the user from each group one at a time until I figured out which group it needed to be in (assuming that one other than the SQL Agent group was needed for this service to run). |
|
|
njvorhies
Starting Member
4 Posts |
Posted - 2007-03-29 : 15:25:22
|
I am also getting this error message in the SQL logs.Date 3/29/2007 2:01:16 PMLog SQL Agent (Current - 3/29/2007 2:01:00 PM)Message[298] SQLServer Error: 15281, SQL Server blocked access to procedure 'dbo.sp_sqlagent_get_startup_info' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online. [SQLSTATE 42000]I am tried through the Surface Area Configuration to enable the Agent also and it errors out like it does when trying to start the service through the Services window. |
|
|
njvorhies
Starting Member
4 Posts |
Posted - 2007-03-30 : 11:40:03
|
problem solved. I didn't have the user set up in the local group policy to be able to "lock pages in memory" once that was set and the server rebooted, the service ran just fine. |
|
|
riggaP
Starting Member
1 Post |
Posted - 2008-07-17 : 01:56:00
|
OMG Thankyou!Had exactly the same problem with 2 DMZ machines (i.e. no domain user could be used). Been beating my head against a wall (and google) for nearly 2 days! |
|
|
DarkPeace
Starting Member
1 Post |
Posted - 2008-08-08 : 17:31:39
|
You GUYS Rock.. for anyone else on win2k3 goto :Administrative Tools -> Local Security Policy -> New window - >Local Policies -> User Rights Assignment - > Lock pages in memory Properties.Add your AD user here.Note : It doesn't work until a reboot (yes i tried). Thanks a bunch. |
|
|
CanadaDBA
583 Posts |
Posted - 2009-09-19 : 07:46:12
|
Thanks DarkPeace for adding the detailed steps. Regards! quote: Originally posted by DarkPeace You GUYS Rock.. for anyone else on win2k3 goto :Administrative Tools -> Local Security Policy -> New window - >Local Policies -> User Rights Assignment - > Lock pages in memory Properties.Add your AD user here.Note : It doesn't work until a reboot (yes i tried). Thanks a bunch.
Canada DBA |
|
|
|
|
|
|
|