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 |
|
rammohan
Posting Yak Master
212 Posts |
 Posted - 2010-09-21 : 05:33:27
|
| Hi,i need read data from a table x which is in another db server called tech for that i had written query lik this from current db serverselect * from [tech].dbo.dgty.xdgty is data base.I am getting following errorlogin failed for user 'xyz'.Please suggest me a solutionOne can never consent to creep,when one feels an impulse to soarRAMMOHAN |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-09-21 : 06:38:50
|
| one ways is to create a linked server ( Link the other server with this server)Have a look at:http://msdn.microsoft.com/en-us/library/aa213778(SQL.80).aspxhttp://msdn.microsoft.com/en-us/library/aa215786(SQL.80).aspxSecondly,select * from [tech].dbo.dgty.xshould beselect * from [tech].dgty.dbo.xRegards,Bohra |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-09-21 : 12:58:15
|
| Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=150425 |
|
|
|
|
|
|
error while reading data from another server