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"
[quoted text, click to view] <jasper_smith9@hotmail.com> wrote:
>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
Hi,
Go to SQL Server program groups nad select "SQL Server Configuration
Manager"
Thanks
Hari
SQL Server MVP
[quoted text, click to view] <walanta> wrote in message
news:ndcse2lg3v26uv0s31sh8sob6rl84l9tq4@4ax.com...
>
> 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
>>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
In the Server Name box, type server_name,port_number
Linchi
[quoted text, click to view] "walanta" wrote:
>
> 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 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
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 [quoted text, click to view] <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!
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 [quoted text, click to view] <walanta> wrote in message
news:ndcse2lg3v26uv0s31sh8sob6rl84l9tq4@4ax.com...
>
> 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
>>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
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 ---
Don't see what you're looking for? Try a search.
