Rhys Crombie
Last activity
Member since
Votes
0
Subscriptions
2
Replies

Rhys Crombie commented,
Response from the SLD team. You CAN override the database name, the change we’ve made is to support basic connectivity options that a significant number of users struggled with. We will add a change in to make the ‘change the database name’ simpler by adding back into the new database configuration dialog screen. In the meantime please do the following: Setup your database settings so that it is accessing the correct server. Test your connection Find the file ESFA.DC.ILR.Desktop.WPF.exe.Config Find the line that looks like this: <add key="IlrDatabaseConnectionString" value="Data Source=dct-hal-dev\sqlexpress;Initial Catalog=ILR2021;Integrated Security=True" /> Your server name and connection method may be different Where it says Initial Catalog change the value to what ever you wish <add key="IlrDatabaseConnectionString" value="Data Source=dct-hal-dev\sqlexpress;Initial Catalog=ILR2021_override;Integrated Security=True" /> Save the file. Run FIS Your new database name will be present in the connection string Run and the new database will be created by the process
Response from the SLD team. You CAN override the database name, the change we’ve made is to support basic connectivity options that a significant number of users struggled with. We will add a chang...

Rhys Crombie commented,
Hi Simon, I have enquired to the developers about this. I too used to specify the database name, having to deal with 3 ukprns, and now it is fixed and so undoes everything that i had set up this year. Currently waiting for a response
Hi Simon, I have enquired to the developers about this. I too used to specify the database name, having to deal with 3 ukprns, and now it is fixed and so undoes everything that i had set up this...

Rhys Crombie commented,
a bit late to the party but you can also have the sql connection to point to any server that has sql server installed, providing you have access to that server. SQL server doesn't have to be a local installation on your pc. Our goes direct onto our data warehouse server and all our reports run from there without having to extract data from the fis into another db.
a bit late to the party but you can also have the sql connection to point to any server that has sql server installed, providing you have access to that server. SQL server doesn't have to be a lo...