August 19, 2013 at 12:53 pm
Running Windows-7 Pro 32 bit. Trying to start SQL Server Agent. It is stopped & greyed out so cannot be started.
Tried to install SQL Management Studio 2008 R2, get Validation Errors unable to install.
Is there any quick way I can get the SQL Server Agent to run and/or install the above SQL Managemnet Studio?
Thanks for any help
August 20, 2013 at 9:26 am
You should use SQL Server Configuration Manager to control the SQL Server services. Start -> All Programs -> Microsoft SQL Server (version) -> Configuration Tools -> SQL Server Configuration Manager. Or you can just start typing SQL Server Config in the search box.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 20, 2013 at 9:53 am
Hi Jack & Thanks very much
I have been using the Sql Server Configuration Manager. It reports v 2009. However my problem is that I cannot get Sql Server agent to start. Sql Server is running as is Sql Server browser. Start for the Server Agent is greyed out. Under properties, "start mode" shows "Disabled". When I select either Manual or Auto I get the ff error:
" The remote procedure call failed [0x800706be] "
Thus I can never get it started.
August 20, 2013 at 9:59 am
Okay, are you trying to start the service on a local instance or a remote instance?
Have you verified in the services panel that the RPC service is running and the SQL Server Agent is installed?
I ask about installation because if this is a SQL Server Express instance SQL Server Agent is not included in the install.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 20, 2013 at 1:43 pm
Hi Jack,
Trying to start the service on a local machine. Have no idea if RPC Service is running. Tried to install Sql 2008 R2 but unable to install as apparently a more advanced version is already part of the OS.
Can I download SQL Server Agent from Microsoft, I'll try that.
August 20, 2013 at 2:12 pm
There is not SQL Server Agent Download from Microsoft, it is part of the SQL Server install for all editions except Express.
Where/how did you get the install for SQL Server that is on the machine?
Go to Start and in the search box type services.msc and that will bring up the services panel where you can see if the Remote Procedure Call (RPC) service is running.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 24, 2013 at 8:57 am
Hi,
Here is what I have for services. Apparently my SQL Server Agent as well as the SQL Server came from "Sage ACT". This is my database program which actually led to my trying to deal with the SQL issue in the 1st place.
Here are some instances:
Name Status Start type Log On As
==== ===== ======== ========
RPC Started Automatic Network Service
SQL Server (ACT7) Started Automatic Local System
SQL Server Agent (ACT7) ------- Disabled Network Service
SQL Server Browser Started Automatic Local System
I can provide more info about Sage ACT and am comtemplating a [fee paid] support contract with them if this is all their fault.
Thanks,
John K.
August 24, 2013 at 3:54 pm
Through Google I found this information in Wikipedia:
There are currently two editions of Act! -
Act! Pro is limited to 10 active users and utilizes Microsoft SQL Server 2008 R2 Express.
Act! Premium (access via Windows or Web browser) is designed for small to medium-sized businesses, can handle much larger user numbers and can use more scalable editions of SQL.
So if you have Act! Pro, you have Express Edition, and you cannot start SQL Server Agent, because there is no agent to start.
On http://www.act.com/products/system/2013/premium/ I found this:
Act! Premium uses SQL Server® 2008 R2 SP1 or your existing installation of SQL Server 2008 R2. If you would like to use a different edition of SQL Server other than the one provided, please consult Microsoft documentation for specific requirements for that edition.
I would interpret this as if you get SQL Server with Act! Premiun, you get Express Edition, and you would need to purchase a separate license from MS for a better version, but I could be wrong on that point.
But most likely you have Express Edition, and there is no agent to start. If you want SQL Server Agent, you would need to buy a license for at least Workgroup Edition.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply