Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

sql2008 port number changed Expand / Collapse
Author
Message
Posted Thursday, March 28, 2013 3:46 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 5:21 AM
Points: 412, Visits: 1,020
not able to connect after changing the port number.
Post #1436342
Posted Thursday, March 28, 2013 6:01 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 28, 2014 4:19 PM
Points: 51, Visits: 293
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;


Post #1436417
Posted Thursday, March 28, 2013 8:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, August 28, 2014 12:47 AM
Points: 7,005, Visits: 8,451
- Is sqlbrowser running ?

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



Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

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


- 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
Post #1436513
Posted Friday, March 29, 2013 4:24 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 5:21 AM
Points: 412, Visits: 1,020
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 ?
Post #1436862
Posted Friday, March 29, 2013 4:59 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 28, 2014 4:19 PM
Points: 51, Visits: 293
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?
Post #1436870
Posted Friday, March 29, 2013 6:13 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 5:21 AM
Points: 412, Visits: 1,020
i try to connect locally.
Post #1436887
Posted Friday, March 29, 2013 6:43 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 5:21 AM
Points: 412, Visits: 1,020
changed port number from 1433 to 1440.
No errors found in log.
Post #1436895
Posted Friday, March 29, 2013 6:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:47 PM
Points: 12,910, Visits: 32,020
if SQL browser is not running, are you explicitly adding the port to your connection? how are you connecting locally?



Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1436896
Posted Friday, March 29, 2013 6:55 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 5:21 AM
Points: 412, Visits: 1,020
i am able to connect with instancename with port number but i need to connect without mention the port number.
Post #1436902
Posted Friday, March 29, 2013 6:58 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 5:21 AM
Points: 412, Visits: 1,020
sql browser is running fine..
Post #1436905
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse