ASP.NET

using(Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer m = new Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer())
{
   foreach (ServerInstance si in mc.ServerInstances)
   {
     Response.Write("ServerInstance:" + si.Name + "
");
   }
}

public string RetrieveDataSource<br />
 {<br />
    get<br />
     {<br />
         try<br />
         {<br />
             System.Data.Sql.SqlDataSourceEnumerator en = System.Data.Sql.SqlDataSourceEnumerator.Instance;<br />
             DataTable dt = en.GetDataSources();<br />
             RegisteredServer[] rsvrs = Microsoft.SqlServer.Management.Smo.SqlServerRegistrations.EnumRegisteredServers();<br />
             foreach (RegisteredServer rs in rsvrs)<br />
             {<br />
                     serverName = rs.ServerInstance;<br />
             }<br />
         }<br />
         catch (Exception ex)<br />
         {<br />
             ex2 = ex.Message;<br />
         }<br />
         return serverName;<br />
     }<br />
     }

Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer mc = new Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer();
        foreach (Microsoft.SqlServer.Management.Smo.Wmi.ServerInstance si in mc.ServerInstances)
        {
            Response.Write("ServerInstance: " + si.Name);
        }

swetha sankaran wrote:

The code that was deleted were updated and posted back based on further research and modifications.

swetha sankaran wrote:

String[] instances = (String[])rk.GetValue("InstalledInstances");

using(RegistryKey rk = Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Microsoft SQL Server"))
{
  String[] instances = (String[])rk.GetValue("InstalledInstances"); 
  //Rest of your code goes here
}

using(Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer m = new Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer())
{
   foreach (ServerInstance si in mc.ServerInstances)
   {
     Response.Write("ServerInstance:" + si.Name + "<br />");
   }
}

Rolcr wrote:

the problem is with one particular page, one service, maybe one particula webMethod?

Rolcr wrote:

In order to reproduce the bug, you must identifi the webMethod (or methods) and send the same information than the user are sending to receive the same answer from the service.