Esri Maps pro SharePoint: Jak ladit "Esri Maps Connect" workflow?

ThomasBohnert2

<\/HEAD>

Ahoj,<\/P>

<\/P>

ví někdo, jak mohu ladit Esri Maps Connect workflow v SharePoint 2013?<\/P>

Chci číst externí data z vzdálené SQL Server DB a jediná věc, kterou vidím (s Profilerem na vzdáleném serveru), je připojení navázané jako Anonymous Logon a následující SQL příkazy jsou vykonávány:<\/P>

<\/P>

#1<\/P>

exec sp_executesql N'select TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE from INFORMATION_SCHEMA.TABLES where (TABLE_CATALOG = @Catalog or (@Catalog is null)) and (TABLE_SCHEMA = @Owner or (@Owner is null)) and (TABLE_NAME = @Name or (@Name is null)) and (TABLE_TYPE = @TableType or (@TableType is null))',N'@Catalog nvarchar(4000),@Owner nvarchar(4000),@Name nvarchar(4000),@TableType nvarchar(4000)',@Catalog=NULL,@Owner=NULL,@Name=NULL,@TableType=NULL&lt;\/P>

<\/P>

#2<\/P>

select * from ['FIRST_TABLE_FROM_THE_ABOVE_RESULT'] where 1 = 0<\/P>

<\/P>

<\/P>

Dokumentace říká, že všechny události a detaily by měly být zaznamenány do seznamu historie workflow, ale je prázdný<\/EM>. Takže výsledek je <None> ve všech rozbalovacích polích v rámci formuláře Esri Maps Connect (viz přiložený PNG).<\/P><\/P>Jakákoli pomoc nebo tip na ladění či vyřešení problému by byl velmi oceněn.<\/P><\/P>Děkuji a s pozdravem<\/P>Thomas<\/P><\/BODY><\/HTML>

CarrieDavis

Hi Thomas,

Someone from the SharePoint team might have more troubleshooting info on this.  I have successfully set up a connection with a SQL Server 08 R2 database on the same domain as my SharePoint Server.  With the current configuration of EM4S you will need to enable anonymous access by adding the following permissions to the database.

NT AUTHORITY\ANONYMOUS LOGON or NT AUTHORITY\IUSR will need to have db_reader access to the database.

If external & on the same domain also add this login/user:

[domain name]\[SharePoint server machine name]$ for example mine is AVWORLD\mysharepointmachine$ this will need db_datareader/db_datawriter/db_ddladmin permission. 

There may be issue if the SQL Server is on a different domain than your SharePoint server.  Are you able to make a business connectivity service?  Below is a sharepoint blog that might have some useful information.

Business Connectivity Services (BCS) Overview - SharePoint Blog 

If you still have issues I would suggest to reach out to the support team at support@esri.com.