I enbaled only the TCP/IP Protocol, all the other protocols were disabled and restarted mssqlserver service.

I still got the error.

Any other suggestions will be greatly appreciated.

Thanks

Howard

Do I need to stop and restart the sqlserver services after I disable all the procotols except TCP?

Yes, I get the same error.

For the Server Name I entered 10.1.1.100:1433

Thanks

Howard

I am using SQL Server authentication.

Ignacio:

Thank you for your reply.

No, I did not see anything in the SQL Server Logs.

I went into SSMS > Management > SQL Server Logs > Current - 3/11/2012 and did...

Lowell:

I have more information on

USE msdb;

sp_droprolemember 'db_owner','DatabaseMailUserRole'

not working and possibly a bug as we previously discussed on this posting.

I sent the following question to microsoft:

Using SSMS in Databases...

Gianluca:

I got your code to work. In order to test it I changed "IF @body IS NOT NULL" to "IF @body IS NULL" in order for the dbmail to send...

Lowell:

Thanks again for your detailed response to my questions.

#1:

I executed the following script but it did not drop db_owner from DatabaseMailUserRole.

Do I need to stop and start SQL Server for...

My test email works.

Lowell:

Thank you for the detailed instructions. I have three questions if you have the time to answer them but if your time is limited an answer to question #1 would...

If anyone is watching this post and has a solution I would like to know what it is.

Thanks,

Howard

Lowell:

Thank you for your response.

I believe that you are correct in that it is a permission problem.

I tried adding the With Execute As 'sysadmin' and got the following...

I executed the following code as a query in SSMS prior to setting up the job in order to verify that it works.

EXEC [TOOLS].[maint].[dba_runCHECKDB]

@dbName ...

I changed the Alter to Create and got the following message.

The module 'dba_runCHECKDB' depends on the missing object 'TOOLS.dbo.sp_send_cdosysmail'. The module will still be created; however, it cannot run successfully...

Gianluca:

Thank you very much for your reply.

After creating the Tools database and maint schema I ran your new corrected code.

I received the following error:

Msg 208, Level 16, State 6, Procedure...