Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajkumarrai_bis
Yak Posting Veteran
78 Posts |
 Posted - 2008-09-25 : 10:32:38
|
| Hi,I have created a linked server which reads data from an excel filei am able to run query against this link server and fetch datamy ID has sysadmin rights on this serverhowever our application ID which is a SQL Login is not able to access this linked server and gets following errorMsg 7416, Level 16, State 2, Line 2Access to the remote server is denied because no login-mapping exists.as far as excel file security is concerned everyone has read rights on itcan anyone help what rights should i give to SQL ID to access this linked server ? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-25 : 11:00:02
|
| Does that SQL Login has access to xls files on remote Server? |
 |
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-09-25 : 13:55:47
|
| Can you check whether the sql login has access to the Excel file?? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rajkumarrai_bis
Yak Posting Veteran
78 Posts |
Posted - 2008-09-26 : 03:42:43
|
| As far as excel file security is concerned "Everyone" has read rights on iti have added "everyone" in the security tab of Excel file and given it read rightsI am not sure how can i give SQL ID rights on a Excel filewhen i give this SQL ID sysadmin rights on SQL Server then it is able to access linked serverso the problem seems to be of insufficient rights on SQL Server and not on excel filePlease advice. |
|
|
|
rajkumarrai_bis
Yak Posting Veteran
78 Posts |
Posted - 2008-09-29 : 02:27:17
|
| Waiting for advice..Please help |
|
|
|
rajkumarrai_bis
Yak Posting Veteran
78 Posts |
Posted - 2008-09-30 : 03:24:28
|
| Please help |
|
|
|
|
|
|
Link Server Security Issue