March 3, 2010 at 12:42 pm
Hello
I have installed SQL express 2008. I am able to start the server, and the Server Browser from the configuration manager, but i cant start the Server agent.
The .OUT file in the log folder says:
- ? [100] Microsoft SQLServerAgent version 10.0.2531.0 ((Unknown) unicode retail build) : Process ID 3160
- ? [101] SQL Server RAVNHOLT-PC\SQLEXPRESS version 10.00.2531 (0 connection limit)
- ? [102] SQL Server ODBC driver version 10.00.2531
- ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is RAVNHOLT-PC\SQLEXPRESS
- ? [310] 2 processor(s) and 4096 MB RAM detected
- ? [339] Local computer is RAVNHOLT-PC running Windows NT 6.1 (7600)
- ! [000] This installation of SQL Server Agent is disabled. The edition of SQL Server that installed this service does not support SQL Server Agent.
- ? [098] SQLServerAgent terminated (normally)
How do i solve this problem, or does the Agent have to be running i order to connect to the database using the management studio?
When i try to change the account settings for the agent, i get the message The process terminated unexpectedly [0x8007042b]
March 3, 2010 at 12:50 pm
SQL Server Express does not have SQL Server Agent, that's why you can't start it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply