Please make sure SQL Server Agent service is running on the database server

Trying to do a fresh install of vmware's vcenter 4 and I get the following message when entering the db credentials. I've tried both sql and windows authentication, same thing. Trying this on SQL 2005.

I checked the sql server and the agent is definitely running. Maybe there is something I'm missing.

Anyone know what the problem is?

Who is Participating?
gregca80Connect With a Mentor Author Commented:
i downloaded the vcenter software again.
From the screenshot, perhaps its the DSN you're using.

Or, how SQL Server 2005, by default, disables remote connectivity.  You'd have to get into the SQL Server configs to modify how and which protocols are connectable remotely.
Raja Jegan RSQL Server DBA & ArchitectCommented:
Open Services.msc and check whether SQL Server Agent Service is started.
Right Click on that service and choose properties, Change the Startup type to Automatic and then start it.

Its done and you wont face this issue later on.
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

gregca80Author Commented:
I've tried setting up multiple versions of the DSN with different versions of the sql native client, same thing.

The sql server agent is already running. That's the first thing I checked, it's already set to automatic.

Still stuck :(
Raja Jegan RSQL Server DBA & ArchitectCommented:
Do you have a 64 bit machine with you...

If you have 64 bit machine, then your 64 bit DSN will be in


And your 32 bit version of DSN in the path below


Kindly check whether you are using the appropriate DSN versions.
gregca80Author Commented:
I downloaded the install media again, and now it's working. Must have been a bug.
Raja Jegan RSQL Server DBA & ArchitectCommented:
Kindly explain what you meant by install media so that it can be helpful for others who might be viewing this question later on.

Also close this question if the problem is resolved.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.