SQL SERVER PORT CHANGE

  • CAN ANYONE TELL ME HOW TO CHANGE SQL SERVER PORT WITH QUERY ANALYZER.

  • You mean the port SQL Server listens on? (1433 by default) I don't know if you can do it in script...SQL Server Configuration Manager is how I've always changed it. (I can only think of one time I've ever changed it actually...I'm curious why you are changing?)

    The Redneck DBA

  • We are changing it bcz of some security reasons in our environment.

    Through Enterprise Manager we have already done that number of time.

    But i am curious to know if we can make such amendments through QA.

  • You can change this using xp_regwrite, search this site for its use, essentially it writes to the registry, just find the key and you can change it. But wouldn't the config tools be easier, or are you doing N number of boxes?

    Andrew

  • If you want to know how SQL Server is changing the port when you use EM, Configuration Manager, etc... Start a Profiler trace then make the change.

  • This isn't something you change with T-SQL, it would be done in the Configuration Manager in 2005 or the Server network Utility in 2000.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply