Issue with DPM 2007 connecting to it's agent

My DPM (2007) backup server is unable to connect to my SQL 2000 server database. I'm able to ping the server from my DPM server. Is there an issue with the two (DPM 2007 and SQL Server 2000)?

Who is Participating?
pjamConnect With a Mentor Commented:
Sorry my bad, I thought it said you could not ping.  Is the small business server 2003 32-bit?
If so check out this KB:

So when you go to add the server (with all prerequisites installed) DPM doesn't see the server with SQL2000?
Are they both in the same domain?
I only backup the SQL backups here for SQL 2005, works withought a hitch.  Don't know why there would be an issue with SQL 2000, but it seems you have a network issue rather than DPM since you cannot ping.
jmichaelpalermo4Author Commented:
They are both in the same domain and I can ping the servers from each other
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

jmichaelpalermo4Author Commented:
Ah sorry, I should have provided more info: The DPM is running Server 2008 Enterprise x64. I can see the SQL server in the list, but the database does not appear when I expand it.
just a thought have you enabled an Enterprise license for SQL?  I am fairly sure that is reqired for SQL and why I only backup the SQL backups.  So you need 2 Enterprise licnces.   See attached jpeg of my licenses.  You can access your licenses on the Management\Agents tab and then "Update Licenses" is on the far right.  Just for kicks make sure it is 2 for Enterprise and then see if you can see database, you can try that without purchasing to see if it works.

update licenses
What did you do to make it work?  Just curious.
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.