How to set the file repository manually

Issue

Sometimes, we have to go into the SQL management studio to set the file repository manually in order to perform a database upgrade. Getting a LinkTaxRates error trying to set repository.

Solution

Run the following query either via admin utility or through SQL management studio

update gen_pref set filelocation = 'location of your repository (fully qualified UNC path)'

 

example.

update gen_pref set filelocation = '\\server\repository'