Re: Software for connecting to a remote SQL Server

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 01/11/05 

Date: Tue, 11 Jan 2005 14:13:39 -0500

Most tools should be able to specify the port; I'd be very surprised if Web
Data Administrator did not have a configuration option somewhere. Usually
you can specify the name/ip of the server followed by ,port_number if there
isn't an explicit place to enter the value.

Anyway, there are plenty of other tools, most of which will have to offer
this ability, if you can't get the above to work.
http://www.aspfaq.com/2442 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"Joshua Beall" <jbeall@donotspam.remove.me.heraldic.us> wrote in message
news:A9VEd.1903$SS6.431@trnddc07...
> Hi All,
>
> I would like to be able to connect to a remote SQL Server and fire
arbitrary
> queries, browse tables, and so forth.  Very much like MS's "SQL Server Web
> Data Administrator" (link:
>
http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en).
> However, the remote server is configured to have SQL Server listening on a
> nonstandard port (10030), and SWDA does not let you choose the port to
> connect to.
>
> Any leads?  I would rather not have to buy a commercial piece of software.
> SWDA sounds like exactly what I need, if I could only choose the port to
> connect on.  I tried indicating the port using fqdn:10030 for the
hostname,
> but it didn't work.
>
> This port configuration is beyond my control; I cannot change the port
that
> SQL Server listens on.
>
> Thanks very much for any leads!
>
> Sincerely,
>   -Josh
>
>

Relevant Pages

  • Re: ADP problems after SQL 2005 Upgrade
    ... Use the SQL Server Configuration Manager to create aliases; ... each port can be associated only with a single instance. ... Sylvain Lafontaine, ing. ...
    (microsoft.public.access.adp.sqlserver)
  • [NT] Microsoft SQL Server 2000 Unauthenticated System Compromise
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Microsoft's database server SQL Server 2000 exhibits two buffer-overrun ... clients connecting to TCP port 1433 or both. ... This message is a single byte packet, ...
    (Securiteam)
  • Re: Do SqlServer 2000 & SqlServer 2005 co-exist
    ... Either SQL Server 2000 or SQL Server 2005. ... So you have to move one of them to another port. ... You could allow an program exception in your firewall instead of a port number exception. ... I understand that you can connect to SQL 2000 named instance on the local ...
    (microsoft.public.sqlserver.setup)
  • Re: IIS, SQL 2000 & XPs Firewall
    ... Only one instance of SQL Server can use TCP port 1434. ... You may find it easier to use SQL Server Configuration Manager ... 2008 will be a named instance ... you will have to open those as exceptions in the firewall. ...
    (microsoft.public.sqlserver.connect)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... and port 1433 will not be open. ... If someone can crash SQL Server by connecting to port 1433, ... You don't need multiple security experts. ...
    (microsoft.public.sqlserver.security)