SQL Mail - Configuring

Sep 27, 2006

wasnt sure which forum to put this in - so i'll attempt here!

i have been trying to setup SQLMail in SQL2000 but have been having a few problems

i have created an Outlook MAPI profile for SQL to use. i have tested the profile and it is sending emails - the profile was created using the correct user which has local admin privileges and also a domain account 

i then assigned this profile to SQLMail within Enterprise manager and clicked Test. this completed successfully stating it was able to start & stop a MAPI session.

so i assumed that was all thats needed??

through Query Analyzer i run a simple test

EXEC xp_sendmail 'Craig.Gamble@<mydomain>.com' 'The DB is full'

i get a success message saying SQL mail sent. but it doesnt appear to send anything? i never recieve anything. The sent items does not contain anything and even when checking the actual Exchange server there is no sign of any mail being sent

i also checked the SQL account permissions to make sure it could access the Exchange Server using the

EXEC xp_cmdshell 'NET USE \EnterpriseIPC$' and again this returned success

so now im stumped!

is there anything else i can check to see where or what its supposedly sending??

any help greatly appreciated.
Cheers,
Craig

View 1 Replies


ADVERTISEMENT

Configuring SQL Mail - Help Please

Jun 18, 2001

Hi all,
I want to configure my SQL mail. I am able to configure SQL mail when i run the SQLAgent and SQL Server services under domain account for which Mail box was created in MS Exchange server. Also it works fine. But i want to Configure SQL mail without using Domain account (dont want to run services under domain account due to security reasons).

Anybody know how to Configure SQL mail without using domain account or is it possible to configure like that? Your suggestions are highly appreciated.
thanks in advance.
regards..

View 5 Replies View Related

Configuring SQL MAIL

Aug 4, 2005

Hi All,My question is that can I configure SQL MAIL, if my EXCHANGESERVER is on different domain and my SQL is running on differentdomain.Can anyone guide me for this because I googled a lotwithout any result.I am using SQL SERVER 2000 Enterprise Edition with service pack 3.and MICROSOFT EXCHANGE SERVER 2000.ThanksT.V

View 1 Replies View Related

Configuring SQLServerAgent 2000 Mail Session

Apr 3, 2007

How do I configure the SQLServerAgent 2000 mail session? Do I need MS Outlook installed on the server?

View 1 Replies View Related

Configuring Database Mail In SQL Server 2005

Aug 20, 2007



Hi

I have created profiles in my database as mentioned below. now i want to delete the profile created in database.
can some one tell me how to proceed furthur.

i need to delete them permenantly.
EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = 'MyMailAccount',
@description = 'Mail account for Database Mail',
@email_address = 'makclaire@optonline.net',
@display_name = 'MyAccount',
@username='makclaire@optonline.net',
@password='abc123',
@mailserver_name = 'mail.optonline.net'
-----------------------------------------------------
EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'MyMailProfile',
@description = 'Profile used for database mail'
--------------------------------------------------------EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'MyMailProfile',
@account_name = 'MyMailAccount',
@sequence_number = 1

-------------------------------------------------------EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@profile_name = 'MyMailProfile',
@principal_name = 'public',
@is_default = 1 ; Regardskrishna

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

Integration Services :: Sending Mail With HTML Format In Send Mail Task

Aug 18, 2015

I have to send mail with HTML formatĀ  and attaching multiple files dynamically via send mail task.

View 10 Replies View Related

DB Mail And Notify Operator Through DB Mail Error Could Not Retrieve Item From The Queue

Feb 2, 2007

I've set up DB mail and sent a test e-mail and that comes through fine.

I set up an Operator with email Name: DWhelpton@k-and-s.com;MWeaver@k-and-s.com

I created a job and set up the notifications to e-mail the operator on failure.

When the job runs and fails, I do not get an e-mail and I get the following exception in the db mail log:

Date 2/2/2007 8:35:00 AM
Log Database Mail (Database Mail Log)

Log ID 402
Process ID 3936
Last Modified 2/2/2007 8:35:00 AM
Last Modified By NT AUTHORITYSYSTEM

Message
1) Exception Information
===================
Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException
Message: Could not retrieve item from the queue.
Data: System.Collections.ListDictionaryInternal
TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Controller.ICommand CreateSendMailCommand(Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DBSession)
HelpLink: NULL
Source: DatabaseMailEngine

StackTrace Information
===================
at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)
at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession)
at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)


What step am I missing?

View 1 Replies View Related

XP_sendmail Puts Copy Of Mail In Sent Mail Of Exchange Client.

Jul 9, 2001

I am using nt4.0 sp5 with sql7.0 sp3 and exchange client.
Does anyone know how to keep xp_sendamil form putting a copy of the mail message in the sent mail folder or an automated process for deleting all mail in the sent folder? As it stands now I must manually delete all messages from the sent mail folder on a daily basis.

Thanks,

Ed.

View 6 Replies View Related

SMTP Database Mail Showing Error While Sending Mail

Mar 7, 2007

Lokendra writes "I have configured the Database mail profile and account in Sql Server 2005 but the mail is not sending and showing the following error message:

Error,235,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2007-03-05T15:16:07). Exception Message: Cannot send mails to mail server. (Mailbox name not allowed. The server response was: Sorry<c/> that domain isn't in my list of allowed rcpthosts.).
),3000,90,,3/5/2007 3:16:07 PM,sa


but while in the same mail set up in previous instance of sql server 2005 the message was sending very well. After installing new instance of sql server 2005 the problem is arising.


Anybody can tell me that what I can do so that i can send mail using the SMTP databasemail account."

View 1 Replies View Related

SSIS Send Mail Task - Failure Sending Mail

Dec 13, 2007

Dear all,
I have switched off the firewall settings on my system and as suggested im entering the minimal information and data to send the mail.
but still the Mail Task is failing..
plz suggest.

View 11 Replies View Related

SSIS Send Mail Task - Failure Sending Mail

Jun 8, 2006

Hi Everyone,

Hopefully someone out there will have an idea as this is driving me nuts.

I've setup a task to email on success/failure and keep receiving the following message when executed:

Progress: The SendMail task is initiated. - 0 percent complete
[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.".
Progress: The SendMail task is completed. - 100 percent complete
Task Send Mail Task failed

When I configure Outlook Express on the same machine with the same settings it works.

On the SMTP Connection Manager I have left the default name, tested with both an IP address and Server Name, and no authentication or SSL.

On the Send Mail Task, it uses the above connection. The To: , From: , Subject fields are populated. Message SourceType is DirectInput, MessageSource is Test, Priority is Normal and no attachments or expressions etc.

Nothing useful is logged in the Event Viewer even with full logging turned on.

Any suggestions appreciated,

Thanks.









View 11 Replies View Related

Configure SMTP Server Mail To Send Mail

Feb 10, 2008

Hello,
The Database Mail feature is already enabled on the server, also I have a mail account on the other server.
The problem I faced is that I need to send mail from my SQL Server using a created email account on the other server. How should I configure my email to do that ?
Should I use a sysmail_add_account procedure to enable account, also set profile and profile account ? Does this way creates server mail account that is binded with other email account?
The mail should be sent from my SQL Server.
Thank You.

View 3 Replies View Related

Database Mail With Yahoo Business Mail Server

Feb 20, 2008

Hi all....

Our company use yahoo business mail server for our corporate mails. I know that I can configure database mail with SMTP. But when I try to configure database mail account with yahoo bizmail, I cannot do that. It gets configured but when I test it it doesn't send any mails. Do I need to have any special condiguration for this. SMTP address is smtp.bizmail.yahoo.com. Also I have specified the Authentication using my user name and password. Please help

Thanks

Rajesh

View 10 Replies View Related

Error Sending Mail With Send Mail Task

Feb 6, 2008

I keep getting a generic "Error Sending Mail" error. For testing purposes I am just trying to send using my own email account. What goes in the SMTP Server box in the connection manager? I have tried:

A - the exchange server address (SOMETHING.us.company.com)
B - The SMTP properties I see when I look at the properties of my email address: (my.name@abcd.efgh.company.com)
C - Just the end portion of the SMTP properties: (abcd.efgh.company.com)
D - My email address (my.name@company.com)

I don't know what to enter, or what is giving me such a generic error message.

View 7 Replies View Related

Help With Mail That Send Mail When Database Bakcup Fails

Sep 1, 2006

Hello

I have got a script which gives the mail to the dba mail box when database backup fails.

In the script I want to make a change so that I get the particular database name , on what ever database i implement.

Can you tell me some suggestions.

The script I am using is :



use master
go
alter PROCEDURE dbo.SendMail
@to VARCHAR(255),
@subject VARCHAR(255),
@message VARCHAR(8000)
AS
BEGIN
SET NOCOUNT ON;
DECLARE
@rv INT,
@from VARCHAR(64),
@server VARCHAR(255);
SELECT
@from = 'testsql2000@is.depaul.edu',
@server = 'smtp.depaul.edu';


select @message = @message + char(13) + Char(13) + @@servername + '-'+ db_name()+ '-' + 'Backup Status Failed' + Char(13)

EXEC @rv = dbo.xp_smtp_sendmail
@to = @to,
@from = @from,
@message = @message,
@subject = @subject,
@server = @server;
END
GO




--- After the above script is run the following should be given in the 2nd step when
--- the backup jobs are scheduled ------

exec master.dbo.sendmail
@to = 'dvaddi@depaul.edu',
@subject =' Test sqlserver 2000',
@message = '' ;




Thanks

View 4 Replies View Related

Sending Mail To Several Users With Send Mail Task ?

Nov 10, 2006

I know you can specify additional recipients in the To column by sepperating them with a semicolon. But whats the easiest way to send to several users, when the email address must be retrieved from a table with a query like this:

select email from problem_subscribers

where project = 'project1'

and statusmail = 'OnError'

So when the eventhandler gets an OnError i want the mail task to be sent to each problemsubscriber.



View 3 Replies View Related

How Do I Mail Results From A Query To A Mail Recipient

Sep 12, 2002

i have to create a scheduled task that does the following:

a) creates an Excel Spreadsheet from a SQL Query

b) sends the spreadsheet to a user

i then need to schedule this task so that it runs every day and creates a NEW spreadsheet (doesnt matter it the name is the same as long as it overwrite what is already there)

HELP me PLEASE i dont like this SQL Game anymore !!

Daniel.:mad: :confused:

View 5 Replies View Related

Sql Mail Failed., Need Help To Set Up Sql Mail In Sql Server 2000

Sep 26, 2001

Hi, I have created a profile named sqlmail in exchange server. I tried to run the sql mail service from support service under sql mail to put the profile name, I got the following error: can any one assist me in setting up sql mail in an sql server 2000. .... thanks
Ali

Microsoft SQL - DMO(ODBC SQLState: 42000)
Error 18025:xp_test_mapi_profile: failed with mail error 0x80004005

View 1 Replies View Related

Unable To Send Test Mail From DB Mail

Jul 29, 2013

NOT ABLE TO SEND TEST MAIL FROM DB MAIL...The mail could not be sent to the recipients because of the mail server failure. . Exception Message: Cannot send mails to mail server. (Failure sending mail.).Exception Message: Cannot send mails to mail server. (Failure sending mail.).

View 4 Replies View Related

Problem With Sending Mail Via Database Mail

Mar 9, 2007

Hi every body


I want to send a simple mail using DATABASE MAIL feature in SQL SERVER 2005.

I've defined a public profile.
I've enabled Database Mail stored procedures through the Surface Area Configuration .

but   I can't send a mail with sp_send_dbmail stored procedure in 'msdb' database .


when I execute sp_send_dbmail in the Managment Studio  the message is
"Mail queued"  but the mail is not sent.

Could it be related to Service Broker?Because  the Surface Area Configuration indicates:'this inctance does not have a Service Broker endpoint'.If so, how should I make an endpoint?

here is the log file after executing sp_send_dbmail:


1)  "DatabaseMail process is started"

2)   "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2007-03-08T00:49:29). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it)."

 The DatabaseMail90.exe is triggred ,so the mail is transfered to the mail queue but  DatabaseMail90.exe couldn't give the mail to SMTP server.The promlem is what should I do to make DatabaseMail90.exe able to connect to  the server?



please help me.

POUYAN

View 21 Replies View Related

Permission To Send Mail Mail From Dts

Oct 2, 2002

hello everybody.

I have server server1
sql server and agent and mail profiler
running using mydomainsvcsql

dts (test_dts)created by user domainalex
with "use windows athentication"

dts steps
1. exe sp_who2
2. send mail to joe



user domainjoe run
DTSRun /S server1 /E /N test_dts
with error
Error: -2147220352 (80040480); Provider Error: 0 (0) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed

what permisissions should be granted to
domainjoe
in order to run dts from DTSRun ?


Thank you

View 4 Replies View Related

SQL Mail - Problems With Sending A Mail

Oct 14, 1999

Hi.
I have problems with sending a mail from SQL Server:
SQL Mail starts.
Command: xp_sendmail 'MRudyk','Halo!'
returns:Unknown recipient: Parameter '@recipients', recipient 'Mrudyk'
'Mrudyk' is valid recipient...

View 2 Replies View Related

Not Able To Send Test Mail From DB Mail

Jul 29, 2013

NOT ABLE TO SEND TEST MAIL FROM DB MAIL///The mail could not be sent to the recipients because of the mail server failure. . Exception Message: Cannot send mails to mail server. (Failure sending mail.).Exception Message: Cannot send mails to mail server. (Failure sending mail.).

View 3 Replies View Related

Delete Mail From DB Mail Queue

Apr 16, 2007

I had a very recent problem where an excess number of mail records were queued. I ran sysmail_delete_mailitems_sp and deleted them from the InternalMailQueue, but it looks like they still exist in the ExternalMailQueue as I keep getting messages in the log similar to "Mail Id 2277459 has been deleted from sysmail_mailitems table. This mail will not be sent". The MailItem_Id keeps incrementing so it looks like it's working its way through. The problem is we can't use it to sent current mail until it gets through about another 3 million records.
If there is some way to delete those records from the External Mail Queue or fast-forward the system to the current records that would be very helpful. Any ideas?

John

View 2 Replies View Related

Configuring 2GB RAM For SQL

Oct 30, 1998

Dear all

Problem and symptoms

We have recently added 1GB Ram to our systems and now we are trying to optimally configure 2GB of RAM for SS6.5 SP4 and we are getting the fllowing error INFREQUENTLY

"Not enough memory for pss allocation"

We have to restart the SQL server/ (recover databases) to get out of this. Since it is a heavily loaded production environment you can imagine the impact!!.

SPECS

OS-- NT4/sp3
H/W -- Dual Processor Alpha 4100
MEM -- 2GB
SQL PArameters:
memory--819200
Worker Threads -- 255
Proc cache -- 12%

Work done so far

There is a recommendation to reduce the memory or stack size parameters ref:Q160683!!

Question

1. I would like to know if anyone has got around a similar problem, and how. 2. As in NT Virtual Memory Manager AUTOMATICALLY brokers the allocation of physical memory between the requesting applications (e.g. sqlsrvr.exe) and the page file and no application can write directly to RAM, what does the memory parameter in SQL config control? Also then how is the above KB article relevant?

I look forward to your response

Thanks and regards

Arun

View 3 Replies View Related

Sql Mail And Sql Server Agent Mail With Lotus Notes Domino Server

Jul 7, 2003

Hello Everyone,
I am trying to configure SQL MAIL and SQL SERVER AGENT MAIL feature of SQL SERVER 2000 with Lotus Domino server (Not Microsoft Exchange). Every thing goes fine and it works also. Problem starts when I try to restart SQL Agent Service. It hangs and the status of service remain 'starting'...
Also the size of the sqlagent service process goes upto 12MB. I don't understand why? Can any one help me in solving this problem.
I am using Windows 2000 Advanced Server and SQL Server 2000 with SP3. Domino client is R5.0.5 and Outlook 2000.

View 14 Replies View Related

Configuring SQL Cache

Apr 25, 2007

Hi all,
     I have a question regarding SQL caching.
     I want to use SQL caching for my pages.I've gone through http://msdn2.microsoft.com/en-us/library/e3w8402y(VS.80).aspx article on msdn, where in step by step procedure is explained for this. But I have a slightly different situation. In the article, we need to configure our application from web.config by following...
<!-- caching section group --><caching>  <sqlCacheDependency enabled = "true" pollTime = "1000" >    <databases>      <add name="Northwind"          connectionStringName="NorthwindConnectionString1"         pollTime = "1000"      />    </databases>  </sqlCacheDependency></caching>
 
Where in "NorthwindConnectionString1" is the SQLdatasource connection string. But I'm not using SQLDatasource, and have my own classes to build a connection datasource and get a dataset, and then bind it to my control.So in this case what should I write for the above "connectionstring"  attribute. My connection string is in web.config only with a section defined. and in my application i'm reading from web.fing only.The connection section i'm using is as follows...
<ConnSettings>
<add key="ConnString" value="server=serverName;database=dbName;uid=dbuser;Pwd=password"/>
</ConnSettings>
I want to know how to configure my sql cache in this situation.
 
Thanks,
Mehul Mistry

View 2 Replies View Related

Configuring SQL Datasource

May 29, 2008

Hi
When I try to configure a SQL datasource and I use a Microsoft SQL Server datasource I get a blank drop down list for server name.  My aspnetdb is available in SQL Server 2005 and I can log into it through management studio, and the service is started.  I am also using Vista Ultimate.
Is there any other configuration I need to do for Visual Studio 2008 to see the SQL Server instance?
Thanks
 Kwis

View 2 Replies View Related

Configuring SSRS On Win XP

Apr 4, 2008

Hi All,

I am fairly new to SSRS. I want to install SSRS on my local system which has OS of Win XP sp2 (not a server). I have installed SQL Server instance on this box. Can any body tell if i need Win Server 2000 or 2003 OS to install SSRS or can i use Win XP, if so please give some guidelines.

Thank's in advance..

View 2 Replies View Related

Configuring User In SQL

Sep 26, 2007

I new to SQL 2005 and have couple of questions regarding configuring the user. Let me start by saying what I need to be achieved.

1. Create a new user which will be user by couple of people to create and execute stored procedures
2. Deny all permissions for this user to access data from certain tables.
3. Configure the role and permissions for this user so that the above two is possible.


I was able to do the first two steps and when the users uses a query, ( select * from 'that table' ) the result in a permissions error. Also that user cannot view the table in SQL manager

The problem now is that that user can create a stored procedure that has the SQL statement Select * from 'that table' and execute the stored procedure to view the table.

The reason I created this user is to allow a team in the company to create stored procedures for Crystal. In theory he should be able to create stored procedures but not get any data from the denied tables. How can I achieve this?

I am trying to resolve this issue for a while now and any help is greatly appreciated.

Regards,

View 7 Replies View Related

Configuring SQL With Sp_configure

Jan 7, 2008


Can someone help? I am new to Visual basic programming and have down-loaded Visual Basic Express. I followed the instructions for creating my first database but when I got to making the SQL database I got the following error message. " Generating user instances in SQL server is disabled, use sp_configure "user instances enabled" to generate user instances" Where do I find sp_configure and how do I start it.

View 1 Replies View Related

Error While Configuring

Mar 28, 2007



While configuring reporting services, in the database setup section, I am entering the instance name connecting to, and the user-id details. On applying the changes, i am getting an error that "Using other edition of database for reporting data sources and/or report server databases is not allowed in this version of Reporting services"



Can anyone help me resolve this issue?



Thanks,

Vijay

View 5 Replies View Related







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