Can't start the SQL Server Agent

Hi all

I have just installed SQL Server 2008 on a new server. After installation I have created new local users for each service of the SQL Server (sql server, sql server agent, Integration Service, OLAP and so on) and each user is member of the corresponding group created by the installation.
The user for the sql server agent for example is member of the group SQLServerSQLAgentUser$MSSQL2008-A$MSSQLSERVER 
This works fine for all services except for the agent which fails when I try to start the service. The event log shows the following messages:

Login failed for user 'MSSQL2008-A\SQLServerAgent'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]

and

SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).


Additional info: the server is not on an AD network&.. all the users I created for the services are local users

Please.... does someone have an idea.....

/Nicolaj
nicolajsbAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Marten RuneSQL Expert/Infrastructure ArchitectCommented:
Maybe you need to grant 'log on as a service' in local security policy?

/Marten
0
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
can you do a runas in cmd prompt? i e:

c:\runas /u:SQLServiceAccount cmd
ENTER
CMD will prompt for password. If it works it will open another CMD prompt. Just to see that the account works.

Try put it in local admin group, if the service starts, then you know its related to permissions somehow.

Come back with results.

Regards Marten
0
nicolajsbAuthor Commented:
just checked.... "log on as service" is grandet by default to the group that is created when the SQL Server is installed and the "runas" thing works fine too.

I have tried to add the user to the Administrators group byt that didn't help either.

If I change the service account for the agent to "Local System" everything works.... but i guess it is best practice to create diticated user accounts for every service and use the groups created during the installation....

0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Marten RuneSQL Expert/Infrastructure ArchitectCommented:
You could try to use the browse button when assigning the account.

If this doesn't work, try creating a new account and see if it will work with this account!

/Marten
0
nicolajsbAuthor Commented:
hmmm tried everything now.... recreating the account, reinstalling the SQL Server.... nothing helps. going back to "Network Service" as the service account for the Agent
0
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
Hi there

The serviceaccount needs access to the database. It's not like with the sql service, witch doesn't need DB access itself. The agent is used to run jobs, and therefore it needs DB Access.

If its a hardened server, i e you have dropped the BUILTIN\Administrators group, or restricted its rights, this may be why it's not starting.

What is the error message in event viewer I want source, category and EventID

/Marten
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.