Reply to thread

Message: [QUOTE="Altman, post: 4319857"] I am a newbie to both SQL Server and webservices. I have mostly done programing in Foxpro, VB6, and a little C++, and VB.net. I have been able to make a simple webservice work but now I am trying to go one step further and return XML string of a table. I am trying to return the Customer table of the northwind database. I am creating the webservice on a XP machine and loading it to a Win 2003 server. The error I am getting is Login failed for user 'NT AUTHORITY/NETWORK SERVICE'. This is my function <WebMethod()> _ Public Function GetData() As String Dim ctest As String, custDS As New DataSet Me.SqlConnection1.Open() Me.CustData.Fill(custDS) Me.SqlConnection1.Close() ctest = custDS.GetXml() custDS = Nothing Return ctest End Function If I do the same function in a vb.net app it works, what am I doing wrong? [/QUOTE]