Prev: access to reporting services
Next: SharePoint Reports Not Viewable
From: orcamajo on 9 Mar 2010 08:51
Error Message:

* Cannot create a connection to data source 'DS_Chevo2_JM.rsds'.
(rsErrorOpeningConnection)
o For more information about this error navigate to the report
server on the local server machine, or enable remote errors


Systems:

* Windows Server 2003 R2 running WSS 3.0 SP2
* Windows Server 2003 R2 running SQL 2005 SP3, Reporting Services, WSS
3.0 object model only

Couple of items of note: SP2 for WSS 3.0 shows installed on the SQL Server
box but in Central Administration the version still shows as 12.0.0.4518 not
12.0.0.6421 like my other front end. Also BI studio is not installed on the
SQL 2005 box.

I have integrated SQL2005 Reporting Services with SharePoint. Both RS
accounts, windows and service, are running under the same domain account. I
have created the unattended execution account which runs under the same
domain account. I have given the domain account Full Control over the reports
library I am using. I realize my permissions are wide open but I am trying
to get this working and then lock down after I understand the issues. I am
able to generate the data source from SharePoint with no problems. When I try
to generate a model from SharePoint I receive the RSErrorOpeningConnection
error in relation to trying to create a connection to the data source. I am
stumped at this point. Any help would be appreciated by both myself and the
client.


From: orcamajo on 20 Mar 2010 06:57
So after working with MS on this issue we were able to get it working by
making two major changes. The first was that NTLM was not set as the
authentication mode on the Report Server. This despite IIS saying to the
contrary. We had to run 'cscripts adsutil.vbs set W3svc/{the id of the Report
Server web site}/ ntauthenticationprovider "NTLM" to set the provider.

We also had to change the app pool account that my SharePoint site was
running under. I have a single front end and a SQL backend with RS running on
it. My app pool account was network service. This had to be changed to a
domain account and voila!!

Please keep in mind SP is connecting to RS using Trusted Account Mode. I did
not set up Kerberos to run in Windows Authentication. Hope this helps someone
else.


"orcamajo" wrote:

> Error Message:
>
> * Cannot create a connection to data source 'DS_Chevo2_JM.rsds'.
> (rsErrorOpeningConnection)
> o For more information about this error navigate to the report
> server on the local server machine, or enable remote errors
>
>
> Systems:
>
> * Windows Server 2003 R2 running WSS 3.0 SP2
> * Windows Server 2003 R2 running SQL 2005 SP3, Reporting Services, WSS
> 3.0 object model only
>
> Couple of items of note: SP2 for WSS 3.0 shows installed on the SQL Server
> box but in Central Administration the version still shows as 12.0.0.4518 not
> 12.0.0.6421 like my other front end. Also BI studio is not installed on the
> SQL 2005 box.
>
> I have integrated SQL2005 Reporting Services with SharePoint. Both RS
> accounts, windows and service, are running under the same domain account. I
> have created the unattended execution account which runs under the same
> domain account. I have given the domain account Full Control over the reports
> library I am using. I realize my permissions are wide open but I am trying
> to get this working and then lock down after I understand the issues. I am
> able to generate the data source from SharePoint with no problems. When I try
> to generate a model from SharePoint I receive the RSErrorOpeningConnection
> error in relation to trying to create a connection to the data source. I am
> stumped at this point. Any help would be appreciated by both myself and the
> client.
>
>
 | 
Pages: 1
Prev: access to reporting services
Next: SharePoint Reports Not Viewable