I need to reinstall the Sql Server 2005 Agent

Question

I need to reinstall the Sql Server 2005 Agent

pucitrabbani

SSC Veteran

Points: 289
More actions
April 16, 2008 at 3:39 am

#379976

i m not in a position to reinstall the server because there are heavy transactions on it live 24 /7 in a week. so please help me out to install the sql server agent only. Your suggestion is highly appreciated. thanks in advance....
regards Imran

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Why do you need to reinstall SQL agent? What's the problem?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

pucitrabbani SSC Veteran Points: 289 More actions · Answer 2

thanks for kind attention

the problem is when i installed the sql server 2005 the agent is not installed with it and at that time i did not know about the agent. but now i have some tasks that can only be performed by jobs and on server there is no option for agent and jobs. i thinks u understand my problem. please help me out

rajankjohn SSCertifiable Points: 5061 More actions · Answer 3

is there an option to select/deselect in SQL Server Agent in the installer (I dont remember)? If so, you can add components. If not, I wonder how youavoided installing the agent. which edition you use?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Not that I can see. I jsut ran the installer. I can't see an option to not install the agent. If the database engine is installed, it is automatically installed as well.

Imran: Run SELECT @@Version please and post the results

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 5

There is no way in the installer to exclude the agent. Is it not appearing in Management Studio?

GSquared SSC Guru Points: 260824 More actions · Answer 6

SQL Server Express doesn't include SQL Server Agent. That's one possibility here.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

GSquared (4/16/2008)
SQL Server Express doesn't include SQL Server Agent. That's one possibility here.

That's what I'm thinking. Though I hope that a 24/7 heavy transaction system is not being run on sQL Express....

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

pucitrabbani SSC Veteran Points: 289 More actions · Answer 8

thanks u all .

it is also strange for me that i have installed the sql server 2005 and there is no option for agent. but when installed there is no option for sql server agent.

the version that i have installed is

so please help me out to update the server by adding the sql server agent without stoping the server ( means transactions).

best regards

IMran rabbani

Software Eng.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

Developer edition includes the agent and there's no way to install the db engine without it been installed as well. (I tested that out yesterday)

Is that the version of your production system? If so, please be aware that Developer edition may NOT be used in a production system. It's a licencing limitation on Developer that it may ONLY be used for development, not production.

If that is your production system, then you need to buy a licence for Standard or Enterprise edition and you will need to upgrade to that.

As for agent, Please have a look in services (Administrative tools - services) and look for the following service names and check the status of the service.

Sql Server

Sql Server Agent

If you connect to that server from management studio (object explorer), do you see SQL Server Agent right at the bottom

Edit: What does the following return?

exec xp_servicecontrol 'querystate', 'SQLSERVERAGENT'

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

pucitrabbani SSC Veteran Points: 289 More actions · Answer 10

when i run this command it gives the result 'Running'

but the agent is not still visible... for ur convineous , i send u image of the screen as bellow..

so please help me out it will clear to u that what probelm aactual is...

thanks in advance...

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 11

I can't see your hard drive. Image url - file:///h:/sql.bmp

Attach a jpg to your post.

SQL agent is installed and is running. Are you sysadmin on that server?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

pucitrabbani SSC Veteran Points: 289 More actions · Answer 12

i m a system administrator. the print screen image is attached with it.

thanks in advance

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 13

Try connecting from full management studio, rather than management studio express.

You can install the workstation componenents alone on your client PC from the same DVD that you installed the server.

btw, you may want to patch those servers. SQL 2000 unpatched (testsys 8.0.194) is a massive security risk. SQL 2005 unpatched is a lot better, but there were bugs in the RTM version. Current patch level is SP2.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Geoff A SSChampion Points: 11511 More actions · Answer 14

im going to post this because google brought me here and there was no answer. Now, i have an answer so i will share....

my agent also disappeared from an install of SQL 2005. The reason is not known for 100% sure, but i believe it was from a SQL 2008 upgrade that was rolled back to SQL 2005. I could be wrong, but I did in fact end up with a perfect SQL engine and no agent. The solution was to recreate the service like this;

C:\>sc create SQLAgent binPath= "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAGENT90.EXE" type= own start= auto depend= netbios

after i started the newly created service, my SQL jobs started working again without issue. (i also changed the account that runs the service from "local account" to a domain admin account)