Could not find file 'SqlAccess.dll'

Question

When running

CREATE ASSEMBLY MyAssembly
FROM 'S:\SourceCode\TryUDF\bin\Debug\TryUDF.dll'

an error is returned:

Could not find file 'SqlAccess.dll' in directory 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\'.

The assembly is a class library built with VS2008. SQL Server is 2005. SqlAcesss.dll exists in the above location, and that Binn directory is in the PATH environment variable for the system. How can I diagnose what is causing this problem?

Answer 1

If it was built with VS2008 check to see if the references to SQL objects in the project are using SQL 2008 libraries. That could be your problem. You might need to recompile your library against SQL 2005 libraries.

Answer 2

I can't find the article right now but I'm pretty sure it's related to the DLL not being signed or the TRUSTWORTHY setting on the SQL Server. The error says file not found but it actually means it wasn't able to load it (not the same thing!).

I'd suggest re-asking on stackoverflow.com if you don't get it sorted.

Answer 3

Solved. Since I had followed procedures suggested by Microsoft Baseline Security Analyzer to secure the SQL Server, possibly incompletely or incorrectly, the SQL Server service account did not have permissions as required to the folder where sqlaccess.dll exists. Immediately upon granting permissions (read, execute, list), the error went away.