MS SQL Server: installation and configuration. MS SQL Server versions. MS SQL Server and 1C

MS SQL Server is a database administration system from the well-known Microsoft Corporation. The product has a high competitiveness and is used by both large industrial enterprises and private individuals. At present, databases are used universally, accordingly, the demand for this program is constantly growing. The development of this product began in 1985, and since then new versions of the program have been coming out every year, developers are introducing new useful functions and removing unnecessary old ones.

History of development, the 90s

1989 - the first version of the software appears, the joint development of Microsoft and Ashton-Tate. The project did not achieve the expected popularity. First, users of the product would have to switch to another operating system. Secondly, by that time, competitors had been able to create a SURB with a broader functionality.

1990 - the release of MS SQL Server 1.1. In terms of functionality, the new version was not much different from the previous version (working with data, supporting the SQL language), but many mistakes and shortcomings were fixed.

1993 - almost simultaneously with the release of the new operating system, SQL Server for Windows NT appears, significantly exceeding its competitors in performance.

1995 - the release of Microsoft SQL Server 6.0, the first product released separately from Sybase (the company with which Microsoft developed the software since 1987). The announcement was very successful.

1998 - A new version of SQL Server 7.0 is introduced in Las Vegas. Many shortcomings were fixed, productivity was improved. This version of the program was designed for large corporations that work with a large amount of data.

History of development, 2000

1999 - the version of MS SQL Server 2000 developed for the same operating system appears. The version had much more functionality than the previous one. Among them, a new method of access to data, recovery algorithms, a new engine (which opens new opportunities for development).

2003 - the creation of MS SQL Server 2005. This version greatly simplified the creation of databases, accelerated the work with a large amount of information and came out with the corrected errors that were in the previous version.

2008 - the appearance of a new version of the program. In fact, it is a more functional version of MS SQL Server 2005. There are no major changes in this version.

Nowadays

In 2010, a mobile version of Compact 4.0 was announced. The version does not require installation and is compatible with platforms such as API, NET and Framework, Visual Studio 2010. In 2014, a new version became available to users. Much attention is paid to increasing the possible amount of databases (up to hundreds of terabytes), business analytics. Also there are developments on the presentation of the database in space. The next version of the product will be called SQL Server 2016, and is currently actively developing it.

Installation

Before you begin the installation, we recommend that you read the system requirements. The minimum are:

• The processor is Intel (or compatible) Pentium III 1000 MHz or higher.
• RAM - 512 MB or more.
• The hard disk capacity is 20 GB or more.

Recommended system requirements:

• The processor is Intel Core i7 3000 MHz or higher.
• RAM from 4 GB or more;
• The hard disk capacity should be from 100 GB or more.

If the computer on which the program is installed is suitable for the above requirements, then you can proceed with the installation. The installation of MS SQL Server is not too complicated and does not differ from the installation of ordinary programs for Windows. There are only some distinctive features that will be described in this article.

1. To start, you must run the installation file with administrator rights (to do this, right-click on the file and select "Run as administrator").
2. The "Installation Center" window opens. In it, select the "Planning" section, where the computer configuration will be checked.
3. If everything went well, select the item "Installation" in the same window, select the first item in the suggested list where we are offered to install the program or add new components to it.
4. Enter the required key (usually it is written on the box with the software).
5. Accept the conditions described in the license, and tick the appropriate place.
6. Then click the "Install" button.
7. We select components for installation.
8. Select the "Default Instance".

For optimal operation of the software, it is necessary to perform the setup before installation. In the next chapter, we'll look at how to do this.

Customize

Setup of MS SQL Server is performed before installation. Therefore, when setting up, it should be especially careful, because some configuration parameters will not be able to be changed after installation.

1. In the "Server Configuration" window, we are prompted to choose the type of services startup (automatically or manually). On all services, except Full Text Filter Daemon Launcher, select "Auto". Click "Next".
2. In the section called "Server configuration" there is no need to change anything, so again click "Next".
3. In the "Database Engine Configuration" window, select "Mixed Mode" and set the administrator login and password. In the same window, go to the "Data Catalogs" tab. We set the path where the files with the databases will be stored. We press further.
4. Select the default setting (first item).
5. In the Error Reporting Settings window, select whether the program will automatically send an error report to Microsoft to improve this software.

This completes the installation and configuration, the program is ready for use.

Configuring Remote Access

Let's consider the way to configure the program for remote access. This function will be useful if the program is installed on more than one computer in the organization. After installing the MS SQL Server software, you must do the following:

1. From the Start menu, select All Programs> MS SQL Server> Configuration Settings.
2. Select Protocols for SQLEXPRESS, then TCP / IP.
3. Switch TCP / IP to Enable.
4. Select "Properties", then the IP Adresses tab.
5. Next, select SQL Server Services.
6. Restart SQL Server Services by selecting restart.

Next, you must allow the operating system firewall to receive incoming messages. To do this, do the following:

1. Access to the firewall features can be found in the Start menu> Administration.
2. In the opened window of the firewall, select Inbound Rules.
3. Then choose Port.
4. Then it will be necessary to specify TCP and the corresponding number, in our case this is 1433.
5. Next, select Allow the connection.
6. In the next step of the Profile, we always check the boxes.
7. Choose the appropriate name.

If everything is done correctly, the MS SQL Server database can be started remotely.

Helpful Tips

The software is a fairly complex software. Here are some useful tips that will make working with MS SQL Server easier:

• Limitations when working with 1C apply to some versions, so before implementing this system, you should clarify the issue of software compatibility.
• If you ran the database in a later version, you will not be able to run it on an earlier version.
• If you need to send several jobs to the server within a single transaction , you must specify the transaction type correctly. For this, it is most convenient to set the mode of automatic transaction detection: SET IMPLICIT_TRANSACTIONS OFF.
• If the program gives an error with several databases, it means that the database files have incompatible versions. In this case, the older database should be converted to a later version.
• To determine the database path, right-click the database and select Properties.

Instead of concluding

Currently, relational databases are used in almost all organizations where it is required to create large and not very storage. The wide distribution of this software gives developers a great push to develop, so that they every year present to the world more and more improved versions of their software. The joint use of MS SQL Server and 1C greatly simplifies the work cycle of many enterprises, eliminating unnecessary paper red tape. The software itself is not too difficult to use and gives users the opportunity to quickly learn all the basic steps necessary to work with this program.