Need a live SQL Server connection accross the Internet

Hi,

I need to debug my program using a customer's database, live, but don't want to put my source code or Visual Studio on their computer to debug it.  Can I do this over the Internet?

Thanks,
Bob
ba272Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

vinhnlCommented:
Yes if your customer machine has a IP (on internet) and you can connect to internet.
ba272Author Commented:
Well, they have a T1 line on order, but I was hoping to understand this connection better so that when they got it I could use it directly.  I assume based on your answer that the answer is "yes". Is that an option in SQL Server?

Thanks,
Bob
vinhnlCommented:
Hi Ba,

If they have a IP address on internet, you can connect to them same to you work on LAN (but your customer has to open port for SQL Server. I know that in system 2000 or NT, you cann't connect to a service on a machine if this machine doesn't open the port. Search on google for imformation !)

Good luck,
VINHNL
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

devsolnsCommented:
yes it is and easy, you'll need to setup tcpip in sql server and then use this connection string.

"Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"

by default it will use 1433 as the port.

keep in mind you will be passing your data around the internet in clear text.  its not advised for anything remotely important.  you may want to use IPSec to connect your two endpoints.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ba272Author Commented:
Thanks.  How do I set up tcpip in SQL Server? I'd also like to use Excel to set up a database connection.

devsolnsCommented:
It may be setup already to first follow instructions of this document and tell me how it goes.

http://www.sqljunkies.com/How%20To/2E1101E0-D5C1-4DBD-A398-FE485DFA439B.scuk
ba272Author Commented:
Thanks.  Looks complicated, but I want to try it.  But I do not want to compromise my customer's network.

The customer has a client-server network with 7 client PCs and a server.  I have my own laptop hooked into their network and accessing their SQL Server database sucessfully.  I remotely control my laptop via GoToMyPC, on which I run my program and Excel queries against the SQL Server database located on their server.  Can I establish the remote network you've described between my remote PC and the laptop?  I do have SQL Server installed on the laptop.  I think that could eliminate the chance that I could wreck their network.

(I've already caused a total system shutdown as I was doing my "on the job training" with SQL Server, and do not relish causing any more damage.)

Thanks,
Bob
devsolnsCommented:
See if the company has the capability for you to VPN in.  That will give us our next best step.
ba272Author Commented:
I have a new idea.  We're looking for a solution which will be completely transparent to the customer, and not put them at any risk whatsoever.  So just to review:

I have my Toshiba laptop running at the customer's location, connected to their server, which is providing me acess to their SQL Server database from the laptop.  The laptop is running VZAccess, which is a Verizon broadband wireless card, which allows me to access the machine remotely.  So I can run an Excel query on the database, but I must load Excel on the Toshiba, which blocks access to the machine's desktop for people who are standing in front of the machine,. which is a problem. We are currently looking into using a VPN option which VZAccess has.

Could I somehow mirror the database onto the Toshiba, then VPN into my laptop to access it?  If SQL Server provides such a service, and if it would also permit me to concurrently access the database remotely, then isn't this a workable solution?  

Thanks,
Bob
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.