I am a total newbie with very little knowledge. Our work has halted due to hardware issues in our old windowsXP PC. We had paid close to $2000 for our ERP software but the company isn't providing tech support anymore!
I want to replicate SQL 2008 R2 installation and settings etc to another windows PC. I do not have the sa password, but the remember password tick box is checked so I'm able to login in to SMSS and see our attached database file. I unable to find any database access settings in our ERP software settings, to which I have access to.
I can't risk changing sa password and then detach database, as I do not know if that needs to be updated in our ERP software too. Once I change sa password in SQL, I'm afraid that I won't be able to revert to existing password, as I don't know it.
The dataconfig file for ERP reads like this -
On our new PC, I have installed SQL 2008 R2, created default instance (database attached to MSSQLSERVER on old PC). Took our database file offline from old PC, detached and attached to MSSQLSERVER instance on new PC. (changed sa password to blank via SMSS)
But still my ERP throws and error - unable to access database path - master. Check login credentials.
I can do as instructed, but afraid of messing the existing setup in the old PC.
Please help, I'm on the edge here. All forms of help are highly appreciated.