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 |
|
codrgiii
Starting Member
29 Posts |
 Posted - 2009-07-07 : 09:56:50
|
| i want to select a table on one of my server, i have 2 servers in total, the first one is the account db and the second is the actual server, i need the second server to collect the info from the first server, so i've set up a linked server in sql 2005, but it dosen't connect to my server and only returns stuff from its own db, how do i set this up to connect to my first server? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-07 : 10:20:07
|
| How have you set up the linked server? Do you have enough access to see anymore than that one DB?What security context are you using in your linked server (check the second tab)? |
 |
|
|
codrgiii
Starting Member
29 Posts |
Posted - 2009-07-07 : 11:22:51
|
| im using the "be made using this security context" which has my servers user and pass that i want to connect too. In data sources (ODBC), i haven't set up a dns which connects from the second server to the first server, how would i do that?i tried adding 192.1.0.1\INSTANCE_HERE but it says it can't connect or the server dosen't exist, i even turned off the servers firewall to try this but still the same errorEDIT-THE IP 192.1.0.1 was just an example ip, same as the instance. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-07 : 11:51:14
|
| Can you ping the ip address? |
|
|
|
codrgiii
Starting Member
29 Posts |
Posted - 2009-07-07 : 12:51:49
|
| tried, and i can ping the address, but this still isn't working and still giving the error, any ideas how to fix this? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-08 : 04:38:07
|
| Whats the error? You never mentioned an error in your posts?!?Are you sure you have full access to all the databases? Can you please expand the master database (on both servers) and open a table to see if you have access. |
|
|
|
|
|
|
|
|
how to do this?