Login failed for user\ASPNET

[Kim Chi via DotNetMonster.com]

I encountered the above-mentioned error when building my webpage. According
to the Microsoft KB on this problem, I have to add a"
trusted_connection=yes" to the connection string and enter a username and
password for SQL server authentication or leave it blank for WIN NT/2000
server.

I am just wondering what this username & password refer to ? I tried with
the logon credentials when I started the computer but it doesn't work.

--
Message posted via http://www.dotnetmonster.com

[Patrick Olurotimi Ige]

Are you using Windows Authentication?
then use:-
"Data Source=SQLSERVER;Initial Catalog=DATABASENAME;Integrated
Security=SSPI;"

Hope it helps
Patrick

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Brock Allen]

trusted_connection=yes is when you want to use the credentials of the running
application (in this case, the credentials of the running ASP.NET worker
process that hosts ASP.NET) to be those used to authenticate with your database.
This means you need to have setup that user in your database and granted
all the necessary permissions. On Windows 2000 by default this user is the
local ASPNET account. On Windows 2003 this is the Network Service account.

If instead you want to use a different set of credentials to authenticate
with the database, then omit trusted_connection=yes and instead use "user
id=joe;password=somepassword". This will now authenticate using that database
account (not using a windows account).

Which option you choose depends upon how you and your DBA work things out.
As for storing secrets (passwords) it's better to go with the windows authentication
to the database using trusted_connection, but this might mean you'll need
to change what user the ASP.NET worker process runs as.

-Brock
DevelopMentor
http://staff.develop.com/ballen

[Manohar Kamath]

Trusted connection indicates that you are using a Windows/AD account to
connect. If you'd like to use such an account, you will need to run ASP.NET
in such user context, using impersonation.

http://www.dnzone.com/ShowDetail.asp?NewsId=504

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com

"Kim Chi via DotNetMonster.com" <fo...@DotNetMonster.com> wrote in message
news:65e894c98cd0449e...@DotNetMonster.com...

[Kim]

After installing MSDE2000 on my WIN XP machine, I created the database from
Access using the upsizing wizard. Although the tables can be seen from the
server explorer, I keep on encountering problem in building my web
application. The error message is "Login failed for user\ASPNET".

I've tried to supply/not supply a username and password at the SQL server
login but both methods could not work. I did not create a username and
password during the upsizing process although I specified a password during
installtion of the MSDE2000. I even uncheck the anonymous user option under
the IIS->Directory Seucrity but that did not help either.

What else can I do ?

[swarovski]

My machine is using MSDE2000 running on WIN XP. I had tried the code
as suggested to be placed at the "Page_Load" event but the webpage
just did not show after much waiting.

If I want to try using a username and password, how should I create
them since my database is already upsized into the server explorer ?

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

[Brock Allen]

You need to add the local ASPNET user as an user in the database and grant
that user access to the DB your application is using. I don't know the command
line switches off the top of my head, so run "osql.exe /?" to get a list
of the commands.

-Brock
DevelopMentor
http://staff.develop.com/ballen

[Kim]

This command just provide a list of switches such as -S, -d, etc. By trying
say "osql.exe /S", it tells me:

Error: no user selected. Try with -U or -E switches.

[Brock Allen]

Ah, yes... so then you need to execute the SQL to add ASPNET as a login to
your DB and setup their DA permissions, etc. So launch "osql -S . -E" then
paste in this SQL and it should start working for you:

exec sp_grantlogin N'THOR\ASPNET'
exec sp_defaultdb N'THOR\ASPNET', N'pubs'
use pubs
exec sp_grantdbaccess N'THOR\ASPNET', N'ASPNET'
exec sp_addrolemember N'db_owner', N'ASPNET'

Replace THOR with your machine name and replace pubs with your database name.
One note is that this SQL adds ASPNET as dbo, so the ASPNET user has total
control over that DB. This is the fastest way to get it working, but I'd
suggest doing some research on SqlServer DB security to know how to scale
back the permissions for this user.

-Brock
DevelopMentor
http://staff.develop.com/ballen