attachments/jcowan/media/windowslivewriter/scsm2012unabletodeploythedatawarehousedu_abfe/clip_image001_thumb.png

SCSM 2012: Unable to deploy the Data Warehouse due to Underscores used within the SQL Instance name

You may have run into this issue of having an underscore in the Instance name, are trying to deploy SCSM, and can’t seem to find out the resolution.  What do you do??

Situation:

I can hit both the RS URLs and the service is running fine prior to deploying SCSM 2012.  The SSRS instance is located on the RDBMS SQL instance for the ServiceManager DB, and SSAS is also deployed to this same server.

No matter what I try, I still get this error even though I was running SQL Server 2008 R2 SP1…

"The SQL Server is not running version SQL Server 2008 SP2 or SQL Server 2008 R2. Please update it to the newest version and retry"

clip_image001

Other known issues:

http://social.technet.microsoft.com/Forums/en-US/setup/thread/d352ee42-d607-46a0-8caa-91070d014256

http://social.technet.microsoft.com/Forums/en-US/setup/thread/cc319477-1045-40ca-8aa0-113aaaa39742

 

Resolution:

  • DO NOT use Underscores “_” within the SSRS instance and DW SQL instances.

 

As easy as this sounds, this was the resolution, but it required an uninstall of the instance, and a reinstall of the instance ID

 

Thank you to Danny Ruiz for pointing out this quirk!

3 Comments

  1. Ryan Cook April 24, 2013
  2. Mike July 19, 2013
  3. JP May 30, 2014

Leave a Reply