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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
May 23, 2001
How can I get data from MS Exchange server using DTS in SQL Server?
View 2 Replies
View Related
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
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
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
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