Re: DB connection problem in attemp to load DataGrid from SQLServer DB
From: Richard Lionheart (NoOne_at_Nowhere.net)
Date: 09/14/05
- Next message: Richard Lionheart: "My current settings are "SQL Server and Windows NT"."
- Previous message: Dan Guzman: "Re: DB connection problem in attemp to load DataGrid from SQLServer DB"
- In reply to: Dan Guzman: "Re: DB connection problem in attemp to load DataGrid from SQLServer DB"
- Next in thread: Dan Guzman: "Re: DB connection problem in attemp to load DataGrid from SQLServer DB"
- Reply: Dan Guzman: "Re: DB connection problem in attemp to load DataGrid from SQLServer DB"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 13 Sep 2005 20:39:49 -0400
Hi Dan,
> ('Integrated Security=SSPI' instead of userid and password).
Great! I stubled acoss that while Googling. I appended it but left
uid/pswd in. Now I've removed the latter. That got me further with a new
symptom.
============
Login failed for user 'ASCI2G-WS2\ASPNET'.
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.Data.SqlClient.SqlException: Login failed for user
'ASCI2G-WS2\ASPNET'.
Source Error:
Line 73: "server=ASCI2G-WS2;database=mycomics;Integrated
Security=SSPI");
Line 74: DataSet ds = new DataSet ();
Line 75: adapter.Fill (ds);
Line 76: MyDataGrid.DataSource = ds;
Line 77: MyDataGrid.DataBind ();
Source File: f:\inetpub\wwwroot\DataGrid-Prosise.Comics.aspx Line: 75
============
So I tried two things:
1. Added ASPNET as a login with no server roles but database access to
MyComics in roles public & db_datareader/writer.
2. I addition, I set security to *both* NT and SQLServer, but I just went
back to Ent. Mgr and can't figure out where I made that change. BTW, I'm
running SQLServer 7.0/SP2 over WinXP-Pro/SP2 with WindowsUpdate stuff.
If you have the time to tell me the path in Ent. Mgr to change the security
mode, I'd be very appreciative.
> Be sure not to use the 'sa' login for routine application access.
OK, thanks.
> Hope this helps.
It ABSOLUTELY helped!
Regards,
Richard
- Next message: Richard Lionheart: "My current settings are "SQL Server and Windows NT"."
- Previous message: Dan Guzman: "Re: DB connection problem in attemp to load DataGrid from SQLServer DB"
- In reply to: Dan Guzman: "Re: DB connection problem in attemp to load DataGrid from SQLServer DB"
- Next in thread: Dan Guzman: "Re: DB connection problem in attemp to load DataGrid from SQLServer DB"
- Reply: Dan Guzman: "Re: DB connection problem in attemp to load DataGrid from SQLServer DB"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
