<div>
<div class="content wysiwyg-content">
I'm having trouble connecting to a SQL server with SSMS over VPN.<br />
<br />

<ul>
<li>I have several VPN connections I can connect to for servicing remote sites. &nbsp;Only one remote SQL server is exhibiting the problem.</li>
<li>With the remote server Windows Firewall OFF, I can connect to the server with SSMS.</li>
<li>With the remote server Windows Firewall ON, I can ping the server but cannot connect with SSMS.</li>
<li>I have verified the listening port on the remote server.</li>
<li><a href="https://filedb.experts-exchange.com/incoming/2020/05_w21/1459389/SQLlisteiningon.PNG" target="_blank" title="SQLlisteiningon.PNG (62 KB)"><img alt="SQLlisteiningon.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2020/05_w21/800_1459389/SQLlisteiningon.PNG" /></a></li>
<li>I have created an inbound firewall rule to open Port 1433 on the remote server:</li>
<li><a href="https://filedb.experts-exchange.com/incoming/2020/05_w21/1459390/sqllisteiningport.PNG" target="_blank" title="sqllisteiningport.PNG (79 KB)"><img alt="sqllisteiningport.PNG" class="file-block lazyload" style="max-width: 604px;" data-src="https://filedb.experts-exchange.com/incoming/2020/05_w21/1459390/sqllisteiningport.PNG" /></a></li>
</ul>
<br />
What am I missing?
</div>
</div>


sqllisteiningport.PNG

SQLlisteiningon.PNG

I'm having trouble connecting to a SQL server with SSMS over VPN.

I have several VPN connections I can connect to for servicing remote sites.  Only one remote SQL server is exhibiting the problem.
With the remote server Windows Firewall OFF, I can connect to the server with SSMS.
With the remote server Windows Firewall ON, I can ping the server but cannot connect with SSMS.
I have verified the listening port on the remote server.
I have created an inbound firewall rule to open Port 1433 on the remote server:


What am I missing?

Firewall blocking SSMS connection

I&#39;m having trouble connecting to a SQL server with SSMS over VPN.

I have several VPN connections I can connect to for servicing remote sites.  Only one remote SQL server is exhibiting the problem.
With the remote server Windows Firewall OFF, I can connect to the server with SSMS.
With the remote server Windows Firewall ON, I can ping the server but cannot connect with SSMS.
I have verified the listening port on the remote server.
I have created an inbound firewall rule to open Port 1433 on the remote server:


What am I missing?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

A virtual private network (VPN) is a network that uses a public telecommunication infrastructure, such as the Internet, to provide remote offices or travelling users access to a central organizational network securely. VPNs encapsulate data transfers using secure cryptographic methods and other security mechanisms to ensure that only authorized users can access the network and that the data cannot be intercepted.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.