Solved

Allowing Remote Connections to SQL Server 2005 through Windows Firewall

Posted on 2015-01-19
6
192 Views
Last Modified: 2015-01-19
Hi all,

I am trying to allow sql remote connections to SQL Express 2005.

Now if I turn off the windows firewall I can connect successfully, However when I turn on the public profile settings it stops any connection being made.

I've added UDP port 1434 and TCP port 1433 to be allowed as both incomgin and outgoing ruls on the fire wall.

However when I try to connect through VS im getting the 40 error, saying the server doesnt exist?

Any ideas?
0
Comment
Question by:flynny
[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
  • 2
6 Comments
 
LVL 24

Expert Comment

by:VB ITS
ID: 40557427
Have you tried all the steps in this article? http://support.microsoft.com/kb/914277

Take note of the text in bold blue text as they collapse to reveal instructions when clicked.
0
 
LVL 50

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40557461
Do you have more SQL Server instances in that server?
And are you sure that instance is listening on 1433?
0
 

Author Comment

by:flynny
ID: 40557506
Thanks for the replies guys,

Vitor,

Yes there is an instance of SQL Server 2008 running on the server as well. How do I identify theport thats being used on the instance?

(As far as I was aware 1434 UDP redirected to the correct instance? am I wrong?)
0
Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40557508
The 1433 and 1434 are used by default for the first installed instance but you can confirm it in SQL Server Configuration Manager by checking in the TCP/IP properties of the instance.
0
 

Author Closing Comment

by:flynny
ID: 40557511
Many thanks Vitor, there insrance was running on a different port.

http://sqlandme.com/2013/05/01/sql-server-finding-tcp-port-number-sql-instance-is-listening-on/

helped me identify and solve.

Thanks for pointing me in the right direction.
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40557518
Just a warning. If the server is behind a firewall you won't want to set a dynamic port for that instance because after each reboot it may use a different port so it's better you chose a static port.
0

Featured Post

Defend Your Organization from The Greatest Threats

Looking to fill the gaps in your security? Bring together information from the network, endpoint and threat intelligence feeds to really see what's happening in your organization. Join the WatchGuardians in their adventures fighting cyber crime!

Question has a verified solution.

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

Suggested Solutions

Do you have a windows based Checkpoint SmartCenter for centralized Checkpoint management?  Have you ever backed up the firewall policy residing on the SmartCenter?  If you have then you know the hassles of connecting to the server, doing an upgrade_…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

739 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