InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 10:33:26 GMT20http://www.sqlservercentral.com/Forums/Topic566756-145-1.aspxaccessing named instances--------------------------------------------------------------------------------helloI installed two named insances of SQL Server 2005 on Win 2003 server.I hv written small appl which list out all the insances of SQL Server available on network .but it is not working , it is displaying only names of SQL Server.Code---Dim dtSQLServers As DataTable dtSQLServers = SmoApplication.EnumAvailableSqlServers() Dim strServer As String For Each dr As DataRow In dtSQLServers.Rows strServer = CStr(dr("Server")) 'strServer = dr("Server") & "\" & CStr(dr("Instance")) If Not TypeOf dr("Instance") Is DBNull AndAlso CStr(dr("Instance")).Length > 0 Then strServer += "\" & CStr(dr("Instance")) End If comboServer.Items.Add(strServer) Next----------------is there any other method for this.Firewall is off on server.ThanksWed, 10 Sep 2008 05:08:05 GMTshital.p