Msg 6501

I am unable to create assemblies in SQL Server 2005. Everytime I try to do so I get the dreaded "Msg 6501... could not open the physical" error.

Here is the compile syntax I'm using from within Eclipse 3.2.0, which invokes C# .NET, to create my .dll:

/target:library ${resource_name} /reference:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlaccess.dll"

I then try to create my my assembly:

create assembly match

from

'C:\Documents and Settings\jeff seeman\workspace\mycsharp\new.dll'

GO

Boom! Bad old Msg 6501. Any suggestions?

Jeff Seeman

What is the full error message?

The last part of it should tell you the specific reason it failed ("The system cannot find the path specified.", "Access Denied", etc.). Since you've probably verified the file exists, I'm guessing it's an Access Denied error, meaning that the account SQL Server is running under does not have access to the file. You should be able to fix this easily by modifying the ACL on the directory or moving the file into a directory that SQL Server is able to access.

Steven