May 17, 2002 at 12:08 am
I am tring to connect the VB application to a remote database in another network. I know that the one way to do this is to remote access the network. How to set it up? Is there other way to connect?
May 17, 2002 at 4:48 am
As far as where it exists as long as you can reach the machine by way of TCP/IP and talk to the port SQL is on the it is just a matter of having an account for that SQL Server. What have you tried and what is happening. If it is a domain and you are trying to use a trusted connection and then you will either need an account you can log into on that domain first from your machine, or if you log into a domain now then a trust will need to be setup to allow your current account rights on that server.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 20, 2002 at 10:25 am
Antares686: Thanks for your assistance. However, the problem for my situation is that the remote network has only one access point to the internet, on which the SQL server is not installed. So, there is no way to connect to the SQL server directly by TCP/IP. I think that I have to set up the remote domain to accept the remote access through VPN and have an account in the remote network, then I need an account in SQL server. Is it right?
May 20, 2002 at 11:05 am
As long as the VPN connection server allows access to the SQL server then yes this should work properly. You don't really have to have domain access unless you will need trusted connections. You can use SQL logins instead. But you have to be able to get thru the connecion to the other network.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 20, 2002 at 4:58 pm
As you work on this remember connectivity is key - until you can ping the server, no point in worrying about the SQL part of it!
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply