connecting VB2005 Express with remote msSQL2005 Express server

pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    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.
    66,365 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following