Hi Srinivas,

Unfortunately I don't have an answer, but I'm in the same predicament and
posted a similar message (including my code) in the
microsoft.public.dotnet.framework.aspnet.webservices news group.  If I get a
response or some sort of revelation as to why this is happening I'll be sure
to post the solution here.

Cheers and Good Luck,

Daniel

Hi again,

I was browsing through this newsgroup hoping for an answer when I noticed a
snippet of code in a semi-related thread that I thought might help shed some
light onto why I was unable to retrieve the information necessary and why
the page was incapable of being displayed.

I added the code below to my webMethod that is returning a string of XML
data and suddenly I was able to get to the heart of my issue.

So here goes.

  string xmlPlayerList;
  try
  {
   sdaManageRoster.SelectCommand.Connection.Open();
   sdaManageRoster.SelectCommand.Prepare();
   sdaManageRoster.SelectCommand.Parameters["@player_id"].Value =
player_id;
   sdaManageRoster.SelectCommand.Parameters["@is_active"].Value =
is_active;

   sdaManageRoster.Fill(dsPlayerList);
   xmlPlayerList = dsPlayerList.GetXml();
  }
  catch(Exception ex)
  {
   xmlPlayerList = ex.ToString();
  }

  sdaManageRoster.SelectCommand.Connection.Close();

  return xmlPlayerList;

 What this did for me was return the exact text of the exception I was
experiencing (but not seeing).  The gist of it is that the default user was
not able to execute a stored procedure in the master database and so I was
unable to open the Connection in the first place.  Once I put in the
necessary login info and made sure it was saved, my list of players was
successfully returned and displayed on the page.

Of course now I'm faced with the problem of figuring out the best way to
supply the login and password without having it hardcoded into the page
itself, but that's a minor issue compared to tracking down this one.

Cheers and I hope this helps,

Daniel