August 14, 2009 at 8:23 am
Hey,
I have tried to install a SQL server agent using a remote connectivity. when i go through the tool, and execute it, it fails to succeed in all the services:-D. One of the Services (SQL server database service Failed :()
Any suggestions?
August 16, 2009 at 9:49 am
I don't understand what you mean by you execute the command to install SQL Server Agent, you need to run setup to install it and in the developer edition it comes turned off by default so you need to go to configuration manager and turn it on.
Kind regards,
Gift Peddie
August 16, 2009 at 9:21 pm
I think i am out of sync.
As far as i know, Its not possible to intall SQL Server Agent only, And if you are installing SQL Server it comes with all the Editions of SQL Server except Express, and express doesn't support it(so theres is not chance you can install only SQL Server Agent as per my understanding).
All you need to do is
Login into the server
Go to RUN type Services.msc
then find the Service named: SQL Server Agent.
check whether the service is running or not.
If it is not running start it.
If it is not starting up possible reason could be wrong\underpriveledge service account given as a logon account, change it.
If you are unable to find\see the service using SSMS, login to the server with Admin Rights and add the User in one of these roles:
SQLAgentUserRole
SQLAgentReaderRole
SQLAgentOperatorRole
or ask your Admin to do that for you.
Regards,
Sarabpreet Singh 😎
Sarabpreet.com
SQLChamp.com
Twitter: @Sarab_SQLGeek
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply