Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbthj
Posting Yak Master
143 Posts |
 Posted - 2009-01-13 : 13:29:37
|
| The basic question is this:Can I script a change to default tcp/ip port for listening:Background:At install - and certain other times - a clustered 2005 instancechooses - at random - a port (not 1433) to listen on. That recently causeda problem after a Windows security patch was installed.I can change it back to what it was in Configuration Manager.Not all DBAs in my shop know how to do that. I would rather run a script on startup of SQL Server which says, "which tcp port is this instance listening on? .... That's not the one I want, change it to this one."Is it possible to do something like that? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Listening Port Designation Change. Clustered