DbSchema Database Designer

DbSchema | How to Enable Remote Connections in SQL Server

Publish on DbSchema Blog >>>

To enable enable remote connections on SQL Server, we first have to enable the TCP/IP connections and set the port.

1.What is TCP/IP?

In order to communicate, computers use a protocol, a standard set of rules that facilitates the transfer of information between
This standard is named TCP/IP.

  • IP - is the address to which the data is sent;
  • TCP - is responsible with delivering the data once the IP address is found.

2.Enable TCP/IP connections in SQL Server

1.To enable the connections, we have to open the SQL Server Configuration Manager. Once the Configuration Manager is opened,
go to SQL Server Network Configuration;

2.Right-click on TCP/IP and Enable it;

3.Then, open Properties;


4.In the new window, go to IP Addresses;

5.Scroll to the bottom to and find IPAll;

6.Set the TCP Port to 1433;


7.Restart the application.

3.Configure the Firewall

Now, we have to create a rule that will allow the connection through Windows Firewall.
The easiest way to do it is to open command prompt and execute this command:

netsh advfirewall firewall add rule name=SQLPort dir=in protocol=tcp action=allow localport=1433 remoteip=localsubnet profile=DOMAIN


We will now connect to SQL Server from a remote machine using DbSchema. These principles apply to any other software you
are trying to connect with SQL Server.

1.Configure the ip & port details. The IP can be found by opening command prompt and typing ipconfig. From there
you should copy the IPv4 from Default Gateway;

2.Fill in the credentials. The default user for SQL Server is named sa and the password is the one set at installation;


3.To check if the connection is enabled, press the ping button.


That’s all! Now you’re set and ready to connect.

Visually Manage Databases using DbSchema

DbSchema is a databases client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.
DbSchema main features include:

DbSchema Designer alt >

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams, by double-clicking them. Changes will be saved to the design model and, if DbSchema is connected to the database also into the database. More.

Connection Dialog alt >

Simple Connection Dialog

Choose the database location, the user and password, and simply get connected. Choose 'Edit Manually' into the JDBC URL combo to enter a custom URL. More.

Relational Data Explorer alt >

Relational Data Explorer

Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys. Double-click cells to edit the data. More.

Query Builder alt >

Query Builder

Create SQL Queries featuring JOINS, GROUP BY, ORDER BY just using the mouse. More.

SQL Query Editor alt >

SQL Query Editor

Edit and execute SQL Queries. The editor is autocompletion-enabled. More.

Schema Synchronization alt >

Design Schema in Team & Schema Deployment

DbSchema is using the design model, a copy of the schema structure, independent of the database.
The design model can be saved to file and shared in a team.
Connecting to another database you may compare the design model with the database, commit the differences or merge them in the design model. More.

Dark Theme alt >

Dark Theme

Configurable styles & dark theme. More.

Many features are available in the free Community edition.
The Pro edition adds capabilities to save the design to the model file, design schema in team and deploy the schema on multiple databases.

DbSchema can be downloaded for free. No registration is required.