Client Net Library Changes

I have been asked to consider changing the Net Library TCP/IP port for SQL
Server from the default 1433 to a different one.
The problem is the 1800 user stations.
Is there a scriptable way to change the port on the clients without having
to visit each one to do it manually?When you create an alias o the client (start->run->cliconfg.exe->alias tab)
- a registry key value with the alias properties will be created under:
HKLM\SW\Microsoft\MSSQLServer\Client\Con
nectTo . So you can write a script
to add this registry key value. If this a named instance then the clients
should be able to "dynamically" determine the port number and no registry
key modification should be necessary.
See the MSDN article : How To Use the Windows Script Host to Read, Write,
and Delete Registry Keys
for more details on how to write to the registry through script.
reference:
Books online topics:
- Client Network Utility
- Managing Clients
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx