Local Testing Using SQL Server

I have a SQL server db set up locally.
I have a local DSN set up.
I have DW connected to the SQL server db and can create Bindings and
use Server Behaviors without any problem.
When I try to test the site locally in the browser, I get the
following error:
"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open datab
ase
"xxxxxxx" requested by the login. The login failed."
What am I doing wrong?
Thanks.Most likely, you've set the default database in the connection string to a
database that the login doesn't have access to. Note this would be the
connection string used by the web server to connect to the SQL instance.
Linchi
"Brett_A" wrote:

> I have a SQL server db set up locally.
> I have a local DSN set up.
> I have DW connected to the SQL server db and can create Bindings and
> use Server Behaviors without any problem.
> When I try to test the site locally in the browser, I get the
> following error:
> "Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open dat
abase
> "xxxxxxx" requested by the login. The login failed."
> What am I doing wrong?
> Thanks.
>