Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Davids_Maguire
Starting Member
14 Posts |
 Posted - 2007-03-03 : 06:18:01
|
| hi all , i'm trying to send email from my sqlserver .I used the following procedures:-sysmail_add_profile_sp.sysmail_add_account_sp.sysmail_add_profileaccount_sp.when i try to send the email i got the following error"sql server blocked access to dbo.senddbmail of database send mail component because this component is turned off as a part of security configuration.A Sytem admin can enable the use bu using the SP configure".I'm logging to sqlserver using windows authentication with an Admin account,and i have the outlook installed.(another question :- is outlook is required any way ??)after using the procedure to add the profile I opened the control panel >> mail >> show Profile .. and i can not see my profile added there .. Why ?thanks in Advance |
|
|
|
|
|
sql server 2005 mail problem