app.config not found in SQL Server external assembly call

Question

Hi,

In SQL Server ,I created an assembly to run an external DLL. When I run the stored procedure that execute my function I got an exception that my configuration file is not found.

Does any one know where the app.config should be located so that SQL Server knows how to load it. I have it right now in the same folder as my DLL.

Thanks in advance.

Answer 1

SQLCLR assemblies don't support .config files. As an unsupported workaround you can create an sqlservr.exe.config in the same location as the service binaries and place your configuration in there, the SQLCLR assemblies parse this configuration when the assembly is loaded.