Solved

Error!!

Posted on 2006-07-16
6
170 Views
Last Modified: 2010-04-16
Hi Experts ..

Login failed for user 'CO-B080FE8CE82C\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 'CO-B080FE8CE82C\ASPNET'.

Source Error:


Line 36:                   if(!IsPostBack)
Line 37:                   {
Line 38:                         sqlDataAdapter1.Fill(dsPizzaStores1);
Line 39:                         sqlDataAdapter2.Fill(dsPizzaStores1);
Line 40:             
 
I don't know why this error occured??
this is my connection string :

this.sqlConnection1.ConnectionString = "workstation id=\"CO-B080FE8CE82C\";packet size=4096;integrated security=SSPI;data source=\"CO-B080FE8CE82C\";persist security info=False;initial catalog=PizzaStore";

..??
            
0
Comment
Question by:DrAske
  • 3
  • 3
6 Comments
 
LVL 7

Expert Comment

by:whatsit2002
ID: 17118083
You need to give the ASPNET user access to the database or impersonate a user that already has database access. You can impersonate another user by adding this line to the web.config:

<identity impersonate="true" userName="CO-B080FE8CE82C\database_user" password="dbpassword"/>

Also, giving the ASPNET user access to resources (such as a database) can be a security risk, so I would recommend impersonating another user.

A second option would be to use SQL User Authentication instead of an SSPI context.

Thanks.

Jason
0
 
LVL 9

Author Comment

by:DrAske
ID: 17118116
Actually ... I'm not familiar in web.config ?? I'm studing ADO.NET and I am developing a sample project (Asp.net web application project instead of using windows-Forms) ..

so how to set SQL User Authentication ??
0
 
LVL 7

Expert Comment

by:whatsit2002
ID: 17118195
To use SQL User Authentication, your sql server must be setup to support it. If it is, simply change your connection string to something like:

"server=CO-B080FE8CE82C;user id=sqluser;password=mypassword;initial catalog=PizzaStore;"

Where sqluser and mypassword are the user credentials for your sql user.

Jason
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 9

Author Comment

by:DrAske
ID: 17118282
I added a new user using Enterprize Manager .. User = pizza ; password= pwpizza
but it gives another error :

Login failed for user 'pizza'. Reason: Not associated with a trusted SQL Server connection.

this.sqlConnection1.ConnectionString = "data source=CO-B080FE8CE82C;initial catalog=PizzaStore;user id=pizza; Password=pwpizza";

sorry for this stupid question :(
0
 
LVL 7

Accepted Solution

by:
whatsit2002 earned 500 total points
ID: 17118881
Try this:

1) Open Enterprise Manager.
2) Right-click on the SQL server instance
3) Choose "Properties" from the context menu. The "SQL Server Properties (Configure)" window will open
4) Choose the "Security" tab and make sure that under the "Authentication" header that "SQL Server and Windows" is selected.

That will enable SQL Server authentication so that your connection string will work.

Thanks.

Jason
0
 
LVL 9

Author Comment

by:DrAske
ID: 17120314
Well *whatsit2002* .. it worked ..
Thanx alot ..
and sorry for wasting your time ..

regards, Ahmad;
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Calling stored proc in EDMX 11 23
Allow space in this pattern 2 46
Please explain "Multi-Tenant Services" 5 62
C# MVC and a global static factory that never dies 4 45
Summary: Persistence is the capability of an application to store the state of objects and recover it when necessary. This article compares the two common types of serialization in aspects of data access, readability, and runtime cost. A ready-to…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now