Access problems when creating assambly

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Access problems when creating assambly

Author

Topic

Antinsh
Starting Member

16 Posts

Posted - 2008-03-19 : 04:32:04

Hi!

This is quite weird.

When I first wanted to create assably using:
CREATE ASSEMBLY hash
from 'C:\hash.dll'
WITH PERMISSION_SET = EXTERNAL_ACCESS

... Server returned error:
CREATE ASSEMBLY failed because it could not open the physical file "C:\TESTS_Run_This_In_SQL2.dll": 2(The system cannot find the file specified.).

Then I tried to find file with
exec Master.dbo.xp_fileexist 'C:\hash.dll'
File exists - false
File is directory - false
Parent directory exists - true
Conclusion: Server knows that I have hard drive but cannot see the file (by the way file IS THERE 10000%,alright)

2nd TRY:
Copy file to a Server PC named 'pluto' in a directory...
i try to create an assably:
CREATE ASSEMBLY hash
from '\\pluto\Projekti\ECDL\hash.dll'
WITH PERMISSION_SET = EXTERNAL_ACCESS
...SAME THING: The system cannot find the file specified.
i try to find file.... SAME THING!

3rd TRY:
I copy file to another Server PC, this time i try to find file first:
exec Master.dbo.xp_fileexist '\\Depo\projekti2\ECDL\SRC\Backup\hash.dll'
IT WORKS!!! file is found!!! now everything should work....right!

CREATE ASSEMBLY hash
from '\\Depo\projekti2\ECDL\SRC\Backup\hash.dll'
WITH PERMISSION_SET = EXTERNAL_ACCESS
.....
CREATE ASSEMBLY failed because it could not open the physical file "\\Depo\projekti2\ECDL\SRC\Backup\hash.dll": 5(Access is denied.).

Now this is fun.
The whole point of this is can somebody tell me what permissions I (or Management Studio or whatever) have to have in order to create an assably from dll?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources