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 |
|
hiranjan11
Starting Member
2 Posts |
 Posted - 2009-01-15 : 04:18:55
|
| Dear All,How to solve this problem.This is Error measage to send mail through SQL Server 2005.SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole Automation Procedures' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ole Automation Procedures' by using sp_configure. For more information about enabling 'Ole Automation Procedures', see "Surface Area Configuration" in SQL Server Books Online. Please help me any one.Ranjan |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-15 : 05:13:15
|
The error message tells you EXACTLY what to do.After you tried what the error message say, do the procedure still not work?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-15 : 07:44:57
|
| go to start->programs-> microsoft sql server->surface area configuration manager to enable Ole Automation Procedures |
|
|
|
|
|
|
At time exe. of Storprocedure proble.