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
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
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
I want use SQL MAIL, but I have MDAEMON mail server on my Wndows NT Server!
Can I have any chances for it?
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
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
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
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
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
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.
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.
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
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
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 RelatedHi 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
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
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 RelatedI 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!
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 RelatedHow can I get data from MS Exchange server using DTS in SQL Server?
View 2 Replies View RelatedI 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
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
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.
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
Does anyone know how to prevent an exchange waittype?? Is it happening because of the memory config??
View 4 Replies View RelatedDoes Exchange 2000 and SQL 2000 have to be the same machine to use exoledb.dll?
I want to link to an Exchange server and gain access to a Public Folder Contact Object for use as a lookup table within an Access front end. Someone directed me to use the Exchange OLE DB Provider, but it does not exist on my SQL machine.
Any help is appreciated
I am looking for something on pulling information from Exchange 5.5 Sp4 to SQL7.0. Anyone know where I can start?
-Stu
We have a business requirement for arching emails (5+ years) which are
generated in an e-commerce application. The quantity is substantial and
some of the emails will have MS Word attachments. As stands today, our
Exchange 5.5 environment is already taxed and archiving options are limited.
Someone suggested that there is a way to offload the emails into a SQL
database. If we could do this, this would provide much more latitude.
Generally speaking, is this difficult?
Thanks,
Bill
Hey All,
Is there any way to run SQL Mail with exchange CLOSED? Keeping Exchange always minimized seems rather unneedy, inexperienced developers might just have the tendency to close it. Is there any way to avoid that?
Also, can SQL Mail be configured with something else besides Exchange?
Thanks a bunch!
Ilya
I setup a domain user account and e-mail account for the sql agent. When I want the agent to mail me a message
when something happens it puts it in the out box but does not send until I pull up the outlook express and ping the server to send recieve.
If I don't have outlook express running in the taskbar, it won't send the message at all. The e-mail is configured as an internet mail component.
Any suggestions??
I have a fact table with amounts, all in a single currncy. I would like to be able to process the cube where I can select the currency from a dimension.
The format of the currency exchange dimension must include date, currency code, and exchange rate, where the native exchange rate (the currency that the amounts are in) is defined as 1.000.
I once had a procedure to setup exchange client as email for SQL alerts,
but I've misplaced it. (threw it out, actually) I've not had great luck finding it on the web at MS, or otherwise. Does anyone know where this can be found? Thanks in advance, John
Our organization would like to add tasks to users' Exchange accounts from our SQL Server using a USP. Basically, we are looking for the same functionality as the xp_sendmail syntax provides, but instead of sending an email to a user, we would like to create a task in the user's Exchange Tasks folder based on the information passed from our database via the USP.
Here is an example:
A client must receive paperwork every 6 months based on a date stored in our SQL database.
2 weeks prior to the date the paperwork is due, a USP would detect that John Doe has upcoming paperwork needed.
Bob is John Doe's sales rep. The USP would create a new task in Bob's Exchange Tasks folder indicating that John Doe's paperwork is due on such-and-such a date, setting reminders, etc.
We are currently running SQL 2000 and Exchange 2003 in an Active Directory environment. Any help or pointers would be greatly appreciated!!
Thank you - Jeremy