RE: How do I have my app connect to a remote SQL Server that has port

From: adoanywhere (Mikeadoanywhere_at_discussions.microsoft.com)
Date: 03/22/05 

Date: Tue, 22 Mar 2005 09:35:03 -0800

If your ISP allows DCOM servers to be installed then you could use
adoanywhere/rex. You have several options for connecting - including on port
80. Limited to SQL statements though (you can't do admin like you can in
Enterprise Manager GUI). It is free. Good luck with the ISP.

Mike
www.adoanywhere.com

"Alan Silver" wrote:

> Hello,
>
> I have a few applications that connect directly to a remote SQL Server,
> mainly (but not only) so that web site owners can update the databases
> that run their web sites.
>
> The people that maintain the web/SQL server have now said (quite
> sensibly) that they want to close port 1433 as it is a security risk. I
> would like to know how my client applications are supposed to interact
> with the SQL Server if they don't use port 1433. The ISP told me that
> this server is the only one they have that has the port open, but they
> wouldn't tell me how to do the data access - well, they would, but they
> want consultancy rates for it!!
>
> So, anyone any suggestions? The ISP's only suggestion was to have a
> private ASP on one of the web sites, that you send the connection
> details and SQL, and it returns a recordset as XML. The client
> applications could open the recordset from the URL. They did say that
> they would put Windows security on the page, so anyone trying to get at
> it would need a UID and password, and that the actual URL should be
> encoded in the client application so no-one would ever know it exists,
> but it still sounds like a major security hole to me. I'm sure there are
> better ways of doing this.
>
> I'm sure plenty of people have found a secure way around this, but my
> searches haven't turned up anything helpful.
>
> Anyone any suggestions? TIA.
>
> --
> Alan Silver
> (anything added below this line is nothing to do with me)
>

Relevant Pages

  • Re: SMTP Server for outgoing only behind a home router
    ... They cliam to ONLY block port 80 to keep me from ... you will get a 220 greeting line from the remote SMTP server: ... So AOL.COM methods stops legitimate roaming users from using ESMTP AUTH to ... So look to see of your ISP supports ESMTP AUTH for dynamic IP users and/or ...
    (microsoft.public.inetserver.iis.smtp_nntp)
  • Re: SQL2005: Cannot connect error 11001
    ... The famous Windows Firewall (turned on my Server from which I'm trying to ... Exception Details: System.Data.SqlClient.SqlException: Login failed for user ... Try starting the SQL Server ... if you changed the port ...
    (microsoft.public.sqlserver.connect)
  • Re: Exchange incoming email issue
    ... I have had the 'port blocking' ... couple in the NS area abou the fact that the hosts server will do DNS ... One or more of your mailservers is claiming to be a host other than ... and contacted the ISP that hosts their DNS ...
    (microsoft.public.windows.server.sbs)
  • Re: Failed connections to remote 2k SQL Server
    ... It could be a port issue - that would be my first guess. ... you need to open up UDP 1434 for SQL Server name ... TCP Ports Needed for Communication to SQL Server ... >server's network utility, and client network utility, and ensured that they ...
    (microsoft.public.sqlserver.setup)
  • Re: Connecting to an instance in a cluster
    ... Each virtual server has its own IP address so you can reuse port numbers between instances. ... Microsoft SQL Server MVP ... "Geoff N. Hiten" wrote: ...
    (microsoft.public.sqlserver.clustering)