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

From: Mary Chipman (mchip@nomail.please)
Date: 01/31/03

From: Mary Chipman <mchip@nomail.please>
Date: Fri, 31 Jan 2003 13:09:20 -0500

I'd recommend taking a gander at that ASP.NET security best practices
whitepaper. It's hard to troubleshoot when you're not actually

-- Mary
MCW Technologies

On Thu, 30 Jan 2003 07:27:26 -0800, "logan" <>

>Thanks for the reply, however sql is using (windows and
>sql) Mixed authentication.
>Any other ideas?
>>-----Original Message-----
>>It sounds like your server is configured for Windows
>>only. Go into the server properties in the Enterprise
>Manager and
>>check out the settings on the Security tab. You also
>might want to
>>take a look at the security "best practices" whitepaper:
>>-- Mary
>>MCW Technologies
>>On Wed, 29 Jan 2003 12:28:16 -0800, "logan"
>>>using : .NET Server RC1
>>> IIS 6
>>> SQL 2000 (eval)
>>>ok when i attempt to login to my Web App i get this :
>>>System.Data.SqlClient.SqlException: Cannot open
>>>requested in login 'T254DN_Staging'. Login fails. Login
>>>failed for user 'sa'. (sa is just to test, i've tried
>>>my other logins).
>>>i dont think i want to use integrated security because
>>>many of the users of the site wont have windows
>>>i just want ASP.NET to access the database,
>>> i have tried
>>>adding the ASPNET account as a user in the database
>>>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_
>>>WebConfig authentication mode : tried Forms and None.
>>>neither made a diff.
>>>Machine.Config :
>>> <identity impersonate="false" userName=""
>>>i dont get it. i dont understand, can a brotha just get
>>>some sql data for his web app.