|
Posted by convoluted on September 7, 2007, 7:48 pm
Please log in for more thread options The database name must be the same as the original (HQ will look for the
original store ID when store connects); I don't think the internal IP or
hostname will make a difference for HQ....if you also moved the HQ Client to
the new machine test the db connection there as well to make sure it sees the
local db....
"CarlosM" wrote:
> Ok, I understand all that. But how about the database name, hostname, and IP
> in terms of communicating with HQ.
>
> "convoluted" wrote:
>
> > Hi Carlos...you need to create the database locally not by copying it but by
> > restoring from the backup you created from the original PC1; this backup
will
> > be in the form of a bck extension file; copy that bck file on the local
drive
> > of your new database server; thenin SO Administrator connect locally to any
> > database (ie master), then go to database - create - restore from the bck
> > file you copied locally; this will recreate the database on local - hope
this
> > helps....
> >
> > "CarlosM" wrote:
> >
> > > 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.
> > >
> > >
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap