3.2.3. Installing Microsoft SQL Server
IMPORTANT. Microsoft SQL Server is not supported when you use a server cluster on ARM64 or E2K processors.
The database server is installed from Microsoft SQL Server distribution media.
NOTE. If Microsoft SQL Server 2000 is selected, you need to install Service Pack 2 (Service Pack 4 is recommended) for Microsoft SQL Server 2000 to ensure correct operation of 1C:Enterprise.
The user on whose behalf 1C:Enterprise server accesses MS SQL Server must have the processadmin or sysadmin fixed server role.
Installation information is available in the server documentation:
- Microsoft SQL Server 2005: http://msdn.microsoft.com/ru-ru/library/ms143516(SQL.90).aspxhttp://msdn.Microsoft.com/ru-ru/library/ms143516(SQL.90).aspx.
- Microsoft SQL Server 2008: http://msdn.microsoft.com/ru-ru/library/bb500469(v=sql.100).aspxhttp://msdn.Microsoft.com/ru-ru/library/bb500469(v=sql.100).aspx.
- Microsoft SQL Server 2008 R2: http://msdn.microsoft.com/ru-ru/library/bb500469(v=sql.105).aspxhttp://msdn.Microsoft.com/ru-ru/library/bb500469(v=sql.105).aspx.
- Microsoft SQL Server 2012: http://msdn.microsoft.com/ru-ru/library/bb500469(v=sql.110).aspxhttp://msdn.microsoft.com/ru-ru/library/bb500469(v=sql.110).aspx.
- Microsoft SQL Server 2014: http://msdn.Microsoft.com/ru-ru/library/bb500469(v=sql.120).aspxhttp://msdn.Microsoft.com/ru-ru/library/bb500469(v=sql.120).aspx.
- Microsoft SQL Server 2016: http://msdn.microsoft.com/ru-ru/library/bb500469(v=sql.130).aspxhttp://msdn.microsoft.com/ru-ru/library/bb500469(v=sql.130).aspx.
- Microsoft SQL Server 2017: https://docs.microsoft.com/ru-ru/sql/database-engine/install-windows/install-sql-server?view=sql-server-2017.
- Microsoft SQL Server 2019: https://docs.microsoft.com/ru-ru/sql/database-engine/install-windows/install-sql-server?view=sql-server-ver15.