Database Discussion - Cannot connect to database

Print Page | Close Window

Cannot connect to database

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=28588
Printed Date: 28 March 2026 at 10:32pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Cannot connect to database

Posted By: markt
Subject: Cannot connect to database
Date Posted: 13 May 2010 at 7:08pm

Hi I'm having problems connecting to the sql server database using client tools (Management Studio, and Visual Web developer)

Research on the web suggested trying to isolate the problem as follows:

Ping mssql2.sqllive.co.uk - works and returns IP 84.45.57.66

Tracert mssql2.sqllive.co.uk - works after firewall turned off

Telnet mssql2.sqllive.co.uk - fails with "Could not open connection to host, on port 23 Connection Failed" Message

Adding a connection in VWD or Management Studio gives an error stating that the connection failed.

Clearly there must be a configuration problem somewhere in my setup (XP Pro) but I've exhausted all the areas I can find to diagnose the problem. Please could you advise areas I could try.

Thanks in advance

Mark

Replies:

Posted By: WebWiz-Bruce
Date Posted: 14 May 2010 at 11:09am

Make sure you have opened port 1433 on your Firewall so you can connect to the database server on the default port for SQL Server.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: markt
Date Posted: 14 May 2010 at 6:19pm

Iv'e turned all the firewalls off to test this router, windows and Avast!

Posted By: WebWiz-Bruce
Date Posted: 17 May 2010 at 9:16am

Check with your ISP that they do not block port 1433 used by SQL Server. Some ISP's block this port on home broadband packages.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Edwerd
Date Posted: 04 November 2010 at 11:10am

Did you tried to connect with your database using Sql server management studio, if it’s work, problem is in your VWD. Try to uninstall and reinstall it. Good luck.

Posted By: jonathan cole
Date Posted: 04 April 2011 at 11:27am

try once again with port 1433 and if it is not ok reinstall that.