How to change database connection in a custom module
Hi,
The App.config file of the custom module contains the database connection settings as follows by default.
<connections> <connection id="DatabaseConnection1"> <databasename>Database1</databasename> <servername>(local)\SQLEXPRESS</servername> <integratedSecurity>True</integratedSecurity> <backendconfigurationname>mssqlConfiguration</backendconfigurationname> </connection> </connections>
The above works on a SQL Express instance with Windows Auth. But now I need to change this to install the module on a database on a different server with SQL Authentication. There is a SQL login created with full access to that perticular database instance. Can someone tell me the complete <connections/> block i need to have in the config file of my module to achieve this?
Thanks,
Duneel
Hi Duneel,
if i correctly understand custom module you have nothing to do for connection settings, in fact the module use by default Sitefinity connection in DataConfig.config.
In my case, I just edit servername and databasename and it works nevertheless it's a database with authentification.
Regards,
Nicolas