Solved

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

Posted on 2014-02-27
6
263 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 13

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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 13

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 13

Author Closing Comment

by:Wayne88
ID: 39894939
Thanks Jim
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

708 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

14 Experts available now in Live!

Get 1:1 Help Now