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.
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.
> 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.
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.
> 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.
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.
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 ?
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.
> 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.
"Brock Allen" wrote: > 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.
> > 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.
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:
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.
> 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" wrote:
>> 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 >>> 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.
|
