Hi! I am in the process of installing and configuring Reporting Services and have run across a problem... I created a domain user to run the service,configured the virtual directories and created the database using this domain user. However when I browse to http://localhost/Reports I get the following error: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help Cannot open database "ReportingServices" requested by the login. The login failed. Login failed for user 'DOMAIN\user'. This is totally weird, since I've given the user every possible right in SQL Management Studio... I even tried giving it Administrator rights, to no effect. I can do a remote dekstop connection to themachine with this user and connect to the SQL server using the Management Studio and windows authentication just fine... Something I've missed?

HiYou mentioned that you can log on to Management Studio using Windows Authentication and being logged on on the machine as DOMAIN\user. But did you then also try to execute some query against some table within the ReportingServices database? If this works, your problem is really weird.

Yes I can query and do whatever I want to the database when I connect this way... But there is something fishy about the Reporting Services Configuration Tool... When I create the database I specify the name of the database and the username and password for this account. It then happily churns out that the database was successfully created but that I still need to apply those changes. So I click Apply, upon which I am prompted "Do you want to update the database?" Click okay, and it then generates two warnings: "The database version (C.0.8.40) does not matchyour Reporting Services installation. You must upgrade your Reporting Services database" WTF? The database it just created does not match itself?? And then it states that: "Couldn't generate the update script. There is no upgrade script available for this database version" Great... Earlier I also got some warnings that it might not have applied the user rights successfully, but I am not able to reproduce this warning anymore. So I'm guessing that even though the user has access to the database, Reporting Services is not configured to allow that user to connect? Crazy stuff... So two questions: -Is there a config file for RS where I can set these tings manually? -Is there a log file where I can see more details about what fails?

DrLeary wrote: So two questions: -Is there a config file for RS where I can set these tings manually? -Is there a log file where I can see more details about what fails? -- The log files are created in the C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles or wherever your reporting services is installed. -- At the same location in ReportManager folder you'll find RSWebApplication.config where you can set the credentials manually if you want to. But at most times it is not advisable to change security settings manually. I would suggest go to the Windows Service Identity tab in Report Server configuration tool and set the Build in account value to "Network Service" and check if that works. For the database upgrade warning, just try clicking on the Update button next to the version info and that might help.

I think you have a similar problem as in this case... http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2789139&SiteID=1 The same solution should work for you. Rahul

Hm, running the Windows Service as Network Service didn't help either, it was denied access as well.Logs pretty much all look like this: Code Snippet <Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product> <Locale>en-US</Locale> <TimeZone>W. Europe Standard Time</TimeZone> <Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__02_09_2008_12_02_18.log</Path> <SystemName>AX-DB1</SystemName> <OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName> <OSVersion>5.2.3790.131072</OSVersion></Header>w3wp!webserver!7!09.02.2008-12:02:18:: i INFO: Reporting Web Server startedw3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.w3wp!library!7!09.02.2008-12:02:18:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.w3wp!resourceutilities!7!09.02.2008-12:02:18:: i INFO: Reporting Services starting SKU: Standardw3wp!resourceutilities!7!09.02.2008-12:02:18:: i INFO: Evaluation copy: 0 days leftw3wp!resourceutilities!7!09.02.2008-12:02:18:: i INFO: Running on 1 physical processors, 2 logical processorsw3wp!runningjobs!7!09.02.2008-12:02:18:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 secondsw3wp!runningjobs!7!09.02.2008-12:02:18:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 secondsw3wp!runningjobs!7!09.02.2008-12:02:18:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 secondsw3wp!runningjobs!7!09.02.2008-12:02:18:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 secondsw3wp!library!7!02/09/2008-12:02:19:: i INFO: Call to GetPermissions:/w3wp!library!7!02/09/2008-12:02:19:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "ReportingServices" requested by the login. The login failed.Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace ---But I still think this has something to do with the Configuration Tool not working properly. If I delete the database in SQL Server Management Studio, and start over again in the Configuration Tool by choosing Service Credentials this time (but it's the same with all credetials) and clicking New. It created the database fine, but when I click Apply it churns out the message about the version not matching. If I click on the Tell me more... link I get:ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does not match a supported version. at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseUpgradeScript(String databaseName, String serverVersion, String& script)Is there some kind of update or service pack I might be missing?RMetah: I don't really see how that thread is related. He is only talking about automatically passing his credentials, and he knows the service is already working since he was able to login locally. In my case I'm not able to connect at all.

I had the same problem,I reinstall the SP2 for SQL2005 and its working now

Hi, Try to grant rights before using your report service.Go to Reporting Services Configuration Manger --> Database Setup Choose your parameters 'Server Name, Database Name'Click "connect" After Click "OK"and finally click "Apply"Do this at least once to apply rights for user.regards

Hi, If you are getting this error that means your credentials are not correct. Check what windows credentials you have for your database. If you have the sqlserver credentials then pass those sql server credentials. These can be mention in Configure Report Server -> Connect your serve -> Database Setup -> Select Credentials Type -> SQL Server Credentials -> Mention your account name and password. This solved my problem. So hope this will solve your problem too. kapil

i faced the above problem and i managed to solve it , i hvae bloged the solution in the below post. http://hanymahmoud.blogspot.com/2011/02/crm-2011-rc-installation-error-setup.html