CHAPTER 3-Lesson 2: Deploying SSIS Packages, exercise 2 Deploy your Packages by using an Installer Kit

I'm using the self paced training kit Exam 70-448: MCTS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance.

I had problems and errors completing exercise at the end of step 3-verify the packages were deployed.  I was abIe to run the installer kit via {project name}.SSISDeploymentManifest and was able to connect to the Integration Service in SSMS.  However when I tried to expand the Stored Packages under the MSDB folder, I received a message that the system couldn’t find the files and the message indicated I didn’t have a default instance installed on my server.

After reviewing my installation I saw my default MSSQLSERVER instance was under a sql 2008 express version and I’m working with sql 2008 R2 developer.  To correct this issue I had to uninstall the sql 2008 express version as follows:

• Go to: Start Menu>Control Panel>Programs and Features>Microsoft SQL Server 2008>Uninstall/Change
• Wait for the SQL installer to open and select the MSSQLSERVER instance from the dropdown and uninstall. (Note: I uninstalled several instances I wasn't using.)
• Then I reran the SQL Server 2008 R2 Development Studio installer and installed the default MSSQLSERVER instance.

So far everything is checking out. It took about 4 hours to troubleshoot.  Moving on.