Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Possible Duplicate:
port number of SQL Server

Can any one guide me on How can I change the default port of Microsoft SQL Server in my Windows VPS?

I am using Windows 2008 as my operating System and Microsoft SQL 2008 in my VPS

please help me asap.

share|improve this question

marked as duplicate by Brent Pabst, MikeyB, Ward, HopelessN00b, Tom O'Connor Sep 28 '12 at 15:08

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Before asking a question like this be sure to search the internet and ServerFault. This is a common question and is well documented throughout the internet. – Brent Pabst Sep 11 '12 at 16:26

If you want to change alternative port for MSSQL remote access, please perform following steps :

Go to Start -> Programs -> Microsoft SQL Server -> Configuration Tools -> SQL Server Configuration Manager.

Under SQL Server Network Configuration -> Protocols for SQLEXPRESS -> TCP/IP -> under protocol tab Enable it. -> Under IP Address Tab give Port Number in front of TCP Port field.

Click on Apply & OK.

Restart SQL Services.

Now you can login to your SQL Server using your given port.

Hope this helps you.

share|improve this answer

If you open Sql Server Confirguration Manager on the VPS (Start -> All Programs -> Microsoft SQL Server XXXX -> Configuration Tools -> SQL Server Configuration Manager).

Expand Native Configuration and select Client Protocols and then right click on TCP/IP on the right hand side.

Change the value in default port to whatever value you want it to be instead, apply and restart your SQL server.

share|improve this answer