Developer Workstation Installation

Configure the Connection Strings

• Open the 'web.config' file of the 'Sana.Commerce.StarterSite' project in VS2008;
• Locate the 'connectionStrings' configuration section:

  <connectionStrings>    
  <remove name="LocalSqlServer"/>    
  <add name="LocalSqlServer" connectionString="Data Source=SERVERNAME\INSTANCENAME;Initial Catalog=DATABASENAME;User  Id=USERNAME;Password=PASSWORD;"providerName="System.Data.SqlClient"/>    
  <add name="NavisionStandardService" connectionString="NAVSERVICEURL"/>
  </connectionStrings> 
  
  

  In case of using NAV 2009 you should change the standard NAV connection (NavisionStandardService) to the following format: <add name="Nav2009StandardWebService" connectionString="NAV2009WEBSERVICEURL"/> Replace the 'NAV2009WEBSERVICEURL' tag with the following address: #PROTOCOL#://#SERVERNAME#:#PORT#/#NAVINSTANCENAME#/WS/ #COMPANYNAME#/Codeunit/SC_NAV2009_WebService where: #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.

  
  

  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: connectionString="Url=http://domain.com:7047/DynamicsNAV/WS/.. ..CompanyName/Codeunit/SC_NAV2009_WebService; UserName=YourUserName;Password=YourPassword;Domain=YOURDOMAIN;Timeout=100" The additional parameters are optional. The "classic" version of connection string (without specifying any additional parameters) is also supported: connectionString="http://domain.com:7047/DynamicsNAV/WS/.. ..CompanyName/Codeunit/SC_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;
• Locate the 'appSettings' configuration section:
  
  <appSettings>
      <add key="FrontendUrl" value="FRONTENDURL"/>
      <add key="FrontendThumbnailPath" value="/content/images/ProductImages/Small/"/>
      <add key="FrontendImagesContentPath" value="/content/images/content"/> 
      <add key="ThemesContentFolder" value="..\Sana.Commerce.Startersite\content\images\Themes"/>
  </appSettings>
  
  

  For more information about how to extend the connectionStrings section with additional parameters please read the related note above.

  
  

• 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 'FrontendImagesContentPath' specifies the folder which is used for storing the content images.
  Attribute 'ThemesContentFolder' specifies the folder which is used for storing the themes for the website.

• Locate the 'connectionStrings' configuration section: 
  
  <connectionStrings>
      <remove name="LocalSqlServer"/>
      <add name="LocalSqlServer" connectionString="Data Source=SERVERNAME\INSTANCENAME;Initial Catalog=DATABASENAME;User Id=USERNAME;Password=PASSWORD;"/> 
      <add name="NavisionStandardService" connectionString="NAVSERVICEURL"/>
  </connectionStrings>
  
  
• 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: 
  
  <client>
  <endpoint address="BackofficeFrontendUrl/Management/PublishWebService.asmx"
  binding="basicHttpBinding" bindingConfiguration="PublishWebServiceSoap"
  contract="PublishService.PublishWebServiceSoap" name="PublishWebServiceSoap" />
  </client> 
   
• Replace the 'BackofficeFrontendUrl' 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).