To organize the operation of any centralized system, you need a server that can handle requests from client software. Messengers, social networks, accounting and financial systems - all this has a common data processing scheme. For storage and retrieval of information, certain types of servers are used - SQL. They are based on the language of structured queries. It provides fast and reliable access to stored data, as well as their processing on the fly.
Microsoft SQL Server: Short Description
— , . -, . , SQL .
Microsoft.
SQL Server Express
. SQL Server Express :
- 32-, 64- Windows;
- 1,4 ;
- — 512 , 2 ;
- — 2,2 .
:
Windows Server 2008 R2. , SQL Server Express 2012 . . « SQL Server».
, . , , , . , .
. , . .
, . , , .NET Framework 3.5. , .
.NET Framework
. . .
Windows Server 2008 «», «». Features, - Add Features. , . NET Framework. . .
SQL Server Express 2012
Installation Rules. . « ». , . « » .
« » . . , .
« » « ». , .
«», , Microsoft. — .
, SQL Server Express.
. «», « », MS SQL Server Express Configuration Tools.
, . « SQLEXPRESS». . TCP/IP. Disbled Enabled, .
. IP- IPAll. TCP Port, 1433.
. — SQL Server Services. SQL. , Start Mode "". , Start.
SQL- .
Windows . «» - « ». , — , — . Inbound Rules. "" — « ». " ". Port. — TCP, — 1433. Action Allow the connection. , Profile, . .
— . .
, , .
SQL Server Managment Studio, , , SQL Server Express. , UDP, — 1434.
, Connections SQL Server Managment Studio. « ». . .
, MS SQL Server Express 2012. , . SQL Server 2008 Express , .
As a result, an affordable and productive data warehouse and its management system will be configured on the server.