Please need help with the following.
Running Headquarter at a different location. At the store, there are two PCs. One of them (PC1) is the main one that has the database and Headquarters Client. The other one (PC2) just points to (PC1) to connect to the database with a drive mapping.
PC1 is giving problems and want to make PC2 the main one with the database and communicates with Headquarter. I backed up the database from PC1 and copied it to PC2. Then, I unplugged PC1 from the network and changed system settings, such as hostname and IP, on PC2 to match PC1 so that HQ can communicate with PC2 (now PC1). When I run the SO Administrator to change the SQL server to Local, I get a connection error "it cannot find the database". And until I can connect to a database it does not give me the option to restore database. I uninstall everything and reinstalled it and it still SO Administrator trys to look for the database on the other PC which I unplugged.
What are the proper steps to make the change keep in mind that the HQ needs to communicate with PC2?
I appreciate the help and need to make this change before the main PC crashes.
Thanks in advance.