System Database S’abonner

0
Avatar
Legacy Poster

Is there some why to remotely set the system database location? I'm looking at deploying via group policy and have a policy setup to change the service login account. I'd like to be able to set the system database from a script or GP. Couldn't find the setting in the registry so where kept??

4 commentaires

0
Avatar
Domingo Rodriguez
Modérateur
Actions pour les commentaires Permalien

I can show you how to make a manual configuration of the connection to the BT System database. You can then try to partially or fully automate these steps:

 

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

3. Remove the contents within the ConnectionString tag, so that you're left with the following (see before.png):

 

 

4. Insert your desired connection string, as in the following example, and save the file (see after.png):

 

  • 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
Actions pour les commentaires Permalien

I can show you how to make a manual configuration of the connection to the BT System database. You can then try to partially or fully automate these steps:

 

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

3. Remove the contents within the ConnectionString tag, so that you're left with the following (see before.png):

 

 

4. Insert your desired connection string, as in the following example, and save the file (see after.png):

 

  • 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.

Cool, thanks for the solution! Will it work fine if the System Database Setup utility is not run? I would have no way to do this remotely over the network. I'm not concerned about the connection string being encrypted...

0
Avatar
Domingo Rodriguez
Modérateur
Actions pour les commentaires Permalien

I don't think that you can discard step 6. You can test this in order to be 100% sure, but I don't think it will work, because the BarTender System Database wizard needs to confirm the connection string and then connect to the database. 

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

When I open the system database setup it goes directly to the screen that shows I'm connected to the server I configured in the xml file and if I hit cancel instead of ok the file does not get encrypted. This would suggest that it works fine without hitting OK... I'll have to do some additional testing to confirm it's working without step 6 but at the surface it appears so.

Vous devez vous connecter pour laisser un commentaire.