|
|
|
|
Software for connecting to a remote SQL Server
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
Tue, 11 Jan 2005 18:45:52 GMT
"Joshua Beall"
|
Re: Software for connecting to a remote SQL Server
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" 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
>
>
Tue, 11 Jan 2005 14:13:39 -0500
"Aaron [SQL Server MVP]"
|
RE: Software for connecting to a remote SQL Server
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
Tue, 11 Jan 2005 14:43:05 -0800
"=?Utf-8?B?UmljaGFyZA==?="
|
Re: Software for connecting to a remote SQL Server
Joshua Beall wrote:
> 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
Wed, 12 Jan 2005 11:10:57 +0000
Dooza
|
|