Хочу построить отчет на основе данных в списке SharePoint
Создала RS -project, в нем источник данных с типом Microsoft SharePoint List, в Credentials - "Use Windows Authentication (integrated security)". Затем DataSet и сам отчет.
Посмотрела в Prewiew - замечательно.
Задеплоила.
Открываю отчет со сттраницы Reports - ошибка:

Произошла ошибка при обработке отчета. (rsProcessingAborted)
The execution failed for the shared data set 'DataSet1'. (rsDataSetExecutionError)
Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)
An error occurred when accessing the specified SharePoint list. The connection string might not be valid. Verify that the connection string is correct. (rsSPDataProviderError)
Чтобы получить дополнительные сведения об этой ошибке, перейдите к серверу отчетов на локальном сервере или включите удаленный контроль ошибок

Права везде на все есть. В Prewiew - все прекрасно. Не знаю, что и думать...
М.б. кто-то сможет помочь?

iljy,

я не знаю, как это сделать. Сервер отчетов на локальном сервере - это что имеется в виду?... :(

Ray D,

Извинения, что дальше длинно, зато точно. Цитирую инструкцию (по ней пытаюсь законнектиться для SharePoint integrated mode) :

Connect to a Report Server in Management Studio
You can connect to a native mode report server or a report server that runs in SharePoint integrated mode.
...

To connect to a SharePoint integrated mode report server
1. If Object Explorer is not already open it, select it from the View menu.
2. Click Connect to view the list of server types, and then select Reporting Services.
3. In the Connect to Server dialog box, enter a URL to a SharePoint site. The following example illustrates the syntax: http://<web server>/sites/<site>.
4. Select the authentication type. If you are using Windows Authentication, you must connect using your credentials. If you select Basic authentication or Forms authentication, type the account and password.

Click Connect. The report server appears in Object Explorer.

Не проходит. Там дальше в инструкции:

To register a report server
If you cannot connect to a report server, you either do not have permission to access it or it must be registered. To register the server, click Registered Servers on the View menu,

Click the Reporting Services icon.

Right-click Reporting Services, point to New, and then click Server Registration. The New Server Registration dialog box is displayed.

For Server name, enter a value. The value that you must specify will vary depending on the server mode:

For a native mode report server, type the name of the report server instance. Report server instance names are based on SQL Server instance names. By default, the instance name of a local report server instance is just the computer name. If you installed the report server as a named instance, use this syntax to specify the server: <servername>[\<instancename>].

For a report server that runs in SharePoint integrated mode, the server to connect to is the SharePoint site with which the report server is connected. Connecting to the SharePoint site is necessary so that you can view the permission levels that control access to report server content and operations. You can specify any site in the site collection. The following example illustrates the syntax: http://mysharepointsite.

For Authentication, select which authentication mode to use to access the Web server. You must choose the authentication mode that the report server is already using.

If you are using default security, choose Windows Authentication.

If you installed and deployed a custom security extension, choose Forms Authentication.

If you configured the report server to use Basic authentication, choose Basic Authentication.

If the report server is configured for SharePoint integrated mode, choose Windows Authentication.

Click Test to verify the connection.

Все делаю по инструкции, кликаю TEST, получаю ошибку: Testing the registered server failed. Verify the server name, login credentials, and database, and then dick Test again. Additional information:
Unable to connect to the server at http://srvspoint-co1/ntb The specified URL might not be valid or there might be a pro
Unable to connect to the server at http://srvspoint-col/ntbl. The specified URL might not be valid or there might be a problem with the report server version or configuration. Specify a different URL, or contact your server administrator to verify that the report server runs SQL Server 2008 or later. Additionally, if you are trying to connect to a SharePoint-integrated report server, verify that SharePoint Is installed on the server and that the report server uses SharePoint integrated mode. (Microsoft. SqlServer. Management. UI. RSClient)

Как проверить, что SP установлен на сервере и использует SharePoint integrated mode? Что делать?... :(

Модератор: Тема перенесена из форума "Microsoft SQL Server".

Не знаю, устанавливала не я. А можно это где-то посмотреть? В студии, например?

Ray D,

Сделала, вижу дерево с ветками:Jobs, Security, Shared Schedules. И что мне это дает?

Ray D,

готово. Значит, все же native mode report server?
Ну хорошо, заново запустила отчет. Все то же сообщение об ошибке, и новое в конце: The request failed with HTTP status 401: Unauthorized.

:(