Impersonate And Exchange Linked Server

Mar 17, 2004

Hello,

On my SQL Server 2000, I have successfully created a linked server to my Exchange 2000 server (located on the same physical computer). I can't send request and everything is fine.

But now, I would like to apply the "Impersonate" setting. The big problem I've got is that Exchange doesn't use a login and password for the authentification but use the Windows credentials.

I have try things like :
login : <domain name><username> with the real password
login : <username>@<internet domain name> with the real password
but that doesn't work.


I would like to know if there is a way to "impersonate" user log on the SQL Server when they try to use the linked server to Exchange Server.

Thank a lot

Felix Pageau
fpageau@NOSPAM.str.ca



Print | Copy URL of this post



Expand All Collapse All

View 3 Replies


ADVERTISEMENT

Create Linked Exchange Server

Aug 29, 2007

I'm using sql server 2005 and exchange 2003. End result is I want to upload email attachments to a table in sql. No one seems to have any idea how do do this except with .net, which i know nothing about so not really an option for me. I found this bit of info with some extensive web searching. Can anyone help fill in the blanks? I can't get the linked server to work yet.


EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\.ackofficestoragemailservernamepublic folders'

Error received:The OLE DB provider "exoledb.DataSource.1" has not been registered.

View 1 Replies View Related

Stored Proc Requesting Data Via An Exchange Linked Server

Jan 7, 2004

Hello,
I have created a MS Exchange 2000 link server in my MS SQL Server 2k. I have created a stored procedure (and a view...) using info from that linked server. When I am logged on the server as the Administrator, I can call my stored proc without any problems. When I use another computer (and I am not logged as the admin of the server) and I call the stored procedure, the following error is always raised :
Server: Msg 7302, Level 16, State 1, Procedure test_proc, Line 3
" Impossible de créer une instance du fournisseur OLE DB 'exoledb.DataSource.1'. "
<== I know it is a french error but it can be translated as : "Unable to instancied the OLE DB 'exoledb.DataSource.1' provider"

I would like to know if I can make run my stored proc in the admin account or what should I do to make it work

View 1 Replies View Related

How Do I Impersonate A SQL Server Login?

Mar 14, 2007

I am currently logged in as local admin on my laptop, and I want to connect to clients SQL Server 2005.
I can't use my local admin and have to use company network login.

How can I impersonate my network login when connecting to the SQL Server when using local admin account?


Peter Larsson
Helsingborg, Sweden

View 4 Replies View Related

How To Impersonate User For Data On Another Server?

Dec 26, 2006

Hello all,

I have a quick question. The sql reporting server is on server A, and the actual data for the report is on a sql server 2005 called server B. When I am actually developing my report and click preview, everything works perfectly using windows authentication. However, whenever I publish and try to view the report, i get this error:

An error has occurred during report processing.Cannot create a connection to data source 'serverB'.Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.How do I change the login for this datasource while still using windows authentication and not mixed mode?

Thanks

View 1 Replies View Related

Impersonate And Sqlexpress

Oct 2, 2006

I don't want to use "network service" account for app poll identity for asp.net applications because of security reason. But I try to use sqlexpress I receive following error message.

"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed."

But when I try to connect master db with same account (test) there is no problem. Then I create to user profile for "test" account but same error occurred.

Does anyone know how I can resolve this? Thanks!

View 5 Replies View Related

How To Get Impersonate Permission?

Sep 24, 2007




Say i have two login accounts in sql server 2005,I want to do context switch operation for two accounts.

I want to know to get impersonate permission....


any suggestions?

thanks

View 5 Replies View Related

SQL Server And Exchange

Nov 15, 1999

How do I get my Exchange address from my exchange server stored in my SQL Server 7.0 database? Or, how do I query that list from SQL Server 7.0...?

Thanks!

Dean

View 1 Replies View Related

SQL Server Without Exchange

Jun 2, 1999

Hello,
I'm having difficulties to figure out how to set up Sql Server / Windows NT / MAPI in order to send e-mails.

Is it possible to manage emails from Sql Server without exchange ?

Thanks in advance

Sam

View 1 Replies View Related

MS Exchange Server

Jun 8, 2000

Hi there,

I have just installed Exchange Server.
Can any one help me for what I have to do in Exchange Server so that I can send Email
from SQL Server 7.0

Thanx in advance,
zak

View 2 Replies View Related

SQLContext.WindowsIdentity.Impersonate() Fails

Dec 26, 2007

I am calling SqlContext.WindowsIdentity.Impersonate() within a CLR Stored Procedure and getting the following error:


System.InvalidOperationException: Data access is not allowed in this context. Either the context is a function or method not marked with DataAccessKind.Read or SystemDataAccessKind.Read, is a callback to obtain data from FillRow method of a Table Valued Function, or is a UDT validation method.

The CLR Routine does not do any kind of data accees (as far as SQL is concerned).

Here is the routine:


[SqlFunction(

DataAccess = DataAccessKind.Read,
SystemDataAccess = SystemDataAccessKind.None )] public static int CallService( string sServer, int iPort, string sPath, SqlXml cSqlXmlRequest, out SqlXml cSqlXmlResponse ) { string sXmlResponse = string.Empty; WindowsImpersonationContext cImpersonationContext = null; try {
cImpersonationContext = SqlContext.WindowsIdentity.Impersonate(); sXmlResponse = SoapTransport.CallService( sServer, iPort, sPath, cSqlXmlRequest.Value );


...
} catch (...) { throw; } finally { if ( cImpersonationContext != null ) cImpersonationContext.Undo(); } return SQL_SUCCESS; }

The only SQLContext method/properties that are called is the WindowsIdentity. Further, if I "push" the SqlContext.WindowsIdentity.Impersonate(); call inside CallService, everything work. (It also works correctly if I leave the call of and change the execution identity of SQLServer).

Any ideas as to why this error is occurring and how to resolve it?

Thanks.

View 1 Replies View Related

Cannot Impersonate User For Data Source

May 26, 2008

Hi all,

I encountered a problem when I tried to generate .rdl report in my PWA website integrated with report server. In the "Manage Data Source", when I set the credential type to "Windows authentication (integrated)", it works.
However, when I changed it to "Stored credentials" with the windows account as the Login, the following error occurs:

An error has occurred during report processing. (rsProcessingAborted)

Cannot impersonate user for data source 'CustomizedDB'. (rsErrorImpersonatingUser)

Logon failed. (rsLogonFailed)

Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)



Does anyone know the reason behind? Thanks in advance.



The problem also happens when "Prompt for credentials (use as Windows Credential)" is used.

View 1 Replies View Related

Using SQL MAIL Without A MS Exchange Server ?

Oct 28, 2000

I want use SQL MAIL, but I have MDAEMON mail server on my Wndows NT Server!
Can I have any chances for it?

View 1 Replies View Related

Import Exchange Into SQL Server With DTS?

Oct 4, 2000

Import Exchange into SQL Server with DTS?

Our users enter data into the MS Exchange database using custom Outlook forms. We want to import that data in SQL Server using SQL Server Data Transformation Services (DTS). We do not see Exchange in the Data Source list in the DTS wizard. Is there an easy way to do this? Maybe an OLEDB provider for Exchange?

Thanks,
Bob

View 1 Replies View Related

Extracting Data From Exchange Into SQL Server Db

Mar 22, 2002

Has anyone been able to solve the issue with setting up a package in EM, which connects to an Exchange(.edb) database and extracts the data into a SQL Server db. Previous message posts don't offer much insight. So far, all I have is using Access 2000, to connect & move the data, then extract from here.
Thanks in advance for any help.
BV

View 1 Replies View Related

Window NT Messaging Or Exchange Server ??

Dec 22, 2000

Hi

I have Outlook 2000 and SQL 7 .. do I need Window NT Messaging and Exchange Server to configure a profile for the mail to work ???

thanks in advance for the answer

View 2 Replies View Related

SQL Server And Exchange Calendar Items

Jun 14, 2004

We are looking to take rows from an existing SQL server table and use them to create calendar entries in Exchange server.

Is there a way SQL server can be set up so that this can be done as a trigger when new rows are entered into the table?

Thanks
Tim Smith

View 3 Replies View Related

My Exchange Server Stops Responding To Clients.

Dec 15, 2007


Hi All,
I am having exchange server 2003.
With following details.

1.Operating System 2003 standerd with sp2.
2.Exchange server 2003. Service pack don't know ( How to check)

From last 2 months, every two days my exchange server stops responding to clients.

When I check the services, all the Exchange related services are ON. ( they are running fine).

Then I use to Restart All excahnge related services, i.e Microsoft Exchange Information Store & Ms Exchange System Attended service and things starts working fine again.

This I have to do every 2 days.

I don't know why this is happening.

Can anyone assist me to resolve as it is getting critical day-by-day.
Also How can I check which service pack of exchange is installed.

Many Thanks

Muzaffar
Network Admin.
Carrier - Saudi Arabia.

View 2 Replies View Related

Is It A Good Idea To Install SQL On Exchange Server?

Nov 16, 2007



I am out of my element here but I have someone who is working on a project for me that entails him migrating our Access database to sql. He wants to load the sql software on our exchange server but our IT guy is saying this is not a good idea. Any thoughts???

Thanks,

Beth

View 5 Replies View Related

Want To Link SQL Server DB To MS Exchange E-Mail-Address Data

Mar 1, 2002

Hi all,
I'd like to link a SQL Server database / table to Microsoft Exchange Server E-Mail-Address data, for an Employee Directory project.

I've read a little about "Web Store", a little about ExOLEDB, but I've come across nothing along practical lines. I.e., I still don't know where to begin!

For example the "Web Store" should be created on the SQL server, but how do you create it? Any insights will be greatly appreciated.

Gallagher

View 1 Replies View Related

Does SQLMail Require A Mail Account On The Exchange Server?

Sep 3, 2006

I just read that if you use an exchange server...the account that youstart SQL with needs a mail on the exchange box.Is this true?I know I didn't need an account when I've set it up before...but Imight have been using a POP3 server.I have Outlook 2003 installed on the server. Windows 2003 Enterprise.Thanks.

View 1 Replies View Related

URGENT !!! Running Exchange/IIS/MS SQL7/Site Server On Same Physical PC

Aug 16, 2000

Hi All,

I have an issue where I am told that we should run Exchange/IIS/MS SQL7/Site Server on same physical PC (cost cutting analysis).

Could anyone please tell me in a few words why I should not run the above mentioned services on the same physical computer ?

I would appreciate any input.

Regards,

Romy Stevensen

View 4 Replies View Related

XP_SENDMAIL Problem After Windows Trust With Exchange Server Established

Jul 23, 2005

After a trust with exchange server established the xp_SendMailgives the following error:xp_sendmail: failed with mail error 0x80070005Prior to the trust everything worked fine.I have tried the following:1)Checking SQL and SQLAgents accounts all match up with default mailprofile.2)Confirmed I could send from outlook logged in under the account.3)xp_stopmail and xp_startmail4)restarted the SQL Agent5)Confirmed outlook settings as defined in:kb153159 -http://www.sqlnewsgroups.net/link.a...b/153159/EN-US/I also tried a pop3 account just to test, but no luck.I think what is happening is now that the trust is established when SQLmakes a mail contection it thinks it is user admin@<otherdomain> ratherthan admin@<normaldomain> and therefore thinks that agent account isdifferent than the mail account.Please help if you can.Thanks.

View 2 Replies View Related

Linking SQL Server 2k To Exchange Server 2003

Jun 8, 2004

I am trying to find information about creating a link server in SQL 2000 to connect to Exchange 2003 server. Can anyone help with this?

I am also interested in any kind of tutorial on how to connect to Exchange 2003 Server using C#.

Thanks!

View 1 Replies View Related

Configuring Mail For SQL Server Agent - Problem With Exchange And Outlook On Same Machine?

Jul 23, 2005

I would like to configure e-mail alerts on my SQL Server 2000 box.However, we also run Exchange on the same machine. I've been told therecould be conflicts/issues having Outlook on the same machine asExchange; and apparently, one needs Outlook to configure a mail profilefor SQL Server Agent.Is there, in fact, anything to worry about? If so, are there anywork-arounds beside moving Exchange to another server? (we've only gotone server, so this is not an option for us at this time).Thanks.- Dana

View 1 Replies View Related

Linked Server ( Not Able To Access Any Tables Under LINKED SERVER From My DESKTOP Enterprise Manager

Mar 25, 2002

Hi ,
On my Desktop i registered Production Server in Enterprise Manager
on that Server if i go to SecurityLinked Servers
There is another Server is already mapped, when i am trying to see the Tables under that one of the
Linked Server i am getting the Error message saying that
"Error 17 SQL Server does not exist or access denied"

if i went to Production Server location and if i try to see the tables i am able to see properly, no problems
why i am not able to see from my Desk top
i am using the sa user while mapping the Production Server on my DESKTOP using (ENTERPRISE MANAGER)

And i check the Client Network Utility in the Alias using Named Pipe only, i changed to TCP/IP still same problem
What might the Problem how can i see the Tables in Linked Server from my DESKTOP

Thanks

View 5 Replies View Related

DB Engine :: How To Point Linked Server To Specific Database / Rename Linked Server

Apr 24, 2015

I am using Linked Server in SQL Server 2008R2 connecting to a couple of Linked Servers.

I was able to connect Linked Servers, but I cannot point to a specific database in a Linked Server, also, I cannot rename Linked Server's name.

How to point the linked server to a specific database? How to rename the Linked Server?

The following is the code that I am using right now:

USE [master]
GO
EXEC master.dbo.sp_addlinkedserver
    @server = N'Machine123Instance456',
    @srvproduct=N'SQL Server' ;
GO
EXEC sp_addlinkedsrvlogin 'Machine123Instance456', 'false', NULL, 'username', 'password'  

View 6 Replies View Related

Scripting Stored Procedure Add With Linked Server Reference When Linked Server Is Not Available

Jul 18, 2006

Is there a way to bypass the syntax checking when adding a stored procedure via a script?

I have a script that has a LINKed server reference (see below) .

INSERT
INTO ACTDMSLINKED.ACTDMS.DBO.COILS ..etc.

ACTDMSLINKED does not exist at the time I need to add the stored procedure that references it.

PLEASE to not tell me to add the LINK and then run the script. This is not an option in this scenerio.

Thanks,

Terry

View 4 Replies View Related

How Can I Get Data From MS Exchange Server Using DTS In SQL Server?

May 23, 2001

How can I get data from MS Exchange server using DTS in SQL Server?

View 2 Replies View Related

Getting An Email (Exchange 2000) Message Into SQL Server 2000

May 9, 2002

I have a public mailbox that gets information mailed to it (in a pre-determined format).

Is there a way for that info to be put into a table in SQL Server without any user interaction (something running on the exchange server)?

I hope I've given enough info.

Thanks for any and all help!

Ron

View 1 Replies View Related

Connect Exchange 2000 Server To SQL 2000

Feb 25, 2004

I need to populate a Public Contacts Folder on an Exchange Server with data in a SQL 2000 Table. What would be the best way to do this?

Thanks

View 1 Replies View Related

SQL 7.0 In SMS And Exchange?

Oct 24, 1998

Has there been any indication from Microsoft as to when they anticipate using SQL 7.0 in SMS and Exchange? We are currently planning our MCSE+I certification training course schedules through the end of March. We are currently using SMS 1.2 and Exchange 5.5, which use SQL 6.5. We are planning to schedule the SQL 6.5 Admin and Design classes, but knowing when Microsoft will switch to SQL 7.0 for their BackOffice apps may influence our schedule. I have been told that we could take the SQL 7.0 Design class, and the instructor could tell us what has changed since SQL 6.5. I was told that the SQL 7.0 Admin class is very much different, however. Could anyone shed any light on this?

Terry J. LeBlanc
Lambda Novatronics, Inc.

View 1 Replies View Related

Access To Exchange

Aug 9, 2002

Has anyone tried to link an Exchange database to SQL Server? I was wondering if I could query the Exchange database with SQL.

Thank you,
Jennifer

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved