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

Have to enter the port to connect via management studio Expand / Collapse
Author
Message
Posted Sunday, August 19, 2012 8:20 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 17, 2014 12:57 PM
Points: 126, Visits: 206
A strange problem has cropped up in our enviornment that I'm kind of scratching my head about. Why all of a sudden would users who connect via Management Studio or Query tools have to enter the port to connect to SQL Server? Ideas of what to look at?


Post #1346988
Posted Sunday, August 19, 2012 11:19 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 2:53 AM
Points: 1,101, Visits: 5,290
I think SQL Server Browser service has stopped.
Post #1346997
Posted Monday, August 20, 2012 2:06 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 10:45 AM
Points: 1,058, Visits: 2,696
i go with suresh.


Regards
Durai Nagarajan
Post #1347022
Posted Monday, August 20, 2012 5:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 5, 2012 5:44 AM
Points: 3, Visits: 140
If SQL Server Browser Services is stopped then you have to specify the port number when connecting to that SQL Server instance.
Post #1347086
Posted Monday, August 20, 2012 5:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 17, 2014 12:57 PM
Points: 126, Visits: 206
No, checked for that. The Browser services is running on all systems where this is occurring.


Post #1347091
Posted Monday, August 20, 2012 5:58 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 10:45 AM
Points: 1,058, Visits: 2,696
is "named pipes" enabled in sql configuration manager

Regards
Durai Nagarajan
Post #1347107
Posted Tuesday, August 21, 2012 12:26 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 5:39 PM
Points: 286, Visits: 582
If you specifically set the Network Protocol in the 'Connection Properties' of SSMS to be 'TCP/IP', do you still need the port?

If you connect via sqlcmd, do you need the port?

Do you have any aliases set up in Configuration Manager?


Clare
_________________________________________________________________________________________________________________
Measure twice; cut once (and have a good saw)

Hey, just a thought.....did you check Books Online yet?
Post #1347580
Posted Tuesday, August 28, 2012 12:55 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 12:45 PM
Points: 88, Visits: 402
check for UDP port 1434 not being blocked by a firewall.


Post #1351195
Posted Tuesday, August 28, 2012 1:37 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 17, 2014 12:57 PM
Points: 126, Visits: 206
Thanks for the responses. I will pass it along. It appears to be a security issue only happening to laptop users coming in via the VPN.


Post #1351218
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse