Databases Reference
In-Depth Information
Figure 9-12
Figure 9-13 shows the output from running the above commands.
Figure 9-13
To verify that the default port has been changed, you can run this command:
Get-WmiObject -namespace root\Microsoft\SqlServer\ComputerManagement10 -class
ClientNetworkProtocolProperty -filter "PropertyName
=
'Default Port'"
Figure 9-14 shows that the default TCP/IP port has been changed to 7001. The complete script is in
ChangeTCPIPDefaultPort.ps1
.
Managing SQL Server Client Aliases
SQL Server client aliases make user connections easier, faster, and more convenient. Each alias saves all
the information you need to connect to a SQL Server, such as the server name and the client protocol
used to connect to a server. By using an alias, you do not need to enter the information each time you
connect. You can also use an easy-to-remember nickname for your application that is different from the
actual server name.
Search WWH ::
Custom Search