Installing Microsoft SQL Server 2008 R2
1.) Before you start, you need to download and unpack the package with the program Microsoft SQL Server 2008 R2 by placing it in the required folder.
2.) You need to run the program installer " setup.exe"
3). In the dialog box, you must accept the installation NET Framework:
4.1)Download and installation progress
5.) The installation process is completed, you must click on the "Exit" button.
6.) After installing the Microsoft .NET Framework, the Fixes for Windows Server 2003 (KB942288-v4)", you must click on the "Next" button.
7.) It is also necessary to accept the licensing terms software, click the "Next" button. After that, the system update process takes place.
7.1) Installation process
8.) The installation process is completed, you must click on the "Finish" button.
9.) After installing the above software and updates, the PC needs to be rebooted, this will be warned in the dialog box. You must click the "OK" button and wait for the PC to restart.
10.) After the reboot, a new "SQL Server Installation Center" dialog box will automatically appear, in which you must select the "Installation" tab. On the tab, select " New installation or adding components to an existing installation."
11.) On top of this window, a new "Install SQL Server R 2" dialog box will launch and the PC will be checked for necessary components for further successful software installation.
12.) After checking the PC, you need to authenticate the installed software by specifying the edition or entering the product key.
14.) You must click the "Install" button to install the installer support files.
15.) It is necessary to wait for the end of the process of identifying problems, if any are identified, they must be eliminated and the test repeated. Otherwise, you must click the "Next" button.
16.) You must select the desired composition of the installation of SQL Server components and click the "Next" button.
18.) You must wait until the end of the rules definition process and click the "Next" button.
19.) After checking the rules, you need to configure the instance. For simplicity, you must select the "Default Instance" and click the "Next" button.
21.) Service accounts and collation configuration must be specified. For subsequent use, it is most appropriate to select "Use the same account for all server services". Press the "Next" button.
22.) The next step in the installation is to set the authentication mode to mixed and provide a password for the account system administrator SQL Server. After setting, click the "Next" button.
24.) Set the Reporting Services configuration mode. To obtain the desired result, you must select "Set the default configuration to work in native mode", click the "Next" button.
27.) At this step, you need to check all the installation components, the path of the configuration file and click the "Install" button.
28.) You can monitor the installation progress in the penultimate installation step.
29.) After a long installation, the step "Completed" comes. Installation completed.
Today we will consider the installation Express Version 2008 SQL Server, as well as the development and administration environment Management Studio Express. These products are free and are perfect for novice programmers and administrators.
Many novice programmers and administrators want to practice programming and database administration, but do not know how, because full-fledged DBMS are paid, so Microsoft specifically releases Express versions of their products, such as SQL Server Express, Management Studio Express, visual studio Express they are all free as they are lite versions. But for learning and practice, they are great, and if you master these products, then you can easily switch to full-fledged versions. This software certainly has different versions today we will consider installing the 2008 version of SQL Server Express and, accordingly, Management Studio Express 2008.
What is MS SQL Server 2008 Express and Management Studio Express
And first, let's talk about what kind of software it is.
Note! I will install these products on the operating system Windows Server 2008 r2, since I have a test server at hand with this particular version of the OS installed, respectively, the versions will be downloaded for the 64-bit processor architecture, my files are called as follows: SQLEXPR_x64_RUS and SQLManagementStudio_x64_RUS, but don't worry, the installation process is absolutely identical. You, accordingly, download distributions for your OS, for example, for a 32-bit architecture, the files will be called: SQLEXPR_x86_RUS and SQLManagementStudio_x86_RUS. This is if you, for example, want to install yourself on home computer. These products can be installed on Operating Systems like: Windows XP service pack 2, Windows XP Service Pack 3, Windows Vista, Windows 7 and of course for all server operating systems from Microsoft starting from version 2003. But you can find more details about the requirements and information on the official download page, I advise you to read it.
Installing SQL Server 2008 Express
After you have downloaded these installation packages, we proceed to the installation and we will start, of course, with SQL Server.
To do this, run the executable file, in my case SQLEXPR_x64_RUS. First, the files will be unpacked and then the “ SQL Server Installation Center» where, by the way, a lot useful information, you can climb, but to install we need to go to the item " Installation» and select « »
The installer will then check your system for possible problems and will return the results, which can be viewed by pressing the button " Show details”, and then click “OK”.
The installer will then ask you to install " ", we press" Install».
Speaking of which, a window will appear throughout the installation.
Do not be afraid, this is normal, because installing a SQL server is not an easy task for a computer.
For example, I have two warnings, the first is due to the fact that this server is a domain controller for me, and as you probably know, ideally a domain controller should only perform the functions of a domain controller and no more, but since I have this test server, I just do not pay attention to this warning, but I advise you not to install anything else on the controller. The second warning is related to the fact that my server is not connected to the Internet. does not have Internet access, for details you can click on the link "Attention!", where will detailed description errors or warnings.
Where we will be prompted to enter the product key, but since we have the Express version, we do not need to enter anything, so immediately click " Further».
And on this window we will be asked to read the terms of the license and accordingly agree with them, we read, agree and click " Further". I advise everyone to read the license terms of all products from Microsoft, as you can read something interesting, since I know perfectly well that no one ever reads these terms, but in vain.
After you clicked next, a window for selecting components will open, on the left in the window there will be a description of these components, we only need “ DataBase Engine Services", But what's trifles, let's install everything at once, so put all the checkmarks and click" Further”, Yes, by the way, here you can choose an alternative installation path for all components, but this is so by the way, suddenly someone needs it, but I leave everything by default.
Then we will be asked to change the name of the instance, I leave it as it is, and you, if of course you need it, you can rename it, click " Further».
Then the installer will analyze the free space on the disk, on which all SQL server components will be installed, everything is fine with me, so I immediately click " Further».
Then we continue to configure the SQL server, and at this stage we need to set the authentication settings, or rather the authentication mode and set the credentials of the SQL server administrator. I chose " Windows authentication mode» i.e. in this case, only those users who are registered on this computer or, if the server is included in a domain, all domain users will be able to connect to the SQL server, while creating users on the SQL server itself is not necessary. And to assign an administrator, I clicked " Add current user» i.e. my credentials under which I install the server ( you can assign multiple administrators). Click " Further».
On the next window, you can select the settings for sending error reports, I don’t want to send reports, so I don’t check the appropriate boxes, I click “ Further».
Then the program will inform us about the rules that will be followed or not followed during the installation process, I press " Further».
And finally, everything is ready for installation, and the program will display a summary of all installation parameters, you check everything and click " Install».
And now the installation has begun, it will take about 5 minutes and in conclusion it will display a window in which it will be indicated whether the installation of the SQL server components was successful, everything is fine with me, I press " Further».
That's all, the installation is completed, on the next window, just click close.
You can also close the window SQL Server Installation Center". The server, by the way, started immediately, you don’t need to force it to start, but for the future, you can start, stop or restart it using the snap-in “”, which you can find in:
Start->All Programs->Microsoft SQL Server 2008->Configuration Tools-> SQL Server Configuration Manager
Installing Management Studio Express
Now let's start installing management studio, to do this, run the installation package. And strangely enough, we will open again " SQL Server Installation Center". We also click Installation” and choose “ New installation of stand-alone SQL Server or adding features to an existing instance”, in general, everything is the same. There will be a window for checking the installation rules, click "OK" on it. Then, just like when installing the SQL server, the program will install " Installer Support Files". We do everything exactly as when installing the SQL server, we reach the component selection window, and select " Controls", in principle, you will not be mistaken, since you simply cannot select other components, click" Further».
Then again all the same windows, checks free space on the disk, sending reports, checking the installation rules and the installation itself, in the conclusion that the installation of the component was successful, a window will appear.
Start->All Programs->Microsoft SQL Server 2008->SQL Server Management Studio
After starting, you will need to configure the connection to the SQL server in the " Compound”, where in the field “ Server name» specify the computer name, then the name of our SQL server ( we asked it during the installation process, sqlexpress ), in the end I got dc1\sqlexpress, select established Check authenticity and click " Connect».
And if you did everything right, you will open Management Studio and, in particular, the object browser, where you can actually create databases, we talked about this in the material How to create a database in MSSql 2008 and write queries, well, in general, learn programming in Transact-SQL.
On this, our article has come to its logical conclusion. Good luck learning SQL Server!
Last update: 10.10.2017
MS SQL Server is available in various flavors. First of all, this is MS SQL Server Enterprise - a complete edition aimed at use in real projects. It is he who is used on various hosting and database servers. However, it is only available in a paid version (not counting the trial period) and costs quite a lot of money.
For simple applications the Express edition may also suffice: it's free. In addition, it has an advantage - it can be set up as a real server and used in real tasks, but it has reduced functionality compared to the full version.
And also there MS SQL Server Developer Edition. This is a full-featured release that contains all the functionality that the full version of MS SQL Server Enterprise has, but is aimed only at development needs. At the same time, this version cannot be used for deployment as a real server on real projects. However, to study all the mechanics of MS SQL Server, this version is the best option, so we will use this version.
So let's install MS SQL Server 2017 Developer Edition. To do this, go to https://my.visualstudio.com/Downloads?q=sql%20server%202017%20developer . An account may be required for access. Microsoft entry. In this case, you must sign in with your Microsoft account.
Leave the default language as English and load everything iso file. Since the downloaded file has the .iso extension, after downloading, unpack it and run the installer program. We will see the installation wizard window:
Here we select the first item "New SQL Server stand-alone installation or add features to an existing installation". Next, using a sequence of steps, we will need to set the installation options.
Click on the "Product Key" item. At this stage, you must enter the key, or specify one of the free editions. Here we specify the release "Developer" and proceed to a new step on the button Next.
Next, you will need to accept the license agreement. And then click through to the "Feature Selection" step. At this stage, you are prompted to select the components to install. Here we mark all the components, taking into account the amount of free memory:
Depending on the selected components, the number of installation steps increases, where you need to make any settings. In my case, all components are selected. Therefore, in what follows, we consider the case when all components are selected.
For the name, specify the Default instance option, and for the ID, set MSSQLSERVER . This will be the name of the instance by which we can access the server from external applications.
Then click the next two steps with default options to "Database Engine Configuration". Using the Add Current User button here, we will add the current user as an administrator for the server.
In the next step "Analysis Services Configuration" we will also add the current user as an administrator for the Analysis Services feature:
For the next two steps, leave the default settings. And then at the step "Distributed Replay Controller" we will similarly add the current user
In all subsequent steps, we will leave the default settings and on the very last screen for installation, click on the Install button:
After some time, MS SQL Server will be installed.
So, we installed SQL Server 2017, while assigning the identifier "MSSQLSERVER" to it. It should be noted that before connecting to it, you need to make sure that it is running. To do this, you can open the services window:
If it is not running, we can start it in the same place in the services panel, and after that we will be able to work with it.
To organize the work of any centralized system, a server is needed that can process requests from client software. messengers, social networks, accounting and financial systems - all this has a common data processing scheme. To store and retrieve information, separate types of servers are used - SQL. They are based on the Structured Query Language. It provides fast and reliable access to stored data, as well as their processing on the fly.
small description
This product is a free solution that allows you to short time deploy reliable storage for storing and processing large amounts of information. The server can be used to create web portals, applications and other types of specialized software. Actually, any site on the Web in one reincarnation or another uses the SQL server.
Download latest current version product is available from the official Microsoft website.
SQL Server Express limits on system resources
It is worth saying a little about the requirements. To run and ensure uninterrupted SQL job Server Express should look like this:
- operating systems can be used both 32-bit and 64-bit from the Windows line;
- Processor clock speed must exceed 1.4 GHz;
- RAM - at least 512 MB, preferably 2 GB;
- free hard disk space - 2.2 GB.
Installation: subtleties and nuances
Work will be considered Windows platform Server 2008 R2. It is assumed that SQL Server Express 2012 has already been downloaded and is present on the computer. You need to run its installer as an administrator. In the window that appears, select the item "Install a new instance of SQL Server".
Next will be the text license agreement to be read and accepted. Then, if updates were found that are relevant to this moment, you will be prompted to install them. This can be done later, in an already installed server.
The next step will present the choice of components. You can leave everything as suggested by the installer. Here you also need to specify the path to place the files.
Next, the installer will check if the system is ready for installation. And there might be a situation where it detects that the .NET Framework 3.5 component is missing. This means that you will have to interrupt for a while and install the required software.
Installing the .NET Framework on a Computer
This component contains a set of libraries and applications for working with network services and services. Without it, it is impossible to launch many systems and programs. Moreover, each individual version may contain its own set.
In 2008, this is done through the Start menu, then Administrative Tools. Select Features in the tree structure on the left, and Add Features in the main window. The system will prompt you to check the components that are available for installation. In this situation, the entire NET Framework package is of interest. In the next step, it is recommended to leave the default checkboxes. The final step will be a window with a message about the successful installation of the component.
Return to SQL Server Express 2012
Installation paused at the Installation Rules step. It needs to be restarted. The "Instance Configuration" item will appear. Here you can specify a name, and let the rest of the parameters remain as they are. Then in "Server Configuration" it is better to leave the default values.
The "Database Engine Configuration" item will prompt you to set the authentication method. It is better to choose a mixed mode. It is worth noting that this setting cannot be changed in the future.
Setting
After the installation is complete, you need to do a little initial configuration of SQL Server Express.
First you need to configure access to the server. To do this, go to the Start menu, then All Programs, MS SQL Server Express and Configuration Tools.
A window will open, in the left panel of which there is a tree structure of elements. It is interested in the item "Protocols for SQLEXPRESS". The nested elements will be displayed in the right window. You need to select TCP/IP. Through the context menu, the default value of Disbled is changed to Enabled, that is, it is enabled.
Then you need to select the properties of the protocol. The second IP address tab has an IPAll item. It contains the TCP Port values, which should be replaced with 1433.
Now we need to turn again to the element tree. Here you need to select the top one - SQL Server Services. You just need to check if the SQL browser server is running. If not, you need to double-click on it and set the Start Mode to "Automatic". And start the browser server manually by clicking in context menu start.
Now it remains to restart the SQL server completely.
Setting up incoming messages
To do this, you need to install in the firewall Windows new server rule. You can get into these settings through the "Start" - "Administration Tools". As usual, left panel- tree of elements, right - settings. You need to find the Inbound Rules item. And in the "Actions" window - "New Rule". The Setup Wizard will open. Here you need to select Port. Further, the protocol is TCP, and the port number is 1433. At the Action step, set Allow the connection. Further, on the Profile item, you need to specify the scope of the rule. All three checkboxes can be checked.
And the last step is setting the name. It is better to specify clear and accessible.
After the rule is configured and saved, it is worth making sure that it works and is running.
Client connection
In order to connect to the server through SQL Server Management Studio, you need to create a firewall rule, just like it was shown for SQL Server Express. The only difference is that the protocol will be UDP and the port will be 1434.
If you can't connect in any way, then you need to view the Connections properties in SQL Server Management Studio. Here the item "Allow remote connection to this server. It should have a checkbox enabled. Now everything will work.
Conclusion
The article showed how to install and configure Express 2012. As you can see, the procedure is not so complicated and any PC user can handle it. Installing the equally popular SQL Server 2008 Express may be slightly different from the version described in the article, but the methodology and algorithm will be the same.
As a result, an accessible and productive data storage and a data management system will be configured on the server.
The topic of installing MS SQL Server is usually bypassed. Indeed, it is difficult not to install this DBMS, even when doing it for the first time, it is just as difficult not to launch the 1C:Enterprise Server in conjunction with it. However, there are a number of subtle subtleties that can significantly poison the life of an administrator, which we will talk about today.
MS SQL Server ranks first in terms of the number of implementations in conjunction with 1C:Enterprise, this is largely due to the low entry threshold, a person without experience is quite capable of mastering this bundle, purely according to the Next - Next - Finish method. And, what is most interesting, all this will work. Let's say more, in the overwhelming majority of cases, the default SQL server settings are more than enough to ensure the productive operation of the 1C: Enterprise server and touching them is not only unnecessary, but even harmful.
First of all, remember to system base tempdb, which is actively used by 1C to store temporary tables and intermediate results. Moreover, it is used immediately by all 1C databases running on the server. And since by default it is located in the installation folder of the SQL server, i.e. on the system drive, then as the load increases tempdb becomes a bottleneck for the entire server. Very often this leads to situations: bought fast HDD/ SSD, there are enough disk resources, and 1C slows down, which can cause serious difficulties for novice administrators.
Second moment. Comparison encoding tempdb must match the comparison encoding information bases, otherwise this may in some cases lead to unexpected results, up to serious errors in the calculations.
At the same time, these difficulties are not at all difficult to avoid, just spend a couple of extra minutes during installation or carefully review the settings of an already installed server.
Installing MS SQL Server to work with 1C:Enterprise
As we have already said, installing SQL Server is extremely simple, and we will not describe this process in detail, paying attention only to the necessary settings. Let's start with the choice of components, since 1C does not use most of the mechanisms of the SQL server, and if you are not going to use them for other purposes, then we leave only Database Engine,Communication means of client funds and Controls(optional).
Management tools can not be installed on the server, but installed separately on the administrator's workstation and managed from there available servers MS SQL.
You should also check the sorting options, if your regional settings are correctly configured, then most likely you won’t have to change anything there, but it’s desirable to control this parameter, there should be Cyrillic_General_CI_AS.
AT Server Configurations specify Mixed Mode Authentication and set a password for SQL superuser - sa. Also specify below the administrators of this instance of the SQL server, by default there is already an account under which the installation was made, but if other users should also administer this instance, then it makes sense to specify them right away.
Next bookmark - Data directories- requires the most careful attention. Be sure to specify as the storage location for user databases and database tempdb space on a productive array or a separate disk. Although you can specify the location of the database when creating it, the task correct settings by default, it saves you from unnecessary work, as well as from the situation when the database is created using 1C tools and ends up in the default directory, i.e. on the system drive. You can also immediately specify the directory for storing backups.
You can leave the rest of the settings as default and complete the installation.
Setting up MS SQL Server to work with 1C:Enterprise
If you are dealing with an already installed instance of SQL Server, make sure that the comparison encoding Cyrillic_General_CI_AS, otherwise, the data should be uploaded using 1C tools, and the server should be reinstalled (or install another instance if this one is used by other services).
To do this, open Management Studio, select the required instance of the SQL server and clicking on it right click mouse go to Properties.
Then go to bookmark Memory and specify the amount of RAM available to the SQL server, otherwise the SQL server will seek to utilize all available memory. In a situation where the roles of the SQL server are combined with other roles, and in small and medium-sized implementations, it is usually located on the same machine as the 1C server, you should subtract the required system and 1C server from the total amount of memory, giving SQL what remains.
It is difficult to give unambiguous recommendations here, it all depends on the amount of data being processed, in practice it makes sense to allocate half of the free memory to the SQL server, subsequently adjusting this value based on its actual load.
The next setting will be related to security. To connect 1C to the server, an account is most often used sa, which, to put it mildly, is unsafe, as it gives the person who entered under it full access to the SQL server. Considering that 1C databases are often administered by third-party specialists, it makes sense to create a separate account for them.
To do this, open Security - Logins and create a new name (account), specify authentication SQL Server and set a password.
Then go to bookmark Server Roles and allow dbcreator, processadmin and public.
Then use this account to connect to the SQL server from 1C.
Another setting applies to already created databases, open the properties of the desired database and go to the tab Files. Find an option Auto Zoom/Maximum Size for the data file. By default, there is 1 MB, which is very suboptimal, when actively working with the database, the DBMS will only increase the file size, in addition, when several databases are actively working, this will lead to significant fragmentation of the data file. Therefore, based on the size of the database and the activity of the work, set a higher value that will not lead to a constant increase in the database file.
Transferring tempdb
In conclusion of our article, we turn again to the database tempdb, there are often situations when the file of this database needs to be moved to another location. For example, the server was installed with default settings and tempdb is located system partition, or you have purchased an SSD and want to bring there not only bases, but also tempdb(which is the correct solution). Also, under heavy load tempdb it is recommended to put it on a separate disk.
To change the location of a file tempdb open Management Studio, select Create request and in the window that opens, enter the following text, where E:\NEW_FOLDER- new base location:
use master
alter database tempdb
modify file(
name=tempdev,
filename = N"E:\NEW_FOLDER\tempdb.mdf")
go
alter database tempdb
modify file(
name=templog,
filename = N"E:\NEW_FOLDER\templog.ldf")
go
Then click Run, after executing the query, restart the SQL server, database and log files tempdb will be created in the new location, the files in the old location must be deleted manually.
This is where we will end today, finally reminding you not to forget about database maintenance and backups.