You were partially right, my SMTP settings were wrong, but this didn't solve the problem. I have no idea what else I can try to start database mail.ĭennes Inscreva-se em meu treinamento on-line de T-SQL. _delete_mailitems_sp also restarted the SQL Server service and SQL Server agent service several times. In the middle of all these tests I already deleted the messages in the queue using I already tried to start/stop the database mail in MSDB with the following statements: I can see the mail queue status as inactive using the following statement: All the mail messages stay in the queue, I can see the messages in the queue using one of these statements: I solved the problem with this statement in the master and MSDB:Įxec sp_change_users_login 'Auto_Fix', '#MS_PolicyEventProcessingLogin#',Įvent after these corrections, database mail doesn't start, I mean, I can't see the start message in the log. At this point I realized this was the result of my previous tests with the system databases. Next I saw error messages in the log about the user #MS_PolicyEventProcessingLogin#. Now I'm doing some tests with database mail and several problems appeared.įirst, I received an error message from database mail wizard and I solved with this statement:ĪLTER DATABASE msdb SET NEW_BROKER WITH ROLLBACK IMMEDIATE A few days ago I did some tests with backup/restore/rebuild of the system databases, everything worked fine, or at least it seemed having worked fine.
0 kommentar(er)
