Post reply

Problem Creating Assembly with Permission Set of UNSAFE

  • July 21, 2007 at 7:28 pm

    #372876

    Yesterday, I began the process of moving a database from SQL 2000 to SQL 2005.  All is fine except that a stored procedure uses a external stored procedure (xp_getfiledetails) that has been retired.  I went ahead and wrote a vb application to replace this stored procedure.  My problem is that I can't create the assembly with the permission set of UNSAFE.  Can someone please give me a recipe with an explanation of what is being done to allow me to create the assembly and use it in SQL 2005.

    Thank you.

  • July 22, 2007 at 11:23 am

    #721388

     you will have to:

    create a signed assembly in .net  environment

    create an asymentic key on sql server for the .net assembly

    grant EXTERNAL_ACCESS or UNSAFE permission set to the .net assembly

    probably create a login for the asymetric key

    and you might additionally need to assign permissions to the user that is running the sql server process

    Everything you can imagine is real.

  • July 23, 2007 at 11:45 am

    #721590

    Hello Bledu

    Thank you for the information.  I was able to get it to work.  FYI -- you ARE required to create a login for the asymetric key.

     

    Clay

  • July 23, 2007 at 11:59 am

    #721598

    did u get it to work from what i have you? i don't think  you are required to create the login, in my case i ended up do it because i was having the usual  programming problems

    Everything you can imagine is real.

  • July 23, 2007 at 12:30 pm

    #721615

    I tried to create the procedure WITHOUT creating the login and it Failed.  After I created it, I was able to create the procedure.

  • July 23, 2007 at 12:44 pm

    #721621

    that was my experience as well

    Everything you can imagine is real.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply