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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-09 : 09:16:46
|
| Darren writes "I am getting the following error from a site I'm running.Error Type:Microsoft OLE DB Provider for SQL Server (0x80040E14)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. I've had a quick look at the database and the master database doesn't have the SPs that are needed so the part regarding security configuration does seem to make sense though I'm not really sure what needs to be done to "install" them.Any help would be much appreciated." |
|
|
nosepicker
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-08-10 : 00:13:11
|
| What happens when you execute sp_configure? What is the run value for "OLE Automation Procedures"? The error message is stating that you need to set this option to 1. If you don't see that record, configure the "show advanced options" to 1 to see all the possible options. |
 |
|
|
|
|
|
SQl 2005 server