New Web Dataform wizard won't connect to SQL server

[gary]

Hello:

I am using the new web dataform wizard to load a new webform that is to
connect to an sql database on MSDE. However, when I run it, I get the
following message:

Login failed for user 'GARYLAP\ASPNET'

I do not get this message when I connect to an access database. I have not
required any usernames or passwords.

Any help would be appreciated.

 

[Miha Markic]

Hi gary,

Yup, that's right.
Asp.net application is running under aspnet local account.
You could allow aspnet account to connect to sql server (not recommended),
use sql server authentication (passing username and password within
connection string) or change the account under which your aspnet application
runs:

Put a line into
web.config file somewhere under
<system.web> node:
<identity impersonate="true" userName="USER" password="PASSWORD"/>