Login failed for user 'XYZ1492\IUSR_XYZ1492'
Trying to work my way through the Walkthrough for a Distributed Application included in the VB help file. The application currently consists of a web form that accesses a web service. Windows Integrated security is being used.
I get the error message shown below at application startup (with the web form project designated as the startup project.) The message indicates that user USR_XYZ1492 (the anonymous user) was unable to login to SQL Server. I don't understand why the anonymous user is in play if I'm using Windows Integrated Security with anonymous access turned off. Also, the web service works fine if launched directly.
Help appreciated.
Greg Dunn
------------------------------------------------------------------------------------------------
Server Error in '/AuthorsWebClient' Application.
------------------------------------------------------------------------------------------------
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Login failed for user 'XYZ1492\IUSR_XYZ1492'. at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) at System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at AuthorsWebService.AuthorsService.GetAuthors() in c:\inetpub\wwwroot\AuthorsWebService\AuthorsService.asmx.vb:line 122 --- End of inner exception stack trace ---
Source Error:
Line 43: <System.Web.Services.Protocols.SoapDocumentMethodAttribute(" http://www.*-*-*.com/ ;, RequestNamespace:=" http://www.*-*-*.com/ ;, ResponseNamespace:=" http://www.*-*-*.com/ ;, Use:=System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle:=System.Web.Services.Protocols.SoapParameterStyle.Wrapped)> _
Line 44: Public Function GetAuthors() As authors1
Line 45: Dim results() As Object = Me.Invoke("GetAuthors", New Object(-1) {})
Line 46: Return CType(results(0),authors1)
Line 47: End Function
