Hi All,

I tried creating this account but when i send test mail, it gives me this
error :-

The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 6 (2008-05-21T17:28:16). Exception
Message: Cannot send mails to mail server. (Client does not have permission
to submit mail to this server. The server response was: 5.7.3 Client was not
authenticated.).
)

However when i re-create the whole profile and account again, it works..What
happended?

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...erver/200805/1

My guess? The first time you tried, you set up the wrong credentials (e.g.
mis-typed the password). The error message is not that mysterious and is
not very open to creative interpretation. YMMV.

Typically if you are sending through an SMTP server that is inside your
network, you can leave the server as authentication not required for IP
addresses within your subnet.



On 5/21/08 8:31 PM, in article 8481d6552b103@uwe, "honeybee86 via
SQLMonster.com" <u43452@uwe> wrote:

> Hi All,
>
> I tried creating this account but when i send test mail, it gives me this
> error :-
>
> The mail could not be sent to the recipients because of the mail server
> failure. (Sending Mail using Account 6 (2008-05-21T17:28:16). Exception
> Message: Cannot send mails to mail server. (Client does not have permission
> to submit mail to this server. The server response was: 5.7.3 Client was not
> authenticated.).
> )
>
> However when i re-create the whole profile and account again, it works..What
> happended?

Hi,

A brief description of what I am doing.
I am putting this SQL in the server. So, my concern is when other user log in
to this server and sends and email, can they use my created account and
profile in sending this email?
I have already set this profile in public and as default. What should I do
more?

Aaron Bertrand [SQL Server MVP] wrote:
>My guess? The first time you tried, you set up the wrong credentials (e.g.
>mis-typed the password). The error message is not that mysterious and is
>not very open to creative interpretation. YMMV.
>
>Typically if you are sending through an SMTP server that is inside your
>network, you can leave the server as authentication not required for IP
>addresses within your subnet.
>
>On 5/21/08 8:31 PM, in article 8481d6552b103@uwe, "honeybee86 via
>SQLMonster.com" <u43452@uwe> wrote:
>
>> Hi All,
>>
>[quoted text clipped - 10 lines]
>> However when i re-create the whole profile and account again, it works..What
>> happended?

--
Message posted via http://www.sqlmonster.com

> I am putting this SQL in the server. So, my concern is when other user log in
> to this server and sends and email, can they use my created account and
> profile in sending this email?

Is this something you want or do you not want this?


> I have already set this profile in public and as default. What should I do
> more?

For a user to be able to send emails using database mail, one need access to the mail profile (as
you describe above) and also member show if the appropriate database role in the msdb database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"honeybee86 via SQLMonster.com" <u43452@uwe> wrote in message news:8482117675ef3@uwe...
> Hi,
>
> A brief description of what I am doing.
> I am putting this SQL in the server. So, my concern is when other user log in
> to this server and sends and email, can they use my created account and
> profile in sending this email?
> I have already set this profile in public and as default. What should I do
> more?
>
> Aaron Bertrand [SQL Server MVP] wrote:
>>My guess? The first time you tried, you set up the wrong credentials (e.g.
>>mis-typed the password). The error message is not that mysterious and is
>>not very open to creative interpretation. YMMV.
>>
>>Typically if you are sending through an SMTP server that is inside your
>>network, you can leave the server as authentication not required for IP
>>addresses within your subnet.
>>
>>On 5/21/08 8:31 PM, in article 8481d6552b103@uwe, "honeybee86 via
>>SQLMonster.com" <u43452@uwe> wrote:
>>
>>> Hi All,
>>>
>>[quoted text clipped - 10 lines]
>>> However when i re-create the whole profile and account again, it works..What
>>> happended?
>
> --
> Message posted via http://www.sqlmonster.com
>

Hi,

Ok..means I need to set it as default and as public profile. As for the basic
authentication, will it has any impact if I didnt put it as the same as
database mail role? I am kind of blur in this part.

Or can you teach me on how to make sure anyone can use this email sending?

Thanks

Tibor Karaszi wrote:
>> I am putting this SQL in the server. So, my concern is when other user log in
>> to this server and sends and email, can they use my created account and
>> profile in sending this email?
>
>Is this something you want or do you not want this?
>
>> I have already set this profile in public and as default. What should I do
>> more?
>
>For a user to be able to send emails using database mail, one need access to the mail profile (as
>you describe above) and also member show if the appropriate database role in the msdb database.
>> Hi,
>>
>[quoted text clipped - 21 lines]
>>>> However when i re-create the whole profile and account again, it works..What
>>>> happended?

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...erver/200805/1

> Or can you teach me on how to make sure anyone can use this email sending?

Make sure that the profile is public (as it seems you have done already).
In msdb, add guest to the DatabaseMailUserRole role.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"honeybee86 via SQLMonster.com" <u43452@uwe> wrote in message news:848659ce4d15c@uwe...
> Hi,
>
> Ok..means I need to set it as default and as public profile. As for the basic
> authentication, will it has any impact if I didnt put it as the same as
> database mail role? I am kind of blur in this part.
>
> Or can you teach me on how to make sure anyone can use this email sending?
>
> Thanks
>
> Tibor Karaszi wrote:
>>> I am putting this SQL in the server. So, my concern is when other user log in
>>> to this server and sends and email, can they use my created account and
>>> profile in sending this email?
>>
>>Is this something you want or do you not want this?
>>
>>> I have already set this profile in public and as default. What should I do
>>> more?
>>
>>For a user to be able to send emails using database mail, one need access to the mail profile (as
>>you describe above) and also member show if the appropriate database role in the msdb database.
>>> Hi,
>>>
>>[quoted text clipped - 21 lines]
>>>>> However when i re-create the whole profile and account again, it works..What
>>>>> happended?
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums...erver/200805/1
>

Hi,

I manage to retrieve the database mail user roles. However, I can only see 2
user whereby I dont see my name there. But, how come I am still able to send
email?

Those with the name there sure can send email already right?

Tibor Karaszi wrote:
>> Or can you teach me on how to make sure anyone can use this email sending?
>
>Make sure that the profile is public (as it seems you have done already).
>In msdb, add guest to the DatabaseMailUserRole role.
>
>> Hi,
>>
>[quoted text clipped - 22 lines]
>>>>>> However when i re-create the whole profile and account again, it works..What
>>>>>> happended?

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...erver/200805/1

You are right, my user is not in the databasemailroles. So, what should I do?
Add my name there?

sp_addrolemember @rolename = 'DatabaseMailUserRole',
@membername = 'honeybee'

Please advise thanks...

honeybee86 wrote:
>Hi,
>
>I manage to retrieve the database mail user roles. However, I can only see 2
>user whereby I dont see my name there. But, how come I am still able to send
>email?
>
>Those with the name there sure can send email already right?
>
>>> Or can you teach me on how to make sure anyone can use this email sending?
>>
>[quoted text clipped - 6 lines]
>>>>>>> However when i re-create the whole profile and account again, it works..What
>>>>>>> happended?

--
Message posted via http://www.sqlmonster.com

I tried to add, but it show me error whereby it state that this user is not
in the database mail roles.

honeybee86 wrote:
>You are right, my user is not in the databasemailroles. So, what should I do?
>Add my name there?
>
>sp_addrolemember @rolename = 'DatabaseMailUserRole',
> @membername = 'honeybee'
>
>Please advise thanks...
>
>>Hi,
>>
>[quoted text clipped - 9 lines]
>>>>>>>> However when i re-create the whole profile and account again, it works..What
>>>>>>>> happended?

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...erver/200805/1

Make sure you understand the difference between login and users. This is basic stuff and you should
find good info on this in Books Online. Then make sure that the person(s) has logins and that each
login exists as a user in msdb. Now add that user to this role. Or, if every login should be able to
send email, make sure that guest is enabled in msdb and then add guest to this role.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"honeybee86 via SQLMonster.com" <u43452@uwe> wrote in message news:848f7245cb95a@uwe...
>I tried to add, but it show me error whereby it state that this user is not
> in the database mail roles.
>
> honeybee86 wrote:
>>You are right, my user is not in the databasemailroles. So, what should I do?
>>Add my name there?
>>
>>sp_addrolemember @rolename = 'DatabaseMailUserRole',
>> @membername = 'honeybee'
>>
>>Please advise thanks...
>>
>>>Hi,
>>>
>>[quoted text clipped - 9 lines]
>>>>>>>>> However when i re-create the whole profile and account again, it works..What
>>>>>>>>> happended?
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums...erver/200805/1
>

Hi,

Ok...
What you mean is every login should have it's name in the DatabaseMailRoles?
or you mean by exists as a user in msdb? how we know that and then only
exists in DatabaseMailRoles?
How does that guest is enable in msdb and then add the guest roles?
Besides, your guest is a keyword or just refering to someone name?
If you have any resources do inform me.
Thanks.

Tibor Karaszi wrote:
>Make sure you understand the difference between login and users. This is basic stuff and you should
>find good info on this in Books Online. Then make sure that the person(s) has logins and that each
>login exists as a user in msdb. Now add that user to this role. Or, if every login should be able to
>send email, make sure that guest is enabled in msdb and then add guest to this role.
>
>>I tried to add, but it show me error whereby it state that this user is not
>> in the database mail roles.
>[quoted text clipped - 12 lines]
>>>>>>>>>> However when i re-create the whole profile and account again, it works..What
>>>>>>>>>> happended?

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...erver/200805/1