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