Strange Problem with SQL Server 2005 Reporting Service Database Name

Thursday, 30 April 2009 23:21 by RanjanBanerji

I was setting up SQL Reporting Services today and observed a very strange problem.  Once everything was installed and I was using the Reporting Services Configuration Tool I kept getting an error when trying to create the Reporting Service database.  The error was none specific and said I should look into permissions.  I checked permissions and determined that was not the problem.

I then proceeded to use the generate script option and executed the script in SQL Management Studio and I saw that there was an error.  The error was towards the bottom of the script at the following line:

 

-- END STORED PROCEDURES

USE XYZ[XYZReportServerTempDB]

-- standard script to set the database version, can  be used both the catalog database and the tempdb database

 

The error was that XYZ database did not exist. Indeed it did not. The big question is why did the script say Use XYZ{XYZReport…] to start with? I then set out to try the following:

  1. Try to configure reporting services with a database named XYZReportServer
  2. Try to configure reporting services with a database named XYZ

What needs to be kept in mind is that the default name for a SQL Reporting Services database is ReportServer.  Generating scripts for these two different database names gave some interesting results.  No errors with the database name as XYZ.  But XYZReportServer will generate the error.  Further testing showed that [AnyName]ReportServer generated this error.  Any other database name worked.

So what’s with this?  I briefly searched and did not find anything on this subject.  Is it a bug?  a feature?  Is it something that only I have experienced?  I will have to try and reproduce this error on a different instance of SQL Server 2005 Reporting Services.  In the mean time if you are getting an error creating a reporting services database check the name.

Categories:   SQL Server
Actions:   E-mail | Permalink | Comments (0) | Comment RSSRSS comment feed