Connect to DB using another TCP port from SQL management Studio

Hi,
The DBA set database on server to a high TCP port number.
How can I connect to it from Microsoft SQL2005 management Studio.
I can't find the option to set TCP port number in there.
Thanks!You can use tcp:servername,port in the connection dialog although if the SQL
Browser is running you should still be able to use the instance name. As an
alternative you can set up a client alias using SQL Server Configuration
Manager>SQL Native Client Configuration>Aliases
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
<walanta> wrote in message
news:loure2pjt4o6rvq7t5r3rvh4mln76i3pan@.
4ax.com...
> Hi,
> The DBA set database on server to a high TCP port number.
> How can I connect to it from Microsoft SQL2005 management Studio.
> I can't find the option to set TCP port number in there.
> Thanks!|||Where is "connection dialog" ?
I'm using SQL server management studio-> object explore-> connect->
database engine -> ...
I see "servername:", "authentication:", "connect to database:",
"network protocol"...
No place I can put "tcp:192.168.1.1,8800" or somthing like that.
On Thu, 24 Aug 2006 22:08:36 +0100, "Jasper Smith"
<jasper_smith9@.hotmail.com> wrote:

>You can use tcp:servername,port in the connection dialog although if the SQ
L
>Browser is running you should still be able to use the instance name. As an
>alternative you can set up a client alias using SQL Server Configuration
>Manager>SQL Native Client Configuration>Aliases|||Hi,
Go to SQL Server program groups nad select "SQL Server Configuration
Manager"
Thanks
Hari
SQL Server MVP
<walanta> wrote in message
news:ndcse2lg3v26uv0s31sh8sob6rl84l9tq4@.
4ax.com...[vbcol=seagreen]
> Where is "connection dialog" ?
> I'm using SQL server management studio-> object explore-> connect->
> database engine -> ...
> I see "servername:", "authentication:", "connect to database:",
> "network protocol"...
> No place I can put "tcp:192.168.1.1,8800" or somthing like that.
>
>
> On Thu, 24 Aug 2006 22:08:36 +0100, "Jasper Smith"
> <jasper_smith9@.hotmail.com> wrote:
>|||It's in the Server name box i.e. if your server was called FOO and on port
55551 you would use
tcp:FOO,55551
in the Server name box
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
<walanta> wrote in message
news:ndcse2lg3v26uv0s31sh8sob6rl84l9tq4@.
4ax.com...[vbcol=seagreen]
> Where is "connection dialog" ?
> I'm using SQL server management studio-> object explore-> connect->
> database engine -> ...
> I see "servername:", "authentication:", "connect to database:",
> "network protocol"...
> No place I can put "tcp:192.168.1.1,8800" or somthing like that.
>
>
> On Thu, 24 Aug 2006 22:08:36 +0100, "Jasper Smith"
> <jasper_smith9@.hotmail.com> wrote:
>|||If SQL Browser is started you should be redirected automatically. For
security reasons (and the fact that this is not enabled in the setup
process by default) the SQL Browser service can not be running. The
port can be specified manually by putting it after the instancename you
want to connect to:
For default instances: Servername\InstanceName,Portnumber
For named instances: Servername,Portnumber
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--

Connect SQL Server to Oracle 9i

I need to connect SQL Server 2000 to an Oracle database on another network for which we have permissions. The Oracle tech (they have no dba...a vendor set all of this up) created a schema for us and now I need to access it. They have provided a username and a password.

for example:

uname = test
pwd = testpwd
oracle box = ias4_192.x.x.x

In SQL Server how do I make this happen? Do I need to set up an ODBC connection, sp_addlinkedserver, etc. etc. I posted to another forum and was told something about a tnsnames.ora file and possibly a listener.ora file?!? Both the Oracle guy and myself are complete idiots when it comes to this kinda stuff. We each vaguely understand our own system but this heterogenous stuff is killing us! Please help. We need a step-by-step outline to make this happen. Any help would be GREATLY appreciated. Thanks!In order to connect the SQL Server via sp_addlinkedserver, you need to establish connectivity to the Oracle server.

You need to install the Oracle drivers onto the SQL Server (do a minimum install, just the drivers and the network connectivity tools).

Then you need to open your Oracle Network assistant and configure the connection settings (hostname or ip address and port number). You will need to give these settings a name (called a Net Service Name, I think).

Once these steps are complete, then you can use sp_addlinkedserver to specify the correct settings for SQL Server to "see" the Oracle server. You can also add it through the graphical utility in SQL's Enterprise Manager (under Security/Linked Servers). This latter method may be a bit easier for novices.

Please note, these are the steps that I have used for both Oracle 7.x and Oracle 8.x. They may be slightly different for 9i.

HTH,

hmscott