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
Hi Everyone How can i resolved my problem this??..Im using Operating system window 7..
September 5th, 2011 10:11pm

Are you sure it is a SSIS related issue? What edition of Windows 7? How to reproduce this error? On the surface it seems that something is either not installed or there are no appropriate rights. Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
September 5th, 2011 10:23pm

I use edition operating system is Window 7 Ultimate. I search related of this thread most of their suggestion is to delete C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS directory. But i don't have a folder like that in window 7.
September 5th, 2011 10:29pm

Then this question arises: do you have the SQL Server installed (whatever edition)?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
September 5th, 2011 10:39pm

Yes i have sql server 2005 installed. How can i resolved this my problem:((
September 5th, 2011 10:41pm

Need to understand first what you are doing. How would I repro this issue? E.g. my guess you are getting this error when the OS starts yes, no?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
September 5th, 2011 10:45pm

No. Additional Information I made my Program In Computer 1 when i debug it's work then when i try to the computer 2 when i debug the program not work Failed to Generate......The connection will be closed. both of them i installed sql server.
September 5th, 2011 10:50pm

No. Additional Information I made my Program In Computer 1 when i debug it's work then when i try to the computer 2 when i debug the program not work Failed to Generate......The connection will be closed. both of them i installed sql server. What program is that?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
September 5th, 2011 10:56pm

I use Visual Studio 2010. Im Make a system.
September 5th, 2011 10:57pm

What kind of interaction there in your code is regarding the database? Right now it seems that it could be user rights, are you using the same account to test the "system" on Comp2?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
September 5th, 2011 11:01pm

I believe your issue can be fixed by one or more of these: Make sure the SQL service account has the necessary permissions and/or Edit the connection string. Remove the "User Instance=true". Arthur My Blog
September 5th, 2011 11:41pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics