Posted by Erland Sommarskog on 10/02/73 11:44

(jimmy84c@gmail.com) writes:
> 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."

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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: SQL Server needs help from MS Access (or something)
• Prev in forum: Re: rights issues with linked server
• Thread view: Re: SQL server express 2005 local accounts problem. please help!

[Reply to this message]