asked on

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?

Thanks!
vcenter.JPG

nasserd

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 R

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.

gregca80

ASKER

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 R

Do you have a 64 bit machine with you...

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

c:\windows\system32\odbcad.exe

And your 32 bit version of DSN in the path below

c:\windows\sysWOW64\odbcad32.exe

Kindly check whether you are using the appropriate DSN versions.

gregca80

ASKER

I downloaded the install media again, and now it's working. Must have been a bug.

Raja Jegan R

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.

ASKER CERTIFIED SOLUTION

gregca80

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial