• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

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

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
0
Wayne88
Asked:
Wayne88
  • 3
  • 3
1 Solution
 
Jim P.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.
0
 
Wayne88Author 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?
0
 
Jim P.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.)
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
Wayne88Author 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.
0
 
Jim P.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.
0
 
Wayne88Author Commented:
Thanks Jim
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now