DB connection problem in attemp to load DataGrid from SQLServer DB

  • Thread starter Thread starter Richard Lionheart
  • Start date Start date
R

Richard Lionheart

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
 
I mistakenly posted this question on this newsgroup. I think it's more
appropriate on the following,
where I've just now reposted this question:

microsoft.public.dotnet.framework.aspnet.webcontrols;microsoft.public.sqlserver.security

I appologized for any inconvenience I've caused.
 
Back
Top