After changing for Windows 11, my application cannot create a user instance SQL Server due to a failure to start the process for the instance user

Question

After changing for Windows 11, my application cannot create a user instance SQL Server due to a failure to start the process for the instance user

Marcel Duboué 20

Hello,

I already post my question at the tag SQL Server; after 2 weeks of work, they thing that the problem is due to the fact that my old application Visual Studio uses User Instances, which, for them is an old feature.
The message delivered is

User's image

And the beginning of the code, trying to open the first DB is

User's image

Please tell me your diagnostic, ans possibly any solution to recover my application

Thank you

Erland Sommarskog 87,761 Reputation points

2023-09-02T18:39:41.18+00:00

For Visual Studio people: I've been investigating Marcel's problem with getting the user instance to run in the thread https://learn.microsoft.com/en-us/answers/questions/1352060/0x80004005-error-when-connecting-to-sql-server-201.

My recommendation is that he rewrites the application to not use user instances, since this is an old and dusty feature. For some reason, Marcel finds this difficult, so maybe he needs some help with that. As for why the user instance does not start, I have very little idea; the error messages are not very helpful.

Erland Sommarskog 87,761 Reputation points

2023-09-02T18:39:41.18+00:00

For Visual Studio people: I've been investigating Marcel's problem with getting the user instance to run in the thread https://learn.microsoft.com/en-us/answers/questions/1352060/0x80004005-error-when-connecting-to-sql-server-201.

My recommendation is that he rewrites the application to not use user instances, since this is an old and dusty feature. For some reason, Marcel finds this difficult, so maybe he needs some help with that. As for why the user instance does not start, I have very little idea; the error messages are not very helpful.

After changing for Windows 11, my application cannot create a user instance SQL Server due to a failure to start the process for the instance user

Activity