Connection between two DBMS Sql Server

Question

Connection between two DBMS Sql Server

Navigation

#1 by (2 votes)

0

Is there any way beyond Linked to connect two DBMSs?

Problem:

I need to use tables from another database that is on another server with SQL SERVER installed.

My current server is also SQL Server;

sql sql-server

asked by anonymous 26.10.2017 / 14:56

1 answer

I would like a hint on checked, select option how do I clear fields if a person selects an option Solutions counter in recursion

score 2 · Answer 1

You need to create a linkedServer between the servers. Through the Linked Server you create a communication link between one server and another so that you can have free access to the data stored on the other server, but the important thing is that the user that will be used to create the linked has access permission to work with these data

Example Server1, instance "192.168.0.10" and Server2, instance "192.168.0.11", and will have to access the "Client" table of the final server 11, then do a Linked Server, it can be by Studio same, then the query will be done as follows:

SELECT * FROM [192.168.0.11].[NOME_BANCO].DBO.Cliente

If on the linked server you created using IP will be done as above, but if you did using the instance, change the IP by the instance name of SQLSERVER.