<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 Administration
»
Problem with Database mail
23 posts, Page 2 of 3
««
1
2
3
»»
Problem with Database mail
Rate Topic
Display Mode
Topic Options
Author
Message
Aspet Golestanian Namagerdi
Aspet Golestanian Namagerdi
Posted Monday, March 04, 2013 10:11 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, May 17, 2013 12:30 PM
Points: 174,
Visits: 661
I created Account and Profile from the scratch and when I run the following query:
SELECT items.subject,
items.last_mod_date
,l.description FROM dbo.sysmail_faileditems as items
INNER JOIN dbo.sysmail_event_log AS l
ON items.mailitem_id = l.mailitem_id
I didn't get any result.
Post #1426349
Aspet Golestanian Namagerdi
Aspet Golestanian Namagerdi
Posted Monday, March 04, 2013 10:32 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, May 17, 2013 12:30 PM
Points: 174,
Visits: 661
When I tried to run the DatabaseMail.exe manually in Windows event log I face with the following error message:
Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException
Message: There was an error on the connection. Reason: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server), connection parameters: Server Name: ., Database Name: msdb
Post #1426362
Aspet Golestanian Namagerdi
Aspet Golestanian Namagerdi
Posted Monday, March 04, 2013 5:26 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, May 17, 2013 12:30 PM
Points: 174,
Visits: 661
Sorry ,I guess I have missed something.What is OPC three script?
Post #1426535
MyDoggieJessie
MyDoggieJessie
Posted Monday, March 04, 2013 7:36 PM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 2:19 PM
Points: 2,037,
Visits: 3,761
It was in the first response to your post - OPC.Three gave you a script to run
______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1426561
dan-572483
dan-572483
Posted Tuesday, March 05, 2013 9:20 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 2:53 PM
Points: 332,
Visits: 953
Does the server have anti-virus software on it?
Some anti-virus services will block any email that tries to send from a server to protect it from being used to send spam. When I set up a SQL server to use Database Mail, I routinely have to ask our engineer in charge of anti-virus to turn off this blocking on on the server.
Check the System & Application logs for messages about emails being blocked that correspond to your attempts to use Database Mail, and ask whoever configures anti-virus in your organization.
Post #1426891
Welsh Corgi
Welsh Corgi
Posted Tuesday, March 05, 2013 9:27 AM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 6:19 AM
Points: 3,833,
Visits: 4,052
Aspet Golestanian Namagerdi (3/4/2013)
In sysmail_sentitems,there is not any record.
In sysmail_unsentitems,In includes all the test emails I have tried
In sysmail_event_log does not show that DatabaseMail process has been started to stopped at all.
The last two event in this table are(I manullay stopped and started the mail Queue):
The mail queue stopped by login...
The mail queue started by login...
Why don't you try seaching:
SELECT *
FROM msdb.dbo.sysmail_allitems
Why haven't you tried opc.three queries?
Whay are you trying to execute the DatabaseMail.exe?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1426893
Aspet Golestanian Namagerdi
Aspet Golestanian Namagerdi
Posted Monday, March 18, 2013 1:45 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, May 17, 2013 12:30 PM
Points: 174,
Visits: 661
In sysmail_faileditems I didn't see any failure.I ran DatabaseMail.exe manullly,because I didn't see any
"DatabaseMail process is started" & "DatabaseMail process is shutting down" events in msdb.dbo.sysmail_log table.Even when I e3xecute the DatabaseMail,nothing happened and also I didnt get any error message?
Any thoughts?
Post #1432326
dan-572483
dan-572483
Posted Tuesday, March 19, 2013 11:25 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 2:53 PM
Points: 332,
Visits: 953
Did you rule out anti-virus email blocking as I suggested? That's the only issue I've had with Database Mail in my environment (We're using McAfee AV).
Post #1432802
It's the Database!!!
It's the Database!!!
Posted Tuesday, March 19, 2013 11:49 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, May 17, 2013 7:39 AM
Points: 136,
Visits: 307
I had the same issue about a month ago and after serveral head banging hours I contacted the mail server guys, the server was not set to send mail and the prot was blocked. Please run OPC's scripts as well! :)
Post #1432826
dan-572483
dan-572483
Posted Tuesday, March 19, 2013 3:16 PM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 2:53 PM
Points: 332,
Visits: 953
Sometime's it's not the database
Post #1432912
« Prev Topic
|
Next Topic »
23 posts, Page 2 of 3
««
1
2
3
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
