Is it possible to transfer the exe program with SQL database to another computer?

Question

C++ / C#

Good day everyone!
I have an exe program written in C# and using MS SQL 2008.
The program was written and installed on a computer many years ago by a programmer who is no longer with us.
I need to start using the program on another computer. I myself do not know how the connection to the database occurs in the program itself, it seems to be sewn into the code.
By logging into SQL Management Studio, I can find the database in use and see the host and login to connect to the database (I don't know the password).
If I run the program on another computer (I installed MS SQL 2008 there), then, undoubtedly, there is an error connecting to the database.
Tell me, is it possible to transfer the program at all? If so, then
1) do you need to create the same hostname, login and password one-on-one on a new computer?
2) what if I don't know the password in MS SQL on the old computer?

Answer 1

1. You can try to decompile the program and see what you need, or fix it.
2. If the password cannot be found, then it can be reset - v-consult.be/2011/05/26/recover-sa-password-micros... (the first instruction that came up in the search).
3. Perhaps you will be satisfied with the option to "clone" the entire machine or virtualize it.

Answer 2

look in the directory with the program for the file [some name].config
There should be a connectionStrings section
. You can set the connection string to the new database in it

Answer 3

Take IL spy , decompile the exe assembly, look for where the password is wired.