sql server data warehouse: Software for connecting to a remote SQL Server -- sql server data warehouse

RE: Software for connecting to a remote SQL Server

Richard
1/11/2005 2:43:05 PM

sql server data warehouse:

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

[quoted text, click to view]

Software for connecting to a remote SQL Server

Joshua Beall
1/11/2005 6:45:52 PM

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

Re: Software for connecting to a remote SQL Server

MacKenzieMouse
1/25/2005 3:47:48 PM

[quoted text, click to view]
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.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server data warehouse group.