 |
|
Windows Web Hosting 30 Day Free TrialWindows Hosting 30 Day Free Trial, with no obligation, on all our Windows Web and Reseller Hosting Packages.For more information see our Windows Hosting 30 Day Free Trial page. |
Cannot connect to database |
Post Reply 
|
| Author | |
markt 
Newbie 
Joined: 13 May 2010 Status: Offline Points: 3 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Cannot connect to databasePosted: 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
|
|
 |
|
|
WebWiz-Bruce
Admin Group 
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Points: 8028 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
markt
Newbie
Joined: 13 May 2010 Status: Offline Points: 3 |
Post Options
Thanks(0)
Quote Reply
Posted: 14 May 2010 at 6:19pm |
|
Iv'e turned all the firewalls off to test this router, windows and Avast!
|
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Points: 8028 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
Edwerd
Newbie
Joined: 04 November 2010 Location: UK Status: Offline Points: 2 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
jonathan cole
Newbie
Joined: 18 February 2011 Status: Offline Points: 8 |
Post Options
Thanks(0)
Quote Reply
Posted: 04 April 2011 at 11:27am |
|
try once again with port 1433 and if it is not ok reinstall that.
|
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
