Setup SQL connection on IIS7

Hi All,
I am new to IIS and am trying to write a simple ASP.NET application.
My ADO.net code works fine in the development environment (outside IIS); but
I can't get it two work within IIS7. This is all on my local machine not a
production web server.
I tried removing the default connection, which is the localSQL connection
and create a new one attaching to my SQL Server on the network, but it fails
when launching the web page indicating that it can no longer find the
localSQl connection. It's odd to me because I never, in any place, wrote
code using any local connection.

Anyway, if someone would be so kind and steer me in the correct direction
for setting up a proper connection to my sql server on IIS7 I would
appreciate it.

Thanks.

Would you mind posting the ASP.NET code.

Regards,

Trevor MCSD


"Thunder" <jrugo DeleteThis @patmedia.net> wrote in message
news:06AC94E6-52AC-4173-9BC5-7094CCE4A667@microsoft.com...
> Hi All,
> I am new to IIS and am trying to write a simple ASP.NET application.
> My ADO.net code works fine in the development environment (outside IIS);
> but I can't get it two work within IIS7. This is all on my local machine
> not a production web server.
> I tried removing the default connection, which is the localSQL connection
> and create a new one attaching to my SQL Server on the network, but it
> fails when launching the web page indicating that it can no longer find
> the localSQl connection. It's odd to me because I never, in any place,
> wrote code using any local connection.
>
> Anyway, if someone would be so kind and steer me in the correct direction
> for setting up a proper connection to my sql server on IIS7 I would
> appreciate it.
>
> Thanks.