I have a very unique issue but lack the database configuration skillset to resolve. In my numerous attempts to re-setup, uninstall and reinstall. I was nowhere near.

I was given a Point of Sales machine which i was told that its 4 years old and it could be dying soon. Are we able to duplicate the data and bring the exact configuration to another machine. I am not able to debug the code via Visual Studio to see where is throwing the error but when i attempt to do this on a new machine. I am getting a “Connection Error”

There were 1 configuration that i saw in its app.config.

<add name="x.My.MySettings.POSConnectionString" connectionString="Data Source=seapos\SQLExpress;Initial Catalog=DB;User ID=sa;Password=sa"             providerName="System.Data.SqlClient" /> 

and upon digging further, i found

Data Source=T-WORK;Initial Catalog=DB;Integrated Security=True 

in the code.

I have strong reasons to believe that they are taking the second connection string to connect.

I tried to install a SQLExpress and have the user id setup with the exact same username and password but still get the not-so-useful error.

I think that my issues is with my inability to setup such that the server name is name exactly like its datasource.

Question- How can i ensure my setup will allow me to have the data source to be named “T-Work” or “seapos\SQLExpress”