How to access a database on a remote SQL Server
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
June 9, 2008 3:13 PM
UPDATED:
June 9, 2008 10:42 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.