In the article, we will consider instructions for installing the 1C: Enterprise server in the office. The 1C installation option in the client-server form is the most suitable. But first you need to understand what a client-server architecture is. After that, we will tell you in what cases it makes sense to implement this architecture, and most importantly - how to do it right. If you are faced with the installation for the first time, then our material will be very useful to you.
What is a client-server architecture
It is worth noting that 1C in all cases works as a client-server. But there is a so-called file version, in which all work takes place exclusively on local computers. At the same time, the system itself divides the entire computer memory into a conditionally server and conditionally client. In this case, its own built-in database management system is used. It has one drawback - low speed and low stability.
When working in the client part, requests to 1C are generated, after which they are transferred to the conditionally server part, where processing takes place. The results of this processing go back to the conditional client part. In fact, this is a server version of the system, but it is customary to call it file. As you can see, there is subtlety, but it is small. In general, it is much better to use the server version of the software, since it is much more stable and allows more clients to work with one database at the same time.
As for the client-server option, then for the proper functioning of the database, third-party software systems are used. These are MS SQL, Oracle, DB, DB2, PostgresSQL. It is worth noting that third-party control systems are considered more powerful than integrated ones. At the same time, the best performance is ensured, and most importantly, the database security is increased significantly.
We will consider installation of client-server architecture on MS SQL. This is the best option for the correct operation of 1C. When installing PostgreSQL 1C server, there is a need for databases to be indexed frequently. Oracle has a large number of problems with organizing data in a database. DB2, when compared with competitors, is limited in number length.
Do I need to transfer the database to the server version
In the event that no more than 7 people work with one database, and its size is quite small, then it will be quite enough to use the file option. But if from 8 to 12 people work simultaneously with one base, and its volume is up to 4 GB, then it is best to use the client-server version. In this case, a lot will depend on personal perception when working with the database. Problems can occur with a large number of simultaneous resource requests.
The question is that during operation, each user accesses the registers, and access to them may be blocked for other employees. Therefore, they will be queued when trying to access a register that has been locked. 1C at the same time freezes.
In the event that with a large number of calls the system freezes, it is necessary to modernize the architecture, use a more advanced type. If it works with the database for more than 15 people, and its total size is more than 4 GB, then you should not even think about installing the file system. Immediately you need to install the client-server version 1C.
Installation: basic steps
Steps to be performed when deploying client-server: MS SQL installation on the server:
- Installation on the same server platform 1C.
- Installation on all computers of clients 1C. You need to install only where you need to connect to the database server.
- Creating an infobase in SQL.
We will tell about how 1C is installed on a Windows server, as well as settings, in our article.
Software Update
You can even use any powerful personal computer as a server. But it is best to use the server hardware, as it is much more powerful and will be able to work with requests faster. To install, you need the SQL distribution. Open the folder with it and run the installation file, which will automatically unpack all the necessary resources to your computer.
Note that the NET component must be installed on the computer. Framework If it is not there, you need to update the operating system. But you can simply download the installation file separately and run it. This procedure is completely free, files need to be downloaded only from official sources - from the Microsoft website.
Distribution Installation Procedure
As soon as you run the installer of the database management system distribution kit, you need to enter the license key. Next, you will be asked to read the licensing conditions and check the box that you agree with them. After that, you can move on. When you get to the choice of components, you need to do it right. If you plan to use the control system only for 1C operation, check the boxes next to the following components:
- Database Engine Service.
- Management Tool Management Tool.
- Client Tool Connectivity Communications Tool.
As for the other components, they are not needed during 1C operation. They will only take up space on your hard drive. After that, click the “Next” button and continue installing the distribution.
The final installation of the DBMS
Next, go to the "Sorting Options" tab. Be sure to select the Cyrillic_General_CI_AS parameter, which determines the server configuration. You also need to check the “Mixed mode” box in the “Server Configurations” tab.
During installation, you will need to enter the username and password of the super-user (usually the username is SA, and the password is SQL). Here you need to specify the administrators of this instance of the database management system.
Now go to the “Data Directories” tab and select the location of user and temporary databases on disks with the maximum performance. It is advisable to use SSDs on RAID. Now it remains to click "Next" and proceed to install the distribution. Leave all other settings as default. After installation, your SQL distribution is fully operational.
Installation on a server computer
Now you can begin to install the 1C 8.3 server on Windows and start the services. You will need a distribution of the 1C: Enterprise platform. You can use these:
- Technological platform 1C: Enterprise for Windows - this installs the software on computers with a capacity of 32 bits.
- The version “Server 1C: Enterprise” can be installed on servers with a bit capacity of both 32 and 64 bits.
It is worth mentioning about the extended version of "CORP." True, not every company needs the installation of the 1C Enterprise 8.3 server. If necessary, to begin the installation, you need to open the directory and run the file named setup.exe.
Software Installation Procedure
After that, the assistant will start, it will remain to follow its prompts. On the very first page you just need to click "Next", then select the components that you want to install:
- Administration of the 1C: Enterprise server. Installation instructions will follow.
- Directly server software components.
The list will contain many components, their list varies depending on the version, but you only need to install these two. Select all the necessary components and proceed to the next step. In the event that the server is installed as one of the services of the Windows OS, you need to make a point for an individual user. From under it, the service will be launched. To do this, you will need:
- Check the box next to “Install 1C: Enterprise server as a Windows service (recommended)”.
- Turn the "Create USR1CV8 User" switch to the desired position.
- Enter the password twice for the user you are creating.
Installation complete
You can also select an existing user in order to start 1C. But he must have the following rights:
- Logging in as a batch job.
- Logging in as a service.
- Users of performance logs.
You will also need to set permissions on the service file directories on the server. A user that is created automatically by default has all the necessary privileges. As soon as you are done, click the “Next” button and proceed directly to the installation. In this case, all the necessary files will be copied to the server.
During installation, the assistant will offer you to install the protection driver. In that case, if you use a software license for 1C server, then you do not need to install this driver. After the installation is successfully completed, you will see the last window with the “Finish” button. Click on it and complete the installation.
Installation on client computers
Now let's look at how to install software on client computers. Earlier we looked at installing 1C 8.3 server on Windows. The procedure is almost similar, but there are differences in the details. For installation, you need to run the installation file, which is located in the distribution folder. If you click on the “Change” button, you will have the opportunity to edit the list of components that will be installed. The number of components depends on which version of the distribution you are using.
Software components
Description of software components:
- Thin client - these components are required for normal operation in client-server mode.
- “1C: Enterprise” is the main set of components, including thin and thick clients, configuration and administration elements.
- File version of the thin client - necessary for the normal functioning of the file version of the client.
- Various modules for expanding the web server - are necessary for the operation of web services and clients.
- Server "1C: Enterprise" (installation of 1C 8. 2 server is considered in our material, it is performed in the same way as version 8. 3).
- Language Interfaces - A user interface for working using various languages.
- Server administration is a set of additional components that allow you to administer 1C server clusters.
- Information base converter for 1C: Enterprise.
- Configuration storage servers - allow you to save all the settings of software components.
When you select the necessary components, click on the "Next" button and install the program.
As with the installation of the 1C: Enterprise server, the assistant will offer you to install the protection driver. But it will be needed only if the electronic key installed in the USB connector is used during the operation of the software.
Upon successful completion of the installation, you will be taken to the finish window, you just have to read the contents of the Readme file (optional) and click on the “Finish” button.
How to add an infobase to the list
When setting up and installing the 1C: Enterprise server, a shortcut for launching the software appears on the desktop. When you open, you start the program, but the list of databases will be empty. The program will offer you to choose the right base:
- If you need to create a new database to keep records, click the "No" button. And first, install a standard template, on the basis of which create a database.
- If you have a base, you need to connect to it. In this case, click “Yes” and add the existing database to the list.
Database Creation Procedure
In the SQL version, the database is created in much the same way as in the file one. But there are differences - when choosing the type of database location, you must specify "On the server." Next, set the parameters necessary for work:
- On the “Server Cluster” tab, specify the name or address of the server on which SQL is installed.
- Specify a name in the column "Information Base Name".
- Indicate the type of database management system - SQL.
- Indicate the name of the super-user and his password (discussed above).
- If necessary, indicate the date offset.
- Be sure to check the box next to "Create a database if it is missing."
- Click the "Next" button.
That's all, now the database is created and it is located on the server. It can be seen among available and edited.
Initially, the database is empty, it is a kind of framework - a place on the server allocated for data. For filling, you need to use the means of loading / unloading infobases. It is recommended that you specify a maintenance plan after configuration — these are the procedures that SQL must perform according to a schedule. For example, it can make copies at specific times or delete temporary files.