The partner on the PC has a MS SQL , the IP static. Can I somehow access and work with it through my SSMS ?

    2 answers 2

    You need to do the following. First set up the server

    Now for the customer. When you start SSMS , a window appears to connect to the database. Fill it

    • In the ServerName field - (ip address of the server) (the name of the SQL server instance on the server). If only one instance of SQL server is installed on the remote machine, then the name of the instance is optional, it is enough to specify only ip.
    • Autentification - choose SQL Server authentification
    • Well, in the User name and Password fields, enter the authentication data of the user created on the server.

    PS After setting up the server, you can also start telnet and check the availability of the open port on the server. Open telnet and enter something like this
    192.168.0.1 1433
    If the port is listening, you can try to connect via SSMS

    If you have any questions, ask.

    • Thank you, good answer! - Lightness

    If I understand correctly, then you want to be on one server to make requests to another server without switching between servers?

    In this case, read about Linked servers.

    In short: You specify the IP of the remote server in the settings of the linked servers in MS SQL Server and you can write requests of this type to another server while on the same north:

     Select * from [Название удаленного сервера].[схема].[Таблица]

    True, there are some limitations ... For example, you cannot perform queries on tables where there is XML ...

    • I would like to work with a remote database, as if it were on my PC. Make queries, delete / create tables, edit data, etc. - Lightness
    • In this case, my answer is a bit past ... And his IP is pinged at you? What if when you start SSMS you specify its IP and accounting? - iluxa1810
    • In the firewall and escule server, you need to allow incoming connections - gecube
    • @ iluxa1810, IP pinged, but IP and accounting for ssms do not channel. I am sure that there are some settings in SSMS to open access for external users, only the problem is to find them. - Lightness