-
Title
Error: Cannot create a connection to data source 'SharedDataSource' -
Description
When generating a report for InTrust Plugin for Active Directory, the following error is generated:
An error has occurred during report processing.
Cannot create a connection to data source 'SharedDataSource'
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings sql server does not allow remote connections.(Provider:Named pipes provider,error:40-Could not open a connection to SQL Server) -
Cause
The data source string is not correctly filled out.
-
Resolution
Confirm the correct data source is being used and that a connection string exists for the report.
1. In Knowledge Portal, go to the report and click on "Change Report Properties".
2. Under the "Properties" menu, click on "Data Sources".
3. The "A Shared data source" is pointing to "/QKP/SharedDataSources/InTrust Audit" by default. If it is pointing to another data source, that is OK, too.
4. Now open another Internet Explorer window and go to SQL Server's Reporting Services webpage. The default is http://Srs_servername_hostname/reports (please replace <Srs_servername_hostname> with the host name of the Reporting Services server.
5. In step #4's window, click "Details View" and navigate to the InTrust Audit data source. The default would be to click on QKP | SharedDataSources | InTrust Audit as pointed out in step #3. If step 3 is different, follow the same path.
6. Once the data source is clicked, under "Properties" menu on the left pane, the "Connection string:" displays the connection string. Make sure that is filled out correctly. If it is not filled out, the default would be:
data source= questen3;initial catalog= InTrust_Audit_DB ;
Note: The "data source" is the hostname of the SQL Server. The "initial catalog" is the name of the InTrust Audit Database. The exact name can be found in InTrust Manager in Configuration | Data Stores | Databases | the audit database will be displayed on the right pane and, under the "database" column, is the name of the database you need to enter for "initial catalog".
1. Click "Apply"
2. Re-run the desired report.