Script To Change The System Database Folgen

0
Avatar
Legacy Poster

If we move the system database to another SQL server is there a script that can be written and pushed down to computers so that we do not need to touch every installation of Bartender and change where the database resides manually?

3 Kommentare
0
Avatar
Domingo Rodriguez
Moderator
Aktionen für Kommentare Permalink

I can give you the instructions on how to manually configure the connection to the system database. Some of these steps can probably be scripted / automated:

 

 

1. Using Windows' "Services" control panel, stop the BarTender System Service:
 
2. Open the Bartender System Service configuration file, "Config.xml", with a text editor.  This can be found in:
«CommonApplicationData»\Seagull\System\Service
 
Where «CommonApplicationData» depends on the Windows Version you're using:
 
Windows 7 
Windows Vista 
Windows Server 2008     C:\ProgramData
 
Windows XP 
Windows Server 2003     C:\Documents and Settings\All Users\Application Data
 
3. Remove the contents within the ConnectionString tag, so that you're left with the following:
 
....
    <ConnectionString>
    </ConnectionString>
....
 
4. Insert your desired connection string and save the file:
 
** If a Windows Login is used, the connection string must also contain “Integrated Security=SSPI"
 
5. Start the Bartender System Service from the Windows Services control panel.
 
6. Run the System Database Setup utility again.  This will accomplish two things: It will allow you to confirm that you've correctly entered your connection string, and that you're now connected to the desired database. Your connection string will be re-encrypted once you press "OK" and exit the System Database Setup utility.
0
Avatar
Legacy Poster
Aktionen für Kommentare Permalink

Sweet ... 

0
Avatar
Bart Deman
Aktionen für Kommentare Permalink

Hi

I've tried the solution suggested by Domingo Rodriguez but when I go to the Administrative Console I get:

 I'm performing my test by creating a database using the database wizard. Then replacing the content inside the "connection string" tags with:
Server=<local host>\BarTender;Database=<departement name>;Trusted_Connection=True;Integrated Security=SSPI;
where <local host> and <departement name> are the name of my laptop and the name of a database.

Any suggestions? I'm using BT 2016 R3 version 11.0.3.3094 (64-bit). It is a trial version of the Enterprise Automation. I'm preparing a migration path for an upgrade of BT10.1 to BT2016. My goal is to give each departement their own BarTender database. By using a group policy I want to change the config.xml so that the correct database is choosen.

Kind regards
Deman Bart

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.