Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Help me

Sinjith_shrSinjith_shr Member Posts: 6
[b][red]This message was edited by Sinjith_shr at 2004-6-1 21:13:16[/red][/b][hr]
I have two SQL server machines running in same network.From my query analyzer i want to access both server objects from the same connection. I dont want to connect to server2 in the server1 Query Analyzer i will give the 'SA' user and password for both servers. Also I logged in as a sa user in the server1. Is it possible to do like that. If any body knows how to do this plz help me. I need it very urgently


Comments

  • abhishek12abhishek12 Member Posts: 3
    : [b][red]This message was edited by Sinjith_shr at 2004-6-1 21:13:16[/red][/b][hr]
    : I have two SQL server machines running in same network.From my query analyzer i want to access both server objects from the same connection. I dont want to connect to server2 in the server1 Query Analyzer i will give the 'SA' user and password for both servers. Also I logged in as a sa user in the server1. Is it possible to do like that. If any body knows how to do this plz help me. I need it very urgently
    :
    :
    : I suppose you want to access the data from two server through the same query analyser??? If this is the case, you can use the format ... format to access the data. If this does not solve your problem then probably I have not understood your question. You can just explain me with an example. May be I'll be able to help you!!!

  • ShanooShanoo Member Posts: 32
    : : [b][red]This message was edited by Sinjith_shr at 2004-6-1 21:13:16[/red][/b][hr]
    : : I have two SQL server machines running in same network.From my query analyzer i want to access both server objects from the same connection. I dont want to connect to server2 in the server1 Query Analyzer i will give the 'SA' user and password for both servers. Also I logged in as a sa user in the server1. Is it possible to do like that. If any body knows how to do this plz help me. I need it very urgently
    : :
    : :
    : : I suppose you want to access the data from two server through the same query analyser??? If this is the case, you can use the format ... format to access the data. If this does not solve your problem then probably I have not understood your question. You can just explain me with an example. May be I'll be able to help you!!!
    :
    :

    If I am not wrong then you will have to use sp_addlinkedserver to make it work. After adding the remote server as linked server, you can use fully qualified name (described in the previous response) for accessing the tables of the remote server.
  • Sinjith_shrSinjith_shr Member Posts: 6
    : : : [b][red]This message was edited by Sinjith_shr at 2004-6-1 21:13:16[/red][/b][hr]
    : : : I have two SQL server machines running in same network.From my query analyzer i want to access both server objects from the same connection. I dont want to connect to server2 in the server1 Query Analyzer i will give the 'SA' user and password for both servers. Also I logged in as a sa user in the server1. Is it possible to do like that. If any body knows how to do this plz help me. I need it very urgently
    : : :
    : : :
    : : : I suppose you want to access the data from two server through the same query analyser??? If this is the case, you can use the format ... format to access the data. If this does not solve your problem then probably I have not understood your question. You can just explain me with an example. May be I'll be able to help you!!!
    : :
    : :
    :
    : If I am not wrong then you will have to use sp_addlinkedserver to make it work. After adding the remote server as linked server, you can use fully qualified name (described in the previous response) for accessing the tables of the remote server.
    :

  • Sinjith_shrSinjith_shr Member Posts: 6
    : : : : [b][red]This message was edited by Sinjith_shr at 2004-6-1 21:13:16[/red][/b][hr]
    : : : : I have two SQL server machines running in same network.From my query analyzer i want to access both server objects from the same connection. I dont want to connect to server2 in the server1 Query Analyzer i will give the 'SA' user and password for both servers. Also I logged in as a sa user in the server1. Is it possible to do like that. If any body knows how to do this plz help me. I need it very urgently
    : : : :
    : : : :
    : : : : I suppose you want to access the data from two server through the same query analyser??? If this is the case, you can use the format ... format to access the data. If this does not solve your problem then probably I have not understood your question. You can just explain me with an example. May be I'll be able to help you!!!
    : : :
    : : :
    : :
    : : If I am not wrong then you will have to use sp_addlinkedserver to make it work. After adding the remote server as linked server, you can use fully qualified name (described in the previous response) for accessing the tables of the remote server.
    : :
    :
    :
    Thks frds
    it was the solutions i was looking for. Thanks for the support u have
Sign In or Register to comment.