how to query db on dedicated server from my lan ?

what is the best way to send data to and query SQL 2005 server express
edition db hosted on a dedicated server with ISP ?
i need to query it directly from an application on my LAN (asp site on same
machine as sql db also needs to query db)
i can obviously use port 1433 but what other option do i have ? i.e ssl
port, xml web service ?
Any information is helpful
ScottScott,
For security reasons, I would change the port from 1433 and use encryption.
If the server is dedicated to your use configure have multiple NICs in the
server (about least three). Alow one for the ISP to use, allow one or two
for your site to use but restrict the incoming allowed IP range to your
systems, another two if you have external customers that will be accessing
the Web application.
"scott" <aintnospamhere@.yahoo.com> wrote in message
news:Oqsm3aNeGHA.1204@.TK2MSFTNGP02.phx.gbl...
> what is the best way to send data to and query SQL 2005 server express
> edition db hosted on a dedicated server with ISP ?
> i need to query it directly from an application on my LAN (asp site on
> same machine as sql db also needs to query db)
> i can obviously use port 1433 but what other option do i have ? i.e ssl
> port, xml web service ?
> Any information is helpful
> Scott
>
>
>|||perfect thanks, i understand all of that apart from how to use encryption on
the port ?
is it just a case of using the encryption key in the connection string from
our app i.e
"data source=SERVER;initial catalog=sms" (with encryption)"
if so how do you tell SQL server to only accept encyted data / queries on
the port we decided to use ?
thanks for your help Danny
Scott.
(ps what are PIPES for then ?)|||For SQL 2005 it's recommended to use an SSL certificate, however you can get
some benefit by enabling Force encryption in the SQL Server Configuration
Manager.
"scott" <aintnospamhere@.yahoo.com> wrote in message
news:OTWBbCOeGHA.2188@.TK2MSFTNGP05.phx.gbl...
> perfect thanks, i understand all of that apart from how to use encryption
> on the port ?
> is it just a case of using the encryption key in the connection string
> from our app i.e
> "data source=SERVER;initial catalog=sms" (with encryption)"
> if so how do you tell SQL server to only accept encyted data / queries on
> the port we decided to use ?
> thanks for your help Danny
> Scott.
> (ps what are PIPES for then ?)
>