Recently my company decided to look into using System Center Configuration Manager to help manage our servers and workstations. I decided to start learning the 2012 beta instead of the 07 R2 version.
After getting it installed I’m unable to do a push install to a client so I need to look at the reports to help figure out what’s going wrong. So I’m trying to setup a Reporting Services Point but when I click the Verify button for the Site Database Server Name and Database Name it fails with “Error.” Since it isn’t providing any further details and information for 2012 is limited I’m struggling to find a solution. Any help would be appreciated.
Here’s what I can tell you about my setup.
Server OS – Win 2k8 R2 running as a virtual machine using Hyper-V
SQL 2008 SP1 with CU14 installed
SQL Reporting services installed
I’ve verified that the Site database server name and Database Name are correct. While I’m new to SCCM I’m also new to SQL so it’s very possible I don’t have something configured correctly but I’m not sure what it would be at this point.