Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Impersonation from SQL Server to Exchange linked server

 
   Database Forums (Home) -> Security RSS
Next:  Interactive Maps in Forms  
Author Message
pepegirolas

External


Since: Oct 29, 2008
Posts: 1



(Msg. 1) Posted: Wed Oct 29, 2008 10:25 am
Post subject: Impersonation from SQL Server to Exchange linked server
Archived from groups: microsoft>public>sqlserver>security (more info?)

Hi, im tryin to get IMPERSONATION to work between SQL Server 2005 and
Exchange 2007 via ExoleDb (Microsoft Exchange OleDb provider)
The two servers are in the same box (Running Windows Server 2003), the user
can impersonate Exchange accounts (its the same user that i use for EWS and
impersonation works for him accessing Exchange Web Services)

The linked server is created with this:

EXEC master.dbo.sp_addlinkedserver @server = N'exchange1',
@srvproduct=N'Exchange OLE DB provider', @provider=N'exoledb.DataSource.1',
@datasrc=N'file://./backofficestorage/ex2007.local/MBX/testuser01'

I tried all the posible "sp_addlinkedsrvlogin" combinations (thats not the
problem) .

When i make queries the following error is shown in SQL Managment Studio:

OLE DB provider "Exoledb.DataSource" for linked server "Exchange1" returned
message "Could not impersonate the user. COM security must be setup to allow
'IMPERSONATE' access.".

When i try the server connection the following message is displayed:

Cannot connect using OLE DB provider "Exoledb.DataSource" to linked server
"EXCHANGE1". Verify the connection parameters or login credentials associated
with this linked server.
OLE DB provider "Exoledb.DataSource" for linked server "EXCHANGE1" returned
message "Could not impersonate the user. COM security must be setup to allow
'IMPERSONATE' access.". (.Net SqlClient Data Provider)

Server Name: DEVEX2K7-EXCH
Error Number: 7304
Severity: 16
State: 2
Procedure: sp_testlinkedserver
Line Number: 1

Some of the things i have tried (with no luck) are the following:

* Set the server for "Trusted for delegation"
* Set the user account to "Account is trusted for delegation"
* Check that the user i'm trying to impersonate have not checked the "Account
is sensitive and cannot be delegated"
* Set the component services computer default impersonation level to
"Delegate"

I donīt know what i'm missing, any help will be grateful.

 >> Stay informed about: Impersonation from SQL Server to Exchange linked server 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> Security All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]