How to learn who reads my blog?
QuickBooks client over VPN
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What can I do?
• What to Read?
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Зарегистрируйся!

QAIX > Software, Computer Help > QuickBooks client over VPN 28 July 2008 16:43:43

  Recent blog posts: 
  They have birthday today: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Moderators:

QuickBooks client over VPN

Mark St Laurent 28 July 2008 16:43:43
 We have set up a gateway to gateway VPN between QuickBooks Enterprise server
site and wish to connect remote client at another site. Standard windows
file transfer averages 30k/sec. Fractional T1 @ 256K on server side standard
ADSL on the client side. Opening quick books client very slow. I am not that
familiar with bandwidth requirements for this app and realize that an RDP or
term services session may be faster but is this really necessary. Can it not
be accomplished over VPN, as it would on the local LAN and what would be
reasonable in terms of bandwidth requirements. I know this is more of a
networking question. I am hoping that others in this group who have also
expanded their businesses and use QuickBooks could shed some light on this
issue.


Add comment
Mike Schumann 22 February 2005 22:44:18 permanent link ]
 Terminal Server is the ONLY way to go. If you have a normal QBooks client
connection over a VPN link, and the link goes down, you have a very good
chance that your QBooks database will be corrupted. Terminal Server solves
this problem.

There is nothing you can do to make performance on this type of a connection
acceptable. With large QBooks files (150+MBytes), performance becomes a big
issue even on 10MBPS LANs.

Mike Schumann

"Mark St Laurent" <stormrunner'_remov­ethis'@comcast.net> wrote in message
news:qAKSd.8345$Pz7­.6826@newssvr13.news­.prodigy.com...> We have set up a gateway to gateway VPN between QuickBooks Enterprise > server site and wish to connect remote client at another site. Standard > windows file transfer averages 30k/sec. Fractional T1 @ 256K on server > side standard ADSL on the client side. Opening quick books client very > slow. I am not that familiar with bandwidth requirements for this app and > realize that an RDP or term services session may be faster but is this > really necessary. Can it not be accomplished over VPN, as it would on the > local LAN and what would be reasonable in terms of bandwidth requirements. > I know this is more of a networking question. I am hoping that others in > this group who have also expanded their businesses and use QuickBooks > could shed some light on this issue.>


Add comment
JerryMouse 22 February 2005 23:06:13 permanent link ]
 Mark St Laurent wrote:> We have set up a gateway to gateway VPN between QuickBooks Enterprise> server site and wish to connect remote client at another site.> Standard windows file transfer averages 30k/sec. Fractional T1 @ 256K> on server side standard ADSL on the client side. Opening quick books> client very slow. I am not that familiar with bandwidth requirements> for this app and realize that an RDP or term services session may be> faster but is this really necessary. Can it not be accomplished over> VPN, as it would on the local LAN and what would be reasonable in> terms of bandwidth requirements. I know this is more of a networking> question. I am hoping that others in this group who have also> expanded their businesses and use QuickBooks could shed some light on> this issue.

An alternative solution, perhaps, is remote access. That way nothing but the
screen and keyboard have to move over the network (and the mouse).


Add comment
Gary 23 February 2005 00:55:43 permanent link ]
 "JerryMouse" <nospam@bisusa.com>­ wrote in message
news:111n96e36ga3j3­e@news.supernews.com­...> Mark St Laurent wrote:> > We have set up a gateway to gateway VPN between QuickBooks Enterprise> > server site and wish to connect remote client at another site.> > Standard windows file transfer averages 30k/sec. Fractional T1 @ 256K> > on server side standard ADSL on the client side. Opening quick books> > client very slow. I am not that familiar with bandwidth requirements> > for this app and realize that an RDP or term services session may be> > faster but is this really necessary. Can it not be accomplished over> > VPN, as it would on the local LAN and what would be reasonable in> > terms of bandwidth requirements. I know this is more of a networking> > question. I am hoping that others in this group who have also> > expanded their businesses and use QuickBooks could shed some light on> > this issue.>
An alternative solution, perhaps, is remote access. That way nothing but
screen and keyboard have to move over the network (and the mouse).>

I recently switched a client over to terminal services from PCAnywhere, and
they are very happy with the result. Unless the location I was helping
didn't have a Windows Server, I wouldn't do it any other way.

Gary


Add comment
Mike Schumann 24 February 2005 02:49:15 permanent link ]
 If someone can't afford Windows Server, a poor man's approach is to set up a
computer running Windows XP Pro using the built in Remote Access capability.
This is identical to running a Terminal Server, except that a user can't be
logged on to the computer's console if someone is using the machine remotely
(and vis versa).

Mike Schumann
mike@traditions.com­

"Gary" <gmegerer@yahoo.com­> wrote in message
news:p­SNSd.5423$v31­.2138@fe04.lga...> "JerryMouse" <nospam@bisusa.com>­ wrote in message> news:111n96e36ga3j3­e@news.supernews.com­...>> Mark St Laurent wrote:>> > We have set up a gateway to gateway VPN between QuickBooks Enterprise>> > server site and wish to connect remote client at another site.>> > Standard windows file transfer averages 30k/sec. Fractional T1 @ 256K>> > on server side standard ADSL on the client side. Opening quick books>> > client very slow. I am not that familiar with bandwidth requirements>> > for this app and realize that an RDP or term services session may be>> > faster but is this really necessary. Can it not be accomplished over>> > VPN, as it would on the local LAN and what would be reasonable in>> > terms of bandwidth requirements. I know this is more of a networking>> > question. I am hoping that others in this group who have also>> > expanded their businesses and use QuickBooks could shed some light on>> > this issue.>>
An alternative solution, perhaps, is remote access. That way nothing but> the>> screen and keyboard have to move over the network (and the mouse).>>
I recently switched a client over to terminal services from PCAnywhere, > and> they are very happy with the result. Unless the location I was helping> didn't have a Windows Server, I wouldn't do it any other way.>
Gary>


Add comment
Mark St Laurent 24 February 2005 03:43:28 permanent link ]
 Thanks for the info. I know I used quite a few acronyms in the original post
but I did indicate that I was aware this could be accomplished using
RDP("Windows XP Pro using the built in Remote Access capability") or,
TermServices depending on the QB server level. It seems that 2005 directly
supports and 2003 requires a couple of work arounds. My question was with
using Direct File access through VPN. The consensus seems to indicate that
the database requirements for bandwidth preclude this as an option. We will
probably be going with either RDP or VNC over VPN. If the previous posts
regarding bandwidth requirements are inaccurate which I doubt, possably
someone could post what reasonable requirements are necessary for the direct
access option. Your, previous post indicated that you have experienced
problems with 10 MBPS Lan which is infinitely faster than any remote
connection we could or would afford.
Again thanks for your time I have no experience with QB and the input from
this forum has saved me from recommending connection upgrades that would be
marginal at best and possably result in a corrupted database.
"Mike Schumann" <mike-nospam@tradit­ions-nospam.com> wrote in message
news:%D8Td.9693$x53­.2134@newsread3.news­.atl.earthlink.net..­.> If someone can't afford Windows Server, a poor man's approach is to set up > a computer running Windows XP Pro using the built in Remote Access > capability. This is identical to running a Terminal Server, except that a > user can't be logged on to the computer's console if someone is using the > machine remotely (and vis versa).>
Mike Schumann> mike@traditions.com­>
"Gary" <gmegerer@yahoo.com­> wrote in message > news:p­SNSd.5423$v31­.2138@fe04.lga...>> "JerryMouse" <nospam@bisusa.com>­ wrote in message>> news:111n96e36ga3j3­e@news.supernews.com­...>>> Mark St Laurent wrote:>>> > We have set up a gateway to gateway VPN between QuickBooks Enterprise>>> > server site and wish to connect remote client at another site.>>> > Standard windows file transfer averages 30k/sec. Fractional T1 @ 256K>>> > on server side standard ADSL on the client side. Opening quick books>>> > client very slow. I am not that familiar with bandwidth requirements>>> > for this app and realize that an RDP or term services session may be>>> > faster but is this really necessary. Can it not be accomplished over>>> > VPN, as it would on the local LAN and what would be reasonable in>>> > terms of bandwidth requirements. I know this is more of a networking>>> > question. I am hoping that others in this group who have also>>> > expanded their businesses and use QuickBooks could shed some light on>>> > this issue.>>>
An alternative solution, perhaps, is remote access. That way nothing but>> the>>> screen and keyboard have to move over the network (and the mouse).>>>
I recently switched a client over to terminal services from PCAnywhere, >> and>> they are very happy with the result. Unless the location I was helping>> didn't have a Windows Server, I wouldn't do it any other way.>>
Gary>>


Add comment
*Watt 26 February 2005 20:31:46 permanent link ]
 Mark,

We have use a VPN, and the bandwidth is nowhere near what is necessary to
handle an app like Quickbooks. (Although Quickbooks is not our only
offender.)

We have successfully used QB with : Terninal Server on Win2000 and Win2003
servers, the XP remote access, and PC Anywhere.

The terminal server approach is by far the fastest, cleanest, most secure,
and most reliable.

You might check out the previous threads on installation and configuration
of QB on the terminal server.

*Watt

"Mark St Laurent" <stormrunner'_remov­ethis'@comcast.net> wrote in message
news:qAKSd.8345$Pz7­.6826@newssvr13.news­.prodigy.com...> We have set up a gateway to gateway VPN between QuickBooks Enterprise > server site and wish to connect remote client at another site. Standard > windows file transfer averages 30k/sec. Fractional T1 @ 256K on server > side standard ADSL on the client side. Opening quick books client very > slow. I am not that familiar with bandwidth requirements for this app and > realize that an RDP or term services session may be faster but is this > really necessary. Can it not be accomplished over VPN, as it would on the > local LAN and what would be reasonable in terms of bandwidth requirements. > I know this is more of a networking question. I am hoping that others in > this group who have also expanded their businesses and use QuickBooks > could shed some light on this issue.>


Add comment
Z Man 5 March 2005 07:08:59 permanent link ]
 
"*Watt" <GAGJVXTCIXGM@spamm­otel.com> wrote in message
news:6o2Ud.16528$ds­.3277@okepread07...>­ Mark,>
We have use a VPN, and the bandwidth is nowhere near what is necessary to > handle an app like Quickbooks. (Although Quickbooks is not our only > offender.)>
We have successfully used QB with : Terninal Server on Win2000 and Win2003 > servers, the XP remote access, and PC Anywhere.>
The terminal server approach is by far the fastest, cleanest, most secure, > and most reliable.>
You might check out the previous threads on installation and configuration > of QB on the terminal server.

QuickBooks versions prior to Enterprise don't support Terminal Services.
Some users have gotten it to work, but if you fry your data, don't complain
to Intuit. Be careful out there...


Add comment
Mike Schumann 5 March 2005 09:28:11 permanent link ]
 Yes, QBooks Pro is NOT officially supported on Terminal Server. However, if
you understand how Terminal Server works, and you have the 5 user pack (if
you are interested in having more than one simultaneous QBooks session on
the Terminal Server), you shouldn't have any problem making this work.

If you do run into problems, QBooks won't run. I've never heard of anyone
"frying" their data while using Terminal Server.

Mike Schumann

"Z Man" <z1z@hotmail.com> wrote in message
news:SqaWd.29099$th­3.28510@fe08.lga...>­
"*Watt" <GAGJVXTCIXGM@spamm­otel.com> wrote in message > news:6o2Ud.16528$ds­.3277@okepread07...>­> Mark,>>
We have use a VPN, and the bandwidth is nowhere near what is necessary to >> handle an app like Quickbooks. (Although Quickbooks is not our only >> offender.)>>
We have successfully used QB with : Terninal Server on Win2000 and >> Win2003 servers, the XP remote access, and PC Anywhere.>>
The terminal server approach is by far the fastest, cleanest, most >> secure, and most reliable.>>
You might check out the previous threads on installation and >> configuration of QB on the terminal server.>
QuickBooks versions prior to Enterprise don't support Terminal Services. > Some users have gotten it to work, but if you fry your data, don't > complain to Intuit. Be careful out there...>


Add comment
*Watt 5 March 2005 23:37:00 permanent link ]
 Z Man,

You a shill for Intuit ?

The question related to shedding light on how people are remotely accessing
the QB over a VPN.

As someone who has used QB on Terminal Services, used QB over PC Anywhere,
used QB over a WinXP RDP connection, AND discussed these with Intuit tech
support......I think I can throw in my two cents !

The enterprise version is definitely NOT needed. I have been using the QB
Pro 5 user since 2001 and have zero problems.

Now we might discuss the need to have suitable backups for your data due to
drive failure, fire, tsunami, user idiocy, etc.....All of these are more
likely than data being "fried" from terminal services use.

Cheers, and I won't complain,

*Watt

"Lets shed light, not heat...."





"Z Man" <z1z@hotmail.com> wrote in message
news:SqaWd.29099$th­3.28510@fe08.lga...>­
"*Watt" <GAGJVXTCIXGM@spamm­otel.com> wrote in message > news:6o2Ud.16528$ds­.3277@okepread07...>­> Mark,>>
We have use a VPN, and the bandwidth is nowhere near what is necessary to >> handle an app like Quickbooks. (Although Quickbooks is not our only >> offender.)>>
We have successfully used QB with : Terninal Server on Win2000 and >> Win2003 servers, the XP remote access, and PC Anywhere.>>
The terminal server approach is by far the fastest, cleanest, most >> secure, and most reliable.>>
You might check out the previous threads on installation and >> configuration of QB on the terminal server.>
QuickBooks versions prior to Enterprise don't support Terminal Services. > Some users have gotten it to work, but if you fry your data, don't > complain to Intuit. Be careful out there...>


Add comment
Guest 28 July 2008 16:43:43 permanent link ]
 three years later... Still a problem?
Since I've got client still experiencing this problem, I take it Intuit has not seen fit to address this basic design flaw. The physical proximity of client to server should not be an issue. Whether they be connected by LAN, WAN, VPN, ISDN, or a dialupnetworking connection, no client server application should ever need to transfer the entire database to the client for the purposes of logging in, or entering transactions. Even multi-year reports based on tens of thousands of datapoints, if designed properly using a database server, will return only what the user can read in a single sitting.

If I'm mistaken, could someone please update this thread with a link to a patch or kb item?
If not, could Intuit please put some resources on this?

Thanks,
S:)­
Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.


QAIX > Software, Computer Help > QuickBooks client over VPN 28 July 2008 16:43:43

see also:
Allowing Acrobat Reader to save and…
unscribe
[Fwd: print and close a document]
пройди тесты:
see also:
Blackfriday&Cybermonday special…
'Jasper' Xbox 360s finally availabl...
Nintendo makes $6 profit on each Wii…

  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .