Replaced my SQL Server, now need to point Service Connect to it


(system) #1
My mistake...I got myself confused between APM and ESC... APM has the tool.
 
Two ways to do change the DB in ESC. The unofficial and the official.
 
Unofficial: Troll the registry of the machine with ESC installed on it and look for the old database server name or the name of the Service Connect database (I think default is ESCDB)  Then change the associated information (i.e. server name) to the new server, backup and restore the database to the new server. Stop and restart all your ESC services.
 
Official: Backup all of your connections as per the ESC admin manual.  Uninstall then reinstall with the lastest version making sure you point to the new db server, then restore your connections through the admin console.
 
Sorry for the misinformation.
 
Cheers
Simon Hall
 
 
 
 

(system) #2
We got a new SQL Server and got everything install and working with Epicor, but still have not switch Service Connect to communicate with the new SQL server.

Has anyone done this? If so, where do we make that change? I assume it has to be in the Epicor Service Connect Admin Console, but don't know where.

Thanks,
Andrew

(system) #3
I don't actually know where it is, because in the SC Console you are already
connected to the DB.

Easiest thing to do is to back up the DB, and then restore it to the new SQL
server, then do a re-install of service connect. When you do the re-install,
just select the new DB location instead of creating a new DB.

Alternately, you can also just create a new DB and import a complete backup
from your old DB to make sure everything is connected correctly and points
to all the right spots.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Drew
Sent: Saturday, November 02, 2013 4:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Replaced my SQL Server, now need to point Service Connect
to it

We got a new SQL Server and got everything install and working with Epicor,
but still have not switch Service Connect to communicate with the new SQL
server.

Has anyone done this? If so, where do we make that change? I assume it has
to be in the Epicor Service Connect Admin Console, but don't know where.

Thanks,
Andrew



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo Groups Links

(system) #4

If you use web services, you also need to point ws configuration to the correct server location.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ned
Sent: Saturday, November 02, 2013 9:38 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Replaced my SQL Server, now need to point Service Connect to it

 

 

I don't actually know where it is, because in the SC Console you are already
connected to the DB.

Easiest thing to do is to back up the DB, and then restore it to the new SQL
server, then do a re-install of service connect. When you do the re-install,
just select the new DB location instead of creating a new DB.

Alternately, you can also just create a new DB and import a complete backup
from your old DB to make sure everything is connected correctly and points
to all the right spots.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Drew
Sent: Saturday, November 02, 2013 4:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Replaced my SQL Server, now need to point Service Connect
to it

We got a new SQL Server and got everything install and working with Epicor,
but still have not switch Service Connect to communicate with the new SQL
server.

Has anyone done this? If so, where do we make that change? I assume it has
to be in the Epicor Service Connect Admin Console, but don't know where.

Thanks,
Andrew

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo Groups Links


(system) #5
If the name of the SQL server has changed then this will not work.  There are several references inside the ESCDB database to the SQL server instance name.  It is not easy to change these references.


The best option is to do the Service connect backup to scs file, do a clean install and then do a restore from the scs file backup.



(system) #6
Hello,
I believe the information for the SQL ESCDB is in the exe.config file on the machine that ESC is installed on.  There is also a tool (Can’t remember what it is called now) that helps you update the information.  I’ll check on our server when I get to work in the morning and get back to you.
 
Cheers
Simon Hall