LarryZ
asked on
Can't start SQL Server Agent (SQLEXPRESS)
Just installed Visual Basic 2008 Express and SQL Server 2008 Express. I was able to get SQL Server Management Studio installed, and can create and query databases OK.
However, I can't start SQL Server Agent, even if Start Mode is set to Manual or Automatic.
State=Stopped
Start Mode = Automatic
Log On As = NT AUTHORITY\Network Service (Funny that Network Service is not all caps)
If you try to strat it manually, dialog box says "The request failed or the service did not respond in a timely fashion.".
The Applications Event Log shows Error ID 103
"SQLServerAgent could not be started (reason: Error creating a new session)"
In VB.net 2008, I cannot add a new SQLEXPRESS database to any project. Messsage says "You don't have permission to open this file". I wonder if this is related to the Agent not running?
I'm much better at .NET programmer than database administration. Could you some SQEXPRESS help please.
However, I can't start SQL Server Agent, even if Start Mode is set to Manual or Automatic.
State=Stopped
Start Mode = Automatic
Log On As = NT AUTHORITY\Network Service (Funny that Network Service is not all caps)
If you try to strat it manually, dialog box says "The request failed or the service did not respond in a timely fashion.".
The Applications Event Log shows Error ID 103
"SQLServerAgent could not be started (reason: Error creating a new session)"
In VB.net 2008, I cannot add a new SQLEXPRESS database to any project. Messsage says "You don't have permission to open this file". I wonder if this is related to the Agent not running?
I'm much better at .NET programmer than database administration. Could you some SQEXPRESS help please.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This is a bug in RC0 Express edition and is confirmed by Microsoft in the below link:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=351806
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=351806
ASKER
Thanks. Are the paid versions a lot easier to get up and running?
>>Are the paid versions a lot easier to get up and running?
Yes, the installation is much similar to Express edition installation.
Yes, the installation is much similar to Express edition installation.
ASKER