rivkahannah
Programmer
Hi,
I am a newbie to SQL Server. I have a SQL Server 2000 database that has an Access 2000 front end. I set up several stored procedures that are called using pass through queries in the front end. On my test server, they run fine and on a second database that I also set up with the same front-end/back end schema they work fine also. However, on the production server the stored procedures keep giving me this error: EXECUTE permission denied on object 'xp_TempSite', database 'reimb', owner 'dbo'
The front end uses an application log in that I set up and I have granted execute permissions on all of the sp's. I have tried revoking and re-granting the permissions but it doesnt seem to help. I can also run views through the pass through queries without any errors.
Please help!
Thank you!!
Rebekah
I am a newbie to SQL Server. I have a SQL Server 2000 database that has an Access 2000 front end. I set up several stored procedures that are called using pass through queries in the front end. On my test server, they run fine and on a second database that I also set up with the same front-end/back end schema they work fine also. However, on the production server the stored procedures keep giving me this error: EXECUTE permission denied on object 'xp_TempSite', database 'reimb', owner 'dbo'
The front end uses an application log in that I set up and I have granted execute permissions on all of the sp's. I have tried revoking and re-granting the permissions but it doesnt seem to help. I can also run views through the pass through queries without any errors.
Please help!
Thank you!!
Rebekah