September 06, 2010     |
Network Toaster
SQL Security Forums
Note: SQLSecurity.com does not allow nor require registration due to privacy concerns for users. SQLSecurity.com is open and anonymous for all. Please report any abuse or profanity.
Reply To Message:
Posted By n/a on 5/2/2006 7:48:42 PM
Subject: RE: Listen on 2 ports at the same time
Message: 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;"
UserName: 
Subject:  Listen on 2 ports at the same time
Body:
  
Show Replies:


ActiveForums 3.6
Copyright 1999 by Chip Andrews   |  Privacy Statement  |  Terms Of Use