Solved

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

Posted on 2014-02-27
6
265 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
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.

 
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

863 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now