Local Testing Using SQL Server

Local Testing Using SQL Server

am 13.11.2007 22:00:31 von Brett_A

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.

Re: Local Testing Using SQL Server

am 14.11.2007 19:25:33 von Jon Paal

post sql server questions here:

microsoft.public.sqlserver.programming