Posted by jimmy84c on 04/06/06 13:23

Hi all,

After working for weeks on a project in VB.Net, I decided to deploy a
test version on a user's computer.

The user's XP SP2 computer has sql server xpress 2005 installed, and my
VB.net creation. Everything works without problem when the user's XP
account is set with Administrator permissions. But when i change the
user account to Limited, the program fails with the following message:

"Failed to generate a user instance of SQL server due to a failure in
starting the process for the user instance. The connection will be
closed."

The connection string I'm using is: "Data
Source=.\SQLEXPRESS;AttachDbFilename="|DataDirectory|\DbTrial1.mdf";Integrated
Security=True;User Instance=True;Connect Timeout=30"

Is there a workaround to get access for XP users with limited accounts?

Many thanks :)

p.s. allready tried changing in the connection string to "User
Instance=False", but then i get the error "An attempt to attach an
auto-named database..... failed.. etc"

And I've already tried the most common suggestion to delete the
"SQLEXPRESS" folder in local settings\application data... but that
doesn't do anything either :(

[Back to original message]