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>]
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.....