| Author |
Messages |
|
jimma (guest)
 |
| 05/01/2006 9:07 AM |
 Quote
 Reply
 Alert
|
I want to eliminate port 1433 and change to another port. However, I have thousands of users who are linked to the default. is there a way to have one instance of SS listen on two ports 1433 and 14333 (for example) for a period of time so that I can get the users moved over? I have seen some pages on this but not how to do it.
|
|
|
|
|
Chip Andrews (guest)
|
| 05/02/2006 7:48 PM |
Quote
Reply
Alert
|
What version of SQL Server are you using? If it's 2000 or 2005 then you shouldn't have to worry about configuring the client so long as the UDP 1434 listener is operational.
If you need to reconfigure the client en-masse, you can use group policy or other tools to make the necessary registry changes. In addition, you can add a directive in your connection strings to use the new port:
"Provider=sqloledb;Data Source=190.190.200.100,14333;Network Library=DBMSSOCN;Initial Catalog=pubs;Integrated Security=SSPI;" |
|
|
|
|
|