470,644 Members | 1,204 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,644 developers. It's quick & easy.

Changing the default port number and still connecting

RWC
Hello,

I have SQL Server 2000 Enterprise Edition, and I'd like to change the
default port to something else (we'll use 2033 for this example). I've
tried to connect from another computer on the same subnet using
"ServerName:2033" as the server, but it doesn't connect. It will connect if
I change the Server to use the default port and change the server to connect
to on the client to "ServerName", but either I"m not referencing the new
port number properly or ????

Any help you could provide would be great.

Thanks In Advance!
Rick
Jul 23 '05 #1
1 1832
Hi,

Stop all applications and Third party software services in the server.
After the applications and services are stopped, change the port and start
SQL Server
service. This should enable SQL Server to take control of new port. Open the
sql server error log and see if the new port is used.
See additional details from old post.

http://groups.google.co.in/groups?q=...ft.com&rnum=10

Thanks
Hari
SQL Server MVP

"RWC" <rc******************@hemmingway.com> wrote in message
news:kUAde.1198452$8l.948157@pd7tw1no...
Hello,

I have SQL Server 2000 Enterprise Edition, and I'd like to change the
default port to something else (we'll use 2033 for this example). I've
tried to connect from another computer on the same subnet using
"ServerName:2033" as the server, but it doesn't connect. It will connect if I change the Server to use the default port and change the server to connect to on the client to "ServerName", but either I"m not referencing the new
port number properly or ????

Any help you could provide would be great.

Thanks In Advance!
Rick

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Seal | last post: by
1 post views Thread by Rolln_Thndr | last post: by
2 posts views Thread by ASP Developer | last post: by
6 posts views Thread by swartzbill2000 | last post: by
4 posts views Thread by Sir C4 | last post: by
10 posts views Thread by 7stud | last post: by
reply views Thread by warner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.