Re: Login failed for user 'myComputer\ASPNET'

Tech-Archive recommends: Fix windows errors by optimizing your registry

On 6 Oct 2005 15:14:02 -0700, trouling@xxxxxxxxx wrote:

¤ An aspx page I made with a DataGrid and SQLConnection to my local MS
¤ SQL server shows appropriate DB information when view from within the
¤ .NET designer. However, when selecting: "View in Browser", the
¤ following error appears.
¤
¤ Login failed for user 'myComputer\ASPNET'
¤
¤ Selected failing code is:
¤ SqlDataAdapter1.Fill(AuthorsDS1)
¤
¤ Any ideas where I can set the appropriate authentication properties. Is
¤ it in the setup of MS SQL or IIS?

The answer to this question largely depends upon your configuration. If your ASP.NET app is
configured for Integrated Windows authentication with a local SQL Server database then enabling
impersonation should resolve the problem.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconaspnetimpersonation.asp


Paul
~~~~
Microsoft MVP (Visual Basic)
.

Relevant Pages

  • Re: Copy database schema from Access to SQL Server
    ... It can import a JET database in a single stroke. ... Hitchhiker's Guide to Visual Studio and SQL Server ... ¤ projects to SQL Server, ... schema and then use DDL code to create the corresponding objects in SQL Server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: If ACCESS 2002 is the back end database for VB6, then should I use ADO???
    ... ¤>> Just google ~MSDE won't run on Vista~ and read it and weep. ... ¤>"As part of this push we have made the decision to not support MSDE on ... MSDE didn't cost you anything anyway, nor does SQL Server 2005 Express. ...
    (microsoft.public.vb.general.discussion)
  • Re: What Database model should I use?
    ... I'm not sure which SQL Server I'm going to convert to ... ... I'm currently converting the application to VB6 ... > ¤ I have been programming in microsoft access for years. ... upgrade the JET engine to a real SQL database, ig SQL Serever, Orical, MySQL ...
    (microsoft.public.vb.database)
  • Re: If ACCESS 2002 is the back end database for VB6, then should I use ADO???
    ... ¤>¤ That's what is so sad. ... ¤>MSDE didn't cost you anything anyway, nor does SQL Server 2005 Express. ... MSDE may run on Vista but it and SQL Server ... But hey, if you can get great support for what just became an open source product, ...
    (microsoft.public.vb.general.discussion)
  • Re: Copy database schema from Access to SQL Server
    ... ¤ projects to SQL Server, ... schema and then use DDL code to create the corresponding objects in SQL Server. ... template database and the target database and compare their schemata. ...
    (microsoft.public.dotnet.framework.adonet)