I have configured my system to connect to the SQL Server 2008, I am running under windows server 2008, and I made the following:-
1.Enable TCP/IPon my SQL Server.
2.Activate and enable the 192.168.1.20 for the SQL Server on port 1433.
3.Add two inbounds rules & two outbound rules for the 1433 post on the firewall and the sqlserver.exe.
But when I tried to connect the database I got the following error:-
The TCP/IP connection to the host 192.168.1.20, port 1433 has failed. Error: "connect timed out. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections
at the port, and that no firewall is blocking TCP connections to the port.".
When I typed the following:
telnet 192.168.1.20 1433 it gave me
Connecting To 192.168.1.20...Could not open connection to the host, on port 1433 : Connect failed
Connecting To 192.168.1.20...Could not open connection to the host, on port 1433 : Connect failed
Hi,
From the error message you post, please check that you have the correct hostname / IP address and port and try again. It seems that your IP address or port is not correct.
johnjohn1231...
Participant
929 Points
885 Posts
Error connecting to sql server 2008 using tcp/ip
Dec 16, 2012 12:20 PM|LINK
I have configured my system to connect to the SQL Server 2008, I am running under windows server 2008, and I made the following:-
1.Enable TCP/IPon my SQL Server.
2.Activate and enable the 192.168.1.20 for the SQL Server on port 1433.
3.Add two inbounds rules & two outbound rules for the 1433 post on the firewall and the sqlserver.exe.
But when I tried to connect the database I got the following error:-
The TCP/IP connection to the host 192.168.1.20, port 1433 has failed. Error: "connect timed out. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
When I typed the following:
telnet 192.168.1.20 1433 it gave me
Connecting To 192.168.1.20...Could not open connection to the host, on port 1433 : Connect failed
So what might be the problem ?
Mudasir.Khan
All-Star
15346 Points
3142 Posts
Re: Error connecting to sql server 2008 using tcp/ip
Dec 16, 2012 02:04 PM|LINK
which logging method are you using ? Is the Mixed Mode authentication enabled
radamanthys
Member
228 Points
74 Posts
Re: Error connecting to sql server 2008 using tcp/ip
Dec 17, 2012 09:59 PM|LINK
Can you log on locally on server?
Are u using Windows Auth or Mixed Security?
Chen Yu - MS...
All-Star
21826 Points
2513 Posts
Microsoft
Re: Error connecting to sql server 2008 using tcp/ip
Dec 18, 2012 08:01 AM|LINK
Hi,
From the error message you post, please check that you have the correct hostname / IP address and port and try again. It seems that your IP address or port is not correct.
You could reference on this thread to connect your server by tcp/ip :http://stackoverflow.com/questions/2388042/connect-to-sql-server-2008-with-tcp-ip
Thanks.
Feedback to us
Develop and promote your apps in Windows Store
Mandeep Joon
Participant
1570 Points
387 Posts
Re: Error connecting to sql server 2008 using tcp/ip
Dec 18, 2012 08:48 AM|LINK
Hi,
It clearly means that your server is not listning on port 1433, Please check again firewall rules. Also try to Telnet some other ports.
Also Enable TCP/IP Service and restart all your sql services then try again, Ithink it will work fine then.
Mark it is answer if it is useful.
Mandeep Joon
Blog:- Hightechnology.