Impossible to connect database server via Management Studio

SQL Server Administration
1

Hello,
I'm not able to connect a DB Server via IP address using my SQL Server 2019 Management Studio though via Remote Desktop I can access to this DB Server.
Where I have to investigate to solve this problem?

Thanks a lot.

Luis

2

please see if below links help

3

Your question isn't clear. Can you connect when using RDP, but not from your machine?? Can you ping the server. Why are you using IP address instead of ServerName or AG Name?

4

in relation to your network where is the sql server located at?

  • Local network?
  • Cloud?
  • Work network accessed via vpn

Can you be a little bit more detailed?

5

I'm using the FortiVPN Client.
On the remote server I can connect only via Remote Desktop, not via Management Studio and not via Ping.
I'm using only IP address (but I know the Db server name also).

L.

6

what happens when you do the following in command line

>>nslookup
>server.name
7

image

8

nope. first nslookup by itself, then you enter the server name. Please google nslookup. Also you just exposed your ip addresses to the whole world. I would remove that Luigi

9

If you can't ping the servername or IP, then it's probably being blocked by a firewall

1 Like
10

Yes, that's fixed the problem.
Thank you Mike.

L.