Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
    
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
add comment

marked as duplicate by Brent Pabst, MikeyB, Ward, HopelessN00b Genius of network, 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.

2 Answers

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
add comment

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
add comment