Hi, make sure that the HQ Server is open and listening mode before connecting HQ Client.

try to use HQ Server as windows services and assign different ports and different instances for each store, you can do it with a batch file for assign diferrent potrs and instances and you can use third part software for set HQ server as windows service.

Fernando España

try to use HQ Server as windows services and assign different ports and different instances for each store, you can do it with a batch file for assign diferrent potrs and instances and you can use third part software for set HQ server as windows service.

This theory is interesting to me.  Can you eloborate or give me more infromation on how you do this.  I have 20 stores and I was interested in assigining a different port per store to see if this would improve performance.  Is this why you did it or for other reasons?  Can you also eloborate on how you did it throuh a batch file.  I would think you would have multiple instances of the hqserver running on one server??

Regards,

Mike Cates

. Additional instances of HQServer can be run by passing database and login information through a command line or using a batch file. The format is:

HQServer  -s <servername> -c <catalog name> -u <user id> -p <user password> -a <port address>

For example:

HQServer -s SQLSeverComputer -c HQSample -u sa -p  -a 34200

If you forget the command, run HQServer /? and you will see the usage

format.

Fernando,

 Hey thanks for the information.  I do appreciate it.  Would you mind if I elobrate on my solution and why I ask???

 Ok, here it is. 

I have 20 stores and I poll 10 top of the hour and 10 bottom of the hour.  And I am considering your theory but I would like to know what the advantage is?  Is it for performance, worksheet processing.  HQ errors due to mutil polling????

Just curious, becuase I had a MAJOR issue that MS had to fix after installing SP2 that was a result of the HQ average cacaulation that is actually done at polling.  After MONTHS and MONTHS of working with MS and the FANTASTIC help from Gregg Kosel at Microsoft, it was determined that they changed the way they do that cacualtation and it was actually done at polling.  Long story short we do not use the average function and disabled it and all went back to normal...

 Regards,

Mike Cates

Hi, we has the same problem in the past, but this process help us to solve it. He have 16 super markets like Walmart and using this process on dell 2950 using windows server 2008 and virtualization we created 4 vm runing 4 HQ servers in different lan cards and different ports. He have not problems now.  at same time we move to SQL server 2008 for HQ database and stores and working hard in tunnig running profiles for performance both side and  it's work much better. we are plannig to apply SP in next months becouse some HOOKS are not compatible with encrypt for passwords.  IN my wish list I hope MS change HQ server and Client Structure may be running on WebService, or may be running as Integration Serveces and moving work proces to stored procedures and trigger, but......, this is only in my wish list.

Regards,

Fernando.

This makes most sense, thanks for sharing.

Hi guys,

One of our clients has an issue with HQ Client connection. They use RMS HQ and has three locations. The stores connection schedules are set at ten, fifteen and twenty minute intervals within the hour. The server is set to backup the database multiple times during the day.

Their problem is that the store one HQ Client seems to be getting stuck when all three stores connect on the hour. This does not happen every hour, but it does happen at worst once a day and at best it will happen once every few days.  The message that I see on the HQ Client is "<<Post Message>> Message Timeout."  Once I clear this message I get a general error message that states "An error has occurred, connection will be aborted."

Have any of you encountered this error before? or can anyone advise me what causes this bug and how to fix this?

Any help is greatly appreciated.

Thank you.

Hi Gene,

I had that same issue.

We have 22 stores and I have made five different HQ server with different port number.

Here's the error message I get almost twice a day from each store.

Error #-2147467259

Login timeout expired

(Source: Microsoft OLE DB Provider for SQL Server)

(SQL State : HYT00)

(NativeError : 0)

No Help file available

Anyone know how to fix this issue?

how do we run HQ Server with a different instance?

Hi Gene,

I am having that exact issue on one of my systems now?  I see that no one here directly responded.  Did you end up finding a solution?  If so, would you be willing to share?  Thanks for any help or direction you can provide.

Cheers

Hi Fernando, when you create 4VM running 4HQ servers in different lan card, which OS did you install? Windows Server? or Windows7?

I am currently running a dedicated HQ Server and created 5 different HQ Server with different port numbers. Not using VM and 1 LAN Port for all HQ Servers. Would it make a lot difference using VM and separate LAN port for each HQ Servers?

I am not sure about how quickly get ROI back. I will need to purchase VM license or I can use Hyper-V and purchase separate license for each VM and also upgrade LAN card to multiple LAN port...

We just had the same error 3704. We noticed that SQL service was not running on the HQ server, although the test connection from the HQ client were successful. Turning ON the SQL service fixed the problem.