NOTE: This page has been translated automatically from Russian to English. Original page.
Instructions for installing and configuring SQL Server and 1C
The basis for this statement served as SQL Server 2014 Enterprise 8.3 and 1C, and this instruction may work for other versions of SQL Server and 1C.
Table of contents
Installing and configuring the MS SQL Server.
1. MS SQL Server 2014 Editions.
2. Change version or enter the SQL Server 2014 the Microsoft key.
3. Determination of the installed version of Microsoft SQL Server.
4. Configure ports for access to MS SQL Server 2014 network.
5. Change Memory settings of the SQL Server 2014 the MS.
6. Adding a new user to the MS SQL Server.
A. Authentication SQL Server.
B. Windows Authentication.
7. Create a new database in MS SQL Server.
8. Detach and Attach databases in MS SQL Server 2014.
A. Removing the base ..
B. Joining base ..
9. Create a database backup.
Installation and setup of 1C Enterprise 8.3.
1. Software licensing system "1C: Enterprise 8.x".
A. File a software license.
B. Types and versions of software licenses.
C. About pincode and activation of licenses.
D. Options licenses.
E. Features of the account of client licenses.
F. Obtaining a license.
2. Installation of the client-server variant of 1C Enterprise 8.3.
3. Installation templates.
4. Adding a base 1C Enterprise.
A. Add the information base of the launch window "1C: Enterprise".
B. Addition of the information base of the console server administration "1C: Enterprise".
C. The properties of the information base ..
D. The addition of the existing information in the database list information database launch window "1C: Enterprise".
5. Ports used by 1C Enterprise 8.3.
6. Change the port used by 1C Enterprise 8.3 default ..
7. To add a rule in the firewall Windows Server 2012 R2.
Post-installation settings and features to optimize the SQL and 1C.
1. The log file and work with it ..
A. Where is the log.
B. Transfer of registration journal to another server.
C. Setting the log.
D. Optimization of the log.
E. Return the old log recording format.
2. Clear the cache 1C users.
3. Customize and create technological log (TJ).
4. Setting 1C 8.3 cluster.
5. Lock installation information base compounds.
6. Enable debugging on a server 1C 8.
7. What should I do if the transaction log is growing - _log.ldf file for MS-SQL.
8. Routine operations on the database level for MS SQL Server.
A. Updating statistics.
B. Purification procedure cache.
C. Defragmenting indexes.
D. Reindexing tables.
9. Create Backup`ov Windows tools (+ archiving).