Credentials not quite right - rsErrorOpeningConnec

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Credentials not quite right - rsErrorOpeningConnec

Author

Topic

teahou
Starting Member

4 Posts

Posted - 2012-03-13 : 15:42:38

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'AdventureWorks2008'. (rsErrorOpeningConnection)
Cannot open database "AdventureWorks2008" requested by the login. The login failed. Login failed for user '<domain>\<login>'.

This is a setup on my local machine, nothing remote.

My settings:

In BIDS -> Shared Data Source -> Creds -> Windows Auth

In SQL Server -> Security -> Logins -> MyLogin Properties -> Server Roles -> public and sysadmin

In Reporting Config -> Service Account -> Network Service

In Reporting Config -> Database -> Databasename -> ReportServer

In Reporting COnfig -> Database -> Credential -> Windows Account

In Report Manager -> Assign Roles -> System Admin (Note: Content manager is not listed)

I am not sure what I am missing. I can view and deploy reports in BIDS and I can go to localhost/reports and localhost/reportserver and the reports are listed there, but when I click to view, I get the above error. Please let me know what I need to change, thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-03-13 : 15:46:32

which server the datasource is trying to connect to? what the credential set for it in reportmanager?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

teahou
Starting Member

4 Posts

Posted - 2012-03-13 : 16:45:34

Shared Data source: Name is AdventureWorks2008.

Connection string: Data Source=(local);Initial Catalog=AdventureWorks2008

"what the credential set for it in reportmanager?"
Not totally sure what your asking for. The Service Account is set to Network Service and the DB Credentials are set to Windows Account wioth my <domain>\<login> and password.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-03-13 : 23:03:43

nope for datasource that is deployed to report manager is it using service account itself or remotely stored credential?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

teahou
Starting Member

4 Posts

Posted - 2012-03-14 : 10:33:59

The shared data source accessed through BIDS, the credentials are set to "Use Windows Authentication (integrated Security). I am on a network using AD, so I guess my credentials are stored on the network.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources