Re: Login Failed For User

From: Miha Markic [MVP C#] (miha)
Date: 02/22/04 

Date: Sun, 22 Feb 2004 19:36:48 +0100

Hi,

Asp.net app runs under aspnet local windows account.
You are using windows authentication in connection string for sql server.
You might use sql server authentication, run the asp.net application under
different account or add local window aspnet account to local sql server. 

-- 
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com
"Midos" <anonymous@discussions.microsoft.com> wrote in message
news:3E7D3DE0-C937-4FC2-9C59-B219A94EA839@microsoft.com...
> I am trying a simple example to bind a DataGrid in a WebForm to a table in
the Northwind database in SQL Server. I don't know why am I getting a login
failure message that reads: Login failed for user 'MAYYAD\ASPNET'
>
> Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
>
> Exception Details: System.Data.SqlClient.SqlException: Login failed for
user 'MAYYAD\ASPNET'.
>
> Source Error:  line 94
>
>
> Line 92:     Private Sub Page_Load(ByVal sender As System.Object, ByVal e
As System.EventArgs) Handles MyBase.Load
> Line 93:         'Put user code to initialize the page here
> Line 94:         SqlDataAdapter1.Fill(DataSet11)
>
>
> Source File: c:\inetpub\wwwroot\WebTest\WebForm1.aspx.vb    Line: 94
>  Thanks Midos.
>
>

Relevant Pages

  • Re: Connexion to SSIS
    ... A way to verify it the account in question to the local admins and try ... If you do not want to, can use proxy accounts. ... only SQL Server authentication and use it to connect my remote client to the ... SQLServer Account by SQL Server Authentication? ...
    (microsoft.public.sqlserver.dts)
  • Re: Connexion to SSIS
    ... A way to verify it the account in question to the local admins and try ... If you do not want to, can use proxy accounts. ... only SQL Server authentication and use it to connect my remote client to the ... SQLServer Account by SQL Server Authentication? ...
    (microsoft.public.sqlserver.dts)
  • SA password
    ... That's of course if your NT account has SA priveledges. ... you do not, and you did not delete the builtin admins, you ... >Right click on your SQL Server in the Enterprise Manager ... >and then change back to Use SQL Server authentication, ...
    (microsoft.public.sqlserver.security)
  • SQL Server: beginner: "Login failed for user sa."
    ... Could you help me please with SQL Server problem? ... Server in SQL Server Authentication, account sa, password sa. ...
    (comp.databases.ms-sqlserver)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
Quantcast