Script To Change The System Database
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?
-
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\ServiceWhere «CommonApplicationData» depends on the Windows Version you're using:Windows 7Windows VistaWindows Server 2008 C:\ProgramDataWindows XPWindows Server 2003 C:\Documents and Settings\All Users\Application Data3. 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 -
Sweet ...
0 -
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 Bart0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
3 Kommentare