We help IT Professionals succeed at work.

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

gregca80
gregca80 asked
on
1,252 Views
Last Modified: 2012-05-07
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
Comment
Watch Question

Commented:
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 & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
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.

Author

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 & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
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.

Author

Commented:
I downloaded the install media again, and now it's working. Must have been a bug.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
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.
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.