ChewCheeLim

Impersonation\Delegation stops working after moving SQL server to a separate VM.

Discussion created by ChewCheeLim on Aug 28, 2013
Latest reply on Aug 28, 2013 by pcombellick

Hi,

 

We implemented impersonation\delegation to pass windows credential to all AF SDK calls. The 1st phase implementation where SQL server resides on the same box as AF server, things were working. We switched to have SQL server sitting on a separate box (VM) and changing the AF Service connection string to point to the new SQL server instance, then the Impersonate\delegation stops working. However, based on the AF detail loggings to Event Viewer, we are able to see proper USER id is being passed to AF SDK call. See below detail log copied from event viewer.

 

Does anyone know why?

 

Stop working = none of the AF DB is being returned when accessing AFDatabases.

 

 

 

 

 

Here is my 1st phase implementation, how I got it working..

 

http://vcampus.osisoft.com/discussion_hall/development_with_osisoft_sdks/f/28/t/4256.aspx

 

 

 

 

 

Service authorization succeeded.

 

Service: net.tcp://emdevcldaf01:5457/AFServer/Service

 

Action: http://tempuri.org/IAFServer/GetCheckOutInfo

 

ClientIdentity: DEVCLD\clim; S-1-5-21-871181246-4234381062-482176449-1110

 

AuthorizationContext: uuid-3e46b3dc-0487-46bf-938b-7403361bbc13-96628

 

ActivityId: <null>

 

ServiceAuthorizationManager: <default>

Outcomes