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.

Trevor
Wed Nov 14 14:16:23 PST 2007

Would you mind posting the ASP.NET code.

Regards,

Trevor MCSD


"Thunder" <jrugo@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.

Rick
Thu Nov 15 04:08:52 PST 2007

Are you using ASP.Net 2.0 and membership and roles? If so, you will note
that there is a LocalSQLServer connection string and references to it in
Machine.config which may be what you are running into.

--
Rick Barber

http://www.orcsweb.com
Managed Complex Hosting
#1 in Service and Support

"Thunder" <jrugo@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.