Summary: Running ArcSDESQLExecute fails when using OPENQUERY. Error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.(18456) System: SQL Server 2008r2 (Enterprise Database - "DB1") and 2016 SP2 (Non-Enterprise Database connected with OPENQUERY - "DB2") Driver: ODBC Driver 13 for SQL Server Python: Pro 2.2.2 instance (3.6.5) Connection Files Created with Catalog 10.3.1 Details: Executing a simple query with ArcSDESQLExecute is successful. When OPENQUERY is used it appears credentials are not passed to the joined server/database. I've tested this with several users that are added as Logins to the Servers and Databases. This query runs properly in SQL Server Management Studio. Other SQL Log Errors: * There is already an object named '##SDE_8868_184399_DB1' in the database. * Invalid object name 'DB1.dbo.SDE_branches'. (208) * Statement(s) could not be prepared. (8180) * Invalid object name 'DB1.PSLARKIN.SDE_logfiles'. (208) SELECT gis_ACO_NUM , PID_NUM FROM ( SELECT LTRIM ( RTRIM ( ACO_NUM ) ) ACO_NUM , LTRIM ( RTRIM ( PID_NUM ) ) PID_NUM FROM DB1 . DB1SCHEMA . SEGPOINTS WHERE ( SUBSTRING ( PID_NUM , 6 , 1 ) = '.' AND LEN ( PID_NUM ) = 10 ) OR ( SUBSTRING ( PID_NUM , 6 , 1 ) = '.' AND LEN ( PID_NUM ) = 11 AND SUBSTRING ( PID_NUM , 11 , 1 ) NOT LIKE '%[^a-zA-Z]%' ) UNION SELECT LTRIM ( RTRIM ( ACO_NUM ) ) ACO_NUM , LTRIM ( RTRIM ( PID_NUM ) ) PID_NUM FROM DB1 . DB1SCHEMA . SEGHISTORYPOINT WHERE ( SUBSTRING ( PID_NUM , 6 , 1 ) = '.' AND LEN ( PID_NUM ) = 10 ) OR ( SUBSTRING ( PID_NUM , 6 , 1 ) = '.' AND LEN ( PID_NUM ) = 11 AND SUBSTRING ( PID_NUM , 11 , 1 ) NOT LIKE '%[^a-zA-Z]%' ) ) AS segPoints --section above the join will run correctly with ArcSDESQLExecute. Section below will not. LEFT JOIN ( SELECT DISTINCT CASE WHEN SUBSTRING ( seg_merge_nbr , 3 , 1 ) = '-' AND SUBSTRING ( seg_merge_nbr , 1 , 2 ) IN ( '97' , '98' , '99' ) THEN '19' + REPLACE ( seg_merge_nbr , '-' , '' ) WHEN SUBSTRING ( seg_merge_nbr , 3 , 1 ) = '-' AND SUBSTRING ( seg_merge_nbr , 1 , 2 ) IN ( '00' ) THEN '20' + REPLACE ( seg_merge_nbr , '-' , '' ) ELSE seg_merge_nbr END gis_ACO_NUM , parent_parcel FROM OPENQUERY ( DB2Server , 'SELECT seg_merge_nbr,parent_parcel,seg_status_cd FROM DB2Server.DB2.DB2Schema.seg_merge' ) where seg_status_cd = 'DONE' ) AS asc_seg ON ACO_NUM = gis_ACO_NUM AND PID_NUM = parent_parcel WHERE gis_ACO_NUM is not null

I guess Assumed Answered is legit because OPENQUERY does work! I just have no idea why im getting this intermittent error!

Unfortunately, there isn't an easy way to do that, but we can keep discussing it here anyways. So, how is the linked server security set up? And, since it works part of the time, any ideas of what is changing over time.

The error is still occurring intermittently. Please remove the 'Assumed Answered' mark.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcSDESQLExecute compatible with OPENQUERY?

PhilLarkin1

Summary: Running ArcSDESQLExecute fails when using OPENQUERY.

Error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.(18456)

System: SQL Server 2008r2 (Enterprise Database - "DB1") and 2016 SP2 (Non-Enterprise Database connected with OPENQUERY - "DB2")

Driver: ODBC Driver 13 for SQL Server

Python: Pro 2.2.2 instance (3.6.5)

Connection Files Created with Catalog 10.3.1

Details:

Executing a simple query with ArcSDESQLExecute is successful. When OPENQUERY is used it appears credentials are not passed to the joined server/database. I've tested this with several users that are added as Logins to the Servers and Databases. This query runs properly in SQL Server Management Studio.

Other SQL Log Errors:

There is already an object named '##SDE_8868_184399_DB1' in the database.
Invalid object name 'DB1.dbo.SDE_branches'. (208)
Statement(s) could not be prepared. (8180)
Invalid object name 'DB1.PSLARKIN.SDE_logfiles'. (208) <- Will reference my user name regardless of which OS user is set in the SDE connection file.

Query:

<SPAN class="keyword token">SELECT</SPAN> gis_ACO_NUM <SPAN class="punctuation token">,</SPAN> PID_NUM <SPAN class="keyword token">FROM</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">SELECT</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LTRIM<SPAN class="punctuation token">(</SPAN>RTRIM<SPAN class="punctuation token">(</SPAN>ACO_NUM<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> ACO_NUM
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">,</SPAN>LTRIM<SPAN class="punctuation token">(</SPAN>RTRIM<SPAN class="punctuation token">(</SPAN>PID_NUM<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> PID_NUM
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">FROM</SPAN> DB1<SPAN class="punctuation token">.</SPAN>DB1SCHEMA<SPAN class="punctuation token">.</SPAN>SEGPOINTS
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">WHERE</SPAN> <SPAN class="punctuation token">(</SPAN> SUBSTRING<SPAN class="punctuation token">(</SPAN>PID_NUM<SPAN class="punctuation token">,</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'.'</SPAN> <SPAN class="operator token">AND</SPAN> <SPAN class="token function">LEN</SPAN><SPAN class="punctuation token">(</SPAN>PID_NUM<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">10</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">OR</SPAN> <SPAN class="punctuation token">(</SPAN> SUBSTRING<SPAN class="punctuation token">(</SPAN>PID_NUM<SPAN class="punctuation token">,</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'.'</SPAN> <SPAN class="operator token">AND</SPAN> <SPAN class="token function">LEN</SPAN><SPAN class="punctuation token">(</SPAN>PID_NUM<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">11</SPAN> <SPAN class="operator token">AND</SPAN> SUBSTRING<SPAN class="punctuation token">(</SPAN>PID_NUM<SPAN class="punctuation token">,</SPAN><SPAN class="number token">11</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">NOT</SPAN> <SPAN class="operator token">LIKE</SPAN> <SPAN class="string token">'%[^a-zA-Z]%'</SPAN> <SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">UNION</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">SELECT</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LTRIM<SPAN class="punctuation token">(</SPAN>RTRIM<SPAN class="punctuation token">(</SPAN>ACO_NUM<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> ACO_NUM
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">,</SPAN>LTRIM<SPAN class="punctuation token">(</SPAN>RTRIM<SPAN class="punctuation token">(</SPAN>PID_NUM<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> PID_NUM
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">FROM</SPAN> DB1<SPAN class="punctuation token">.</SPAN>DB1SCHEMA<SPAN class="punctuation token">.</SPAN>SEGHISTORYPOINT
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">WHERE</SPAN> <SPAN class="punctuation token">(</SPAN> SUBSTRING<SPAN class="punctuation token">(</SPAN>PID_NUM<SPAN class="punctuation token">,</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'.'</SPAN> <SPAN class="operator token">AND</SPAN> <SPAN class="token function">LEN</SPAN><SPAN class="punctuation token">(</SPAN>PID_NUM<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">10</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">OR</SPAN> <SPAN class="punctuation token">(</SPAN> SUBSTRING<SPAN class="punctuation token">(</SPAN>PID_NUM<SPAN class="punctuation token">,</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'.'</SPAN> <SPAN class="operator token">AND</SPAN> <SPAN class="token function">LEN</SPAN><SPAN class="punctuation token">(</SPAN>PID_NUM<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">11</SPAN> <SPAN class="operator token">AND</SPAN> SUBSTRING<SPAN class="punctuation token">(</SPAN>PID_NUM<SPAN class="punctuation token">,</SPAN><SPAN class="number token">11</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">NOT</SPAN> <SPAN class="operator token">LIKE</SPAN> <SPAN class="string token">'%[^a-zA-Z]%'</SPAN> <SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">AS</SPAN> segPoints
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">--section above the join will run correctly with ArcSDESQLExecute. Section below will not.</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">LEFT</SPAN> <SPAN class="keyword token">JOIN</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">SELECT</SPAN> <SPAN class="keyword token">DISTINCT</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">CASE</SPAN> <SPAN class="keyword token">WHEN</SPAN> SUBSTRING<SPAN class="punctuation token">(</SPAN>seg_merge_nbr<SPAN class="punctuation token">,</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'-'</SPAN> <SPAN class="operator token">AND</SPAN> SUBSTRING<SPAN class="punctuation token">(</SPAN>seg_merge_nbr<SPAN class="punctuation token">,</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">IN</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'97'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'98'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'99'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'19'</SPAN> <SPAN class="operator token">+</SPAN> REPLACE<SPAN class="punctuation token">(</SPAN>seg_merge_nbr<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'-'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">WHEN</SPAN> SUBSTRING<SPAN class="punctuation token">(</SPAN>seg_merge_nbr<SPAN class="punctuation token">,</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'-'</SPAN> <SPAN class="operator token">AND</SPAN> SUBSTRING<SPAN class="punctuation token">(</SPAN>seg_merge_nbr<SPAN class="punctuation token">,</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">IN</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'00'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'20'</SPAN> <SPAN class="operator token">+</SPAN> REPLACE<SPAN class="punctuation token">(</SPAN>seg_merge_nbr<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'-'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">ELSE</SPAN> seg_merge_nbr
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">END</SPAN> gis_ACO_NUM
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">,</SPAN>parent_parcel
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">FROM</SPAN> <SPAN class="keyword token">OPENQUERY</SPAN><SPAN class="punctuation token">(</SPAN>DB2Server<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'SELECT seg_merge_nbr,parent_parcel,seg_status_cd FROM DB2Server.DB2.DB2Schema.seg_merge'</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">where</SPAN> seg_status_cd <SPAN class="operator token">=</SPAN> <SPAN class="string token">'DONE'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">AS</SPAN> asc_seg
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">ON</SPAN> ACO_NUM <SPAN class="operator token">=</SPAN> gis_ACO_NUM <SPAN class="operator token">AND</SPAN> PID_NUM <SPAN class="operator token">=</SPAN> parent_parcel
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">WHERE</SPAN> gis_ACO_NUM <SPAN class="operator token">is</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="token boolean">null</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

All comments

PhilLarkin1

Oh, SSMS functions. Right. They are returning my user, and user with domain as prefix (Domain\user).

Like magic, it is now running properly. I have no idea why. I'll come back to this thread if the problem occurs again.

Thanks for your help.

bixb0012

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> sde_conn <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># path to SDE connection file</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> conn <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ArcSDESQLExecute<SPAN class="punctuation token">(</SPAN>sde_conn<SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> conn<SPAN class="punctuation token">.</SPAN>execute<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'SELECT CURRENT_USER'</SPAN><SPAN class="punctuation token">)</SPAN>
u<SPAN class="string token">'dbo'</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> conn<SPAN class="punctuation token">.</SPAN>execute<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'SELECT SYSTEM_USER'</SPAN><SPAN class="punctuation token">)</SPAN>
u<SPAN class="string token">'Domain\\username'</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> ‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Regarding security, I am talking specifically about the security settings for the linked server setup in SQL Server.

SQL Server: How to List the Full Properties of all Linked Servers – Justin Cooney

PhilLarkin1

Hi Joshua- Thanks for the reply. Have you used OPENQUERY in this context?

Connection File Properties: I'm connecting as Operating System User.

Execute: These attributes are not available. Could you share example syntax. Maybe im not calling them right. They aren't described on the help page.

Security: SQL Server and Windows Authentication

I'm going to try a connection file created with Pro.

bixb0012

Sharing with Geodatabase‌

bixb0012

Several questions come to mind:

What are your connection properties in the SDE connection file?
When using the SDE connection file, what does CURRENT_USER and SYSTEM_USER return through ArcSDESQLExecute?
What are the settings for the security page of the linked server?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.