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 |
|
BigSam
Starting Member
30 Posts |
 Posted - 2006-12-20 : 10:12:57
|
| We are migrating from SQL2k to SQL2k5. I've created copies of my SQL2k databases on a server running SQL2k5, using a restore. So far everything looks good. Now we are trying to test our applications that run against the database. When we try to login our asp application with a user ID & password were are getting an error from SQL:EXECUTE permission denied on object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'Anybody got any ideas or solutions?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-20 : 13:26:38
|
| Well did you try adding the EXEC permission to that system stored procedure?Tara Kizer |
 |
|
|
BigSam
Starting Member
30 Posts |
Posted - 2006-12-20 : 13:53:21
|
| Ok. It worked that time. I believe it was due to me having changed the users role.Thanks |
|
|
|
|
|
|
SQL2k -> SQL2k5