SSRS Data Source Authentication

• Simon Facer

  SSCertifiable

  Points: 5427

  More actions

  March 7, 2007 at 11:15 am

  #171612

  I need help, and I'm sure it's just a simple fix (hopefully). How do I set up the authentication for SSRS Data Sources - both SSAS and SQL 2005 Data sources. I have a project that is set to roll out to production soon, and both my data sources (SSAS and SQL 2005) are set up to use Windows credentials as "Credentials stored securely in the report server", and marked as "Use as Windows credentials when connecting to the data source". As it's my user Id in both, this is a problem!!

  I'm absolutely sure that this isn't the right way to do this, for either type of connection.

  Any help would be much appreciated.

   

• xanthos

  SSCrazy

  Points: 2510

  More actions

  March 12, 2007 at 4:16 am

  #694317

  You have a few options here:

  1. You can use integrated security. The report user need read permission on your datasources (or exec permission on some SP's)
  2. You can use a dedicated domain account (service-account) Besides access to your datasources this account needs the right to logon locally on your RS-server.
  3. You can use a SQL account.