3.2.3. Installing Microsoft SQL Server
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.