March 31, 2008 at 2:17 am
Hello I am getting the following error while connecting Named instance
===================================
Error connecting to 'MachineName\KATMAI_NEW'.
===================================
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorCore)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SupportedServers.GetSqlEngineEdition(SqlOlapConnectionInfoBase connectionInfo)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SupportedServers.GetHierarchyBuilder(SqlOlapConnectionInfoBase connectionInfo)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.BuildDataModel(SqlOlapConnectionInfoBase ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.GetHierarchy(SqlOlapConnectionInfoBase ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ConnectToServer(Object connectionInfo, IDbConnection liveConnection, Boolean validateConnection)
===================================
Microsoft.SqlServer.Smo.UnSafeInternals.ManagementUtil.EnterMonitor(System.Object) (Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorCore)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Sdk.Sfc.ObjectLoadInfoManager.LoadHierarchy()
at Microsoft.SqlServer.Management.Sdk.Sfc.ObjectLoadInfoManager.GetFirstObjectLoadInfo(Urn urn)
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetServerVersion(Urn urn, Object ci)
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetObjectsFromCache(Urn urn, Object ci)
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
======================================================================
i installed 2 (MachineName\Katmai & MachineName\Katmai_New) instances in the same machine.
Both the instances are running with the same domain account.
Before installing the 2nd instance MachineName\Katmai_New i was able to connect the 1st MachineName\Katmai instance.
After installing the 2nd instance MachineName\Katmai_New i was not able to connect both the instances.
In this machine SQL 2005 is also installed, before installing 2nd named instance both SQL 2005 & Sql 2008 working fine.
Now SQL2005 is working fine but sql2008 is not working.....
February 22, 2009 at 8:52 pm
Ditto.
Anybody have any answers?
SQL Server 2008 installed side-by-side with SQL Server 2005 Developer Edition.
Noticed it after I installed SP1 and the Silverlight 2 Tools
February 23, 2009 at 2:55 am
What TCP port have you specified for these instances. If you are trying to use the same port for both instances, you can conect only to the first instance that gets started. If you use different ports for each instance then you can connect to both instances.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 23, 2009 at 8:10 pm
They are using different ports.
February 25, 2009 at 10:31 pm
Is the issue solved.
"Keep Trying"
February 26, 2009 at 8:30 pm
Nope.
February 27, 2009 at 1:39 am
Pls keep us updated on this.
"Keep Trying"
February 28, 2009 at 3:45 pm
Are you able to connect locally to the named instances? What operating system is this installed on?
K. Brian Kelley
@kbriankelley
March 1, 2009 at 7:13 am
Are you able to start service for any of these 2008 instances?
Manu
March 1, 2009 at 4:58 pm
Yes, the services all run, and I can run sqlcmd. SQL Server Profiler works. But SQL Server Management Studio is unusable.
January 20, 2010 at 9:26 am
First, try to add the programs you are using to your windows firewall exception, as using ServerName\InstanceName to access named instance invokes a sql server discovery process, which uses UDP protocol during part of the process. It can be blocked by default on VISTA and Windows 7, or your companies group policy.
If it still not work for you, you can find out the Port of the named instance, and connect by using "ServerName,Port# " instead of "Servername\InstanceName". This bypass the discovery step, which should work too.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply