Permission Issue

Question

Permission Issue

utsabchattopadhyay

SSC Enthusiast

Points: 170
More actions
December 26, 2007 at 12:59 pm

#121519

Hi
I am facing one issue? In one of my recently built box, I can’t start SQL Server Agent service account is given local admin right.
OS: Win 2K3 SP1 64BIT
SERVER: SQL2005 SP2
Service account is member of Logonas service
Error: Service is starting and then stopped informing it has nothing to do.
Could you please advise what right I should give to service account to resolve this issue? All other services are starting.
Regards
Utsab Chattopadhyay

Viewing 7 posts - 1 through 6 (of 6 total)

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

TheRedneckDBA SSChampion Points: 14001 More actions · Answer 1

If the account that the sql server agent service is running as is a local admin, I can't imagine it's a permission issue. Did you verify that the password is correct and that the account isn't locked out?

The Redneck DBA

utsabchattopadhyay SSC Enthusiast Points: 170 More actions · Answer 2

Hi

My apology for the confusion. Actaully I wanted to mention that we cann't allow it to run as Local Admin. It's running as Local Admin.

Please help

Regards

Utsab Chattopadhyay

GRE (Gethyn Ellis) SSCrazy Eights Points: 9602 More actions · Answer 3

Appologies if you have tried this but if you search for:

SQL Server Agent, service startup accounts

In BOL it should give you place to start...

Gethyn Elliswww.gethynellis.com

DonaldW SSCarpal Tunnel Points: 4525 More actions · Answer 4

Do you have another box where the service is running normally? If so, look at its service account and give the account where the service is failing the same permissions.

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 5

My apology for the confusion. Actaully I wanted to mention that we cann't allow it to run as Local Admin. It's running as Local Admin.

That doesn't make sense? It's Which account is it running by? Local Administrator or not?

Use Configuration Manager to select the account, NOT CONTROL PANEL. That way the correct permissions will be set.

If it won't start, check the logs. They'll clue you in.

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 6

Steve is right - you should do all changes to SQL 2005 through the cdonfiguration managers ( including the separate Reporting Services RSConfig utility ).

Running as a local admin account is not reccomended. You open yourself up for SQL Injection attacks if you have security concerns.

Greg E