Where can I find the network configuration for the MICROSOFT##SSEE

Wayne88
Wayne88 used Ask the Experts™
on
I can't seem to find the network configuration for the instance MICROSOFT##SSEE.  Can someone provide instruction on how to get there?

Attached is what I only see.  Thanks.
ss.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2014

Commented:
To connect remotely you need to enable the TCP/IP services.

You will also need to go to the Services and turn on the SQL Server Browser services.
Top Expert 2015

Author

Commented:
Thanks but before I can enable the TCP/IP services for this SQL instance don't I need to go to the network configuration then enable it from there?
Most Valuable Expert 2014

Commented:
If the computer is on the network the SQL Server Browser services is the network configuration.

(Provided the firewall is off -- or the holes are punched for SQL.)
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Top Expert 2015

Author

Commented:
Hi Jim, sorry but I am still a little confused.  I guess my question should have been "how can I configure the SQL Browser TCP/IP settings?"  I am expecting to see the settings as shown in the SQL Server Configuration Manager but I now think that it's wrong.
Most Valuable Expert 2014
Commented:
By default SQL Server uses port 1433TCP/1434UDP to accept the connections. The SQL Server Browser service listens on those ports by default.

If you have a named instance, like ServerName\SBSSMonitoring, then the SQL Server Browser will redirect to the actual ports the instance is working on. That can be seen in the SQL Server 2005 Services folder which ports those are. But the Browser service generally makes it irrelevant what the ports are.

With over 15 years of maintaining SQL Servers I have run into one app that actually got down to the port level that were used.
Top Expert 2015

Author

Commented:
Thanks Jim

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial