I am getting xp_sendmail: Procedure expects parameter @user when I run xp_sendmail.
How do I associate a given SQLService login profile (SQLMail_Whatever) to outlook?
From stackoverflow
-
Here's how I got it working with SQLServer2005 (need to use sqlmail for backward compatibility):
- Login to the machine running the sql server with the login profile you intend to use for mailing
- Configure an outlook account for that specific account
- Setup SQLServer and SQLServer Agent services to startup using the same account
- From SqlSever Management-->Legacy-->SQLMail setup and test outlook as profile name
- From SQL Server Agent-->Properties-->Alert System check enable mail profile and pick SQLMailand outlook in the dropdowns.
After a service restart xp_sendmail will work.
0 comments:
Post a Comment