Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Login failed for user 'TNTU082154\ASPNET'

Posted on 2005-02-28
Medium Priority
Last Modified: 2008-02-01
Hi there,

I am new to SQL Server, and I am following the book course "SAMS ASP.NET KICKSTART". I am trying to view data from the SQL server in a datagrid bound to a data set.

When I go to run the ASPX web page, it comes up with Login failed for user 'TNTU082154\ASPNET'.

I have a shallow grasp on the securities and permissions involved, and here is where I am so-far:

SQL Server 2000 is running on XP Pro, with IIS installed. - Domain\M-Name: GB898\TNTU082154
Local machine Win XP Pro running Visual Studio.net Professional. - Domain\M-Name: GB898\TPG22245

I have tried creating various 'New Login's under the SQL Server Enterprise manager, but I still get the error. I know the link to the SQL Server is good, as within Visual Studio, I can view, insert, delete data within the database etc...

Please can I have simple instructions on what I need to do on both my local machine, and the Server to allow the Webpage to authenticate properly!!! - It's very frustrating, I have spent the last four hours trying to get this to work... :-[

Your help is REALLY appreciated.


Question by:LoveToSpod

Accepted Solution

tony_o1 earned 2000 total points
ID: 13420564
Visual studio authenicates against the sql server using the current logged in user on the machine it's running on. The asp.net service uses it's own acct. machinename/aspnet. What you need to do is create an acct in Enterprise Manager for [machinename]/aspnet and give permission to that acct to access the db in question. That should get you going.



Author Comment

ID: 13420888

Thanks for your help, in the end I got it going by entering

<identity impersonate="true" />

into the web.config file.

You get the points anyways!!



Expert Comment

ID: 13541432
What are the implications of giving [machinename]\ASPNET permission to the database? How about the implications of setting "identity impersonate" to "true?

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

579 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