July 2, 2014 at 9:44 am
I am working with SQL Server 2008 R2 and am logged into SSMS as sa.
This is a new install of SQL 2008, as we are moving to a new server. We have an application which worked on the old server and its not working on the new. Obviously I missed something in the configuration.
The application gets the error EXECUTE permission denied on object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'. I have made sure that OLE Automation is enabled, which is the usual cause of this error.
When I try to grant EXECUTE on the login in question, I get this error.
Cannot find the user '<username', because it does not exist or you do not have permission.
The user does exist, as the application is connecting with it. I'm running the grant execute as 'sa'.
Any thoughts come to mind as to what I'm missing.
July 2, 2014 at 9:58 am
I found my own solution shortly after posting,.
It was due to the db being restored and the login getting orphaned from the user. This statement solved my problem. Hopes this helps someone else.
USE master
GO
CREATE USER <dbuser> FOR LOGIN <dbuser>
GO
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply