January 3, 2009 at 2:07 am
Hello,
I`m new with SQL Server. I`m curently using SQL Server 2000 with SP4 , and i can start the server but can`t manage to start the SQL Server Agent. I`ve created a username (but not curently logged on with it) to use with SQL Server and Server Agent ( Administrative Tools -> Services -> MSSQL$SQL ).
Any ideas or sugestions ? Also i would like to know the role of the Server Agent and if it can be bypassed.
Thanks,
Paul
January 3, 2009 at 10:28 am
Review the event logs for any errors when trying to start SQL Server Agent. You can also review the SQL Server error logs for any messages there.
SQL Server Agent is the service that runs all jobs for that instance of SQL Server. Without it - you won't be able to create and setup maintenance plans, or any other types of jobs. If this is just a localized development system - that might not be a problem.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 3, 2009 at 10:31 am
Thanks for the quick answer 🙂 ,
I`m just trying to do a little school project on my local computer, no remote no big deals. I don`t even know if i`ll practice triggers. Create delete tables and modifying them.
Regards,
Paul
January 3, 2009 at 10:38 am
Well, just for that you don't need SQL Server Agent. If that is all you are doing, you might want to consider installing SQL Server Express instead. Download the version with Advanced Services (I think that is what it is called) - which comes with SSMSE (Express version of the studio).
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply