Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Login failed for user 'machinename\ASPNET'

Reply
Thread Tools

Login failed for user 'machinename\ASPNET'

 
 
=?Utf-8?B?TWFuZGFyIFBhdGls?=
Guest
Posts: n/a
 
      05-26-2004
H
I am getting following error
Login failed for user 'machinename\ASPNET
when tryiong to do the following:
SqlDataAdapter1.Fill(DataSet11
This user is never specified in the database and never mentioned anywhere in the code. I am creating sqldataadapter with wizard in VB Dot net 200
Regard

 
Reply With Quote
 
 
 
 
Cowboy
Guest
Posts: n/a
 
      05-26-2004
Sounds like you are using Windows Security on your SQL Server instead of
mixed mode. In this instance, it would take the logged in user and attempt
to log on to SQL as that person. YOu would then get this error.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
"Mandar Patil" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi
> I am getting following error:
> Login failed for user 'machinename\ASPNET'
> when tryiong to do the following:
> SqlDataAdapter1.Fill(DataSet11)
> This user is never specified in the database and never mentioned anywhere

in the code. I am creating sqldataadapter with wizard in VB Dot net 2003
> Regards
>



 
Reply With Quote
 
 
 
 
=?Utf-8?B?TWFuZGFy?=
Guest
Posts: n/a
 
      05-26-2004
ASPNET is not user on the machine and machinename\ASPNET is also not the SQL server instance.
 
Reply With Quote
 
Donald E. Hurley Jr.
Guest
Posts: n/a
 
      05-26-2004
The ASPNET account is the default user for ASPNET.

Are you trying to connect to the database with Integrated security, or do
you specify a username/pass.

If you try to use integrated security and you have anonymous access turned
on, it will use the ASPNET account to try to connect to SQL Server. Try
specifing a UserName/Password.

IE.

packet size=4096;integrated security=SSPI;data source=dhurley3;persist
security info=False;initial catalog=Northwind

or

packet size=4096;user id=sa;data source=dhurley3;persist security
info=False;initial catalog=Northwind;password=pass;

Hope this helps.

"Mandar Patil" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi
> I am getting following error:
> Login failed for user 'machinename\ASPNET'
> when tryiong to do the following:
> SqlDataAdapter1.Fill(DataSet11)
> This user is never specified in the database and never mentioned anywhere

in the code. I am creating sqldataadapter with wizard in VB Dot net 2003
> Regards
>



 
Reply With Quote
 
Jeff Dillon
Guest
Posts: n/a
 
      05-26-2004
That is the problem. Add this user logon to SQL Server

"Mandar" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> ASPNET is not user on the machine and machinename\ASPNET is also not the

SQL server instance.


 
Reply With Quote
 
Scott Allen
Guest
Posts: n/a
 
      05-27-2004
Mandar:

In this case you have several options:

- use a "mirrored" local account on the SQL machine, meaning you'll
create an ASPNET account on the SQL machine, synchronize passwords for
the ASPNET account on the web server and SQL machine, and give the
ASPNET account the ability to login to SQL. There is a more detailed
description of how to do this in the following document:

Building Secure ASP.NET Applications: Authentication, Authorization,
and Secure Communication
http://msdn.microsoft.com/library/de...SecNetHT01.asp

- run the ASP.NET worker process in the context of a user who can
access SQL

- use mixed mode authentication (pass a uid and password in the
connection string)

HTH,

--
Scott
http://www.OdeToCode.com

On Wed, 26 May 2004 13:21:13 -0700, Mandar
<(E-Mail Removed)> wrote:

>ASPNET is not user on the machine and machinename\ASPNET is also not the SQL server instance.


 
Reply With Quote
 
=?Utf-8?B?TWFuZGFy?=
Guest
Posts: n/a
 
      05-27-2004
Thanks
I changed the sql server authentication to SQL authentication
Mandar
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot open user default database. Login failed. Login failed for user 'HEMPC\ASPNET' Tony Johansson ASP .Net 3 01-02-2010 04:09 PM
Cannot open database requested in login 'HumanResources'. Login failed for user 'companyDomain\BOSIIS$'. Homer ASP .Net 3 09-25-2007 07:45 PM
Error:Login failed for user ''. The user is not associated with a trusted SQL Server connection. CFTK ASP .Net 5 01-09-2007 10:51 AM
Login failed for user ''. The user is not associated with a trusted SQL Server connection. Dennis ASP .Net 0 06-26-2006 03:55 PM
Login failed for user ''. The user is not associated with a truste =?Utf-8?B?U3lsdmFu?= ASP .Net 4 11-26-2005 04:35 AM



Advertisments