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”