Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2006
    Posts
    26

    Unanswered: Linked Server & SQL Auth

    I am stuck... I am trying to use a linked server in sql 2005 (xls sheet), it works great using windows authentication but since the program will not be running locally i would prefer to use sql auth...

    when i log in using the sql name i have created. it only has connect & execute permissions on the main database (as it should), but i also need to query this linked server, when i try to query it i get authentication failed. how do i fix that?

    the xls is on a fat32 partition and can be moved to an ntfs partition with out any problems.

    thanks in advance

  2. #2
    Join Date
    May 2003
    Location
    Rochester, NY
    Posts
    135
    ...not sure if this is the problem, but have you granted read permissions to the database (e.g. db_datareader role)?

  3. #3
    Join Date
    Jul 2006
    Posts
    26
    no i have not, i thought that would give to much power to that user and allow it access to other databases..if that is false please let me know..

  4. #4
    Join Date
    May 2003
    Location
    Rochester, NY
    Posts
    135
    The db_datareader database role is for only within the database it is granted. So you would only be granting read access to tables within the specified database that the public role does not already allow read access to.

  5. #5
    Join Date
    Jul 2006
    Posts
    26
    i do not have these options on a linked server so... what is next.

Posting Permissions

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