Restore via C# via Stored Procedure

jzelhartjzelhart Posts: 5 New member
In my connection string, we use a standard user that doesn't have rights to do the restore but inside the Stored Procedure, we user the LOGIN AS USER option to increase the rights.

I can run the Stored Procedure from SSMS without any issues. Both as sa and as the Standard User. But when I run it via the C# Code, I get Error Code 580 - Permission issue.

Anyone have any ideas?
Sign In or Register to comment.