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


ADVERTISEMENT

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

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

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

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 View Related

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

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

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

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

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

Exchange WaitType

Nov 3, 2000

Does anyone know how to prevent an exchange waittype?? Is it happening because of the memory config??

View 4 Replies View Related

Linking To Exchange From SQL

Mar 16, 2004

Does 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

View 14 Replies View Related

Pulling Information From Exchange Into SQL?

Apr 3, 2001

I am looking for something on pulling information from Exchange 5.5 Sp4 to SQL7.0. Anyone know where I can start?
-Stu

View 3 Replies View Related

Moving Exchange Email To SQL

Apr 27, 2001

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

View 1 Replies View Related

SQL Mail And Exchange Question?

Jul 9, 2001

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

View 3 Replies View Related

SQL AGENT MAIL Not Using Exchange

Oct 27, 2000

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??

View 2 Replies View Related

Currency Exchange As A Dimesnion

Dec 22, 2004

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.

View 7 Replies View Related

SQL Alerts Via Exchange Email

Dec 9, 1998

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

View 1 Replies View Related

Generate Exchange Task From T-SQL

Aug 17, 2006

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

View 1 Replies View Related







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