Re: Login failed for user 'myComputer\ASPNET'

re:
> Login failed for user 'myComputer\ASPNET'

Is "myComputer\ASPNET" a login name in your SQL Server ?

It seems you are using Windows authentication in SQL Server.

If so, you need to add "myComputer\ASPNET" to the logins for your database.



Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================
<trouling@xxxxxxxxx> wrote in message
news:1128636842.357785.131740@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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?
>


.

Relevant Pages

  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: asp.net sql trusted connections between machines
    ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Very basic login question
    ... In order to use Windows Authentication the two computers have to be members of the same domain or trusted domains. ... you should have a login at the SQL Server on the XP Pro workstation. ...
    (microsoft.public.sqlserver.security)
  • Re: How to install and configure SQL Server 2005 on Net work and s
    ... database to backend and then link all table from front Access database to ... we never allowed user can login to sql server to do any thing, ... Each user they required Windows Authentication when they open they won ... install the sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: MS SQL Server Management Studio Express - Changing User at Windows Authentication
    ... if i have 2 Computers in different domains (one with a SQL Server) and want to connect to the SQL Server with Windows authentication how can i change the login information in the "Connect to server" dialog. ... wenn ich 2 Computer in unterschiedlichen Domänen habe und mich mit diesen vom andren aus per Management Studio Express verbinden will kann ich bei der Windows Authentifizierung den Usernamen und das Passwort nicht ändern. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)