User and remote connection questions in SQL Server Management Studio

0

I created a remote connection from my database here at work so that I can access from home just by entering the company's fixed IP. Now I need to know if it is possible, for example: I have several users created, but I want only the user "query" to be able to connect to the bank externally.

My DB information:

Main database (work): Microsoft SQL Server 2016 (with Management)
Microsoft SQL Server Management Studio 2008

If this possibility exists, could you guide me how?

Complementing:

To better explain, in the case here in the company, we use Management Studio. Let's say that from my house I have the same program (no bank, only Management) and at the time the program requests the server name, username and password I would put FIXED IP, PORT (example: 255.255.255.255, 3333) from company.

I know all the users I have available for login, but I want only the user to be accepted on this type of connection and that other users are blocked unless I have local access.

    
asked by anonymous 08.05.2018 / 19:34

0 answers