Isn't it hopeless situation? I begin to believe that it is...

I don't see any mail profiles listed in the combo box.   When I press test at SQL mail after typing mail profile name I get an error:

Microsoft SQL-DMO (ODBC SQLState:...

Thanks Andy for your patient

Yes I'd  created a new profile through Control Panel|Mail with the new domain user account.

You know, I tried to do the same on the second our test...

If he has any permission on any object he will see it because he will be in public role of DB. The next thing is what is granted to him

Thanks Andy for your trying, but the problem remains. The account has local admin rights, also I gave it the same rigths (at local policies) as the previous login (which...

Agreed with Chris. You should check your permissions again.

Agreed with Allen. There is another way to grant user permission to execute stored procedure located in master db. The user must be at least public on master. Then you click the...

OK. I found it. It can be done in OS

Somewhere I saw an error like yours... When I'll find the  solution I'll post it

Microsoft says:

"Using a dedicated user account means creating a domain user account that is used

solely for the SQL Server and SQL Server Agent...

Yes. Edit your server registration properties and uncheck "show system databases and system objects"

Do you have the output of your error?

Hi,

It should help you:

http://www.mssqlcity.com/Articles/Replic/SetupMR/SetupMR.htm

Good Luck!

We have clustered enviroment running on one domain account, which has local admin rights on both cluster nodes. On the same domain account run SQL server agent and SQL mail....

It looks like it sounded unusuall only for me I think that there is nothing bad if DB owner would be a member...