Re: Login failed for user 'myComputer\ASPNET'

You really haven't provided any useful information so someone can
intelligently help!
IE: connection string.

>From your error, i am assuming your db connection string specifies that your
using window integrated security.

Check that you have added the asp.net account to your sql server logins...

Cheers,
Adam

<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: One Connection String for Multiple Users (SQL)
    ... Hitchhiker’s Guide to Visual Studio and SQL Server ... "William Vaughn" wrote: ... This uses the> same connection string for all instances of the application. ...
    (microsoft.public.sqlserver.connect)
  • RE: How do I configure Analysis Services for Excel 2003 users?
    ... they had had Office 2003 installed AFTER SQL Server. ... > I have been preparing a set of cubes in Analysis Services 2005 to be viewed ... > Excel reports have been designed as pivot tables based on AS cubes, ... > Surely it must be that the connection string is incorrect but I seem to have ...
    (microsoft.public.sqlserver.olap)
  • Re: Connecting to Sql Server using an IP address
    ... using IP address without port number (default port number ... of SQL Server is 1433) cannot connect to the SQL Server on a remote ... name in the connection string can connect the remote machine successfully. ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problem connecting to an SQL 2005 Express Instance in RANU mod
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... I'm using SQL2005 Express User Instance Feature. ... attaching an MDB file with the following connection string: ...
    (microsoft.public.sqlserver.connect)
  • asp.net 2.0 login control
    ... A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] ... These problems left me stranded for days, then today, on another machine, I hit a different set of problems I kept getting the following "Failed to generate user instance of SQL Server due to a failure in starting the process for the user instance. ... (Basically this is a new option in the connection string that allows you to point out where the ..mdf file resides eliminating the need to create database in some SQL instance.) ... Beware that the windows account of the user that first creates the connection in this databaseless manner, becomes exclusive user for this file and no other windows account will be able to create a connection to this file. ...
    (microsoft.public.dotnet.languages.vb)