I know how to change the port number via SQL Server Configuration Manager, but is there any way to do so via the command-line or sqlcmd? Thanks.

link|improve this question

40% accept rate
feedback

1 Answer

up vote 2 down vote accepted

You can't change the port via sqlcmd and I've never found a command line option. You can, however, do it via WMI. Check out this blog entry to get you started if you're interested in going that route.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.