Home > IT Answers > SQL Server > connecting VB2005 Express with remote msSQL20...
Help

Question

  Asked: Nov 14 2007   8:07 AM GMT
  Asked by: Teqani

connecting VB2005 Express with remote msSQL2005 Express server


SQL Express, Visual Basic, Remote access servers, Connect, SQL Server 2005, VB 2005

I'm trying to do the above with no sucess although I can connect msQuery, create msAccess projects, and ODBC with the remote server. The remote server is already configured to accept remote connections.!!!

the message is that the remote server do not allow remote connections!!!

any ideas

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
Last Answered: Dec 2 2007  11:39 AM GMT  by Mrdenny


Latest Contributors: ShankyBoy


Conflicting firewall configuration can cause issues. I am not sure what OS you are on but try turning off the Firewall to be sure.

If that works, MS SQL Server default to TCP Port 1433. Try keeping that port open for incoming connections.

I have encountered issues in the past where there were multiple firewalls (Windows firewall, Norton Firewall) conflict and finally not allow servers to receive incoming connections.

Hope that helps.

-- Shashank
http://codingunknowingly.blogspot.com

Also make sure that you have restarted the SQL Server since you told it that it can accept remote connections.

Denny
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server, Development and Microsoft Windows.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   Dec 2 2007  11:38AM GMT

This URL <a href="http://www.tek-tips.com/faqs.cfm?fid=5481" rel="nofollow">http://www.tek-tips.com/faqs.cfm?fid=5481</a> has an FAQ which I wrote a while ago to help throuble shooting of connection issues when connecting to SQL Server.