Microsoft sql server installation. Installing and configuring Microsoft SQL Server Express. Create a new SQL Server user account
Nowadays databases are used almost everywhere, from websites to applications. The possibilities for using the SQL language are endless. This article will discuss how to install MS SQL Server 2017 Express on your computer. In most cases, this is necessary for learning the SQL programming language or for testing database operations.
Installing MS SQL Server 2017
Microsoft SQL Server 2017 Express- powerful and reliable free a data management system that provides functional and reliable data storage for websites and desktop applications.
For example, you need to learn the SQL language and for this you need your own SQL server. It will help you with this MS SQL Server 2017 Express, it is provided absolutely free by Microsoft. Anyone can download and install it.
I also want to immediately note, install SQL Server 2017 Express You can only use the following operating systems: Windows 10/8/8.1; Windows Server 2012; Windows Server 2012 R2; Windows Server 2016
Download MS SQL Server 2017 Express
First, we need to download SQl Server. We type “SQL Server 2017 Express” into any search engine and select the Microsoft website. 
We will be redirected to a page where we can select the language we need and download MS SQL Server 2017 Express. There you can also see the necessary system requirements for the correct operation of the server. Click the “Download Now” button 
We will be asked to choose the type of installation, there are three in total: 
Basic
- The basic version contains only the SQL Server database engine. Suitable for situations where you need to accept remote connections or perform remote administration.
Custom
- Along with the SQL DBMS, this package contains full-text search functions and Polybase services.
Download media
- LocalDB is a lightweight version of Express that has all the software features, runs in user mode, installs quickly, requires no configuration, and has low system requirements. Use this version when you need an easy way to create and work with a database from code. It can be packaged with database and application development tools such as Visual Studio, or embedded in an application that works with local databases.
Having trouble choosing? Then select the installation type " Custom"
Select the required item. Specify the desired language and media location. Click the “Install” button. 
Installing and configuring MS SQL Server 2017 Express
After downloading, the installation center will open to us. We need to select the item “New installation of a stand-alone instance of SQL Server...” 
After waiting a little, a window with a license will open, we accept. Next we will see the installation rules, and possible problems or warnings that may interfere with the operation servers. Click “Next” 
Next, we will be offered a choice of components; by default, the ones we need are already selected. Click “Next” 
Now we are prompted to provide a name and identifier for the instance servers. Leave everything as default and click “Next”. 
Next, we will be asked to specify service accounts and sorting options. We leave everything as is, do not check the box “Grant the right to perform volume maintenance tasks to the SQL Server Database Engine service.” Click “Next” 
Then we will be asked to configure the kernel DBMS. Here you can see the configurations, data directories (where they will be stored), authentication mode. Leave everything as default and click “Next”. 
Next, you must agree to install Microsoft R Open. Click the “Accept” and “Next” buttons 
We do the same with consent to install Phyton. Afterwards, wait for the installation to complete. It may take a long time, depending on your PC. When finished, simply click “Close”.
If an error occurs: " Visual studio shell installation failed with exit code 1638..." must be deleted Microsoft Visual C++ 2017 and restart the PC. Then repeat the installation process SQL Server 2017.
Let's consider the issues of installing and configuring MS SQL Server for 1C.
The first thing I would like to note is that the installation method for MS SQL Server largely depends on the expected load on 1C.
Depending on this, the following options can be identified:
- Option 1. An enterprise with up to 500 transactions per day;
- Option 2. An enterprise with more than 500 transactions per day, but mostly non-interactive (downloading payments from the Internet and client bank, downloading orders from an online store, automatic generation of warehouse and transport operations, etc.);
- Option 3. An enterprise with more than 500 transactions per day, most of which are interactive, i.e. initiated and formalized by users.
For the first two options, MS SQL Server can be installed on the same server where 1C is installed, which is especially true, rather, for the second option, provided that the hardware requirements are met. But in the third case, MS SQL Server needs to be installed only on a separate server.
Let's look at the hardware characteristics for all three cases
If installed on a separate server:
CPU
- Option 1. At least 1.8 GHz (preferably 2-core)
- Option 2. At least 2x2GHz with at least 2 cores
- Option 3. At least 4x3GHz with at least 4 cores
- Option 1. At least 8 GB
- Option 2. At least 32 GB
- Option 3. At least 128 GB
Disk subsystem
- Option 1. SAS at least 120 GB
- Option 2. SAS of at least 500 GB (preferably SSD)
- Option 3. SAS at least 1 TB (SSD recommended)
Network connection
- Option 1. At least 1 Gb/sec
- Option 2. At least 1 Gb/sec (preferably optics)
- Option 3. At least 1 Gb/sec (optics recommended)
In case of joint installation with 1C Enterprise server:
CPU
- Option 1. At least 2x2GHz with at least 2 cores
- Option 2. At least 4x3GHz with at least 4 cores
- Option 1. At least 32 GB
- Option 2. At least 128 GB
- Option 3. It is strictly forbidden to do this
Disk subsystem
- Option 1. SAS of at least 500 GB (preferably SSD)
- Option 2. SSD at least 1 TB
- Option 3. It is strictly forbidden to do this
Network connection
- Option 1. Preferably 1 Gb/sec
- Option 2. Preferably 1 Gb/sec
- Option 3. It is strictly forbidden to do this
Please note that these are the minimum requirements for comfortable work. More precise parameters are selected based on the specific situation, guided by the basic needs of MS SQL Server for 1C in the disk subsystem and the amount of RAM.
Now let's move directly to the installation process of MS SQL Server for 1C in the MS SQL Server 2014 version on the MS Windows Server 2012 operating system
First of all, you need to rewrite the MS SQL Server installation distribution for 1C to the local hard drive of the server.
Run the installation of MS SQL Server for 1C as an administrator.
In the window that opens, select “Install” in the right panel.
The installation of MS SQL Server for 1C will begin. During installation, you will be asked to enter your product key and review the licensing terms. After this, you need to select the server role by selecting “Install MS SQL Server Components”.
The next step is to select the components to install. Usually they are all selected, but if not, then click the “Select All” button.
Don't change anything, i.e. Click “Next” until the “Database Engine Configuration” window appears. In this window, on the first tab, specify the user “sa” and set its password (you can also assign a Windows user, but the “sa” user is considered more secure).
On the other two tabs, you can configure new directories for storing user databases (but it is better not to change).
Now you have installed MS SQL Server for 1C
Let’s “open” our MS SQL Server for 1C. To do this, go to applications and find SQL Server 2014 Management Studio there.
After connecting, select “Security” in the tree on the left, and “Login names” in it. By right-clicking, select “Create Login” from the submenu. In the form that opens, indicate the user name and password (remember this password and this user, because this is what you will indicate when connecting databases from the 1C server).
Go to “Protected objects” and set the right to connect to SQL, as in the figure.
Click on “Ok”. Installation of MS SQL Server for 1C and its configuration is completed.
Let's move on to connecting the 1C database on the 1C server
Launch the 1C:Enterprise server administration console.
Fill out the dialog that opens as shown in the figure.<Имя базы на латинице>- indicate the name of your database.<Имя компа MS SQL Server>- indicate the name of the computer on which you previously installed MS SQL Server for 1C.
Click on “Ok”. The base is connected.
You can connect the database directly from the 1C database connection dialog.
To do this, launch the dialog for opening 1C databases and click the “Add” button.
In the window that appears, select “Create a new information base.”
In the next window, select the desired template in the tree or indicate “Creating a new database without configuration...”.
In the next window, set the name of the database and indicate that it will be on the 1C:Enterprise server.
On the next tab, fill in the fields in the same way as was described in the section connecting the database from the 1C server.
Optimization of SQL for 1C is completed. You can launch and work.
This article will provide detailed step-by-step instructions for installing Microsoft SQL Server 2012. The example shows installation features on operating systems - and, in other operating systems of the Windows family, the installation process is similar.
1. What you will need
- A computer that meets the minimum system requirements to work with SQL Server 2012. Read in detail about the hardware and operating system requirements.
- Administrator rights on the local computer.
- Microsoft SQL Server 2012 installation disk, or disk image (you can download it, for example, from the official website).
- A valid product key (optional) for .
2. Installing .NET Framework 3.5
The first step is to install the .NET Framework version 3.5 SP1. You can read about how to do this in the articles:
3. Install SQL Server 2012
Run the file " setup.exe"from the installation disk.
" SQL Server Installation Center"(SQL Server Installation Center), go to the tab " Installation"(Installation) and click on " New installation of a standalone instance of SQL Server or adding components to an existing installation"(New SQL Server stand-alone installation or add features to an existing installation).
" SQL Server 2012 Setup"(SQL Server 2012 Setup). Let's make sure that there are no problems that may arise during the installation of the installation program support files and click " OK" If any problems still arise, you must eliminate them and repeat the verification procedure by clicking “ Re-enable"(Re-run).
Now you need to enter your product key (if you have one) or select the free edition of SQL Server. It could be:
- Evaluation Edition- a complete set of components, with a use limit of 180 days.
- Express Edition— free version with limited functionality.
Depending on the key entered, the corresponding key will be selected for installation.
We accept the terms of the license agreement, agree (or not) to the transfer of data about the use of components to Microsoft Corporation and click " Further"(Next).
If there are installation program updates, enable product updates by clicking " Enable SQL Server Product Updates"(Include SQL Server product updates) and click " Further"(Next).
We are waiting for the updates to download and installation of the SQL Server installation files to complete.
Now the preparatory stage is over, and we are proceeding with the actual installation and selection of SQL Server parameters. Make sure that there are no problems that may arise during installation and click “ Further"(Next). If there are any problems, you need to eliminate them and repeat the verification procedure by pressing the " Re-enable"(Re-run).
Installation option select " Installing SQL Server Components"(SQL Server Feature Installaion) and click " Further"(Next).
Now we select the components to install. For most cases (for example, for operating and administering a server 1C:Enterprise), it is quite enough to install the components:
- Database Engine Services
- directly the MS SQL Server service itself, and the program "SQL Server Management Studio" for administering SQL Server, i.e. components
- Management Tools - Basic
- Management Tools - Complete
All components can always be delivered/removed by simply rerunning the SQL Server installation. Having selected the necessary components, click “ Further"(Next).
Again, make sure that the installation process will not be blocked, fix the problems otherwise and click “ Further"(Next).
You must now enter the name of the named SQL Server instance or leave the default instance name. It is possible to install up to 50 named instances of MS SQL Server 2012 on one isolated server and up to 25 in a failover cluster when using a shared cluster disk (link). There can only be one default instance. Having decided on the name (Named instance) and identifier (Instance ID) of the SQL Server instance, click “ Further"(Next).
Let's make sure that there is enough free space to install the selected SQL Server components and click " Further"(Next).
Now let's select the startup mode for SQL Server services. Let's change the launch parameter of the SQL Server Agent (SQL Server Agent) to " Auto» (Automatic) (in order to process regulated tasks of the SQL agent). In this window you can also specify from which various SQL Server services will be launched by selecting it in the “ account name" (Account name) and entering the password for this account in the column " Password" (Password) next to the corresponding service. Next, let's go to the " Sort Options"(Collation).
For most programs that will work with SQL server (for example, for systems 1C:Enterprise) just select “ Cyrillic_General_CI_AS" Having specified the sorting parameters, click " Further"(Next).
Now you should select the Authentication Mode. I recommend choosing " Mixed mode"(Mixed Mode), enter the password for the built-in account " sa", as well as add SQL Server administrators from among existing Windows users using the buttons " Add current user" (Add Current User) and " Add…"(Add..). In order not to later forget the password entered during installation, I recommend using special password managers, for example the free program. Having set all the parameters, go to the “ Data directories» (Data Directories).
Here you can select the database storage directory (Data root directory). For most cases, it is recommended to adhere to the following rules:
- If the server configuration includes a RAID array of hard drives, it makes sense to place the data files on it.
- If possible, it is recommended to separate the database files and database log files onto different disks.
- It is advisable to move the temp system database directory and the temp database log directory to a fast SSD disk, this will give a noticeable increase in SQL Server performance.
- In some situations, it may make sense to change the backup directory to a physical disk other than the disk containing the database files.
Having specified the necessary paths, go to the “FILESTREAM” tab.
If in the future you plan to store unstructured data on this SQL server, for example large documents, images, video files, etc., and FILESTREAM storage will be used to store such files, then you must also configure the corresponding parameters on this tab. Otherwise, leave the settings unchanged and click “ Further"(Next).
We decide whether to send (or not send) error reports to Microsoft and click “ Further"(Next).
Once again, make sure that the installation process will not be blocked, correct errors if they occur, and click “Next”.
We check all the parameters entered in the previous steps. Please note that the value of all entered parameters will be saved in the ConfigurationFile.ini configuration file. When re-installing SQL Server, this file can be specified as a parameter for the installation program, in which case SQL Server will be installed automatically, and the settings will be taken from the configuration file. This method can be used if you need to quickly install several instances of SQL Server with the same parameters, or to “back up” the parameters accepted during installation of the current instance.
Click " Install" (Install) to start the SQL Server installation process.
Installation can be quite time-consuming. We are waiting for it to finish.
Then we make sure that all components are installed successfully and complete the wizard by clicking on the “ Close"(Close).
The installation of Microsoft SQL Server 2012 is complete.
4. Configuring Windows Firewall for MS SQL Server 2012
If it is expected that programs located on other computers on the network will work with the SQL server, then on the server itself where the SQL Server service is running, you must configure Windows Firewall for SQL Server to work. You can read more about this here" - " SQL Server Management Studio».
To connect to the SQL Server Database Engine service, in the " Server name" (Server name) specify the computer's network name or local IP address, then "\" and the name of the SQL server instance, or the SQL Server instance alias used, if one is specified.
Did this article help you?
Microsoft® SQL Server® 2012 Express is a free data management system used to provide data storage and organize network operation of some programs, in particular the “Contract Management 5.9 version MS SQL” program.
This product is installed on a server or on a computer that plays the role of a server (SQL Server 2014 is installed in the same way as 2012).
Microsoft® SQL Server® 2012 Express is developed by Microsoft.
If you have any questions related to the operation of this product, you should contact your system administrator or Microsoft.
The Microsoft® SQL Server® 2012 Express distribution is available at https://www.microsoft.com.
2. The SQL Server 2012 Installer form opens.
If you accept the License Agreement, check the box next to “I accept the terms of the license agreement” and click Next.
The installation process for the SQL Server 2012 prerequisites will begin.
Enlarge image
If you need a product update, install the update.
3. On the Select Components step of the SQL Server 2012 Setup form, make sure that all check boxes in the Components section are selected.
If necessary, click the Select All button to select check boxes for all values. Then click Next.
Enlarge image
4. In the next step, “Configuring an instance,” in the “Named instance” field, enter the value SQLExpress or enter a different name in Latin letters (for example, Express2012) if SQL Server with the same name is already installed on the computer (for example, SQL Server 2008 is installed with an instance of SQLExpress) .
Enlarge image
5. In the next step, Server Configuration, in the Service Accounts table, check that the Startup Type column for all services is set to Auto.
If the SQL Server Browser service is set to Disabled, left-click on the drop-down list in the Startup type field and select Auto.
Enlarge image
6. In the next step, Configuring the Database Engine, select the Mixed mode (SQL Server and Windows authentication) radio button.
In the Enter a password field group Specify a password for the SQL Server system administrator account (sa) field, enter the required password (for example, adminpsw).
Also duplicate the entered password in the Confirm Password field.
Be sure to remember or write down this password.
The set password will be used when connecting the database to the SQL server when installing the program “Contract Management 5.9 version MS SQL”.
Enlarge image
For local installation, you can leave "Windows Authentication Mode".
Before creating the database, you will be asked to select a method for storing scanned images and files in the MS SQL Server database.
In the program “Contract Management 5.9 version MS SSQL” there are 2 options for storing scanned images and files in the MS SQL Server database - storing images and files in tables, or using FileStream (option “in File Tables storage”).
The option with FileStream is only possible in MS SQL Server 2008 and higher.
Using FileStream is not subject to the Express database limit (10GB for Microsoft® SQL Server® 2012 Express), resulting in the ability to store large volumes of files and scanned documents in the free version of MS SQL Server Express.
If you intend to use FileStream, then you need to enable FILESTREAM at the level of the MS SQL Server instance used
To enable FILESTREAM, go to the FILESTREAM tab in the dialog box.
Check the "Allow FILESTREAM when accessed through Transact-SQL" checkbox.
Enlarge image
7. In the next step “Error reporting”, click on the Next button.
Enlarge image
8. The next step, Installation Progress, will begin installing SQL Server 2012.
Enlarge image
Wait for the installation to complete.
9. When the SQL Server installation is complete, the Complete form appears.
Verify that all components in the "Information about the installation operation or possible next steps" section in the "Status" column are listed as Successful.
Enlarge image
Click on the "Close" button.
The installation of MS SQL Server 2012 will be completed.
Features of configuring SQL Server 2012 Express to work in network mode
To ensure network use of the Contract Management 5.9 version MS SQL program, check the following settings in SQL Server 2012 Express:
- SQL Server Browser service activity
1. Click the Start button and select Programs / Microsoft SQL Server 2012 / Configuration Tools / SQL Server Configuration Manager.
Enlarge image
2. On the left side of the form, go to the SQL Server Services section. On the right side of the form, click on the SQL Server Browser value.
The Startup Mode field should be set to Auto.
3. If the Startup mode field is set to a different value, double-click the SQL Server Browser value. The Properties form: SQL Server Browser opens.
In the form that opens, go to the Service tab and in the Startup mode field in the drop-down list, select Auto and click the Apply button.
Go to the Login tab and click on the Start button.
The SQL Server Browser service will restart. The Service Status field displays Running.
- SQL Server Protocols
1. Click the Start button and select Programs / Microsoft SQL Server 2012 / Configuration Tools / SQL Server Configuration Manager.
The SQL Server Configuration Manager program opens.
2. On the left side of the SQL Server Configuration Manager form, go to SQL Server Network Configuration / Protocols for SQLEXPRESS.
3. Protocols Shared Memory, Named Pipes, TCP/IP must have the Enabled status.
Enlarge image
4. Place the mouse cursor on the name of the protocol Named Pipes and in the context menu click on the Enabled item.
5. Place the mouse cursor on the name of the TCP/IP protocol and in the context menu click on the Enabled item.
In the Warning form that opens, click OK. The selected protocol will be installed in network mode.
6. Restart your computer.
Connecting to the server:
1. For the first time, it is better to run the program on the same computer where SQL Server is installed.
Before that:
1.1. Open Configuration Manager ( Start >> Programs >> MS SQL Server 2008 >> Settings Tools).
In the "Dispatcher":
A) If you chose to start the server manually when installing the server, start "SQL Server" And "SQL Server Browser".
b) IN enable TCP protocol: Network configuration >> Protocols, right-click on "TCP/IP" - "Enable".
1.2.
Launch the program using the "Entrepreneur-SQL" shortcut (or the File menu >> Switch to SQL).
Create a new or migrate an existing database.
2. Connecting other computers on the network
(if you are using a terminal server, this will not be required).
All actions are performed on the computer where SQL Server is installed.
Menu File >> Open database, click "More".
2.1.
Click the "Firewall_Windows" button - "Create a rule automatically."
Or on your own:
Start >> Control_Panel >> System_and_Security >> Windows_Firewall >> Advanced_Settings >> Rules_for_Incoming_Connections: "Create a rule", select "For port" - 1433 TCP and 1434 UDP.
2.2.
Click the "Connect other users" button - "Create a login name". Set a name and password (any name, the password is preferably 6-7 characters, you don’t need to remember or enter it).
Or on your own:
In "Management Studio": Security >> Logins >> Create. Select "SQL Server Authentication", name and password, uncheck "Set expiration date".
Restart SQL Server (in "Configuration Manager").
2.3.
After this, a file will appear in the program folder connect.udl, in which all settings are saved.
Copy it to the program folder on other computers and run "Entrepreneur-SQL" there.
