Upgraded to full SQL, now how to share over the Internet??

  • Thread starter Thread starter jpSETI
  • Start date Start date
J

jpSETI

On my 'server' I am running XP Pro, I have BCM with SP2 installed, and
I have upgraded to SQL Server 2000 SP4. I followed these instructions:
http://groups.google.com/group/micr...5d08589f39?q=sql&rnum=3&#doc_770cf9f3b60ee35a

Now on my laptop I run BCM. In the Startup Wizard, I can Create or
select a database. I go to Select a database, and here I have to enter
the Computer Name. I need to be able to enter the IP Address... right?

How do I connect to my BCM on the laptop to the SQL server on the other
machine, over the internet? Is it even possible?
 
Be aware that SQL packets over the internet will be in plain text,
unless you use a VPN or you configure your sql server and client to
encrypt using a certificate.

Beyond that consideration, the first question is: can you ping the ip
address of the server from your client?

You should be able to use the ip address instead of a server name to
connect the client to the server. BCM uses a specific tcp port for
connectiond to its sql server instance. The port number is 56183, and
so need to ensure that your BCM database is accessible via that port
and that your server firewall has opened that port.
 
Back
Top