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
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 data source problem in ssrs 2008 r2

Author  Topic 

jassie
Constraint Violating Yak Guru

332 Posts

Posted - 2012-05-14 : 18:00:30
I am having a data source problem on a report builder 3.0 report that I am setting up. I am using a custom data source that is not shared with any other applications.

For the connections to work, I can get the 'credentials stored securely in the report server' to work. However I would prefer for the 'windows entegrated security' option to work.

Note: This option only started to work once I changed the owner of the database from myself to a 'sql login' that I just created. The sql login that I just created is in the security section only for the database instance. This sql login is not in the security are for the new database that I just created called 'testdb'.

Thus can you tell me what I need to do make the 'windows integrated security to work?
   

- Advertisement -