My IT manager doesn't like the idea that a production process written in DTS needs Outlook 2000 running for DTS Email. I tend to agree that having an app like Outlook 2000 running in the production machine is kind of tacky. Am I missing something here? Why would MS suggest such a solution? Is there a way to configure DTS and Outlook so Outlook doesnt have to be running as an app?
Chiefley
Hello,
I would like to send e-mails from MS SQL Server 7. Does Linux accept MAPI client e-mails and deliver them? And if so, how does one set it up?
Thanks,
Denise
Hi,
I had a question. Is is good to configure Outlook Express as my default mail client for SQL Mail. I had to do this as Outlook 98 was not responding and there was couple of other problems.
I have a Reporting Services 2005 report that is emailed to users. I created/formatted the report based on how it looked in Outlook 2003 which all of our users had at that time. The report is wide, but just fit in the email window when it was full size. Now I have a user who has been converted to Outlook 2007 and he emailed me a copy of the report he received in Outlook 2007 and it looks like it reduced the column sizes; it does not fill the entire email window and wraps the wording on most lines because the column sizes have been reduced.
The report is:
Delivered by: Report Server E-mail
Include Report is checked
Render Format is Web archive
Any ideas on how I can fix this?
Thanks in advance.
I am trying to install SQL Mail to send automatic system messages. The SQL Mail service starts but when I try to test it I get the following error. Does any one have any solution to this problem?
Error: A Mapi error ( error number 273) occured. Unable to get the default MAPI message Store due to MAPI error 273. The information store could not be opened.
I am trying to install SQL Mail to send automatic system messages. The SQL Mail service starts but when I try to test it I get the following error. Does any one have any solution to this problem?
Error: A Mapi error ( error number 273) occured. Unable to get the default MAPI message Store due to MAPI error 273. The information store could not be opened.
I created a new MAPI profile on the server, and it seems to work fine with Outlook. I also dropped the previous default MAPI profile.
Now, when I go to the EM SQLAgent Properties, the only MAP profile offered in the SQLMail drop-down is the old, deleted profile. Also, only the old profile comes up with xp_get_MAPI_profiles.
How can I get SQLAgent to recognize that I've set up a new mail profile?
Hi,
I recently installed MS SQL server version 7.00.623 on a Win2k server. I installed Outlook 2000 and had the Exchange Administrator create a mailbox in order to use SQL Mail and SQL Server Agent alerts when jobs fail. The Outlook mailbox was set up with a different name then the SQL Server Agent so I created a new account for the SQL Server Agent to match the name of the mailbox. I can send and receive mail from Outlook when logged into the server but I receive the following error when testing the profile in SQL Mail and SQL Server Agent properties:
"[260] Unable to start mail session (reason: Unable to logon (reason: Unable to get the default MAPI Message Store due to MAPI error 273: The information store could not be opened); check the mail profile and/or the SQLServerAgent service startup account)"
The SQL Server Agent account is a NT User type, uses NT Authentication and has sysadmin server privledges and I am attempting to configure the mail while logging in to the server via Terminal Services Client using this account. I have tried to stop and restart the SQL Server Agent services but still receive the same error. When I log into Outlook, I receive a dialog box titled "Enter Password" that asks for a user name, domain name and password. The Exchange Admin. set this up so I have to use my user name, domain and password.
Do I need to install a service pack for SQL Server?
Did changing the SQL Server Agent account cause this to fail?
Does anyone have any insight on why I cannot get SQL Mail configured?
Thank You So Much
I have several dts packages that run just fine through a third party scheduler. I then put a mail task on them to tell me if the package succeeded or failed. Every time the scheduler gets to the mail task it fails and logs a mapi login failure error. When I execute the dts package on my local box it sends the email with no problems. is it a problem with the robot login or is it associated to the profile? any help would be greatly appreciated.
Elizabeth
I have a situation where a SQL Maintenance Task is running, and suppose to email a report to the sys admin. Currently I am getting a Microsoft SQL-DMO Error 17903, Mapi Login Failure.
I have tested the Outlook 98 application and the profile is set correctly. I have tried to send an email within SQL and I receive the error above. I have carried all activities suggested by Microsofts Online Books. Can anyone suggest where to go from here. All Service Packs have been applied.
Thanks
Chris Le ROY
Error message "Unable to get MAPI profiles" in send mail task(DTS).
View 4 Replies View RelatedI set up e-mail on my SQL server (7.0) via SMTP.
I installed Outlook '97. Typical Installation.
Everything was working fine, for couple of days,
then I got Dr. Watson messages, about MAPI.
Dr.Watson
The application, exemapisp32.dbg, generated an application error The error occurred on 11/ 7/2000 @ 11:35:48.437 The exception generated was c0000005 at address 6e4f2630 (<nosymbols>)
Then SQL will give me this message:
Unable to read local eventlog (reason: The data area passed to a system call is too small).
Anyway, try to reinstall Outlook '97, but the problem continues.
Any help, will be greatly appreciated.
Hi friends,
I have Exchange & sql 7.0 on the same box. I have configured sqlserver
and sqlserveragent for the same nt login. Also a Mail profile is created and assigned to SQL-MAIL & SQL-AGENT.
I have a back-up job in SQLSERVER and the notification is set to exchange mail box. For the first time after restarting the exchange services, the notification works fine. But for the subsequent job executions, the notification failed and the message is "MAPI LOGIN FAILED".
Can any one help me..
Thanx in advance.
regards
MANI
(Isn't this fun? Type MAPI and SQL into Google and it almost tilts!)
Here is the situation:
1- When SQL Agent starts, it establishes a MAPI session. For some bizarre design reason, it keeps that session open as long as it is running, rather than re-opening the session when it has mail to send. (this can be days, weeks, or months)
2- Frequently, Exchange servers are clustered. When the virtual server moves to a different physical server in the cluster, - or the Exchange server is restarted for whatever reason - the (above) MAPI session of the SQL Agent gets jammed.
3- SQL Agent tries, and fails to send an E-mail saying (for instance) that a database dump has completed (etc.)
4- User posts a question to some forum, asking for help again.
My solution: I created a job to run on a daily basis to restart the SQL Agent, and re-establish the MAPI session. Voila!
The problem: Now we (sometimes) get the message:
[241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started)
This is incorrect - the service was never stopped!
*sigh* No hits in Microsoft or Google - Back to the drawing board.
SO: Can anyone think of a way to *test* the MAPI connection in a job step (without actually sending a message), so that the agent restart job is only executed if the MAPI connection is failing?
I have not yet set up SQL2K mail -> Notes, but I see in Q263556 a warning regarding extended MAPI and non-Exchange servers.
Just wondering if anyone is using a SQL2K - Notes MAPI profile -- and if any reliability issues have come up?
Thanks in advance
Scenario:DBMS: SQL Server 2000OS: Windows Server 2003Goal:Enable SQLMAIL via Internet MailProblem:How do I set up the MAPI profile for the SQL Server service account?On Windows 2000 Server, I can use "Control Panel"/"Mail" tocreate a MAPI profile for the SQL Server service account, and thenreference that profile for SQLMAIL in SQL Server and SQL Server Agent.But on Windows Server 2003, there is no "Mail" applet in "Control Panel".How do I create a MAPI profile, for the SQL Server service account,on Windows Server 2003?
View 5 Replies View RelatedWe have 15 clients running our applicaton
14 of then conected to SQL server using TCP/IP and it runs fine
1 of 15 when connected using TCP/IP produce "..Time out error "
but runs fine when swiched from TCP/IP to Named pipes
1.What area should we look to correct problem with Time out using TCP/IP ?
2. Where to get information about using TCP/IP via Named pipes ?
Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
View 78 Replies View RelatedOn Windows XP systems I get the following issue when trying to browse the MSDB folder in SSIS
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
I have noticed another post where several others have noticed the same issue. It appears to only occur on Windows XP installations. Is there a workaround or fix for this?
On our SQL 7.0 servers we have always used Outlook 97 as our mail client and until last week we've had no issues with this setup.
A week ago a number of the servers with this set up started hanging on jobs with mail statments using xp_sendmail and the only solution was to reboot the server. All the servers use the same NT account and the same mail box for the mail. I've talked with our Exchange guys and they say that nothing has changed on the mail server. I found a Q article (Q315886) that suggests starting sql as an application not a service to see if pop ups could be causing the problem. Well no pop ups.
I installed Outlook 2000 on the boxes and that seems to have fixed it. Or at least no problems today with those servers.
Has anyone seen this before or have any idea what might be the cause of it?
thanks
Donna
Hi,
I have SQL2000 installed as the default instance, and now I'm trying to install SQL 2005 standard edition as a named instance.
I receive this error :
SQL Server could not connect to database service for server configuration.. [SQL Native client] Encryption not supported on the client. However I'm able to install client tools
The setup works fine on other box with the same config : SQL 2000/Windows XP, is there any work around for this issue ?
In my SQL 2000 client network utilty "Force proctocol encryption " is desabled and did not find the setting for SQL 2005 !
Thank you
Hello,Is it necessary to upgrade the Client Connectivity Tools on all clientmachines after the SQL Server database server is upgraded from Version7.0 to 2000?Thank you in advance!Eddy
View 1 Replies View RelatedAnyone ever setup the OutLook Express client to use SQL Mail ? I'm able to send messages via OutLook Express; however, SQL Mail doesn't recognize any profiles.
In using OutLook Express do I need to also setup a PostOffice. My server currently doesn't have any POST OFFICE or Mail software under control panel.
Thanks in advance,
Walker
Can anyone recommend a source of info on connecting Outlook to a SQL database of contacts? Also interested in third party tools/solutions that I could just buy and customize.
I need to be able to get at data from my own VB apps, but it would be nice to dump contacts into Outlook for people taking laptops and CE machines on the road. Even nicer if they could use Outlook to update addresses and upload to SQL Server.
Or am I just dreaming?
Is there any way to stop Outlook97 from checking for new mails automatically?
Thanks for any help!
Anybody use them together? If so, how did you set it up?
View 1 Replies View RelatedI have a question that I hope to get an answer from you.
We had an exchange central which used to get data from the outlook and save it in the database, then we have another solution that filters the data we need from there and save it into another database to produce a report for the economy department to be used for wages. Now the exchange central has many problems and they decided not to use it any more. What I want to do is to get data(calendar posts) direct from the outlook into my SQL 2000 database. Is it possible? If yes, what is the best approach to do?
Thanks in advance
Greeting All, has anyone had luck getting SQL mail running withoutOutlook? Will any MAPI email client work?Thanks in advance.Louis
View 1 Replies View Relatedhelp with outlook expres
View 1 Replies View Related
When I try to view someone else's Calendar in Outlook I get this message:
The messaging interface has returned an unknown error. If the problem persists, restart Outlook.
Of course restarting Outlook resolves nothing. Please help.
Hello all,
I am trying to build some sort of interface either directly in MS Outlook on the client comp. or a stand-alone app. The requirement works somewhat like what is done between a PDA and MS Outlook, with the exception that the data only goes one way - SQL Server --> Outlook.
I want to allow for the user to choose from their data in SQL Server and have it bring that data down into their contacts folder. It will need to work over the internet, and MS Exchange is not a preferred method.
Clients are not on the same network as the server, they only connect to the internet via IP and use simple POP mail accounts.
Thanks ahead of time.
Dave
Does anyone know the 'trick' in getting sqlmail (sqlserver 7.0) to work with Outlook 2000 on a windows 2000 server machine. I've setup a mail profile on Outlook, but it is not listed in the dropdown menu in the sqlmail properties.
Outlook communicates with my smtp/pop3 mail server - no problem. I can't get sqlmail to interface with outlook. Basically it is telling me that it cannot find ANY profiles on the server.
I'm trying to make SQLMail work. I have installed Microsoft Outlook 98 with MSSQL 7.0 on a NT Server 4.0 with Service Pack 6. I have set a profile for a user with admin rights to start a service. I can successfully start up with SQL with this account. When I try to start up SQL Mail it comes back with this error:
DESCRIPTION: Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 34 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
With another dialog box:
Error 22030: A MAPI Error (error number: 87) occured:
Can any one Help??
Do I need reapply the service pack??