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/...&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

[ Post a follow-up to this message ]

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/... />
laylang=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
>
>

[ Post a follow-up to this message ]

Just a thought:

You might be able to set the port number in the connection string for
OpenDatasource and/or sp_addlinkedserver - though I dunno for sure...

--Richard

"Joshua Beall" wrote:

> Hi All,
>
> I would like to be able to connect to a remote SQL Server and fire arbitra
ry
> queries, browse tables, and so forth.  Very much like MS's "SQL Server Web
> Data Administrator" (link:
> http://www.microsoft.com/downloads/...&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 tha
t
> SQL Server listens on.
>
> Thanks very much for any leads!
>
> Sincerely,
>   -Josh
>
>
>

[ Post a follow-up to this message ]

Joshua Beall wrote:
> Hi All,
>
> I would like to be able to connect to a remote SQL Server and fire arbitra
ry
> queries, browse tables, and so forth.  Very much like MS's "SQL Server Web
> Data Administrator" (link:
> http://www.microsoft.com/downloads/...&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 tha
t
> SQL Server listens on.
>
> Thanks very much for any leads!
>
> Sincerely,
>   -Josh
>
>

Hi Josh,
I dont know why this works for me, but it may work for you too.

My SQL7 listens on a different port, and I couldnt work out how to get
EM to connect. I then created a DSN on my local computer to the SQL
server and was able to change the default port, once this was tested and
working I was able to connect succesfully to my SQL7 server using EM.

Steve

[ Post a follow-up to this message ]

Hi,

if you want to connect to your sql with another port, you just have to add a
 comma in the server name

eg: 10.0.0.1,8888

to connect to the sql server with ip: 10.0.0.1
and port: 8888

Greets,
Pp

[ Post a follow-up to this message ]

Richard wrote:[vbcol=seagreen]
> Just a thought:
>
> You might be able to set the port number in the connection string for
> OpenDatasource and/or sp_addlinkedserver - though I dunno for sure...
>
> --Richard
>
> "Joshua Beall" wrote:
>
> 
Try CRT from VanDyke Software.  You can change the port with this app.
There is a free 30 day trial then the license is about $30 US.
http://www.vandyke.com/

[ Post a follow-up to this message ]