Question Locked

How to change MS SQL Server 2005 port number if it is a cluster Node?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi All.........!
Environment:
MS SQL Server 2005 SP2 Enterprise Edition
Windows server 2003 sp2
cluster configured.

Need to change one node MS SQL Server 2005 port number.
i know how to change port number for MS SQL Server 2005 if it is not in cluster.

Please help me to change MS SQL Server 2005 port number if it is a cluster Node.

2 replies

by scott_heath

Change the port number using thr SQL Configuration tool then stop the SQL Server services using the cluster administrator and then start it again. I have done this in the past and it has worked fine.

Regards,
Scott

http://scottisageek.spaces.live.com

This discussion is closed to new replies.