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