Have to enter the port to connect via management studio

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Have to enter the port to connect via...

Have to enter the port to connect via management studio

Rate Topic

Display Mode

Topic Options

Author

Message

csoloway

Posted Sunday, August 19, 2012 8:20 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 07, 2013 6:23 AM
Points: 126, Visits: 203

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

Suresh B.

Posted Sunday, August 19, 2012 11:19 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:54 AM
Points: 1,076, Visits: 5,128

I think SQL Server Browser service has stopped.

Post #1346997

durai nagarajan

Posted Monday, August 20, 2012 2:06 AM

SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 10:16 AM
Points: 863, Visits: 2,135

i go with suresh.

Regards
Durai Nagarajan

Post #1347022

AbbeyR

Posted Monday, August 20, 2012 5:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 05, 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

csoloway

Posted Monday, August 20, 2012 5:18 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 07, 2013 6:23 AM
Points: 126, Visits: 203

No, checked for that. The Browser services is running on all systems where this is occurring.

Post #1347091

durai nagarajan

Posted Monday, August 20, 2012 5:58 AM

SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 10:16 AM
Points: 863, Visits: 2,135

is "named pipes" enabled in sql configuration manager

Regards
Durai Nagarajan

Post #1347107

MissTippsInOz

Posted Tuesday, August 21, 2012 12:26 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, June 13, 2013 6:11 PM
Points: 286, Visits: 523

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

Joperez

Posted Tuesday, August 28, 2012 12:55 PM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, June 14, 2013 8:46 AM
Points: 88, Visits: 354

check for UDP port 1434 not being blocked by a firewall.

Post #1351195

csoloway

Posted Tuesday, August 28, 2012 1:37 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 07, 2013 6:23 AM
Points: 126, Visits: 203

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 »

Permissions