Changing location of SQL Server

[Brewhaus]

Because of changes that we are making to our server, we will likely be moving our website locations onto a second server or virtual machines. However, the location of our SQL Server will not change. How do we go about changing in our AC site where it goes to access the db?

[ryanstowasser]

How do we go about changing in our AC site where it goes to access the db?

If you are on the same LAN you should not have to change anything regarding the connectionstring.

When I moved one of my installs, I ran in to an encryption problem.

If you have the Encryption running for your database connection string and Purchase information, you will want to make sure you decrypt your site before you move your files.If you don't, you'll lose your database.config file, your encryption.config file will need to be deleted and you also loose access to any payment information that is stored in your database.

Below are a couple of links I found helpful.

http://help.ablecommerce.com/faqs/ablec ... ation_.htm

viewtopic.php?f=42&t=8296&p=35373&hilit ... ite#p35373

[nickc]

If you are on the same LAN you should not have to change anything regarding the connectionstring.

There's a big performance hit if the DB server is NOT local. Do whatever you can to avoid that.

[Brewhaus]

Nick- would this also be the case if AC is on a virtual machine on the same 'box'? I assume not, but am not familiar enough with SQL to know.

We recently entered an encryption key for the site (just via the admin menu). Again making an assumption- if we move everything to a new server this should not matter, should it?

Lastly, again assuming a partial move, does the AC site have to reside on a server that physically handles e-mail? The options that we have looked at with Server 2008 are a bit of a mess (SBS is no longer set up to connect directly to the internet, other versions do not include Exchange).