Re: DB connection problem in attemp to load DataGrid from SQLServer DB
From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 09/14/05
- Next message: Richard Lionheart: "Re: DB connection problem in attemp to load DataGrid from SQLServer DB"
- Previous message: Richard Lionheart: "My current settings are "SQL Server and Windows NT"."
- In reply to: Richard Lionheart: "Re: DB connection problem in attemp to load DataGrid from SQLServer DB"
- Next in thread: Richard Lionheart: "Re: DB connection problem in attemp to load DataGrid from SQLServer DB"
- Reply: Richard Lionheart: "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 19:49:11 -0500
> If you have the time to tell me the path in Ent. Mgr to change the
> security mode, I'd be very appreciative.
Right-click on the server in EM, select properties and then click the
Security tab.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Richard Lionheart" <NoOne@Nowhere.net> wrote in message
news:%23VsjTTMuFHA.3588@tk2msftngp13.phx.gbl...
> 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: "Re: DB connection problem in attemp to load DataGrid from SQLServer DB"
- Previous message: Richard Lionheart: "My current settings are "SQL Server and Windows NT"."
- In reply to: Richard Lionheart: "Re: DB connection problem in attemp to load DataGrid from SQLServer DB"
- Next in thread: Richard Lionheart: "Re: DB connection problem in attemp to load DataGrid from SQLServer DB"
- Reply: Richard Lionheart: "Re: DB connection problem in attemp to load DataGrid from SQLServer DB"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
