Using 1C:Enterprise with MS SQL Server

To configure the use of 1C:Enterprise in Yandex.Cloud, you need to create a working server, a license server, and a database server. 1C servers will be running Windows Server Datacenter 2019 and the DB server will be running MS SQL Server 2016.

To configure 1C:Enterprise servers:

1. Before you start.
2. Required paid resources.
3. Prepare the infrastructure.
4. Create a VM for the 1C:Enterprise server and license server.
5. Create a VM for the infobase.
6. Set up a server cluster.
7. Set up the license server.
8. Set up the SQL Server.
9. Set up the infobase.
10. Connect to the infobase.

If you no longer need the created resources, delete them.

Before you start

Before deploying the server, you need to sign up for Yandex.Cloud and create a billing account:

1. Go to the management console. Then log in to Yandex.Cloud or sign up if don't already have an account.
2. On the billing page, make sure you linked a billing account, and it has the ACTIVE or TRIAL_ACTIVE status. If you don't have a billing account, create one.

If you have an active billing account, you can create or select a folder to run your VM in from the Yandex.Cloud page.

Learn more about clouds and folders.

Required paid resources

The infrastructure support cost for 1C-Enterprise in Yandex.Cloud includes:

• A fee for the disks and continuously running VMs (see Yandex Compute Cloud pricing).
• A fee for the continuously running Managed Service for PostgreSQL cluster (see pricing for Yandex Compute Cloud)
• A fee for using a dynamic or static external IP address (see Yandex Virtual Private Cloud pricing).

Prepare the infrastructure

1. Make sure that you install the 1C:Enterprise client to check the performance of the infobase and the 1C administration console to manage the server cluster on your computer.
2. Make sure you have a VM running in your cloud with OpenVPN configured for a secure connection to the 1C servers.

Create a VM for the 1C:Enterprise server and license server

Create two VMs: one for the 1C:Enterprise working server and one for the license server. Install the 1C:Enterprise license on a separate server. This way changes to the configuration of other servers won't affect the installed license.

Create two VMs for the 1C server and the license server:

1. On the folder page in the management console, click Create resource and select Virtual machine.

2. In the Name field enter the VM name server-1c for the 1C:Enterprise server and license-server-1c for the license server.

3. Select the availability zone to host the VM in.

4. Under Images from Cloud Marketplace, click Select. Select the Windows 2016 Datacenter public image.

5. Under Computing resources:

   • Choose a platform.
   • Specify the number of vCPUs and amount of RAM:
     • vCPU: 4.
     • Guaranteed vCPU share: 100%.
     • RAM: 8 GB.

6. Under Network settings, select the network and subnet to connect the VMs to. Both VMs must reside in the same subnet. If you don't have a network or subnet, create them right on the VM creation page.

7. In the Public address field, leave the value No address. The VM will be accessed via the OpenVPN server.

8. In the Access section Password field, specify the administrator's password to access the VM.

9. Click Create VM.

Create a VM for the infobase

The infobase will be running the MS SQL Server DBMS and be located on a separate VM.

To create an infobase VM:

1. On the folder page in the management console, click Create resource and select Virtual machine.

2. In the Name field, enter the VM name: mssql-1c-server.

3. Select the availability zone to host the VM in.

4. Under Images from Cloud Marketplace, click Select. Select the SQL Server 2016 Standard public image.

5. Under Computing resources:

   • Choose a platform.
   • Specify the number of vCPUs and amount of RAM:
     • vCPU: 4.
     • Guaranteed vCPU share: 100%.
     • RAM: 4 GB.

6. In the Network settings section, select the network and subnet to connect the VM to. The infobase VM must be in the same subnet as the 1C server.

7. In the Public address field, leave the value No address. The VM will be accessed via a bastion instance.

8. In the Access section Password field, specify the administrator's password to access the VM.

9. Click Create VM.

Set up a server cluster

1. Connect to the VM server-1c using RDP. Log in as the Administrator and enter the password specified when creating the VM.
2. Install the 1C server from the distribution.
3. Start the 1C:Enterprise server administration console.
4. Add the 1C:Enterprise central server Open the context menu of the server list, select New and 1C:Enterprise central server 8.3.
5. In the Name field, enter server-1c and click OK. You'll see the local cluster in the tree on the left.
6. Add a requirement for assigning functionality to the server-1c with the following parameters:
   • In the Requirement object list, select Client connection.
   • In the Requirement type list, select Assign.
   • Leave the other parameters as they are and click OK.
7. Add another requirement for assigning functionality to the server-1c with the following parameters:
   • In the Requirement object list, select Licensing service.
   • In the Requirement type list, select Do not assign.
   • Leave the other parameters as they are and click OK.
8. Apply requirements for assigning functionality to the cluster: open the cluster's context menu and select Apply requirements of functionality purpose (full)..

Set up the license server

1. Connect to the VM license-server-1c using RDP. Log in as the Administrator and enter the password specified when creating the VM.
2. Install the 1C server from the distribution.
3. Connect to the VM server-1c using RDP. Log in as the Administrator and enter the password specified when creating the VM.
4. Open the 1C:Enterprise server administration console.
5. Add the working server to the cluster. Open the Working servers context menu, choose New and Working server. In the Computer field of the window that opens, enter licensing-server-1c. This server will be used to issue licenses to other servers.
6. In the Requirements of functionality purpose section of the licensing-server-1c, open the context menu and select New and Requirement of functionality purpose.
   • In the Requirement object list, select Any requirement object.
   • In the Requirement type list, select Do not assign.
   • Leave the other parameters as they are and click OK.
7. Apply requirements for assigning functionality to the cluster: open the cluster's context menu and select Apply requirements of functionality purpose (full)..
8. Add another requirement for assigning functionality to the licensing-server-1c with the following parameters:
   • In the Requirement object list, select Licensing service.
   • In the Requirement type list, select Assign.
   • Leave the other parameters as they are and click OK.
9. Apply requirements for assigning functionality to the cluster: open the cluster's context menu and select Apply requirements of functionality purpose (full)..

Set up the SQL Server

1. Connect to the VM sqlserver-1c using RDP. Log in as the Administrator and enter the password specified when creating the VM.

2. Open Microsoft SQL Server Management Studio and connect to the database server.

3. Change the authentication mode to the mixed one: open the SQLSERVER-1C server properties, go to the Security section, and select SQL Server and Windows Authentication mode. Click OK.

4. Restart the server.

5. Create a new database: open the Databases context menu and select New Database. Specify the following parameters:

   • Database name: 1c-database.
   • Open the Options section. In the Collation field, select Cyrillic_General_CI_AS.

   Click OK.

6. In the tree on the left, select Security, open the Logins context menu, and choose New Login.... Specify the following settings:

   • Login name: 1c-user.
   • SQL Server authentication: Enter your password and confirm it.
   • Default database: 1c.

7. Open the Server Roles section. Grant the following roles to the user: dbcreator, processadmin, and public.

Set up the infobase

1. In the 1C server administration console, open the Infobases context menu, select New and Infobase.

2. In the window that opens, set the parameters:

   • Name: The name of the database on the SQL Server, 1c-database.
   • Secure connection: continuously.
   • Database server: Your DB server address.
   • DBMS type: MS SQL Server.
   • Database: The DB name, 1c-database.
   • Database server user: 1c-user.
   • Database user password: The user password that you set when creating the DB server user.
   • Allow license issuing by 1C:Enterprise server: Yes.
   • Language (Country): Russian (Russia).
   • Create database if none present: Disabled.
   • Lock execution of scheduled jobs: Disabled.

   Click OK.

Connect to the infobase

1. Connect to the OpenVPN server.

2. Run the 1C:Enterprise client.

3. Click Add.

4. Select Add an existing infobase to the list and click Next.

5. Enter the infobase name, select On 1C:Enterprise server, and specify the following settings:

   • Server cluster: server-1c.ru-central1.internal.
   • Infobase name: 1c.

   Click Next.

6. Click Ready.

The infobase should appear on the list of infobases. You can now start configuring and using the database.

Delete the created resources

To stop paying for the deployed servers, delete the server-1c, license-server-1c, and sqlserver-1c VMs.

If you reserved a public static IP address, delete it.