Solved

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

Posted on 2009-07-04
7
1,181 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
0
Comment
Question by:gregca80
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 4

Expert Comment

by:nasserd
ID: 24778308
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.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24778548
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.
0
 

Author Comment

by:gregca80
ID: 24778783
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 :(
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24778875
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.
0
 

Author Comment

by:gregca80
ID: 24778981
I downloaded the install media again, and now it's working. Must have been a bug.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24779112
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.
0
 

Accepted Solution

by:
gregca80 earned 0 total points
ID: 24779116
i downloaded the vcenter software again.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Backup skipping a few tables 7 58
Substring works but need to tweak it 14 31
Need to merge 3 large tables into one Table in SQL server 2 25
denied execute as 13 31
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question