Copying programs with SQLserver express to a different machine.

Question

Copying programs with SQLserver express to a different machine.

Zalek bloom 1

Few years ago I wrote few programs which are using SQL Express database, now I want to export it to a different PC – what is the correct way?

I did by copying all program folders to a new PC and when I try to run it on a new PC I am getting:
System.Data.SqlClient.SqlException (0x80131904): 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 userid on the new PC is the same, the password is different (Win11 forced me to use Microsoft account password) and the prefix is different – the old one was MSI\ the new one is LG.

So what is the correct way?

Thanks

zb

Jack J Jun 25,291 Reputation points

2022-12-14T06:58:01.347+00:00

@Zalek bloom , Welcome to Microsoft Q&A, what is your current app? Could you provide the related code about your current problem?
Zalek bloom 1 Reputation point

2022-12-17T17:38:52.787+00:00

As I said - few years ago I wrote a C# program which is using SQL Server Express - I wrote it on MSI Win10 machine. Program is working very well and I am using it.
Recently I bought a new LG Win11 PC and I want to export/copy this program to a new machine.
I copied all program files, include .mdf file. I installed SQL Server express of a new machine.
When I try to execute the program I am getting the error:
System.Data.SqlClient.SqlException (0x80131904): 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 suspect it is somehow related to user id, even the user id on the new machine is the same as the old.
In the new machine I see SQL Server is running.
When I open SQL Server Management Studio I see the .mdf file I copied from the old PC in Object Explorer.
When I click on Properties, I see the owner is MSI\Zalek (MSI was my old PC) , but my signon is LG\Zalek (LG is my new PC).

So my question is - what is a proper way to export program and data from one PC to another in a such way, that user LG\Zalek could access database whose owner is MSI\Zalek.

Thanks,

zb
Jack J Jun 25,291 Reputation points

2022-12-19T09:19:31.457+00:00

@Zalek bloom , thanks for the feedback, have you considered that Export the database to sql command text? Then, you could execute the new sql command text in your new computer.
Please refer to the Microsoft Learning Start the SQL Server Import and Export Wizard from SQL Server Management Studio.
·

Your answer

Jack J Jun 25,291 Reputation points

2022-12-14T06:58:01.347+00:00

@Zalek bloom , Welcome to Microsoft Q&A, what is your current app? Could you provide the related code about your current problem?
Zalek bloom 1 Reputation point

2022-12-17T17:38:52.787+00:00

As I said - few years ago I wrote a C# program which is using SQL Server Express - I wrote it on MSI Win10 machine. Program is working very well and I am using it.
Recently I bought a new LG Win11 PC and I want to export/copy this program to a new machine.
I copied all program files, include .mdf file. I installed SQL Server express of a new machine.
When I try to execute the program I am getting the error:
System.Data.SqlClient.SqlException (0x80131904): 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 suspect it is somehow related to user id, even the user id on the new machine is the same as the old.
In the new machine I see SQL Server is running.
When I open SQL Server Management Studio I see the .mdf file I copied from the old PC in Object Explorer.
When I click on Properties, I see the owner is MSI\Zalek (MSI was my old PC) , but my signon is LG\Zalek (LG is my new PC).

So my question is - what is a proper way to export program and data from one PC to another in a such way, that user LG\Zalek could access database whose owner is MSI\Zalek.

Thanks,

zb
Jack J Jun 25,291 Reputation points

2022-12-19T09:19:31.457+00:00

@Zalek bloom , thanks for the feedback, have you considered that Export the database to sql command text? Then, you could execute the new sql command text in your new computer.
Please refer to the Microsoft Learning Start the SQL Server Import and Export Wizard from SQL Server Management Studio.
·

Share via

Copying programs with SQLserver express to a different machine.

Your answer