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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2006-03-22 : 18:19:37
|
| I server A which is Windows authentication, I need get data from another server B which is SQL authentication. How to do it? I always got error. |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-03-22 : 18:27:49
|
| You need to create a link between them in 'Linked Servers' have a read up on Linked Servers in BOL. Once you have created the link, you can simply reference the other server using the notation Server.Database.namespace.TableHTH,TIm |
 |
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2006-03-22 : 20:01:32
|
| I did linkedserver for two SQL authentication. Now, one is SQL authentication and another one is Windows authentication. |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-03-23 : 00:25:29
|
| Now I'm confused.....Can you explain what you're trying to do and maybe someone will be able to help. |
|
|
|
|
|
|
Connect two servers in two authentication mode