Zum Hauptinhalt gehen

Suche

Suche

Script To Change The System Database

Kommentare

3 Kommentare

  • Avatar
    Domingo Rodriguez
    Moderator

    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

    Sweet ... 

    0
  • Avatar
    Bart Deman

    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

    0

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