We are trying to create a C # CLR stored procedure on a SQL Server 2005 machine. The C # code connects to an external data source via an OLEDB driver to obtain a dator. It has been tested on a different console application, and it runs without problems. (OLDEB Driver is the proprietary driver connecting with proprietary DB ...)
On SQL Server, we have set an external permit level on the assembly, it is a strong name and designed for an SSMRTR key This is in SQL Server.
When we try to execute the process, we get the following two problems:
-
The credentials used to contact OLEDB are: Service is running under, and the login credentials of the logged in user are not known.
-
A .NET Framework has been raised:
System.Security Security exception: Request permission type System.Data.OleDb.OleDbPermission
It looks like Driver that we can not manage to run Odbak to the authority in the process. Either this is our lack of configuration or we are just doing something wrong, UNSAFE is also not an option to set permission level ...
Does anyone have any problems with this type of have experience? Any input is welcome!
Regarding your first problem (impersonation):
Comments
Post a Comment