On your router’s configuration page, go to the Port Forwarding Settings Forward the following port traffic to the IP address of your CurrentWare Server computer. Then, you will need to configure your router’s setting. #1 – Preparing your CurrentWare Serverįirst, you will need to set up your CurrentWare Server on a network that has a Public Static IP address (obtained from your Internet service provider). To connect your CurrentWare Clients to the CurrentWare Server over the Internet, you will need to port forward the CurrentWare traffic from your network’s router to the CurrentWare Server computer. Running a Firebird Database with CurrentWare? Read this guide insteadĬonnecting the CurrentWare Clients (Remote workers) For instance, if your IP address is something like 192.Note: This guide is only for CurrentWare connecting to a SQL Database (SQL is the default database used by CurrentWare). The port numbers will be shown after the IP address and the two are separated by a colon. This will populate a list of your active TCP connections.
The “telnet” command is valid for Windows and Unix operating systems.Īll you have to do is type “netstat -a” on Command Prompt and hit the Enter button. You can also specify a domain name instead of an IP address followed by the specific port to be pinged. The easiest way to ping a specific port is to use the telnet command followed by the IP address and the port that you want to ping. Next type netstat -a for a list of your various port numbers.
How to find your port number Start your command prompt.
Look for the title “Ethernet adapter” and look for “IPV4 address”, this is your local IP address.Ĭonnect to the SQL Server using SSMS Next, from the Connect menu under the Object Explorer, choose the Database Engine... Then, enter the information for the Server name (localhost), Authentication (SQL Server Authentication), and password for the sa user and click the Connect button to connect to the SQL Server. In the black box that comes up type “ipconfig”. Type “cmd” into the text box and then click “OK”. How to find your database IP address and SQL port Hold the windows key on your keyboard and then press the “R” key to open up the “Run” box. How do I find my SQL server port and IP address? Then specify the login credentials, click the connect button, and assuming everything is correct it should then connect to the SQL Server. How do I connect to a port number in SQL Server?Ĭonnect using a different port using a comma Normally you would just type the server name into field but to specify a different port use a comma then the port number. Click TCP or UDP depending on the desired port. Windows Firewall To open a port, navigate to Start > Control Panel > System and Security. Find the established, or active, ports on the server by typing in ‘netstat -an |find /i “established”‘ in the command prompt. Hit the “Enter” key on your keyboard and wait for all of the ports to show up on the screen. Listen for open ports by typing ‘netstat -an | find /i “listening”‘ in the command prompt. How can I tell if a port is open between two servers? If it is, then it means that the server is listening on that port. Check to see if the specific port is listed. Select Specific local ports, and then type the port number of the instance of the Database Engine, In my case we are using the default which is 1433.Ĭhecking Windows Firewall for blocked ports Launch Command Prompt. In the Protocol and Ports dialog box, select TCP. To open a port in the Windows firewall for TCP access In the Rule Type dialog box, select Port, and then click Next. To check what’s using Port 80: How do I open port 1433? To find specified open port, use find switch. To see what ports are in computer actually communicates with, use netstat -an | find /i “established” command. To list all listening ports, use netstat -an | find /i “listening” command. To display all open ports, open DOS command, type netstat and press Enter.