Tuesday, June 17, 2008

Problem on SQL Server 2005

Recently just upgraded my SQL Server 2005 Express to Standard Edition.There was a problem on my Reporting Services. I couldn't see my Business Intelligence Project there and when I create the Report there was no Designer and Preview Mode.

Then I google about this problem. Found a solution as below:

go to the location for SQL Server setup and run .\Tools\Setup\vs_setup.exe.
This will install the VS Shell. After this is installed repair the BI Studio installation by running the following from the command line from the .\Tools directory: start /wait setup.exe /qb REINSTALL=SQL_WarehouseDevWorkbench REINSTALLMODE=OMUS

After all, still not appear. I was so frastrated and decided to uninstall and reinstall my SQL Server 2005 Standard Edition.

Finally, after reinstall then it works perfectly...I can create a Business Intelligence Project now.

No comments: