Solved

Error!!

Posted on 2006-07-16
6
174 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
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

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

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.
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

728 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