Goldmine Premium 9.2.59 March 2012
Hi. We have not been using our Goldmine for few years and would like to find a way to keep information while reusing the server it was installed on. So I came up with the idea of migrating database and program to new server.
I copied program to a new server, ran Setup from Goldmine\Setup, pointed to old ini files and it works. In Goldmine ini files it points to old database IP.
Result: Goldmine works on new server while communicating/contacting old MS SQL server.
Installed SQL Express 2012 on new server, restored Goldmine backup successfully. in dbalias.ini pinted IP to new server.
Goldmine does not work, when I start GM and try to login with my account, after that I get error message saying:
"Incorrect configuration of database aliase "GoldMine:" - check dbalias.ini. Login/password can not be empty"
"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied." Native code 17, source "Microsoft OLE DB Provider for SQL Server"
Result: cannot work with restored database
I am guessing I should create additional user in SQL database or try different servertype in dbalias.ini config file? dbalias.ini also contains PASSWORD which looks encrypted, would providing new unencrypted password work?
I only need to keep the data in case employees would need to check one old record, which is unlikely to happen. However we cannot just keep database backup in cold storage without knowing how to restore and make it accessible. Any help would be appreciated.