Setup Web and Database Server

Software Requirements for Database Servers

The database server where you install the Sana Commerce database must meet the software requirements listed in the following table:

Component	Notes
Microsoft SQL Server 2014	Enterprise, Business Intelligence, Standard, Web, Express
Microsoft SQL Management Studio 2014	Enterprise, Business Intelligence, Standard, Web, Express
Microsoft SQL Server 2012 Service Pack 1      -or- Microsoft SQL Server 2012	Enterprise, Business Intelligence, Standard, Web, Express
Microsoft SQL Management Studio 2012	Enterprise, Business Intelligence, Standard, Web, Express
Microsoft SQL Server 2008 R2      -or- Microsoft SQL Server 2008 with Service Pack 1 or later      -or- Microsoft SQL Server 2005 with Service Pack 2 or later	Express, Workgroup, Web, Standard, Enterprise and Datacenter editions are supported Web edition is recommended Express edition can only be used if the database size is under 4GB
Microsoft SQL Management Studio 2008 R2      -or- Microsoft SQL Management Studio 2008      -or- Microsoft SQL Management Studio 2005	Express, Workgroup, Web, Standard, Enterprise and Datacenter editions are supported

• SQL Server and Windows Authentication mode should be enabled for the SQL Server instance.
  
  
• The user who runs the SQL Server service should have 'read' permissions to the folder where the Sana Commerce installer is stored.

Azure SQL Database

Sana Commerce SQL database can be also hosted on Windows Azure. To restore the Sana SQL database to Windows Azure you will be asked to specify the name of your Windows Azure SQL Database instance while installing Sana Commerce.

Service Tiers and Performance Levels
Microsoft Azure SQL Database service tiers have different performance characteristics. If you are going to host the Sana Commerce SQL database on Windows Azure your Azure SQL database should be of a V12 version and Standard/S0 service tier to avoid performance problems.

For more information, see 'Azure SQL Database Service Tiers and Performance Levels' in the Microsoft Library.
For more information about V12 Azure SQL Database, see 'What's new in SQL Database V12'.