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.
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?