SQL Express now supports Reporting Services

There has been a promise for some time by Microsoft to support reporting services on SQL Express. It looks like there are finally delivering on that promise: SQL Express

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Getting the Business Intelligence Studio to show up

I was successful in getting the Business Intelligence Development Studio up and running on one of my servers. It's using SQL Server 2005 Express and by using Visual Studio and the Business Intelligence templates, I could create a project and report. No problem.

I thought I did exactly the same thing on another server. It was already running SQL Server 2005 Express and I downloaded and installed the Toolkit which is supposed to provide the Business Intelligence Development Studio. After the install, it does not show up. I ran the install of the Toolkit again and got the message that the components could not be installed as they were already installed.

I can see that the Reporting Services are running but still unable to access Business Intelligence Development Studio or the templates for creating a Report project.

Anyone run across this before and have a resolution.

Thanks,

Neil

Neil Wornes Authorized iMIS Consultant Wornes Solutions