Re: Changing Default SQL ports on SQL 2000 Server
- From: JPD <nospam@xxxxxxxxxxxxxxxx>
- Date: Wed, 25 Jul 2007 14:48:28 +0100
Hi,
Just change the port via the SQL Server Network Utility. On the client open the Client Network Utility and create a TCP/IP based alias that dynamically determines the port. The client will then use port 1434 to determine which port it needs to use. Make sure that your firewall has both port 1434 and the port the SQL Server instance is listening on open.
Jonathan
CP wrote:
Hi Group,.
As part of best practices we would like to change the default port number that SQL Server 2000 listens on.
Once this has been done, can the application client dynamically determine the new port number using the SQL Server Reporting Service listening on udp 1434?
Please note that Named Pipes are being used to establish the connections and that there is a firewall between the SQL Server and the applications clients.
Regards
CM
- Prev by Date: Re: Preventing windows users accessing a database
- Next by Date: Re: Migrating the WSUS database from a Windows Internal Database instance to a SQL Server 2005 instance on a remote server
- Previous by thread: Re: VB.NET and SQL Security
- Next by thread: Re: Changing Default SQL ports on SQL 2000 Server
- Index(es):
Relevant Pages
|
