Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

DB connect from IIS7

0 views
Skip to first unread message

opunarcisse

unread,
Jul 31, 2009, 4:05:03 AM7/31/09
to
I am using an SQL express 2005 , VS2008 and IIS7. all these are installed on a vista home edition. i have created an asp.net application in VS2008. it works correctly. when deployed in IIS7 on my laptop, my DB connection stops working. I didn't change the DB connection from the one in the VS2008. I can't understand how it works in VS2008 but not in IIS7.

(copy of connection string below)

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\CamcudafManagementDatabase.mdf;Integrated Security=True;User Instance=True

provider = sql

Can some one help me. Narcisse.

opunarcisse

unread,
Jul 31, 2009, 4:04:53 AM7/31/09
to

Scott M.

unread,
Sep 3, 2009, 2:54:29 PM9/3/09
to
When you try your app. on your Vista home edition machine, are you sure
you've got it configured to use IIS and not the built-in ASP .NET
development server, which is used by default?

Also, regardless of whether you are using IIS or the built-in server, is
your SQL instance called "SQLEXPRESS" on both machines and is the database
present on both machines with the same permissions (the ASPNET user account
must have permissions to access the SQL Server?

The problem isn't VS 2008 vs. IIS, as they are 2 different things entirely.
The issue is your SQL installation on one machine vs. your SQL installation
on the other.

-Scott

<Opu Narcisse> wrote in message
news:%232njcWb...@TK2MSFTNGP02.phx.gbl...

0 new messages