Thursday, July 10, 2014

Open dtsconfig files in Notepad ++ (formatted as xml)

I often use Notepad++ as a quick way to open text files, and I want to open dtsconfig files formatted as xml :
in the settings Menu chose style configurator
then add the dtsconfig file extension to xml config:

Friday, May 30, 2014

SSRS 2008R2 refuses to start after upgrade from SSRS 2008

Scenario : After upgrading from SQL 2008 to SQL 2008 R2, reporting services refuses to start. All other SQL server services run normally after the upgrade. steps performed:

 If a AD Domain account is used, it has to be local admin for SSRS To start.
 Local services account do not work either.
uninstall/reinstall reporting services brought another issue : the setup finds - fails the IA64 OS check. The OS is not IA64.
Tried using the command line with the SKIPRULES switch without success.
New error Message : "SQL Path Element is missing" and the setup fails. 

I spent quit some time on Google looking for a solution for this, none of which works. I finally found out how to fix the issue:
 From the command line run
On the report below we can notice 2 SQL2008 component for which the instance is highlighted : MSSQLSERVER.INACTIVE
Resolution Steps to remove the inactive instance:

 First search for files called Datastore_discovery.xml and open the most recent one. List of files left after uninstalling SQL Server Look for the places containing "MSSQLSERVER.INACTIVE" below is a sample
Then look for the related lines containing ProductCode = "{B5153233-9AEE-4CD4-9D2C-4FAAC870DBE2}" (of course yours will be different)
The number of times you have to look for these product codes depend on how many components are listed as inactive. For each of the product codes that you found run: ** msiexec /x {B5153233-9AEE-4CD4-9D2C-4FAAC870DBE2} **
Do this for each product code related the MSSQLSERVER.INACTIVE that you found.

Then run setup again, click on Tools then "Installed SQL Server Features discovery report". If you can still see an instance MSSQLSERVER.INACTIVE you missed one of the Product Codes.

 After cleaning the server completely, I noticed : The existing SQL SERVER 2008R2 instance , SSIS etc.. were still running. I reinstalled SSRS and everything went fine. I did not perform any additional steps.