Home > IT Answers > AS/400 > connecting VB2005 Express with remote msSQL2005 Express server
Teqani
0 pts.
 connecting VB2005 Express with remote msSQL2005 Express server
Connect, Remote access servers, SQL Express, SQL Server 2005, VB 2005, Visual Basic
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

Software/Hardware used:
ASKED: November 14, 2007  8:07 AM
UPDATED: December 2, 2007  11:39 AM
RELATED QUESTIONS
Answer Wiki:
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
Last Wiki Answer Submitted:  December 2, 2007  11:39 am  by  ShankyBoy   15 pts.
All Answer Wiki Contributors:  ShankyBoy   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

Denny Cherry
 64,520 pts.