Error when attempting to use Windows Authentication
- When
- attempting to use windows Authentication for the data source. I get the error below. I can run the report from the report server, but when running from another machine over the intranet the error occurs.
- An error has occurred during report processing.
- Cannot create a connection to data source 'MyDataSource'.
- For more information about this error navigate to the report server on the local server machine, or enable remote errors
Connecttion type: Microsoft SQL server
Connection string: Data Source=MyServerName;Initial Catalog=MyDatabaseName
Connect Using: Windows Integrated Security
John,
Reporting Services relies on the authentication capabilities of the underlying network. So, RS does not authenticate users itself.
Have a look at the roles and the Browser role in particular. See which users have been assigned to this role. It's possible there aren't any users so you will have to add them. RS does not create it's own user accounts, instead it uses the users or groups from the computer. You might want to add a local group with users you want to view reports and add that group to the browser role.
Regards,
Worf
Extract from BOL Topic "Specifying Credential and Connection Information":
Windows NT Integrated Security
When you use the Windows NT Integrated Security option, the report server passes the credentials of the user accessing the report to the server hosting the external data source. In this case, the user is not prompted to type a user name or password.
This approach is recommended if Kerberos is enabled. If Kerberos is not enabled, you should only use this approach if all the servers that you want to access are located on the same computer. For more information, see "Connecting to Remote Data Sources" earlier in this topic.
