Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Cannot create Report Builder Model from WSS 3.0 using SQL2005 Reporting Services

Asked By: Celia Bond Date: Apr 06, 2009 Category: Sharepoint Views: 401

Error Message:


Cannot create a connection to data source 'DS_Chevo2_JM.rsds'.
(rsErrorOpeningConnection)
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.

Tagged:cannot create report builder model from wss using sql2005 reporting services

1 Answer Found

Answer #1 Answered By: Lizette Mcconnell Answered On: Apr 06, 2009

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.

Didn't find what you were looking for? Find more on Cannot create Report Builder Model from WSS 3.0 using SQL2005 Reporting Services Or get search suggestion and latest updates.