01.10.2015

1. Installation and configuration SQL Server 2008 Express on computers with Windows 7 and 8 / 8.1 to connect to the "Electronic Dormitory" program.

2. Configuring SQL Server for networking.

3. Reinstall (uninstall) SQL Server 2008 Express on Windows 7 and 8 / 8.1 computers.

4.Connecting the program "Electronic Dormitory" to SQL Server 2008 Express.

1. Installing and configuring SQL Server 2008 Express on computers running Windows 7 and 8 / 8.1 for connectionto the program "Electronic dormitory"

1.1. Download SQL Server 2008 Express from the official Microsoft website (free and open source).

1.2. Run the installation file.

1.3. Wait while the program unpacks the required data:

Fig. 1. Unpacking data.

1.4. In the window SQL Server Installation Center on the left select the item "Installation" and press « New installation stand-alone SQL Server or add features to an existing instance "(see Fig. 2).

A window should start Installing SQL Server 2008, then a check is carried out for problems that may interfere with the installation. If the test passed, click "OK".

If your operating system did not pass the check for any reason, click "Show details" and fix the error.

Fig. 2. New installation.

To you not required enter your product key as this is the free edition of SQL Server. Click the button "Further", read the license terms, click the button "Further"... Click the button "Install"... The installer will copy the files it needs to disk. Wait for the end of the operation.

1.6. A window will open where a check for the presence of the required components is carried out. If the verification is successful, press "Further".

If you identify the need to install components, install them and go through the test again.

Fig. 3. Components Tab.

1.8. Select the database server name and installation directory. It is recommended to choose the server name as: "SQLEXPRESS"... Click on "Further".

Fig. 4. Server name.

1.9. The installer will check for free disk space. If the procedure is successful, press "Further"... Otherwise, you will need to free up the disk space required for the server.

1.10 Configure service accounts as shown in the figure. V this example the service will be started as account: SYSTEM of the operating system (NT AUTHORITY). Click on "Further".

Fig. 5. Accounts.

1.11 Next item "Tuning the Database Engine"... We recommend that you select Mixed Authentication Mode.

Remember to assign a password to the administrator and remember it.

After installation SQL Server You will be able to connect to it using your login "Sa" and password which you entered at this stage of the installation. You can also use this username and password to connect from the application to the database. Connection settings will be described below. In addition, you can add the current user of the operating system or anyone else to the administrators using the buttons at the bottom of the window. Click on "Further".

Fig. 6. Preparing an administrator account.

Note: if you wish, then on the tab that appears, you can agree to transfer reports on the SQL Server operation to its developer - Microsoft. You can agree to the proposal by checking the appropriate boxes, or reject it. Click on "Further".

1.13 Click "Install"... The installation process for SQL Server should begin. Wait for the installation to finish and click "Further", click Close.

2. Configuring SQL Server for Networking

In order to do SQL Server available for network communication, you need to open the port and activate the protocol TCP / IP for SQL Server Service.

To activate the protocol TCP / IP:

2.1. Run SQL Server Configuration Manager("SQL Server Configuration Manager"). To do this, open the program shortcut by running: Start → All Programs → Microsoft SQL Server 2008 R2 (2005/2008) → Configuration Tools → SQL Server Configuration Manager →;

2.2. After starting SQL Server Configuration Manager, you need to expand the node "SQL Server Network Configuration"("SQL Server Network Configuration"), select item "Protocols for » (instead of the name of your instance of SQL Server, as specified during installation);

2.3. Then, on the right side of the Configuration Manager window, select the protocol TCP / IP and open it by double-clicking on it with the left mouse button or select the item "Properties" context menu for this item;

2.4. In the tab "Protocol"("Protocols") set the switch "Enabled" into position "Yes"("Yes"):

2.5. In the tab "IP Addresses"("IP addresses") in the area containing
The IP address corresponding to the IP address of the computer on which the instance of SQL Server was installed must be installed:

• switch "Active"("Active") to position "Yes"("Yes"):

• switch "Enabled"("On") to the position "Yes"("Yes"):

• in the area of "IPAll" in field "TCP Port"("TCP-port") should be written 1433 :

in field "TCP Dynamic Ports"("Dynamic TCP Ports") remove the content (if any) and leave it blank;

2.6. Then you need to press the button OK... A window will appear notifying you that all changes have been saved but will take effect after restarting the SQL Server service.

Fig. 7. Window with notification about saving changes.

2.7. Play items 2.3 and 2.4 for others "Protocols".

For restarting the service you must select "SQL Server Services" in the "SQL Server Configuration Manager". The right pane displays a list of available SQL Server related services.

2.8. Select a running service named SQL Server (SQLEXPRESS) where instead of SQLEXPRESS name your his an instance of SQL Server

3. Reinstall (uninstall) SQL Server 2008 Express on Windows 7 and 8 / 8.1 computers

In the case when an instance of SQL Server is already installed on the computer and for correct work program, it must be reinstalled (uninstalled), then the following sequence of actions is proposed:

3.1. For complete removal server: uninstall all SQL Server components through the Programs and Features window following all the instructions of the Installer ( Control Panel → Programs → Programs and Features).

Fig. 8. Programs and components (sample list).

To remove a specific instance: uninstall Microsoft SQL Server 2008 and follow the instructions in the Installer to select a specific instance name to uninstall. The rest of the SQL Server components do not need to be removed.

3.2. Further, on the local disk where SQL Server is installed (by default - in the folder “ Program Files"And / or" Program Files (x86) "), you must manually delete the directory left after the item 3.1. - "Microsoft SQL Server \ 100". When deleting, click "Skip" for those files that cannot be deleted.

Note: folder "Microsoft SQL Server \ 100" means the server version, in this case 100 is SQL Server 2008.

3.3. Reboot your computer.

3.4. Repeat step 3.2.

Attention! There is an issue where the steps taken are not sufficient for a fresh install (reinstallation) of SQL Server from the same distribution (same version). During the installation of SQL Server - the process is simply interrupted without any messages. This problem lies in the data stored in the registry left over from the previous server. In this case, we recommend that you follow the steps described below.

* Information on the items below is taken from the site:

Windows Registry Editor Version 5.00

"BootstrapDir" = "C: \\ Program Files \\ Microsoft SQL Server \\ 100 \\ Setup Bootstrap \\"

"PatchLevel" = "10.0.1600.22"

3.6. Then you need to change the extension to ".Reg", double-click on the file and in the line that appears, select "Yes" to fill the registry.

3.7. Then copy the following files and folders from the unpacked SQL Server distribution in the directions indicated:

4. Connection of the program "Electronic dormitory" to SQL Server 2008 Express

4.1. When you first start the program, after registration, a window will appear on the screen for connecting the program to SQL Server, where you need to register as a login "Sa", and the password - the one that was entered in paragraph 1.11 of this manual.

In the server row, select the installed instance of SQL Server with the appropriate name and specify a name for the new database.

Server connection.

4.3. Left-click on a field "To come in", after which the main program window "" should open.

To organize the work of any centralized system, a server is needed that could process requests from the client software... Messengers, social networks, accounting and financial systems - all this has general scheme data processing. For storing and retrieving information, separate types of servers are used - SQL. They are based on the language structured queries... 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 quickly deploy a reliable storage for storing and processing large amounts of information. The server can be used to create web portals, applications and other kinds specialized software... Actually, any site on the Internet in one or another reincarnation uses a SQL server.

You can download the latest current version of the product from the official Microsoft website.

SQL Server Express System Resource Limits

It is worth telling a little about the requirements. To start and ensure smooth operation of SQL Server Express, you need to change to the following form:

• operating systems can be used both 32- 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 with the platform will be considered Windows Server 2008 R2. It assumes that SQL Server Express 2012 is already downloaded and present on the computer. You need to run its installer as administrator. In the window that appears, select the "Install a new instance of SQL Server" item.

The following text will be presented license agreement with which you need to read and accept it. Then, if updates were found that are relevant at the moment, you will be prompted to install them as well. This can be done later, in an already installed server.

In the next step, a selection of components will be presented. You can leave everything as the installer suggested. Here you also need to specify the path for placing the files.

Next, the installer will check if the system is ready for installation. And a situation may arise when it detects that a component is missing. NET Framework 3.5. 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 separate 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 select the components that are available for installation with checkmarks. In this situation, the whole NET Framework package is of interest. In the next step, it is recommended to leave the default checkboxes. The final stage will be a window with a message about the successful installation of the component.

Fallback to SQL Server Express 2012

The installation paused at the Installation Rules step. It needs to be renewed. Instance Configuration appears. Here you can specify a name, and let the rest of the parameters remain as they are. Then, in Server Configuration, it is best to leave the default values.

The item "Database engine configuration" will offer to set the authentication method. Better to choose mixed mode. It should be noted that this setting cannot be changed in the future.

Customization

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 pane 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. Select TCP / IP. Through the context menu, the default value Disbled is changed to Enabled, that is, it is enabled.

Then you need to select the properties of the protocol. The second tab of the IP address has an item called IPAll. It contains the TCP Port values, which should be replaced with 1433.

Now we need to go back to the element tree. Here you need to select the top one - SQL Server Services. You just need to check if the server is running SQL browser. If not, you need to double-click on it and set the Start Mode to "Automatic". And start the server browser manually by clicking Start in the context menu.

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 rule for the server. You can get into these settings through "Start" - "Administration Tools". As usual, the left panel is the tree of elements, the right one is the settings. You need to find the item Inbound Rules. 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 indicate what is understandable and accessible.

After the rule is configured and saved, it is worth making sure that it is working and running.

Client connection

In order to connect to the server through SQL Server Managment 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, you need to view the Connections properties in SQL Server Managment Studio. Here I am interested in the item "Allow remote connection to this server ". The checkbox must be checked in it. Everything will work now.

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. The installation of the equally popular SQL Server 2008 Express may differ slightly from the version described in this article, but the methodology and algorithm will be the same.

As a result, the server will be configured with an available and efficient data storage and data management system.

Server connection:

1. It is better to run the program for the first time on the same computer where SQL Server is installed.
Before that:

1.1. Open "Configuration Manager" ( Start >> Programs >> MS SQL Server 2008 >> Configuration Tools).

In the "Dispatcher":

a) If you chose to start manually when installing the server, start "SQL Server" and "SQL Server Browser".

b) V enable TCP protocol: Network Configuration >> Protocols, right click on "TCP / IP" - "Enable".

1.2. Run the program using the "Entrepreneur-SQL" shortcut (or File >> Switch to SQL).
Create a new or transfer an existing database.

2. Connecting other computers on the network
(if you are using a terminal server, this is not required).

All actions are performed on the computer where SQL Server is installed.
Menu File >> Open Database, press "More".

2.1. Click the "Windows Firewall" - "Create rule automatically" button.
Or on your own:
Start >> Control Panel >> System_and_Security >> Windows_Firewall >> Additional_options >> Rules_for_inbound_connections: "Create a rule", select "For port" - 1433 TCP and 1434 UDP.

2.2. Click the button "Connect other users" - "Create login name". Set a name and password (any name, a password is desirable 6-7 characters, you do not need to remember and enter).
Or on your own:
In "Management Studio": Security >> Logins >> New. Select "SQL Server Authentication", name and password, uncheck "Set expiration date".
Restart SQL Server (in Configuration Manager).

2.3. After that, the 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.

Microsoft® SQL Server® 2012 Express - free system data management, is used to ensure the storage of data and the organization of network operation of some programs, in particular the program "Maintenance of contracts 5.9 version of MS SQL".

This product is installed on a server or on a computer acting as 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 work of this product, you need to 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 Setup form will open.

If you accept the License Agreement, check the box "I accept the terms of the license agreement" and click the Next button.

The installation process for the prerequisites for SQL Server 2012 begins.

Enlarge image

If a product update is required, install the update.

3. In the Select Form Components step of SQL Server 2012 Setup, ensure that all check boxes are selected in the Components section.

If necessary, click the Select All button to select the check boxes for all values. Then click the Next button.

Enlarge image

4. In the next step, "Instance Configuration", in the "Named Instance" field, enter SQLExpress or enter another name in Latin characters (for example, Express2012) if the computer already has SQL Server with this name installed (for example, SQL Server 2008 with an SQLExpress instance is installed) ...

Enlarge image

5. In the next step, Server Configuration, in the Service Accounts table, check that all services in the Startup type column are set to Auto.

If the SQL Server Browser service is set to Disabled, left-click the drop-down list in the Startup type field and select Auto.

Enlarge image

6. In the next step, Configure the Database Engine, select the Mixed Mode (SQL Server and Windows Authentication) radio button.

In the Enter field group password field, Enter the password for the account system administrator SQL Server (sa) 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 "Maintenance of contracts 5.9 version of MS SQL" program.

Enlarge image

For a local installation, you can leave the "Windows Authentication Mode".

Before creating the database, you will be prompted to select a method for storing scanned images and files in the MS SQL Server database.

In the program "Maintenance of contracts 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 the File Tables storage").

The FileStream option is only possible in MS SQL Server 2008 and higher.

The use of FileStream is not subject to the database limitation for the Express version (10GB for Microsoft® SQL Server® 2012 Express), as a result, it becomes possible to store a large volume 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 used instance of MS SQL Server

To enable FILESTREAM in the dialog box, go to the FILESTREAM tab.

Select the Allow FILESTREAM When Accessing Transact-SQL check box.

Enlarge image

7. At the next step, "Error Reporting", click the Next button.

Enlarge image

8. The next step "Installation Progress" will begin the installation of SQL Server 2012.

Enlarge image

Wait for the installation to complete.

9. When the installation of SQL Server is complete, the Completed form appears.

Verify that for all items under "Installation Operation Details or Possible Next Steps", the "Status" column is listed as Successful.

Enlarge image

Click on the "Close" button.

The installation of MS SQL Server 2012 will be completed.

Considerations for Configuring SQL Server 2012 Express for Online Mode

To ensure network use of the "Contract Management 5.9 version of MS SQL" program, check the following SQL Server 2012 Express settings:

- Activity of the SQL Server Browser service

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 the SQL Server Browser value.
The Start Mode field must be set to Auto.

3. If the Run Mode field is set to a different value, double-click the SQL Server Browser value. The Properties: SQL Server Browser form opens.

In the form that opens, go to the Service tab and in the Start mode field in the drop-down list select the Auto value 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 as 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 will open.

2. On the left side of the SQL Server Configuration Manager form, navigate to SQL Server Network Configuration / Protocols for SQLEXPRESS.

3. Protocols Shared Memory, Named Pipes, TCP / IP must be Enabled.

Enlarge image

4. Move the mouse cursor over the name of the Named Pipes protocol and click on the Enabled item in the context menu.

5. Place the mouse cursor over the name of the TCP / IP protocol and click on the Enabled item in the context menu.

In the Warning form that opens, click the OK button. The selected protocol will be installed in online mode.

6. Restart your computer.

This article will provide detailed step-by-step instruction on Microsoft installation SQL Server 2012. The example shows the specifics of install in operating systems - and, in other operating systems of the family Windows process installation is similar.

1. What you need

1. A computer that meets the minimum system requirements to work with SQL Server 2012. Details about hardware requirements and operating system read.
2. Administrator rights on the local computer.
3. Microsoft SQL Server 2012 installation disk, or disk image (you can download it, for example, on the official website).
4. A valid product key (optional) for.

2. Installing .NET Framework 3.5

The first step is to install the .NET Framework 3.5 SP1. How to do this can be read in the articles:

3. Installing SQL Server 2012

Run the file “ setup.exe"From the installation disc.

Opens " SQL Server Installation Center"(SQL Server Installation Center), go to the" Installation"(Installation) and click on" New installation of a stand-alone instance of SQL Server or adding features to an existing installation"(New SQL Server stand-alone installation or add features to an existing installation).

It will start " SQL Server 2012 Setup"(SQL Server 2012 Setup). Make sure that there are no problems that may arise during the installation of the installer support files and click " OK". If, nevertheless, any problems have arisen, it is necessary to 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 a free edition of SQL Server. This 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 entered key, the corresponding key will be selected for installation.

We accept the terms of the license agreement, agree (or not) to transfer data on the use of components to Microsoft and click " Further"(Next).

If there are updates to the installer, enable the product update by clicking " Enable SQL Server Product Updates"(Include SQL Server product updates) and click" Further"(Next).

We are waiting for the download of updates and installation of the SQL Server installation files to finish.

So the preparatory stage is over, and we proceed to the direct installation and selection of SQL Server parameters. Make sure that there are no problems that may arise during the installation and click " Further"(Next). If all there are any problems, it is necessary to eliminate them and repeat the verification procedure by pressing the button " Re-enable"(Re-run).

We select the installation option “ 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 the operation and administration of the server 1C: Enterprise), it is 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, that is, the components

• Management Tools - Basic
  • Management Tools - Complete

All components can always be delivered / removed by simply re-running the SQL Server installation. Having selected the necessary components, click " Further"(Next).

Again, we make sure that the installation process will not be blocked, fix the problems otherwise and click " Further"(Next).

Now you need to enter a name for the named instance of SQL Server, or leave the default instance name. On one isolated server, it is possible to install up to 50 named instances of MS SQL Server 2012 and up to 25 in a failover cluster using a shared cluster disk (link). There can be only one default instance. Having decided on the name (Named instance) and identifier (Instance ID) of the SQL Server instance, click " Further"(Next).

Make sure 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 to " Auto»(Automatic) (to run scheduled SQL Agent jobs). In this window, you can also specify from under which various SQL Server services will be launched by selecting it in the column " account name"(Account name) and entering the password for this account in the column" Password»(Password) next to the corresponding service. Next, go to the tab “ Sorting options"(Collation).

For most programs that will work with the SQL server (for example, for systems 1C: Enterprise) it is enough to choose “ Cyrillic_General_CI_AS". After specifying the sorting parameters, click " Further"(Next).

The Authentication Mode should now be selected. 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 the available 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 free program... Having set all the parameters, go to the tab " Data directories"(Data Directories).

Here you can select the Data root directory. For most cases, it is recommended to adhere to the following rules:

• If the server configuration contains a RAID array from hard drives, it is reasonable to place the data files on it.
• If possible, it is recommended that you separate the database files and database log files on separate disks.
• It is desirable to move the temp system database directory and temp log directory to a fast SSD disk, this will give a tangible performance boost to SQL Server.
• In some situations, it makes sense to change the directory Reserve copy choosing physical disk other than the disk with the database files.

After specifying the necessary paths, go to the "FILESTREAM" tab.

If in the future it is planned 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 make the decision to send (or not send) error reports to Microsoft and click again " Further"(Next).

Once again, we make sure that the installation process will not be blocked, correct errors, if any, 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 reinstalling SQL Server, this file can be specified as a parameter for the installer, in which case the SQL Server installation will proceed in automatic mode, and the settings will be taken from config file. This method can be used if you need to quickly install several instances of SQL Server with the same parameters, or to "backup" the parameters accepted during the 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 its end.

Then we make sure that all components are installed successfully and exit the wizard by clicking on the button " Close"(Close).

The installation of Microsoft SQL Server 2012 is now complete.

4. Configuring Windows Firewall for MS SQL Server 2012

If it is assumed that programs located on other computers in the network will work with the SQL server, then on the server itself where the SQL Server service is running, you need to configure Windows firewall to run SQL Server. 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, followed by" \ "followed by the name of the SQL server instance, or the used alias of the SQL Server instance, if one is specified.

Did this article help you?