Firewall Port 1433 not opening

sql-server sql-server-2008 database-connection firewall
Rohit picture Rohit · Nov 9, 2012 · Viewed 61k times · Source

I am using MS Server 2008 with MSSQL 2008-R2 as database server.

Each time for some work i have to login to server via Remote connection.I tried to configure the SQL Server remote connection on, followed the following steps....

1.Created Inbound and outbound rules for tcp port 1433.

2.In sqlserver configuration manager ,all is set for IP address and POrt no properties.

3.Set the SqlServer instance for remote connections.

But still its not working.

Also when i checked port 1433 for tcp on local computer it is shown closed.

thanks in advance.......

Answer

twoleggedhorse picture twoleggedhorse · Nov 9, 2012

In the SQL Server Configuration Manager->SQL Server Network Configuration->Protocols, check that named pipes and tcp/ip are enabled.

If that doesn't work then it may be your firewall blocking it, try this link: http://msdn.microsoft.com/en-us/library/cc646023.aspx

This may be useful too: http://support.microsoft.com/kb/287932

Related questions

A connection was successfully established with the server, but then an error occurred during the pre-login handshake

I am getting following error when i am trying to connect Production DB from Local Environment. I was able to connect Production DB before, but suddenly i am getting following error, any idea? A connection was successfully established with the …

Read More
A network-related or instance-specific error occurred while establishing a connection to SQL Server

I deployed my asp.net web application on somee.com, whenever I login into this site (ipc.somee.com) it gives me a network related error like: A network-related or instance-specific error occurred while establishing a connection to SQL Server. …

Read More
SQL Server: Native client vs. ODBC?

What is the difference between SQL Server Native Client connection and ODBC connection? What are the pros and cons of these two?

Read More