Configure the Connection Strings

In the previous steps you have set up the Sana Commerce SQL
database and optionally also the NAS. Now you have to configure the
Sana Commerce website and backoffice web applications so they can
connect to these data stores.

Open the 'web.config' file of the
'Sana.Commerce.StarterSite' project in
VS2008;

#PROTOCOL#: the protocol which is used for connecting to the
NAV 2009 service (HTTP or HTTPS).
#SERVERNAME#: the name or IP address of the developer workstation
running the NAV 2009 Server service.
#PORT#: the port number to which the Sana Commerce NAV service is
listening.
#NAVINSTANCENAME#: NAV 2009 service instance name.
#COMPANYNAME#: The name of the company in NAV 2009 database. Please
read about the rules for encoding the special characters in company
names as part of a URL here: http://msdn.microsoft.com/en-us/library/ee414220.aspx.

If you need to specify the user who will be connected to
the NAV Webservice do the following:

The connectionString attribute in the
connectionStrings section can be extended
with additional information about UserName,
Domain, and Password;

Now it is possible to specify Timeout for the connection. If
this parameter is not specified, the default value (60 sec) will be
used.
(The NAS service can be extended only with 'Timeout'
parameter, for example: 'Url=http://#PROTOCOL#://#SERVERNAME#:#PORT#/navision;Timeout=600'
);

These additional parameters and their values must be separated
by semicolon.

Below you can see an example of the extended connection string
for NAV2009 webservice:

Replace the following tags:
#SERVERNAME\INSTANCENAME#: the database server name or IP address
of the SQL database server and optionally the SQL server instance
name. For example, DEV-UA-WS003\SQLEXPRESS used in 'Setup
the SQL Database'.
#DATABASENAME#: the name of the SQL database used in 'Setup
the SQL Database'.
#USERNAME#: the database username used in 'Setup
the SQL Database'.
#PASSWORD#: the password of the database user.
#NAVSERVICEURL#: this tag has the following form:
"#WCFPROTOCOL#://#NASSERVER#:#NASPORTNUMBER#/navision"

where:
#WCFPROTOCOL#: the protocol which is used for connecting to the WCF
service (HTTP or HTTPS)
#NASSERVER#: the name or IP address of the server running the NAS
used in 'Configure
the NAS'. When running the Sana Commerce startup code unit from
the NAV client enter 127.0.0.1.
#NASPORTNUMBER#: the port number to which the Sana Commerce NAV
service is listening. For NAV with Pebblestone Fashion module the
default port number is 6001, for NAV Standard it is 6002;

Open the 'web.config' file of the
'Sana.Commerce.BackOffice' project in VS2008;

Replace the #FRONTENDURL# tag, which should have the following
form:
"#PROTOCOL#://#WEBSITEDOMAINNAME#:#PORT#"

where:
#PROTOCOL#: the protocol which is used for connecting to
the SC website (HTTP or HTTPS)
#WEBSITEDOMANINAME#: the website address that is registered in the
DNS servers of your network.
#PORT# (optional): the port number when it is not the default HTTP
port number (80).

Attribute 'FrontendThumbnailPath' specifies the path to the folder
which is used for storing the product images.
Attribute 'FrontendContentPath' specifies the folder which is used
for storing the content files.

Replace the following tags:
#SERVERNAME\INSTANCENAME#: the database server name or IP address
of the SQL database server and optionally the SQL server instance
name. e.g. DEV-UA-WS003\SQLEXPRESS used in 'Setup
the SQL Database'.
#DATABASENAME#: the name of the SQL database used in 'Setup
the SQL Database'.
#USERNAME#: the database username used in 'Setup
the SQL Database'.
#PASSWORD#: the password of the database user.
#NAVSERVICEURL#: this tag has the following form:
"#WCFPROTOCOL#://#NASSERVER#:#NASPORTNUMBER#/navision"

where:
#WCFPROTOCOL#: the protocol which is used for connecting to the WCF
service (HTTP or HTTPS)
#NASSERVER#: the name or IP address of the server running the NAS
used in 'Configure
the NAS'. When running the Sana Commerce startup code unit from
the NAV client enter 127.0.0.1.
#NASPORTNUMBER#: the port number to which the Sana Commerce NAV
service is listening. For NAV with Pebblestone Fashion module the
default port number is 6001, for NAV Standard it is 6002.

In case of using NAV 2009 you should change
the default connection string and configure it instead of
the original one. You can read about it in the note earlier in this
step.

Locate the 'client' configuration section under the
'system.serviceModel' node:

Replace the 'FrontendUrl' address part, which should have
the following form:

"#WCFPROTOCOL#://#WEBSITEDOMAINNAME#:#PORT#"
where:

#WCFPROTOCOL#: the protocol which
is used for connecting to the WCF service (HTTP or HTTPS)
#WEBSITEDOMANINAME#: the website address that is registered in the
DNS servers of your network.
#PORT# (optional): the port number when it is not the default
HTTP port number (80).

Product Versions

Sana Software Links

Sana Commerce does not accept any liability for the content of this website, or for the consequences of any actions taken on the basis of the information provided. The information below should be interpreted as an example. No rights can be derived from this information.
Sana Software – e-Commerce for Microsoft Dynamics