August 31, 2011 at 6:29 am
hai,
sql server agent node not visible in sql server management studio
checked the version of the sql server - it is enterprise edition.
checked the sql services running in sql server configuration manager and found the following 3
1. SQL Server Integration Services 10.0
2. SQL Server (SQLEXPRESS)
3. SQL Server Browser
Seems like sql server agent is not installed on my machine
How can I install sql server agent without disturbing the existing installation
Thanks
August 31, 2011 at 7:35 am
not sure of another way apart from re-running the installer....
September 2, 2011 at 9:33 pm
There might be two reasons:
1. You might have accidently selected SQLServer Express edition for installation, which will not comes with SQL Server agent
2. While installing SQL Server, you might not choosen to install SQL Server agent.
Solutions:
Case 1:
You need to rein stall the SQL Server, as the SQL Server editions are different.
Case 2:
You can go to CONTROL PANEL -> ADD or REMOVE PROG -> Microsoft SQL Server -> change -> Select the instance name -> Follow the wizard to install the agent
If any issues, write back to us.
SQLforU
info@sqlforu.com
For online training on SQL Server and Sybase, please contact
contact@sqlforu.com
www.sqlforu.com
September 7, 2011 at 1:36 am
ap123 (8/31/2011)
checked the version of the sql server - it is enterprise edition.checked the sql services running in sql server configuration manager and found the following 3
1. SQL Server Integration Services 10.0
2. SQL Server (SQLEXPRESS)
3. SQL Server Browser
How did you check that it's Enterprise Edition???
You say it yourself wthere's only a serv ice voor SQLExpress installed and the express edition doesn't have SQL Agent.
[font="Verdana"]Markus Bohse[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply