I can't login to Sql no matter what i try! i'm ignorant and i need help :)

From: logan (ryan.martin@iccicorp.com)
Date: 01/29/03 

From: "logan" <ryan.martin@iccicorp.com>
Date: Wed, 29 Jan 2003 12:28:16 -0800

using : .NET Server RC1
         IIS 6
         ASP.NET
         SQL 2000 (eval)

ok when i attempt to login to my Web App i get this :

System.Data.SqlClient.SqlException: Cannot open database
requested in login 'T254DN_Staging'. Login fails. Login
failed for user 'sa'. (sa is just to test, i've tried all
my other logins).

i dont think i want to use integrated security because
many of the users of the site wont have windows accounts.
i just want ASP.NET to access the database,
 i have tried
adding the ASPNET account as a user in the database with
administrative db role (again as a test).

SQL Server is set to authenticate in Mixed Mode

IIS is set up for anonymous access with the IUSR_ account

WebConfig authentication mode : tried Forms and None.
neither made a diff.

Machine.Config :
  <identity impersonate="false" userName="" password=""/>

i dont get it. i dont understand, can a brotha just get
some sql data for his web app.

thanks.

Relevant Pages

  • Re: Security controls in a web application
    ... one may be better off passing account management tasks ... to the operating system or database server ... I'm afraid that my web app is lacking of many security controls. ... I have implemented some security controls like a login page that asks ...
    (microsoft.public.security)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ...
    (comp.lang.php)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... the postgres user they are logged in as to one that can make ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ...
    (comp.lang.php)
  • RE: How to allow users to change their password?
    ... be set up to provide the Security dialog window for password changes. ... I'll have to login using their login ... > name/password first. ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.security)
  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)