Results 1 to 3 of 3

Thread: CREATE ASSEMBLY failed because it could not open the physical file

  1. #1
    Join Date
    Sep 2002
    Posts
    159

    CREATE ASSEMBLY failed because it could not open the physical file

    Hi,
    I have sql 2005 localy , dev edition (local01) and server
    with entpr. edition (server01)
    opetion clr enabled = 1 (service restarted)

    I create udf and try implement it

    CREATE ASSEMBLY [YahooGCSQL]
    AUTHORIZATION [dbo]
    FROM '\\superserver\public\dba\YahooGCSQL.dll'
    WITH PERMISSION_SET = EXTERNAL_ACCESS

    1. on local01 it work fine
    2. on server01 getting error
    Msg 6501, Level 16, State 7, Line 1
    CREATE ASSEMBLY failed because it could not open the physical file '\\superserver\public\dba\YahooGCSQL.dll'': 5(error not found).

    I use domain acount with dba permission on local01
    and server01

    account is admin on local01 and has lmited access on server01
    it work on server01 ,when I login server LOCALY using my domain account


    what server permssions (account already DBA on sql server) account should have to run CREATE ASSEMBLY remotly ?

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Add your sql server domain account to that \public\dba shared folder and give read access.

  3. #3
    Join Date
    Sep 2002
    Posts
    159
    folder is really public for all domain users

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •