How to Connect to DNN Content Datasource?

Owned by Natalia Sandovska (Unlicensed)
Last updated: Apr 05, 2018 by Support Ilangl
2 min read

To find our more about establishing connection to data source, please check How to connect to Content Data-source article.

DNN MS SQL Connection

This connection is a primary connection to export/import content. iLangL Cloud is using this string to connect directly to Microsoft SQL Server database. 

The process requires connection between Ms SQL server, where DNN content database is hosted, and iLangl Cloud server.

To find our more about connection to SQL server over the Internet, please read a dedicated article: Connecting to SQL Server over the Internet

And watch video:

Parameters:

  • Server (Required) - the name or network address of the instance of SQL Server to which to connect;
  • Port (Optional) - a server port that will be added to the server name  'Server':'Port';
  • User Id (Required) - the SQL Server login account;
  • Password (not always required *) - the password for the SQL Server login account;
  • Database (Required) - name of the database;
  • Table prefix (Optional) - the database table prefix for your CMS installation.

*

In case of Integrated security on customer's side, it is possible to establish connection without password via Local Connection


Here is what the final connection string generated to Content Provider will look like:

Server=[Server]:[Port];Database=[Database];Uid=[User Id];Pwd=[Password];

DNN HTTP Connection

iLangL Cloud imports content to DNN CMS via MS SQL database connection. DNN uses content cache to optimize server workload and increase performance.

When content is imported directly to a database, DNN web application doesn't know about this operation and therefore, it keeps an old content cached.

In order to refresh this cache, you have to set up 'DNN HTTP Connection' using a DNN user account that has permissions to install plugins.

Once system finishes content import, it logs in with the account specified in 'DNN HTTP Connection' and resets cache.

This will ensure that content changes are visible right after import.

Parameters:

  • Server(Required) - web URL of a website (for example company.com);
  • Port(Optional) - website port (for example: if Port = 80, requests will be sent to http://company.com:80);
  • User Id(Required) -  DNN account name;
  • Password(Required) - DNN account password.