MS SQL Server: installation and configuration. Versions of MS SQL Server. MS SQL Server and 1C

MS SQL Server Microsoft. , . , , . 1985 , , .

, 90-

1989 - , Microsoft Ashton-Tate. . -, . -, .

1990 - MS SQL Server 1.1. ( , SQL), .

1993 - SQL Server for Windows NT, .

1995 - Microsoft SQL Server 6.0, , Sybase (, Microsoft 1987 ). .

1998 - - SQL Server 7.0. , . , .

, 2000

1999 - MS SQL Server 2000, . , . , , ( ).

2003 - MS SQL Server 2005. , , .

2008 - . , MS SQL Server 2005. - .

2010 Compact 4.0. , API, NET Framework, Visual Studio 2010. 2014 . ( ), -. . SQL Server 2016, .

, . :

• - Intel ( ) Pentium III 1000 .
• - 512 .
• - 20 .

:

• - Intel Core i7 3000 .
• 4 ;
• 100 .

, , , . MS SQL Server Windows. , .

1. ( " ").
2. " ". "", .
3. , "", , .
4. ( ).
5. , , .
6. "".
7. .
8. " ".

. , .

MS SQL Server . , .

1. " " ( ). , Full Text Filter Daemon Launcher, "". "".
2. " " - , "".
3. " Database Engine" " " . " ". , . .
4. ( ).
5. , .

, .

. , . MS SQL Server :

1. "" " " > MS SQL Server > .
2. Protocols for SQLEXPRESS, TCP/IP.
3. TCP/IP Enable.
4. "", IP Adresses.
5. SQL Server Services.
6. SQL Server Services, restart.

. :

1. "" > "".
2. Inbound Rules.
3. Port.
4. TCP , 1433.
5. Allow the connection.
6. Profile .
7. .

, MS SQL Server .

. , MS SQL Server:

• 1 , .
• , .
• , . : SET IMPLICIT_TRANSACTIONS OFF.
• , , . .
• "".

, . , . MS SQL Server 1 , . , .