Results 1 to 2 of 2

Thread: How to change the port of MSSQL Server 2008?

  1. #1
    pedrojaviar is offline Newbie
    Join Date
    Dec 2014
    Posts
    2

    Default How to change the port of MSSQL Server 2008?

    How to change the port of MSSQL Server 2008?

    Following steps will be useful to you at a time when you wish to change the default port for the MS SQL

    Server :

    Step1: Go to Start → All Programs → Microsoft SQL Server 2008 R2 → Configuration Tools → SQL

    Server Configuration Manager.
    Step2: Choose SQL Server Network Configuration.
    Step3: Choose Protocols for SQLEXPRESS.
    Step4: Choose properties of TCP/IP Protocol.
    Step5: Now, move to IP Addresses tab.
    Step6: Scroll Down and Modify the Port number from IP ALL Section.
    Step7: Click on Apply and OK button.
    Step8: Once you click on Apply button, one dialog box will pop up and ask to restart the service of

    SQLEXPRESS, click on "Ok" button.
    Step9: Now restart SQL Server Services. (For this, click on SQL Server Services from left pane and

    right click on SQL Server(SQLEXPRESS) and select restart option.)
    Step10: Now open SQL Server Management Studio (For this select Start → All Programs → Microsoft

    SQL Server 2008 R2 and click on SQL Server Management Studio.).
    Step11: Now, you will see a dialog box whose title will be "Connect to Server".
    Step12: In that dialog box, you can write IP-Address,Port (i.e. 127.0.0.0,1989) as Server Name to login.
    Step13: Note that, whenever you change the port do not forgot to allow in Firewall Configuration.

    Thanks,
    Paul J.

  2. #2
    nomanali is offline Banned
    Join Date
    Aug 2015
    Posts
    40

    Default

    Thats what i was searching for. Thanks for the help mate

Similar Threads

  1. Replies: 1
    Last Post: 10-17-2012, 02:47 PM
  2. Replies: 0
    Last Post: 05-05-2010, 12:27 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16