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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-25 : 08:14:30
|
| remo writes "Hello everybody,i have a question, i need to view in Sql Server 2000 sp3 a paradox table using linked server.I successfully create a dns system file that reconize paradox but the main problem is a security problem because into paradox there is no security autentication but sql server must have a remote user with his password for login in remote server.how to bypass this problem? any suggestion?thanks,Remo Angeloni" |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-08-25 : 11:19:19
|
| Just use the 2nd option in the linked server window. It's named "Be made without using security context". That or maybe look at openrowset. I know openrowset still has a slot for uid/pw but maybe you could just leave those blank?DanielSQL Server DBAwww.dallasteam.com |
 |
|
|
|
|
|
Linked Server