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
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

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

752 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