DbSchema Database Designer

DbSchema | How to Enable Remote Connections in SQL Server



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
machines.
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;

network-configuration

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;

tcpip-properties

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

4.Connect

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;

connection-dialog

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

ping

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

DbSchema → Your Trusted Partner in Database Design

Simplify complex database workflows and improve productivity with DbSchema's advanced design and management tools

Visual Design & Modeling
Visual Design & Schema Layout

➤ Create and manage your database schema visually through a user-friendly graphical interface.

➤ Easily arrange tables, columns, and foreign keys to simplify complex database structures, ensuring clarity and accessibility.

GIT & Collaboration
Version Control & Collaboration

➤ Manage schema changes through version control with built-in Git integration, ensuring every update is tracked and backed up.

➤ Collaborate efficiently with your team to maintain data integrity and streamline your workflow for accurate, consistent results.

Data Explorer & Query Builder
Relational Data & Query Builder

➤ Seamlessly navigate and visually explore your database, inspecting tables and their relationships.

➤ Build complex SQL queries using an intuitive drag-and-drop interface, providing instant results for quick, actionable insights.

Interactive Documentation & Reporting
HTML5 Documentation & Reporting

➤ Generate HTML5 documentation that provides an interactive view of your database schema.

➤ Include comments for columns, use tags for better organization, and create visually reports.