sql2008 port number changed

  • not able to connect after changing the port number.

  • charipg (3/28/2013)


    not able to connect after changing the port number.

    What with?

    Where from?

    What did you change from what to what?

    If you can try running this code on the SQL server that you have changed and post the results:

    declare @T table (logDate datetime , ProcessInfo sysname , [text] varchar(800));

    insert @T exec xp_readerrorlog;

    select LogDate , [TEXT]

    from @T

    where [TEXT] like 'Server is listening%'

    order by logDate;

  • - Is sqlbrowser running ?

    - are you specifying the port number in your connection data ? If yes: did you modify it ?

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • changed port number via sqlserver configuration.

    Restarted the sqlserver service.

    trying to connect sqlserver instace via SSMS.

    do i need to update the port number in any where else ?

  • Where can you connect from?

    locally on the server but not from a remote machhine then it wold indicate that either a fire wall (or a router with an access control list) is blocking you.

    If you cant log in locally on the server look at the event logs and the error log (C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log or some similar place) and see if you get an error.

    If its from only a certain type of application then have a look at the connection string.

    As an aside what did you change the port number from and to?

  • i try to connect locally.

  • changed port number from 1433 to 1440.

    No errors found in log.

  • if SQL browser is not running, are you explicitly adding the port to your connection? how are you connecting locally?

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • i am able to connect with instancename with port number but i need to connect without mention the port number.

  • sql browser is running fine..

  • you are very, very sparse on the details.

    is there more than one instance of SQL on the machine, and that is why you changed the port number?

    why did you change the port number anyway?

    SQL browser , if it is running, will direct connections if they try to connect to say, MyMachine\SQL2012 to the right port, and usually that is the dynamic port, becasue a different, default instance is listening on 1433. If that is the only instance, then change the port number back.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • charipg (3/29/2013)


    i am able to connect with instancename with port number but i need to connect without mention the port number.

    Then what is the name of the instance that you are trying to connect to??

  • Please restart browser service and then check.

    Note: Assuming here is no new security/firewal rules applied between client and server.

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply