Can you create a connection to data source datasource1?
The datasource1 is an internal datasource so don’t bother looking for it. If you look in the trace logs it’s passing ANONYMOUS LOGON, which has no permissions. So, to fix first create a user with Admin privileges with the same credentials on both servers.
How to fix connection to data source error?
The simple fix is to hardcode a username/password into your datasource. The harder fix is to properly impersonate/delegate your windows credentials through the report manager, to the underlying datasource.
How to solve reporting services ” cannot create “?
This link will download a Microsoft Dynamics GP SRS Report Roles document which can help with identifying which roles will grant permissions to which reports. It does require a customer source login to download, so if you are having trouble accessing the content, reach out to your Dynamics GP partner.
How to create SSRS report in SQL Server?
The final step will be to officially create the login. Click the OK button on the New Login… window and it will do everything to create the login with the security you just defined. That is all you need to do in order to grant security on the SQL side of things for SSRS report.
Can a user not access a data source?
Steve Ho’s scenario is that a user could not access external report’s data source with the credentials of Windows Integrated Security. In this case, the user is not prompted to type a user name or password. This approach is recommended if impersonation and delegation features are enabled.
How to use Windows Integrated Security with DataSource?
Windows Integrated Security only works if your domain has Kerberos-delegation enabled – otherwise you will need to store credentials on the report server (more details: http://msdn2.microsoft.com/en-us/library/ms160330 (SQL.90).aspx) Most likely, you configured the data source credentials to use “Windows Integrated Security”.
How to test a connection to data source?
Looking at the datasource properties on the server, data source is Microsoft SQL Server, Connection string points to the correct server and database and the credentials used are Windows Integrated Security. When I “Test Connection” I receive Connection created successfully.