|
Posts: 34
Joined: August 2010
|
|
#48740
09/25/2012 11:34 AM
|
Joined: Aug 2012
Posts: 395
Member
|
OP
Member
Joined: Aug 2012
Posts: 395 |
Hi,
We went from hosting AC on a Windows 7 Pro machine to a server running SBS 2011 Essentials. I followed Sandeep's hardware/setup instructions to the letter, and it looks like the server is up and running fine.
So the next question is: what's the best way to move the AC data over to the SBS server? Is it just a matter of backing up the data using the AC backup routine and then restoring the data on the server using the AC restore function?
Also, how do I "point" the client computers to look for the database on the SBS server?
Thanks in advance.
Gianni
|
|
|
|
|
Joined: Jun 2009
Posts: 1,811
Member
|
|
Member
Joined: Jun 2009
Posts: 1,811 |
Moving the data is easy - pull a backup, then copy that file to the new machine and restore it on the new machine. Use the Backup/Restore Utility application.
|
|
|
|
|
Joined: Jun 2009
Posts: 1,811
Member
|
|
Member
Joined: Jun 2009
Posts: 1,811 |
If you have Imported Items, you just copy that directory over to the new server.
This all is based on using the same installer that you used on the previous machine so that you aren't doing a database upgrade at the same time.
|
|
|
|
|
Joined: Aug 2012
Posts: 395
Member
|
|
OP
Member
Joined: Aug 2012
Posts: 395 |
Thank you. Seems straightforward enough. How do we setup the client computers to look for the AC data on the new server?
Gianni
|
|
|
|
|
Joined: Jun 2009
Posts: 1,811
Member
|
|
Member
Joined: Jun 2009
Posts: 1,811 |
You have options:
1> Contact support and they will do it for you.
2> Edit the AmazingCharts.xml file (in the client AC Programs folder)
3> Rename the .xml file so that AC prompts you for the server location when you start AC
For all of the above, the server will need the proper firewall settings done, proper share permissions, and proper directory permissions to allow users access to the AC directories.
It is discussed elsewhere, but one of the benefits of a server-based implementation is being able to apply permissions to groups, and assigning each user a individual login and making that login part of the AC users group - easier to administrate, and more secure by default.
|
|
|
|
|
Joined: Apr 2011
Posts: 2,316 Likes: 2
G Member
|
|
G Member
Joined: Apr 2011
Posts: 2,316 Likes: 2 |
Part 4 of the series also tells you how to join client computers to the domain as well as pointing it to the AC Database. http://amazingcharts.com/ub/ubbthreads.php/topics/41344/SBS_Essentials_Installation#Post41344Moving to a New Computer
To transfer to the new computer. Do not copy any program directories directly to the new server.
1) Backup all FILES (.docs, .xls, .etc)
2) Run AC Backup Utility, include everything Imports, Signatures, etc.
3) Install new computers with desired programs, latest updates, etc. and copy files ONLY back
4) Install Amazing Charts latest version
5) Run Amazing Charts from the Program Files folder as an ADMINISTRATOR (Do not click the icon on your desktop)
C:\Program Files\Amazing Charts (32 bit/x86)
C:\Program Files (x86)\Amazing Charts (64 bit/x64)
6) Enter some bogus data temporarily during the setup wizard
7) Close AC and open the Amazing Charts Program folder again from above
8) Run the Backup Restore Utility and browse to your database (full .enc file) (you need the admin password)
9) After restore is complete, run AC as an administrator again. Login to verify information is present.
|
|
|
|
|
Joined: Aug 2012
Posts: 395
Member
|
|
OP
Member
Joined: Aug 2012
Posts: 395 |
Thanks much.
Re Remote Web Access, I set it up using Sandeep's video and have forwarded port 443, but I'm still getting "The domain name was not set up for your server. Wait a few minutes and run the wizard again..."
I know that video said to be patient, but I set this up about 4 hours ago. Is this normal?
Gianni
|
|
|
|
|
Joined: Apr 2011
Posts: 2,316 Likes: 2
G Member
|
|
G Member
Joined: Apr 2011
Posts: 2,316 Likes: 2 |
Lol I absolutely prefer public certificates over self-signed. In Essentials Microsoft issues you a free public certificate on their domain. It's a lot less complicated and you don't have to go through a CA and generate the CSR. Try it locally first. See if you get anything. Check to see if port 443 is open too: http://www.yougetsignal.com/tools/open-ports/
|
|
|
|
|
Joined: Sep 2003
Posts: 12,899 Likes: 34
Member
|
|
Member
Joined: Sep 2003
Posts: 12,899 Likes: 34 |
Damn, I keep trying to disagree with you and just can't.
Bert
Pediatrics
Brewer, Maine
|
|
|
|
|
Joined: Aug 2012
Posts: 395
Member
|
|
OP
Member
Joined: Aug 2012
Posts: 395 |
Hi,
From the Launch Pad, I can connect to the computers in the domain, no problem.
The port testing site says that I have 443 open.
I'll try again tomorrow.
Gianni
|
|
|
|
|
Joined: Apr 2011
Posts: 2,316 Likes: 2
G Member
|
|
G Member
Joined: Apr 2011
Posts: 2,316 Likes: 2 |
This might sound stupid, but make sure you include the https:// prefix when you type the site. e.g. https://domain.remotewebaccess.comYou can't just type domain.remotewebaccess.com
|
|
|
|
|
Joined: Sep 2003
Posts: 12,899 Likes: 34
Member
|
|
Member
Joined: Sep 2003
Posts: 12,899 Likes: 34 |
That would be easy, lol. I recall trying to get RWW to work on 2003. Took me over a month. But, that was with a Cisco PIX. Just slightly harder.
Bert
Pediatrics
Brewer, Maine
|
|
|
|
|
Joined: Aug 2012
Posts: 395
Member
|
|
OP
Member
Joined: Aug 2012
Posts: 395 |
Well, stupid is as stupid does. It worked, lol.
Can't thank you guys and gals enough!
Gianni
|
|
|
|
|
Joined: Apr 2011
Posts: 2,316 Likes: 2
G Member
|
|
G Member
Joined: Apr 2011
Posts: 2,316 Likes: 2 |
Great ha.
You may want to use a link shortner like tinyurl or bit.ly instead of the full link.
e.g. "bit.ly/gobruins" so you don't have to type "https://gobruins.remotewebaccess.com"
|
|
|
|
|
Joined: Sep 2003
Posts: 12,899 Likes: 34
Member
|
|
Member
Joined: Sep 2003
Posts: 12,899 Likes: 34 |
Or you can buy your own and get rid of the remotewebaccess. https://gobruins.comand gb@gobruins.com
Bert
Pediatrics
Brewer, Maine
|
|
|
|
|
Joined: Apr 2011
Posts: 2,316 Likes: 2
G Member
|
|
G Member
Joined: Apr 2011
Posts: 2,316 Likes: 2 |
Then you have to buy the SSL Certificate to go with it ha.
|
|
|
|
|
Joined: Aug 2012
Posts: 395
Member
|
|
OP
Member
Joined: Aug 2012
Posts: 395 |
Okay - probably not the right forum, but I'm going to ask it here because you guys seem to be so knowledgeable:
What billing interface do you recommend? Right now, we're leaning toward Office Ally, but I want a solution that's well-integrated, easy, and reliable, even if it's pay-to-play.
Gianni
|
|
|
|
|
Joined: Sep 2003
Posts: 12,899 Likes: 34
Member
|
|
Member
Joined: Sep 2003
Posts: 12,899 Likes: 34 |
Bert
Pediatrics
Brewer, Maine
|
|
|
|
|
Joined: Apr 2011
Posts: 2,316 Likes: 2
G Member
|
|
G Member
Joined: Apr 2011
Posts: 2,316 Likes: 2 |
Probably best to start a new topic for that one.
Having a domain name is a good idea if you plan on adding a website or email. For us Standard users, we had to buy the domain name anyways and the SSL certificate for the email system. In Essentials, it's only used for RWA, so it's not a big deal if you don't have one.
|
|
|
|
0 members (),
109
guests, and
36
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
.png "ACUF Donor I")
