How to change database connection in a custom module

Posted by Community Admin on 05-Aug-2018 17:39

How to change database connection in a custom module

All Replies

Posted by Community Admin on 23-Feb-2011 00:00

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

Posted by Community Admin on 23-Feb-2011 00:00

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

This thread is closed