I am running on Windows XP Professional Service Pack 1 with all Hotfixes
installed. I am the only user of the system.
I installed SQL Server Developer (2000) and want to access the SQL data from
IIS.
I am running on a local machine and its name is AXP. I can run happily if I
directly access SQL telling it to use Windows authentication.
I have a C# Web Service created and when I run a test of it under Visual
Studio .NET 2003 it tells me:
--------
System.Data.SqlClient.SqlException: Login failed for user 'AXP\ASPNET'.
at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction)
at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec
tionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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, String
srcTable)
at Northwind.Customer.GetCustomers(String Country) in
c:\inetpub\wwwroot\northwind\customer.asmx.cs:line 64
--------
I assume that there is something "very basic" that I need to do to set SQL
to permit access by ASP.NET. I also assume that this is not set in the
"basic install" of SQL Server.
Can someone give me a hint on how to resolve this issue? Is there a better
newsgroup for this question then the C# newsgroup?
Thanks.
--
-- Thom Little -- www.tlaNET.net -- Thom Little Associates, Ltd.
--