SharePoint and SSRS integration has always been something of a challenge, to the point where someone at MS actually wrote a very detailed document and posted it on his own blog. Having gone through this a number of times I thought I had it down pat but apparently I was wrong.

SQL 2005 SP3 introduces a new bug when creating the Report Server databases. It creates the script fine, but then errors out afterwards. If you check your SQL Manager you’ll notice that the databases have been created but they’re empty.

What’s happening is that the script which creates the databases is being created with syntax errors. Assuming the DB you’re creating is called ReportServer, the script should use the following syntax :

USE [ReportServer]

…what it actually uses is :

USE ReportServer

In order to do this, choose the option during the setup to create the scripts and save them to disk, not create the databases. Open up NotePad and do a find and replace. You’ll need to check the temp DB too.