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...not sure if this is the problem, but have you granted read permissions to the database (e.g. db_datareader role)?|||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..|||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.|||i do not have these options on a linked server so... what is next.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment