Different Port

Is there a way to change the default instance of SQL 2005 to use another
port, say 9000? When I try to change these properties under Server
Configuration (Protocols, TCPIP) none of it will then connect outside of
that machine.
Thanks for any help.
KellyWhat di you mean by "none of it will then connect outside of that
machine." Do you mean the clients. If so,you have to specify the Port
on the client side stating Servername\instanceName,Portnumber or you
create an alias on the client machine to connect with.
HTH, jens Suessmeyer.|||resolved had the conneciton string wrong.
Kelly
"scorpion53061" <scorpion_53061@.nospamhereyahoo.com> wrote in message
news:O%23BCgqKLGHA.2828@.TK2MSFTNGP12.phx.gbl...
> Is there a way to change the default instance of SQL 2005 to use another
> port, say 9000? When I try to change these properties under Server
> Configuration (Protocols, TCPIP) none of it will then connect outside of
> that machine.
> Thanks for any help.
> Kelly
>
>