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 database
"xxxxxxx" requested by the login. The login failed."

What am I doing wrong?

Thanks.
Brett_A [ Di, 13 November 2007 22:00 ] [ ID #1869466 ]

Re: Local Testing Using SQL Server

post sql server questions here:

microsoft.public.sqlserver.programming
Jon Paal [ Mi, 14 November 2007 19:25 ] [ ID #1870472 ]
Webserver » microsoft.public.inetserver.asp.general » Local Testing Using SQL Server

Vorheriges Thema: checkbox syntax
Nächstes Thema: Automated Form Submission