Solved

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

Posted on 2014-02-27
6
274 Views
Last Modified: 2014-02-28
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
Comment
Question by:Wayne88
  • 3
  • 3
6 Comments
 
LVL 38

Expert Comment

by:Jim P.
ID: 39893849
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
 
LVL 14

Author Comment

by:Wayne88
ID: 39894771
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
 
LVL 38

Expert Comment

by:Jim P.
ID: 39894785
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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 14

Author Comment

by:Wayne88
ID: 39894797
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
 
LVL 38

Accepted Solution

by:
Jim P. earned 100 total points
ID: 39894917
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
 
LVL 14

Author Closing Comment

by:Wayne88
ID: 39894939
Thanks Jim
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question