Hi All,

I'm trying to run Jeff Prosise's DataGrid example in Chapter 6 of
"Programming Microsoft .NET".

Jeff provided a MyComics.sql file which I've used in Query Analyzer to
create and populate a MyComics database in SQLServer 7.0 installed with NT
authentication.  I verified that the table had been loaded correctly with a
Select statement.

IE displayed the following info:

============================
Exception Details: System.Data.SqlClient.SqlException: Login failed for user
'sa'. Reason: Not associated with a trusted SQL Server connection.

Source Error:

Line 70:
"server=localhost;database=mycomics;uid=sa;pwd=xxxxx");
Line 71:           DataSet ds = new DataSet ();
Line 72:           adapter.Fill (ds);
Line 73:           MyDataGrid.DataSource = ds;
Line 74:           MyDataGrid.DataBind ();

Source File: f:\inetpub\wwwroot\DataGrid-Prosise.Comics.aspx    Line: 72
================================

I exex out the password.  I'm quite sure the password I had supplied was
correct for the "sa" account.

I suspect the problem is a conflict between my specification of NT
authentication and the example's use of the "sa" user.

Any ideas?  Should I post this stuff in some security NG instead?

Thanks in advance,
Richard