How to change database connection in a custom module - Front- & Back-End Development - Front- & Back-End Development - Progress Community
 Front- & Back-End Development

How to change database connection in a custom module

  • 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