• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 486
  • Last Modified:

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)?

Thanks
0
jmichaelpalermo4
Asked:
jmichaelpalermo4
  • 4
  • 2
1 Solution
 
pjamCommented:
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.
0
 
jmichaelpalermo4Author Commented:
They are both in the same domain and I can ping the servers from each other
0
 
pjamCommented:
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:  http://support.microsoft.com/kb/940439

So when you go to add the server (with all prerequisites installed) DPM doesn't see the server with SQL2000?
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
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.
0
 
pjamCommented:
Ah,
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
0
 
pjamCommented:
jmichaelpalermo4:
What did you do to make it work?  Just curious.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now