how to change sql server port

[patchu]

The default SQL Server port is 1433, but we have that port firewalled off to the outside world. Is there a way to change this, say to port 5555 or something like that? We have all our applications talking to SQL Server on that port, and we would prefer not to leave 1433 open.

Thanks for your help.

--PC

[jclausius]

a quick related question, what is your configuration? or more specifically, where is sql server in relation to vault server?


anyway, the answer depends on your backend.

in sql server, the port is set within the netwok parameters within sql enterprise manager.

within msde, you need to modify the registry.

after changing the port/recylcing sql server, you may need to reconfigure the sql client network configuration or vault server's connect string to find the new port location.

[patchu]

I believe I was vague in my question.

The port is already set on the SQL Server to something other than 1433. My question is, how do I set the Vault Admin and the Vault Client to use that other port number?

Thanks for your help.

[jclausius]

Can you elaborate on the question a bit more? It is unclear what you would like to do.

Here is some more background info that may help:

- Vault Server is an ASP.Net Web service running under IIS.

- Vault client/admin communicate w/ the Vault Server through HTTP (default port 80 / 443 (ssl)). If you configure IIS for a different port, simply place machine:port in the login dialog within either application.

- Vault Server connects to SQL Server through the .Net SQLClient database classes. These classes support a variety of protocols - Named Pipes, TCP/IP, IPX/SPX, etc.

- SQL Server can be configured to listen for connections for different types of protocols.

- A database connection to SQL Server can be configured using SQL Server's Client Network Utility. For MSDE users, you can also configure this through ODBC by creating a dummy SQL Server Data Source, and using the Client Configuration from within the ODBC wizard.

- If you happen to know the SQL Client (on the Vault Server) is configured for TCP/IP, you can also place server:port within the connectstring element within Vault Server's web.config. However, I would strongly recommend using the SQL Server Client Network Utility for this type of change.