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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2003-06-11 : 03:51:40
|
| Hi ,I have setup a test linked server and i have successfully executed a query on my local SQL server which actually executes a query on the linked server that i have setup .( I guess that's the way it should work ) . Now I have a front end application which should talk to the Linked server to get the results out , but somehow it fails . So I have traced the query the application generates and when I try to execute the query in the SQL query Analyser , it displays results connecting to the linked server . But the same is not happening through the front end . Am i missing something in the configuration so that my application will talk to the linked server . I have even changed the code in my application to go the linked server , but still it fails . It does not give any errors but simply says that for e.g " o records or documents found " . When I remove the entry of my linked server in the code , I get the results but from my local SQL Server . Would like to have assistance in resolving this issue . Further if the linked server is another geographical location , say another country , what are the configuration settings required ? Like ENABLE/DISBALE RPC , tcp/ip , Opening port on the Firewall etc...Thank you very much . |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-06-11 : 08:11:28
|
| How are you handling login mapping?Jay White{0} |
 |
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2003-06-11 : 23:05:25
|
| Hi ,Yes I wish to have login mapping as my application has got a fixed connection properties to connect to the DB . I would like to map all my logins to map to a single ID . There is also a security feature of impersonation . But I am not to sure what is that and when should I use it .Thanks . |
|
|
|
|
|
|
Linked Server setup .