DBMail does not work
-
I'm setting up Database mail and I'm getting a "Cannot send mails to mail server(Mailbox unavailable. The server response was 5.7.1 <test@ghsdebtsolutions.com>... Relaying denied.IP name possibly forged)" error.
I'm executing a simple:
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'GHSRelay',
@recipients = 'test@ghsdebtsolutions.com',
@body = 'The stored procedure finished successfully.',
@subject = 'Automated Success Message' ;
The profile is using one account and the account is pointing to a relay service IP because of a number of relays limited on a daily basis reached. From outlook the smtp server works fine but from dbmail I get the mentioned error.
Any help would be appreciated.
-
You may get better help from your email administrator. That is where i would go with issues like this one.
-
Unfortunately there is no email administrator. I was recently hired as developer/dba and the only IT guy here.
Emails were already setup when I got here (thank god)
Any help, please?
-
most mail servers allow relaying only for two conditions: if your IP address is on the same subnet as the mail server, ie the internal IP to your mail server on the LAN, or if you explicitly pass a username and password which is valid on the email server.
check your mail configuration and see what has been set up; if it is using anonymous(i believe it is...otherwise it wouldn't reject the relay) then change it to a username and password of a valid email account.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Lowel thanks for your reply.
But no, I'm using the relay server's userid and password. Same ones I'm using from outlook and it works fine there
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply