HQ Client and invalid store id\connection issue

Posted by Pete on April 27, 2007, 6:00 pm

Please log in for more thread options

Have client with four stores. Running RMS V 2.0.
New store is number 4. Have been able to establish connection to HQ but get
this message on the log:
HQ message contains an invalid storeid connection passowrd.
Although the message is quite clear. Where exactly should we be making the
adjustments?
Thank you veruy much.

Posted by Glenn Adams [MVP - Retail Mgmt on April 27, 2007, 6:07 pm

Please log in for more thread options

2 places:
In HQ Manager, Admin/Stores
Open properties for Store 4 ( I believe you need to be in Maintenence
Mode to do this)
Go to connection Schedule Tab - near the bottom of the tab you can enter
a password - this is unique to each store.

In HQ Client, File/Configuration, HQ Server Tab - enter the same
password you used at HQ Manager...

Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.

Pete wrote:

> Have client with four stores. Running RMS V 2.0.

> New store is number 4. Have been able to establish connection to HQ but get

> this message on the log:

> HQ message contains an invalid storeid connection passowrd.

> Although the message is quite clear. Where exactly should we be making the

> adjustments?

> Thank you veruy much.

Posted by Pete on April 27, 2007, 7:22 pm

Please log in for more thread options

This procedure seems to be specifically if we want to assign a password to
scure the communication with the HQ server. Not sure it applies to what were
are looking for however.
In either case we have matched the database user name and password from the
SO to the HQ. We no longer get the message invalid Store ID / Connection
Password but rather this:
<<ExecuteCommand>> Error -2147467259: [DBNETLIB][ConnectionRead [Wr
also get
<<OpenRsRead>> Error -2147467259: Connection failure.

Any ideas on this!
Currently setup up to connect via internet. HQ has Static Public IP and
router has been configured to HQ Server via port 34777, which has been
matched at the SO.

Thank you very much!
"Glenn Adams [MVP - Retail Mgmt]" wrote:

> 2 places:

> In HQ Manager, Admin/Stores

> Open properties for Store 4 ( I believe you need to be in Maintenence

> Mode to do this)

> Go to connection Schedule Tab - near the bottom of the tab you can enter

> a password - this is unique to each store.

> In HQ Client, File/Configuration, HQ Server Tab - enter the same

> password you used at HQ Manager...

> Glenn Adams

> Tiber Creek Consulting

> http://www.tibercreek.com

> glenn@tibercreek.com

> ----------------------------------------------

> Please DO NOT respond to me directly but post all responses here in the

> newsgroup so that all can share the information.

> Pete wrote:

> > Have client with four stores. Running RMS V 2.0.

> > New store is number 4. Have been able to establish connection to HQ but get

> > this message on the log:

> > HQ message contains an invalid storeid connection passowrd.

> > Although the message is quite clear. Where exactly should we be making the

> > adjustments?

> > Thank you veruy much.

Posted by Glenn Adams [MVP - Retail Mgmt on April 30, 2007, 10:11 am

Please log in for more thread options

The answer I gave before was the solution to the Invalid store number or
password error.

You don't have to have the same UserID/Password at the store as at HQ.
I suspect that in changing it you have mis-configured something -
probably HQ Client, but I can't tell from the truncated error message in
your post.

Check HQ Client, File/Configuration, Database Tab. Try the test
connection button and verify that you are connecting. Also, remember
that the HQ Client should be connecting to a Store DB not an HQ DB.

Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.

Pete wrote:

> This procedure seems to be specifically if we want to assign a password to

> scure the communication with the HQ server. Not sure it applies to what were

> are looking for however.

> In either case we have matched the database user name and password from the

> SO to the HQ. We no longer get the message invalid Store ID / Connection

> Password but rather this:

> <<ExecuteCommand>> Error -2147467259: [DBNETLIB][ConnectionRead [Wr

> also get

> <<OpenRsRead>> Error -2147467259: Connection failure.

> Any ideas on this!

> Currently setup up to connect via internet. HQ has Static Public IP and

> router has been configured to HQ Server via port 34777, which has been

> matched at the SO.

> Thank you very much!

> "Glenn Adams [MVP - Retail Mgmt]" wrote:

>> 2 places:

>> In HQ Manager, Admin/Stores

>> Open properties for Store 4 ( I believe you need to be in Maintenence

>> Mode to do this)

>> Go to connection Schedule Tab - near the bottom of the tab you can enter

>> a password - this is unique to each store.

>> In HQ Client, File/Configuration, HQ Server Tab - enter the same

>> password you used at HQ Manager...

>> Glenn Adams

>> Tiber Creek Consulting

>> http://www.tibercreek.com

>> glenn@tibercreek.com

>> ----------------------------------------------

>> Please DO NOT respond to me directly but post all responses here in the

>> newsgroup so that all can share the information.

>> Pete wrote:

>>> Have client with four stores. Running RMS V 2.0.

>>> New store is number 4. Have been able to establish connection to HQ but get

>>> this message on the log:

>>> HQ message contains an invalid storeid connection passowrd.

>>> Although the message is quite clear. Where exactly should we be making the

>>> adjustments?

>>> Thank you veruy much.