Solved

i am unable to connect from outside the network to SQL database

Posted on 2013-10-22
7
458 Views
Last Modified: 2013-10-23
i moved sql database from old machine to new windows server 2012 by attaching it then i created access to database using Windows authentication and SQL authentication

i checked access to database using Windows authentication and i log in without user and pass and its ok
for SQL authentication i am login with user sa and its also ok

now i am trying to connect from outside the network to this database using system information and i set the following:

changed in the router to assign SQL port 2433 to the new machine 192.168.1.137
changed the IP for this machine to 192.168.1.137
in the configuration file of the software that i am trying to connct from i put the user and the new password

what could be the reason that i am unable to connect? what actions can i take to find the reason

Thanks
Gvilbis
0
Comment
Question by:gvilbis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 38

Assisted Solution

by:Hypercat (Deb)
Hypercat (Deb) earned 125 total points
ID: 39592499
Did you set the SQL server to use port 2433?  That is not the default port, unless that's a typo  in your post and you're actually setting it to 1433.
0
 

Author Comment

by:gvilbis
ID: 39592523
i set it in the router but where i have to set it on the SQL server?
0
 
LVL 22

Assisted Solution

by:Steve Wales
Steve Wales earned 375 total points
ID: 39592548
Port 1433 is the default port for the SQL Server Default Instance.

If you want to change it from the default, or if you are using a named instance behind a firewall (named instances use dynamic ports by default - if you need to open a firewall port then you need to configure a dedicated port).  This is setup using SQL Server Configuration Manager.

This is described in the SQL Server Documentation here:
http://technet.microsoft.com/en-us/library/ms177440%28v=sql.100%29.aspx

While you're at it, also check to see if Windows Firewall is running on the server.  If it is, you'll also need to allow traffic on the port you want to use.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:gvilbis
ID: 39594514
i set IP 192.168.1.137 which is the ip of this machine and enable port 2433 and remove Zero from Server SQL configuration as explain above
but when i am trying to connect to IP 192.168.1.137,2433 with Windows authentication or SQL Autentication its not allowing to connect

please see print screen

please advice

Thanks
Gvilbis
Screenshot-2013-10-23-10.42.13.png
Screenshot-2013-10-23-10.43.36.png
0
 
LVL 22

Accepted Solution

by:
Steve Wales earned 375 total points
ID: 39594579
I am unfortunately not 100% up to speed on settings this up.

On a named instance I have that's using a non default port, we removed the 0 in Dynamic ports and installed the port we wanted for all of the local loopback (127.0.0.1) in IP2, the server IP address in IP1 and under IPAll as well.

Double check your settings and try that as well ?

Also, make sure to check the Windows Firewall on the server - if its on, make sure that port is open.
0
 

Author Comment

by:gvilbis
ID: 39594828
OK its working with port 2433 but inside the network, connecting from outside the network to the external ip of the network with port 2433 its not able to connect

i forward port 2433 to the machine 192.168.1.137 in the router but still can not connect
firewall is off now

what action i can take?

Thanks
Gvilbis
0
 
LVL 22

Assisted Solution

by:Steve Wales
Steve Wales earned 375 total points
ID: 39594855
Once you've reach past the talking to SQL Server (which you say is working internally) you're getting into Network specifics, which I'm afraid is way outside my level of expertise.

Your router or the server should have some logs showing the rejected connection attempts and maybe they can show you something there, but I'm afraid networking is not area of expertise.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A safe way to clean winsxs folder from your windows server 2008 R2 editions
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question