Results 1 to 4 of 4

Thread: Linked Server

  1. #1
    Join Date
    Jan 2008
    Posts
    4

    Unanswered: Linked Server

    Hi everyone,
    I am just new here in dbforums and it was a pleasure joining.
    I have a problem regarding a linked server connected to my MSSQL2005 db. My linked server is sybase and i have added same dev users for both sybase and mssql. There are 4 tables in the linked server added into my synonyms(mssql) but the problem is that i cant select/insert into these tables including executing sprocs involved. I already checked the permissions in these tables and all was correct(eg.select/insert/delete grant to dev role). Please help me what to do next.. tnx..

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by xr vincelfs
    I already checked the permissions in these tables and all was correct(eg.select/insert/delete grant to dev role)
    The dev role on which side of things? Must have permissions on both servers!
    George
    Home | Blog

  3. #3
    Join Date
    Jan 2008
    Posts
    4

    permissions

    How do I create dev role on mssql2005? i am quite new with it. I used to work on sybase..

  4. #4
    Join Date
    Jan 2008
    Posts
    4
    Please help e.. how do i create the dev role on mssql2005? up...

Posting Permissions

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