SQLServerCentral.com Articles tagged named instance

How to Connect to a SQL Server Named Instance

Thu, 12 Apr 2012 06:00:00 UT

My network admins have tightened down the network and while we were once able to connect to our named instances via MySQLServer\MyNamedInstance, we're now only able to connect if we specify the port. What happened and what do I need to tell them to fix the issue?

Find which port SQL Server is using to establish connections

Thu, 08 Sep 2011 06:00:00 UT

This article will show you how to determine which network port that SQL Server is listening on for connections

Getting the SSIS package store to work with a SQL Server named instance

Wed, 22 Apr 2009 06:00:00 UT

We have a named SQL instance and I am able to connect to the instance, but when I try to view the SSIS packages stored in the MSDB database I get an error. This does not happen with our default instances. Is there an additional setting that must be changed to get this to work?