How to access a database on a remote SQL Server

Tags:
Remote access
SQL Server
Visual Basic
I want to access a database on a remote SQL Server in my organization. I need to access it with my Visual Basic (VB) application. I can do it on the local machine but not on my remote machine. How do I resolve the issue?
ASKED: June 9, 2008  3:13 PM
UPDATED: June 9, 2008  10:42 PM

Answer Wiki

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

All you should need to do is change the server name in the connection string to point from your local SQL Server database to the remote SQL Server database.

You may also need to change the username and password which you are using to connect with to the username and password which the DBA setup for you.

If you could post the exact error you are getting that would make troubleshooting the error much easier.

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

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