Problem connecting to SQL Server Express in ASP.NET app running onVista

[egress]

I've created an SQL Server Express database with one table that I use
in my test envionement (Windows Vista). I'm developing an ASP.NET web
app with VS 2005 and try to connect to the express server to retrieve
some simple data (no not Membership data). My connection string is:

<connectionStrings>
<add name="MyTestDb" connectionString="Data Source=.
\SQLExpress;Integrated
DataDirectory|MyData.mdf;User Instance=true;"
providerName="System.Data.SqlClient" />
</connectionStrings>

When I run the app, I get this error:
"Failed to generate a user instance of SQL Server due to failure in
retrieving the user's local application data path. Please make sure
the user has a local user profile on the computer. The connection will
be closed."

I've given "NETWORK SERVICE" every permission under the sun to the
App_Data folder, so I don't think that is the problem.

Can anyone help me on this one. I'm thinking this is some weird user
permission thing that happens with Vista. However, I have UAC
disabled and run VS2005 as Admin.

Also, the weird thing is that VS2005 will setup the ASPNEDDB.mdf and I
can use it for Membership data with no problem, but I can't seem to
setup my own db to use.

Thanks in advance for your help.
jim

[Michael Nemtsev [MVP]]

Hello egress,

See there http://forums.microsoft.com/MSDN/Sho...52338&SiteID=1

---
WBR,
Michael Nemtsev [.NET/C# MVP] :: blog: http://spaces.live.com/laflour

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo
eI've created an SQL Server Express database with one table that I use
ein my test envionement (Windows Vista). I'm developing an ASP.NET
eweb app with VS 2005 and try to connect to the express server to
eretrieve some simple data (no not Membership data). My connection
estring is:
e>
e<connectionStrings>
e<add name="MyTestDb" connectionString="Data Source=.
e\SQLExpress;Integrated
eDataDirectory|MyData.mdf;User Instance=true;"
eproviderName="System.Data.SqlClient" />
e</connectionStrings>
e>
eWhen I run the app, I get this error:
e"Failed to generate a user instance of SQL Server due to failure in
eretrieving the user's local application data path. Please make sure
ethe user has a local user profile on the computer. The connection
ewill
ebe closed."
eI've given "NETWORK SERVICE" every permission under the sun to the
eApp_Data folder, so I don't think that is the problem.
e>
eCan anyone help me on this one. I'm thinking this is some weird user
epermission thing that happens with Vista. However, I have UAC
edisabled and run VS2005 as Admin.
e>
eAlso, the weird thing is that VS2005 will setup the ASPNEDDB.mdf and
eI can use it for Membership data with no problem, but I can't seem to
esetup my own db to use.
e>
eThanks in advance for your help.
ejim

[egress]

On Jan 12, 7:34*am, Michael Nemtsev [MVP] <[e-mail]:

Hello egress,

See therehttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=152338&SiteID=1

---
WBR,
Michael *Nemtsev [.NET/C# MVP] :: blog:http://spaces.live.com/laflour

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo

Thanks for the tip Michael. That thread led me in the right
direction. It was actually something as simple as having
impersonation enabled. I disabled it and presto. No problems.
Thanks again.

egress