ASP.NET

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.

swetha sankaran wrote:

public string RetrieveDataSource()

<br />
  public string RetrieveDataSource<br />
        { <br />
            get<br />
            {  <br />
                System.Data.Sql.SqlDataSourceEnumerator en = System.Data.Sql.SqlDataSourceEnumerator.Instance;<br />
                DataTable dt = en.GetDataSources();<br />
                RegistryKey rk = Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Microsoft SQL Server");<br />
                String[] instances = (String[])rk.GetValue("InstalledInstances");<br />
       <br />
                if(instances.Length > 0)<br />
                {<br />
                    foreach(string element in instances)<br />
                    {<br />
                        //add if doesn't exist<br />
                        if(element != "MSSQLSERVER")<br />
                        {serverName = String.Format(System.Environment.MachineName,element);}<br />
                        else<br />
                        {serverName = System.Environment.MachineName;}<br />
<br />
                    }<br />
<br />
                }<br />
                return serverName;<br />
            }<br />
               <br />
            }<br />
<br />
       protected override void RenderToolPart(System.Web.UI.HtmlTextWriter output)<br />
        {<br />
            base.RenderToolPart(output);<br />
            if (ex1 != "")<br />
            {<br />
                output.Write(ex1);<br />
            }<br />
            //server name, instance name.<br />
            output.Write(this.RetrieveDataSource); <br />
        <br />
        }

 String[] instances = (String[])rk.GetValue("InstalledInstances");<br />
<br />
       output.Write(this.RetrieveDataSource); <br />