Re: Adp to SQL 2000 Internet connection basics
- From: "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
- Date: Tue, 29 Apr 2008 11:57:07 -0400
A lot of questions here that would be probably best answered in a newsgroup
dedicated to SQL-Server such as microsoft.public.sqlserver.client or
mps.connect or mps.security or mps.setup or mps.server.
Second, the traffic is not encrypted by default. To encrypt it, you must
install a certificate on the server and use SSL. It's also an all or
nothing solution: you cannot a mixed environment with some connection
encrypted and others not. See:
http://support.microsoft.com/kb/316898/en-us
For your post mapping, you can create an Alias using the SQL-Server Client
Network Utility or use a comma to specify the port number as in
a.b.c.d,1433.
For using two different ports (one external, one internal) using port
mapping on the firewall, I don't know. You will have to make your own
tests. Usually, this is done by using and configuring a proxy (see
http://support.microsoft.com/kb/216415 ) but if you can configure your
server, then you don't have to do this as you can easily configure the
server to listen to another port than 1433 by editing the Server Network
Utility, see http://msdn2.microsoft.com/en-us/library/aa197974(SQL.80).aspx
for SQL-Server 2000.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Marcus" <marcus@xxxxxxxxxxxxxxxxxx> wrote in message
news:KPidnVjmpaEMs4rVnZ2dnUVZ_gWdnZ2d@xxxxxxxxxxxxxxxx
Hi there I'd wish to test my adp application (Access 2003, working
allready on LAN) to access the MS SQL Server 2000 throught the internet.
Questions:
1) If, for security reasons, I'd like to expose a different port on the
internet side I would let the firewall do the port mapping somothing like
route all traffic from port 5555 to internal IP a.b.c.d:1433.
2) What syntax should I use in my app? (Should I set the "globalServer"
variable to "w.x.y.z:5555" where w.x.y.z is the internet ip address of the
router?
3) Is the traffic encrypted?
Thanks
This is the current code:
**********************************************************
Public Sub enableDBConnection(dbName As String)
globalDatabase = dbName
strConnect = "PROVIDER=SQLOLEDB.1;" & _
"INITIAL CATALOG=" & globalDatabase & ";" & _
"DATA SOURCE=" & globalServer & ";Persist Security Info=True"
Select Case globalServer
Case "MyMSWindowsServerName"
strConnect = strConnect & ";USER ID=myUser;PASSWORD=myPassword;"
Case Else
strConnect = strConnect & ";INTEGRATED SECURITY=SSPI"
End Select
CurrentProject.OpenConnection (strConnect)
If globalCn.State = adStateOpen Then
globalCn.Close
End If
globalCn.CursorLocation = adUseClient
globalCn.Open strConnect
globalStrConnect = strConnect
End Sub
**********************************************************
.
- Follow-Ups:
- Re: Adp to SQL 2000 Internet connection basics
- From: Marcus
- Re: Adp to SQL 2000 Internet connection basics
- From: Marcus
- Re: Adp to SQL 2000 Internet connection basics
- References:
- Adp to SQL 2000 Internet connection basics
- From: Marcus
- Adp to SQL 2000 Internet connection basics
- Prev by Date: Adp to SQL 2000 Internet connection basics
- Next by Date: Re: Adp to SQL 2000 Internet connection basics
- Previous by thread: Adp to SQL 2000 Internet connection basics
- Next by thread: Re: Adp to SQL 2000 Internet connection basics
- Index(es):
Relevant Pages
|
