Re: Connect to DB using another TCP port from SQL management Studio
- From: "Jasper Smith" <jasper_smith9@xxxxxxxxxxx>
- Date: Fri, 25 Aug 2006 20:26:10 +0100
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@xxxxxxxxxx
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@xxxxxxxxxxx> 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
.
- References:
- Re: Connect to DB using another TCP port from SQL management Studio
- From: Jasper Smith
- Re: Connect to DB using another TCP port from SQL management Studio
- Prev by Date: Re: Max Connections
- Next by Date: Re: Max Connections
- Previous by thread: Re: Connect to DB using another TCP port from SQL management Studio
- Index(es):
Relevant Pages
|
