SQL server express 2005 local accounts problem. please help!

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="|DataDirecto ry|\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 :(

re: SQL server express 2005 local accounts problem. please help!

(jimmy84c@gmail.com) writes:[color=blue]
> 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."[/color]

I have only played a little with user instances, and I normally do not
work with Express. But my gut feeling is that this should work, else
there would not be much point with user instances.

I submitted a post to our internal MVP forum, to see if I can get some
response from someone who knows this better.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx