SQLMail Woes !
Jul 20, 2005
Trying to get my jobs to send mail when job fails. Should be easy but
it's giving me headache
Had a whole slew of issues. Outlook is installed with a n outlook
mail profile set up that can send mail in outlook. I can create a
SendMail DTS and execute it to send mail
Email works in these scenarios
1. I create a DTS package in SQL Server with just SendMail with the
same Profile "ABC" and click Execute and it sends
2. I can send using Outlook with the same profile "ABC"
3. I can run DTSRun with command prompt calliing the DTS package and
it sends fine
However it wont send in these 3 scenarios (where I need it!):
1. I go to Operator, and put my Profile "ABC" in the Email Name,
click Test and I get this error "Error 22022: SQLServerAgent Error:
The SQLSErverAgent mails ession is not running; check the mail profile
and/or the SQLServerAgent service startup account in the
SQLSErverAGent Properties
sQLServer Agent is running
2. If I add the DTS Package "EmailTest" to one of my jobs as a step
to go to if the 1st step fails, nothing gets sent
3. In JObs -- Notificatioin, If I set the E-maill operator to my
operator, nothing gets sent
I set the Mail Profile to the Mail Profile (in SQL Server AGent'
properties)
However when I click Test, I get this error:
Error 0: Cannot load the DLL sqlmap70.dll, or one of the DLLs it
references
I am using
SQLServer Version 8.00.194,
OS Windows 2003
Help!
View 3 Replies
ADVERTISEMENT
Nov 20, 2000
Is there a way to change the FROM in sqlmail (recipient) from the mailbox account to read a user-defined from. Currently our FROM has the SQL mail account name that was created during the sqlmail setup and we would like to put a user defined name in this variable.
View 1 Replies
View Related
Mar 5, 2001
For the life of me, I cannot get SQL Mail Support Services started on one of my SQL Server 7.0 SP3 boxes. It works fine on other machines of mine. I have a mail profile created using proper accounts who have access to email box. I have configured SQL Server to use that mail profile.
ERRORLOG shows the following each time I try and start the SQL Mail Support Services:
2001-03-05 10:23:48.98 ods Starting SQL Mail session...
2001-03-05 10:23:50.20 ods Error: 17903, Severity: 18, State: 1
2001-03-05 10:23:50.20 ods MAPI login failure..
2001-03-05 10:23:50.20 ods Error: 17951, Severity: 18, State: 1
2001-03-05 10:23:50.20 ods Failed to start SQL Mail session..
Do you have any thoughts or where I may turn for support, other that Microsoft's pay-per issue support?
Thank you,
Brian Kilby
View 2 Replies
View Related
Sep 23, 1999
Hello sir,
I want to configure SQLMail; I use Eudora.
how can-I do that?
Please advice me..
View 1 Replies
View Related
Jul 14, 1999
Dear people,
We have tried to get sqlmail (SQL SERVER 6.5) working on windows NT 4.0. However when we start sqlmail through the enterprise manager we get an error:
"error 17952 sqlserver failed to start sql mail session". MSmail client works ok on the NT machine. The profile in nt mail is the same as the profile name in de configuration of sqlmail. What could be wrong?
Thanks for reading
Michel Landman
View 1 Replies
View Related
Jul 30, 1998
I have installed MS exchange client on my NT 4.0 server.
and installed SQL server 6.5 on same.I have marked MSSQL server service as log on as service and also map correct profile in exchange.I am able to start
sql mail service but when i am trying to send a mail by xp_sendmail i am getting error:
Msg 17914,level 18,state 1
Unknown recipient: Parameter `@recipients`,recipient `devendrar`.
where `devendrar` is profile name
and what i am trying to do is :
xp_sendmail `devendrar`,`msg to send`
can u pls help me to solve this problem.
Devendra Rane.
View 1 Replies
View Related
Mar 10, 2005
Is there any other way to send emails without using SQLMail or xp_sendmail?
without a mail client ?
View 1 Replies
View Related
Feb 27, 2001
I have the following error when trying to test EMail from SQL.
I have logged onto the server and sent EMail using the SQLServer Service Account and the Profile is correct. This tells me that Outlook is working OK and the Exchange Server is sending OK. However, lookin on TechNet Q274330
mentions the error number but it's description is about Emailing an open file. I am not Emailing an open file.
Here's the error message.
xp_startmail 'eweb02mail'
Server: Msg 18025, Level 16, State 1, Line 0
xp_startmail: failed with mail error 0x80040106
Or right clicking on SQLMail and click on Test
xp_test_mapi_mail 0x80040106
View 1 Replies
View Related
Dec 28, 1998
Hi all.
I'm having problems with sqlmail. SOMETIME when I try to send a message the server replies "Could not find the function xp_sendMail in sqlmap60.dll". or ISQW don't finish the query never.
Sqlmail is running. I'm using Outlook express as a simple mapi client.
Sorry my english.
Any help will be appreciate a lot.
Thanks in advance.
Armando Marrero
Armando@Novell2.get.cma.net
View 2 Replies
View Related
Jan 21, 2002
Does anyone know how set up SQLMail and SQLAgentMail (SQL 7/2000) to send email to Groupwise 5.5? Or is it possible at all? Any feedback will be very much appreciated.
View 1 Replies
View Related
May 24, 2002
The start / stop options on the SQL Mail support service are not there.
I'm running with SQL 2000 on Server 2000, with MS Outlook 2000 as the MAPI Client. The client is configured and sending just fine. The SQL Mail properties Test button was able start/stop a mapi session. The profile name on the general tab is "Microsoft Outlook Internet Settings".
Suggestions appreciated.
View 1 Replies
View Related
Feb 1, 2001
Has anyone successfully integrated Groupwise 5.5 with SQLServer 2000? Any suggestions would be appreciated.
Thank you.
View 1 Replies
View Related
Jul 23, 2005
I am using SQLServer2000 with sp3.The SQLServer logs on as user Test on the local computer. I am loggedon as user Test on the local computer.I have created a Exchange Profile and tested that it can send andreceive mail.When I go to Enterprise Manager to set-up this profile for SQL Mail.There is nothing in the drop-down list box.Any ideas?ThanksM
View 1 Replies
View Related
Jul 16, 2001
I recently set up a SQL 7.0 cluster (active/passive) on a pair of Win2K boxes. I noticed that the SQLServerAgent would refuse to send system alerts to my e-mail account, yet net sent messages worked fine. I know I've set everything up properly, so I paid the $245 to speak with Microsoft.
The answer was found; their response follows:
{redacted}
CAUSE:
============
On a cluster an undocumented stored procedure is called by the Operator to send email and this causes it to fail. SQL Mail is not supported on SQL 7.0 clusters and any features depending on it will also fail.
RESOLUTION:
============
SQL 2000 does support SQL Mail on clusters with MS Office 2000 and up.
In SQL 2000 Books Online do a search for the following topics and include the quotes:
“Using SQL Server Tools with Failover Clustering”
Also you can workaround the problem by using a job that uses xp_sendmail to send the alert instead.
{END}
Now is that lame or what? Of all the functions you would expect to work in a failover cluster, you would think that e-mailing the operator in the event of a failure would be high on the list. Apparently, not so. Their official answer was to upgrade to SQL2000. Anybody care to guess the price on doing a dual CPU dual box cluster upgrade?
Now my question is this: The tech person was right, xp_sendmail does work fine. What I have wanting to do, and have been unable to do, is to write a TRIGGER that would fire whenever an error is logged by the SQL server. I have looked around, but could find no documentation on what table it is that receives error logs.
Does anybody know which table receives error messages? I'm wanting to write a trigger that exec's xp_sendmail so I get error alerts.
View 1 Replies
View Related
Oct 9, 2001
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.
View 1 Replies
View Related
Aug 7, 2000
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?
View 1 Replies
View Related
Aug 15, 2000
I need to set up SQLMail togheter with Notes, We have SMTP server and profiles but I can´t get it to work. SQL sends the mail but it disappears into the cyberspace.. Someone help me pls...
View 1 Replies
View Related
Sep 14, 2000
Has anyone created a stored procedure that notifies a customer that their order_status has been changed from 'submitted' to 'backordered' or from 'backordered' to 'shipped'? Once written, how does the sp get automatically executed? Does anyone have an example or a book/site with an example?
--Thanks in advance.
View 1 Replies
View Related
Apr 7, 2000
Hi,
I need help!
SQlmail service starts (SQL server 6.5, Exchange Server 5.5
and Outlook 2000). A mail profile is created which starts the
MSSQLServer and SQLExecutive services.
However, When I tried to send a mail by xp_sendmail, it gave me
a 'General MAPI failure with error message 17902'.
Thank you!
View 1 Replies
View Related
Aug 24, 1999
I have a problem trying to send email using SQLMail. When I setup a new job under SQL Server Agent I can receive mail okay when a job completes, but when I try to receive mail from a Database Maintenance Plan the following error is reported:
Emailing report to operator 'DBA Group'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 17903: [Microsoft][ODBC SQL Server Driver][SQL Server]MAPI login failure.
I cannot figure out the problem as mail is getting through using the profile I setup and also when I use outlook and also from SQL Server Agent jobs.
Any ideas!!!!
View 2 Replies
View Related
Jan 12, 2000
I am having difficulty trying to get SQLMail to work via Notes4.6.1 as the mail system. Firstly the Notes client is working correctly on my machine but SQLMail will simply not start with the SQL-DMO error 17952, and on trying to configure it I type in my profile name(which has been successfully setup previously through the Ctrl Panel Mail and Fax icon with the Lotus Notes Mail information service selected ) and get the error 21002 RegCreateKeyEx - #5 access is denied - which seems to be something to do with permissions but the SQLServer service is logging in a member of Local Admins group.
Has anyone had this before - there seems to be a painful lack of information about this area generally.
Regards.
David Shaw
View 1 Replies
View Related
Nov 26, 2002
All our SQL 7 and 2000 servers here run SQLMail for alerting and notifications (via jobs and DTS packages) and we are increasingly having the issue where MAPI32 goes to 100% CPU utilisation and the server needs rebooting.
We are getting the response from Microsoft that "this happens" - hmmm
Anyone else having this problem come up with a solution or workaround at all?
Regards
Jason
View 2 Replies
View Related
Sep 23, 1998
I am currently working on the SQLMail in SQL Server ver. 6.5 and don`t know
how to start. SQL Server is already installed in the NT Server and some
applications are using this. The problem is how to send mail and receive mail from a Lotus Notes ver. 4.5, not a MS Exchange Mail. Can anybody provide me step-by-step approach to do this? The NT server dont MS exchange installed in it.
thnks.
View 1 Replies
View Related
Jun 1, 1999
Does anyone know if there is a way SQLMail can always send a message using a fixed font like Courrier? I use SQLMail to send out an invoice and even though I format the spacing, the email looks unformatted on some systems.
I am using Exchange 5.5, SQL server 6.5 sp4 and the recipients of the emails could have any email client.
thanks,
-Darin.
View 1 Replies
View Related
Oct 19, 2001
Is it possible to actually insert a file into the email sent via sqlmail/
I ask cos when I try to send the results of a query via SQLMail, the formatting is shot.
I want to automate a job to actually run a query, capture data to a file
and then email the results to my users. I can get to the stage where the file is available, but then I'm stumped.
Any Ideas please.
View 1 Replies
View Related
Feb 11, 1999
SQL mail is configured and working (SQL6.5 sp3). I configured scheduled tasks to notify me of completion status, which it does.
I'm just wondering why the header time is off by 5 hours.(time SQLServer Service sent the message)
The SQL server time and time zone are correct, and so are the time and zone on my workstation.
I tested sending a message from a user on the same Exchange Server as the SQL Server user to the user that recvs the scheduled task mail, and the time is correct in that message header.
Any ideas?
Thanks in advance.
View 1 Replies
View Related
Mar 8, 1999
Has anyone setup Lotus Notes as the email client for SQLMail? I currently have Lotus Notes client installed on dedicated MS SQL Servers but am
having trouble configuring the SQL Mail in order to get it working. Does anyone have any suggestions or instructions on how this is done? I've
researched all of the "Books on line" but they are all slanted to Exchange.
Jim
View 1 Replies
View Related
Nov 11, 1998
I am trying to move SQLMail from a standard SQL 6.5 server to a virtual clustered SQL Server. The exchange profile has been set up and the services are running on a domain login. Exchange is also running as a clustered service which is being used successfully from the standalone SQL Server with SQL Mail.
However, when the SQL Mail service is started on the Clustered SQL Server, the service starts for about 5 seconds and then stops. The logs report that SQL Mail started but no messages are recorded to state that why the service has stopped again.
Any clues anyone please?
View 1 Replies
View Related
Nov 26, 2001
I have a DTS setup that copies a couple of databases from one server to another in order to have a hot backup server. When I execute the DTS package from the DTS portion of the Enterprise Manager tree it runs fine. When I schedule it, it fails with the following error:
DTSRun OnStart: DTSStep_OMWCustomTasks.OMWTransferLogins_1
DTSRun OnError: DTSStep_OMWCustomTasks.OMWTransferLogins_1, Error = -2147467259 (80004005)
Error string: Unspecified error
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700
I cannot find anywhere where this error is explained or even referenced. Any help would be greatly appreciated.
View 2 Replies
View Related
Mar 9, 2000
Here's the table:
Create Table{
id int
comments text}
Much of the data in the Comments field already has carriage return in it. When I use bcp out -c, it uses as a new record to figure out when the new row stats. However, the data in that column has carriage returns! Hence, when it detects the carriage return in the user data(comments) itself, it is pushing the remainder of that text to the 2nd line. Then, when I try to BCP IN, it is trying to push it into ID column!
The text file looks something like this:
ID COMMENTS
-- ---------
1 This is a very long comment with a line return now. User hits return here.
This should be part of the previous record but gets detected as a new row
2 Some Text
3 Some Text
So, in the BCP IN, it is trying to put 'This should be part of..' into the ID column and I am getting an error.
Is there any way I can get BCP to NOT recognize in user data as end of a record??
Thanks
Joyce
View 1 Replies
View Related
Jan 10, 2007
We've had RS running on an internal network for a while now and initially
installed it with no SSL certificate. We recently decided that we would like
to make some reports available through the web, and that we should secure the
data with SSL. So, we registered and set up the subdomain, bought and
installed the certificate, closed off all but port 443 on the box in
question, and opened it up to the world. We tweaked a few options in the RS
config files (after reading around):
RSReportServer.config:
- SecureConnectionLevel changed from 0 to 2 (recommended) - this changed
all but the help file links to https://.
- UrlRoot changed from HTTP to HTTPS, and also changed from internal to
external name (to match the SSL certificate)
RSWebApplication.config:
- ReportServerUrl changed from HTTP to HTTPS and changed from internal to
external name.
After this was changed, along with some IIS tweaks, we were able to get to
the report manager through the web, and force SSL only. The problem right
now is that we are intermittently getting "Underlying connection closed"
errors (described here: http://support.microsoft.com/kb/915599). ; The odd
thing is that we first get the Windows login prompt, wait about a minute then
get the error (which is encapsulated by the Report Manager page style).
After a quick browser refresh, the Report Manager appears almost instantly,
with no 2nd request for a windows login.
My question: Are there any IIS or RS config settings I can look at, or any
log file entries I should look for in order to determine the cause of this
problem? My guess at this point is the error has to do with some sort of
timeout, but to be honest, I have no clue.
Thanks in advance!
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
Oct 18, 2006
I want to be able to intersect many tables. I am building my query from vb code in asp .net based on key fields entered in a search engine box.my query should look like this, which will return the rows that will have the values var, var_2, var_3 in any columns. All three must be in a row for it to be a hit. I cant get this to work in ms sql. I don't know if it supports this feature.select * from t where column1 Like '%var%' or column2 like '%var%' or column3 like '%var%'intersect select * from t where column1 Like '%var_2%' or column2 like '%var_2%' or column3 like '%var_2%'intersectselect * from t where column1 Like '%var_3%' or column2 like '%var_3%' or column3 like '%var_3%' I also googled around and found a where exists... But cant seem to figure out how to do multiple tables:select * from t where exists (select * from t where column1 Like '%var_3%' or column2 like '%var_3%' or column3 like '%var_3%') i would like to add multiple conditions to the where exists table. Could anyone please tell me what I am doing wrong.
View 2 Replies
View Related