INFORMATICS

The Best

Przełącznik języka

BUY COFFEE

If you like the website and want to support the project!

Postaw mi kawę na buycoffee.to

Tools

This Site

Mining

Security

CMS

Hardware

Backup

Windows Server

Uncategorised

useful sites

Databases

Emulators

Powershell

Storage Array

Active Directory

SEO

MSSQL

DNS

Antivirus program

Linux

Foto

You are here: Home

Adding a new instance of the MS SQL EXPRESS


How do I add another instance of MS SQL Express

Run the file from the installation version of MSSQL

 


To install a new instance of MSSQL database server, select option

New installation or add features to an existing installation.

Select the options - new installation or add shared features.

We accept licenses from Microsoft

We reaffirm the selected items to be installed - the default option

We create a new instance of the move to Named instance and enter the name here that will be displayed.


Click Next to create the instance

We reaffirm account settings SQL

Select the options Mixed Mode (SQL Server authentication and Windows authentication)


Set the path to the folder or leave them standard.

Uncheck or report errors

We finish adding instance - successfully

 

Off the SA account - red arrow

Off the sa account - red arrow

After installing a new instance of the server MSSQL may prove that the sa account is disabled.

Turn the database administrator account - SA with the command:

Launching 'sa' account - ALTER LOGIN sa ENABLE

Exclusion of 'sa' account - ALTER LOGIN sa DISABLE

How to do this: Go to the Query window -> press Command -> proceed Query.

Administrative account for the security is disabled by default since version of MS SQL 2005 Server and Express version.

Off the administrative account, as has the red arrow with the inscription SA.

versions of MSSQL

To check the version of SQL Server, including the level of service pack, issue the following commands in SQL Query Analyzer and the result checked in the table below in this article.

SQL 6.5 and SQL 7.0 and later:

SELECT @@VERSION

SQL Server 2000 i nowszy

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

As a result, the query returns:

     version of the product (eg. 8.00.2055)
     the product level (eg. SP4)
     edition (eg., Standard Edition)

 

Current versions on http://sqlserverbuilds.blogspot.com/

Microsoft SQL Server 2016 Builds

BuildKB / DescriptionRelease Date
13.00.500.53 Microsoft SQL Server 2016 Community Technology Preview 2.3 (CTP2.3) 28 Au 2015

 

SQL Server 2014
12.00.4422 3075950 Cumulative update package 2 (CU2) for SQL Server 2014 Service Pack 1 17 Aug 2015
12.00.4416 3067839 Cumulative update package 1 (CU1) for SQL Server 2014 Service Pack 1 22 June 2015
12.00.4100 SQL Server 2014 Service Pack 1 (SP1) 14 May 2015
12.00.2553 3075949 Cumulative update package 9 (CU9) for SQL Server 2014 17 Aug 2015
12.00.2546 3067836 Cumulative update package 8 (CU8) for SQL Server 2014 22 June 2015
12.00.2495 3046038 Cumulative update package 7 (CU7) for SQL Server 2014 23 Apr 2015
12.00.2480 3031047 Cumulative update package 6 (CU6) for SQL Server 2014 16 Feb 2015
12.00.2456 3011055 Cumulative update package 5 (CU5) for SQL Server 2014 18 Dec 2014
12.00.2430 2999197 Cumulative update package 4 (CU4) for SQL Server 2014 21 Oct 2014
12.00.2402 2984923 Cumulative update package 3 (CU3) for SQL Server 2014 18 Aug 2014
12.00.2370 02967546 Cumulative update package 2 (CU2) for SQL Server 2014 27 June 2014
12.00.2342 2931693 Cumulative update package 1 (CU1) for SQL Server 2014 21 April 2014
 12.00.2000 2977315 MS14-044: Description of the security update for SQL Server 2014 (GDR) 12 Aug 2014 
11.00.9120 Microsoft SQL Server 2014 Community Technology Preview 1 (CTP1) 25 June 2013

 

SQL Server 2012
     
11.00.5634 3082561 Cumulative update package 8 (CU8) for SQL Server 2012 SP2 21 Sep 2015
11.00.5623 3072100 Cumulative update package 7 (CU7) for SQL Server 2012 SP2 20 July 2015
11.00.5592 3052468 Cumulative update package 6 (CU6) for SQL Server 2012 SP2 19 May 2015
11.00.5582 3037255 Cumulative update package 5 (CU5) for SQL Server 2012 SP2 16 March 2015
11.00.5556 3007556 Cumulative update package 4 (CU4) for SQL Server 2012 SP2 20 Jan 2015
11.00.5548 3002049 Cumulative update package 3 (CU3) for SQL Server 2012 SP2 17 Nov 2014
11.00.5532 2983175 Cumulative update package 2 (CU2) for SQL Server 2012 SP2 15 Sep 2014
11.00.5532 2976982 Cumulative update package 1 (CU1) for SQL Server 2012 SP2 July 24, 2014
11.00.5058 SQL Server 2012 Service Pack 2 (SP2) June 10, 2014
11.00.3492 3052476 Cumulative update package 16 (CU16) for SQL Server 2012 SP1 May 18, 2015
11.00.3487 3038001 Cumulative update package 15 (CU15) for SQL Server 2012 SP1 March 16, 2015
11.00.3486 3023636 Cumulative update package 14 (CU14) for SQL Server 2012 SP1 January 19, 2015
11.00.3482 3002044 Cumulative update package 13 (CU13) for SQL Server 2012 SP1 November 17, 2014
11.00.3470 2991533 Cumulative update package 12 (CU12) for SQL Server 2012 SP1 September 15, 2014
11.00.3449  2975396 Cumulative update package 11 (CU11) for SQL Server 2012 SP1 July 21, 2014 
11.00.3431   2954099 Cumulative update package 10 (CU10) for SQL Server 2012 SP1 May 19, 2014 
 11.00.3412  2931078 Cumulative update package 9 (CU9) for SQL Server 2012 SP1 March 18, 2014 
 11.00.3401  2917531 Cumulative update package 8 (CU8) for SQL Server 2012 SP1 January 20, 2014 
11.00.3393   2894115 Cumulative update package 7 (CU7) for SQL Server 2012 SP1 November 18, 2013 
11.00.3381  2874879 Cumulative update package 6 (CU6) for SQL Server 2012 SP1 16 Sep 2013 
11.00.3373 SQL Server 2012 SP CU5 16 July 2013
11.00.3368 SQL Server 2012 SP CU4 31 May2013
11.00.3349 Cumulative update package 3 (CU3) for SQL Server 2012 SP1 18 March 2013
11.00.3339 Cumulative update package 2 (CU2) for SQL Server 2012 SP1 25 January 2013
11.00.3335 2800050 FIX: Component installation process fails after you install SQL Server 2012 SP1 14 January 2013
11.00.3321 Cumulative update package 1 (CU1) for SQL Server 2012 SP1 20 November 2012
11.00.3128 Windows Installer starts repeatedly after you install SQL Server 2012 SP1 3 January 2013
11.00.3000 SQL Server 2012 Service Pack 1 (SP1) 6 November 2012
11.00.2419  Cumulative update package 9 (CU9) for SQL Server 2012 21 August 2013
11.00.2410  Cumulative update package 8 (CU8) for SQL Server 2012 18 June 2013
11.00.2405  Cumulative update package 7 (CU7) for SQL Server 2012 15 April 2013
11.00.2401 Cumulative update package 6 (CU6) for SQL Server 2012 18 February 2013
11.00.2395 Cumulative update package 5 (CU5) for SQL Server 2012 18 December 2012
11.00.2383   Cumulative update package 4 (CU4) for SQL Server 2012 18 October 2012
11.00.2376  Microsoft Security Bulletin MS12-070 9 October 2012
11.00.2332 Cumulative update package 3 (CU3) for SQL Server 2012 29 August 2012
11.00.2325 Cumulative update package 2 (CU2) for SQL Server 2012 18 June 2012
11.0.2316         SQL Server 2012 CU1                    12 Apr 2012
11.0.2100.6 SQL Server 2012 RTM        7 Mar 2012
11.00.1913  Microsoft SQL Server 2012 Release Candidate 1 (RC1) 16 December 2011
11.00.1750  Microsoft SQL Server 2012 Release Candidate 0 (RC0) 17 November 2011
SQL Server 2008 R2
10.50.6000   SQL Server 2008 R2 Service Pack 3 (SP3) 26 Sep 2014 
 10.50.4319  2967540 Cumulative update package 13 (CU13) for SQL Server 2008 R2 Service Pack 2 30 June 2014 
10.50.4305   2938478 Cumulative update package 12 (CU12) for SQL Server 2008 R2 Service Pack 2  21 April 2014
 10.50.4302  2926028 Cumulative update package 11 (CU11) for SQL Server 2008 R2 Service Pack 2 18 Feb 2014
 10.50.4297  2908087 Cumulative update package 10 (CU10) for SQL Server 2008 R2 Service Pack 2 16 Dec2013 
10.50.4295   2887606 Cumulative update package 9 (CU9) for SQL Server 2008 R2 Service Pack 2 29 Oct 2013 
10.50.4290   SQL Server 2008 R2 SP2 CU8 30 Aug 2013
10.50.4286   SQL Server 2008 R2 SP2 CU7 17 June 2013
10.50.4285   SQL Server 2008 R2 SP2 CU6 (updated) 13 June 2013
10.50.4279   SQL Server 2008 R2 SP2 CU6 (replaced) 15 April 2013
10.50.4276    SQL Server 2008 R2 SP2 CU5 18 Februar 2013
10.50.4270    SQL Server 2008 R2 SP2 CU4 17 December 2012
10.50.4266    SQL Server 2008 R2 SP2 CU3 15 October 2012
10.50.4263    SQL Server 2008 R2 SP2 CU2 29 August 2012
10.50.4260    SQL Server 2008 R2 SP2 CU1 1 August 2012
10.50.4000 SQL Server 2008 R2 Service Pack 2 (SP2) 26 July 2012
10.50.3720     SQL Server 2008 R2 SP2 Community Technology Preview (CTP) 13 May 2012
10.50.2876      SQL Server 2008 R2 SP1 CU13 17 June 2013
10.50.2875      SQL Server 2008 R2 SP1 CU12 (updated) 13 June 2013
10.50.2874       SQL Server 2008 R2 SP1 CU12 (replaced) 15 April 2013
10.50.2861       Microsoft Security Bulletin MS12-070 9 October 2012
10.50.2869        SQL Server 2008 R2 SP1 CU11 18 February 2013
10.50.2868        SQL Server 2008 R2 SP1 CU10 17 December 2012
10.50.2866        SQL Server 2008 R2 SP1 CU9 6 November 2012
10.50.2861        SQL Server 2008 R2 SP1 Security Update 9 October 2012
10.50.2822        SQL Server 2008 R2 SP1 CU8 29 August 2012
10.50.2817        SQL Server 2008 R2 SP1 CU7 18 June 2012
10.50.2811         SQL Server 2008 R2 SP1 CU6                    16 April 2012
10.50.2806         SQL Server 2008 R2 SP1 CU5                    22 February 2012
10.50.2796         SQL Server 2008 R2 SP1 CU4                    9 Jan 2012
10.50.2789.0         SQL Server 2008 R2 SP1 CU3                    17 Oct 2011
10.50.2772.0         SQL Server 2008 R2 SP1 CU2                    16 Aug 2011
10.50.2769.0         SQL Server 2008 R2 SP1 CU1                    16 Sep 2011
10.50.2500.0 SQL Server 2008 R2 SP1        11 Jul 2011
10.50.1815         SQL Server 2008 R2 CU13                    17 Apr 2012
10.50.1810         SQL Server 2008 R2 CU12                    21 Feb 2012
10.50.1809         SQL Server 2008 R2 CU11                    9 Jan 2012
10.50.1807.0         SQL Server 2008 R2 CU10                    19 Oct 2011
10.50.1804.0         SQL Server 2008 R2 CU9                    23 Aug 2011
10.50.1797.0         SQL Server 2008 R2 CU8                    16 Sep 2011
10.50.1777.0         SQL Server 2008 R2 CU7                    16 Jun 2011
10.50.1765.0         SQL Server 2008 R2 CU6                    21 Feb 2011
10.50.1753.0         SQL Server 2008 R2 CU5                    20 Dec 2010
10.50.1746.0         SQL Server 2008 R2 CU4                    18 Oct 2010
10.50.1734.0         SQL Server 2008 R2 CU3                    17 Aug 2010
10.50.1720.0         SQL Server 2008 R2 CU2                    25 Jun 2010
10.50.1702.0         SQL Server 2008 R2 CU1                    18 May 2010
10.50.1600.1 SQL Server 2008 R2 RTM        12 Apr 2010
SQL Server 2008
10.00.6000 SQL Server 2008 Service Pack 4 (SP4) 30 Sep 2014
10.00.5861       SQL Server 2008 SP3 CU17 19 May 2014
10.00.5852       SQL Server 2008 SP3 CU16 17 March 2014
10.00.5850       SQL Server 2008 SP3 CU15 20 Jan 2014
10.00.5848       SQL Server 2008 SP3 CU14 18 Nov 2013
10.00.5846       SQL Server 2008 SP3 CU13 16 Sep 2013
10.00.5844      SQL Server 2008 SP3 CU12 16 July 2013
10.00.5841      SQL Server 2008 SP3 CU11 (updated) 13 June 2013
10.00.5840      SQL Server 2008 SP3 CU11 (replaced) 20 May 2013
10.00.5835       SQL Server 2008 SP3 CU10 18 March 2013
10.00.5829       SQL Server 2008 SP3 CU9 23 January 2013
10.00.5828       SQL Server 2008 SP3 CU8 19 November 2012
10.00.5826       Microsoft Security Bulletin MS12-070 9 October 2012
10.00.5794        SQL Server 2008 SP3 CU7 21 September 2012
10.00.5788        SQL Server 2008 SP3 CU6 16 July 2012
10.00.5785        SQL Server 2008 SP3 CU5 19 May 2012
10.00.5775         SQL Server 2008 SP3 CU4                    20 Mar 2012
10.00.5770         SQL Server 2008 SP3 CU3                    16 Jan 2012
10.00.5768         SQL Server 2008 SP3 CU2                    22 Nov 2011
10.00.5766         SQL Server 2008 SP3 CU1                    18 Oct 2011
10.00.5500 SQL Server 2008 SP3        6 Oct 2011
10.00.4330         SQL Server 2008 SP2 CU9                    19 Mar 2012
10.00.4326         SQL Server 2008 SP2 CU8                    30 Jan 2012
10.00.4323         SQL Server 2008 SP2 CU7                    21 Nov 2011
10.00.4321         SQL Server 2008 SP2 CU6                    20 Sep 2011
10.00.4316         SQL Server 2008 SP2 CU5                    18 Jul 2011
10.00.4285         SQL Server 2008 SP2 CU4                    16 May 2011
10.00.4279         SQL Server 2008 SP2 CU3                    21 Mar 2011
10.00.4272         SQL Server 2008 SP2 CU2                    17 Jan 2011
10.00.4266         SQL Server 2008 SP2 CU1                    15 Nov 2010
10.00.4000 SQL Server 2008 SP2        29 Sep 2010
10.00.2850         SQL Server 2008 SP1 CU16                    19 Sep 2011
10.00.2847         SQL Server 2008 SP1 CU15                    18 Jul 2011
10.00.2816         SQL Server 2008 SP1 CU13                    22 Mar 2011
10.00.2812         SQL Server 2008 SP1 CU14                    16 May 2011
10.00.2808         SQL Server 2008 SP1 CU12                    17 Jan 2011
10.00.2804         SQL Server 2008 SP1 CU11                    15 Nov 2010
10.00.2799         SQL Server 2008 SP1 CU10                    21 Sep 2010
10.00.2789         SQL Server 2008 SP1 CU9                    19 Jul 2010
10.00.2775         SQL Server 2008 SP1 CU8                    17 May 2010
10.00.2766         SQL Server 2008 SP1 CU7                    15 Mar 2010
10.00.2757         SQL Server 2008 SP1 CU6                    18 Jan 2010
10.00.2746         SQL Server 2008 SP1 CU5                    24 Nov 2009
10.00.2734         SQL Server 2008 SP1 CU4                    22 Sep 2009
10.00.2723         SQL Server 2008 SP1 CU3                    21 Jul 2009
10.00.2714         SQL Server 2008 SP1 CU2                    18 May 2009
10.00.2710         SQL Server 2008 SP1 CU1                    16 Apr 2009
10.00.2531 SQL Server 2008 SP1        7 Apr 2009
10.00.1835         SQL Server 2008 RTM CU10                    15 Mar 2010
10.00.1828         SQL Server 2008 RTM CU9                    18 Jan 2009
10.00.1823         SQL Server 2008 RTM CU8                    16 Nov 2009
10.00.1818         SQL Server 2008 RTM CU7                    21 Sep 2009
10.00.1812         SQL Server 2008 RTM CU6                    21 Jul 2009
10.00.1806         SQL Server 2008 RTM CU5                    18 May 2009
10.00.1798         SQL Server 2008 RTM CU4                    17 Mar 2009
10.00.1787         SQL Server 2008 RTM CU3                    19 Jan 2009
10.00.1779         SQL Server 2008 RTM CU2                    17 Nov 2008
10.00.1763         SQL Server 2008 RTM CU1                    22 Sep 2008
10.00.1600 SQL Server 2008 RTM        6 Aug 2008
SQL Server 2005
9.00.5324 2716427 MS12-070: Description of the security update for SQL Server 2005 Service Pack 4 QFE 9 October 2012
9.00.5295 2598903 FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 21 May 2012
9.00.5294 2572407 FIX: Error 5180 when you use the ONLINE option to rebuild an index in SQL Server 2005 10 August 2011
9.00.5292 QL Server 2005 Service Pack 4 QFE 14 June 2011
9.00.5266         SQL Server 2005 SP4 CU3                    21 Mar 2011
9.00.5259         SQL Server 2005 SP4 CU2                    22 Feb 2011
9.00.5254         SQL Server 2005 SP4 CU1                    20 Dec 2010
9.00.5000 SQL Server 2005 SP4        17 Dec 2010
9.00.4325         SQL Server 2005 SP3 CU15                    21 Mar 2011
9.00.4317         SQL Server 2005 SP3 CU14                    21 Feb 2011
9.00.4315         SQL Server 2005 SP3 CU13                    20 Dec 2010
9.00.4311         SQL Server 2005 SP3 CU12                    18 Oct 2010
9.00.4309         SQL Server 2005 SP3 CU11                    17 Aug 2010
9.00.4305         SQL Server 2005 SP3 CU10                    23 Jun 2010
9.00.4294         SQL Server 2005 SP3 CU9                    19 Apr 2010
9.00.4285         SQL Server 2005 SP3 CU8                    16 Feb 2010
9.00.4273         SQL Server 2005 SP3 CU7                    21 Dec 2009
9.00.4266         SQL Server 2005 SP3 CU6                    19 Oct 2009
9.00.4230         SQL Server 2005 SP3 CU5                    17 Aug 2009
9.00.4226         SQL Server 2005 SP3 CU4                    16 Jun 2009
9.00.4220         SQL Server 2005 SP3 CU3                    21 Apr 2009
9.00.4211         SQL Server 2005 SP3 CU2                    17 Feb 2009
9.00.4207         SQL Server 2005 SP3 CU1                    20 Dec 2008
9.00.4053         SQL Server 2005 SP3 GDR (Security Update)                    13 Oct 2009
9.00.4035 SQL Server 2005 SP3        16 Dec 2008
9.00.3356         SQL Server 2005 SP2 CU17                    21 Dec 2009
9.00.3355         SQL Server 2005 SP2 CU16                    19 Oct 2009
9.00.3330         SQL Server 2005 SP2 CU15                    18 Aug 2009
9.00.3328         SQL Server 2005 SP2 CU14                    16 Jun 2009
9.00.3325         SQL Server 2005 SP2 CU13                    21 Apr 2009
9.00.3315         SQL Server 2005 SP2 CU12                    17 Feb 2009
9.00.3310         SQL Server 2005 SP2 Security Update                    10 Feb 2009
9.00.3301 SQL Server 2005 SP2 CU11            15 Dec 2008
9.00.3294         SQL Server 2005 SP2 CU10                    20 Oct 2008
9.00.3282         SQL Server 2005 SP2 CU9                    18 Aug 2008
9.00.3257         SQL Server 2005 SP2 CU8                    16 Jun 2008
9.00.3239         SQL Server 2005 SP2 CU7                    14 Apr 2008
9.00.3233 SQL Server 2005 QFE Security Hotfix            8 Jul 2008
9.00.3228         SQL Server 2005 SP2 CU6                    18 Feb 2008
9.00.3215         SQL Server 2005 SP2 CU5                    17 Dec 2007
9.00.3200         SQL Server 2005 SP2 CU4                    15 Oct 2007
9.00.3186         SQL Server 2005 SP2 CU3                    20 Aug 2007
9.00.3175         SQL Server 2005 SP2 CU2                    28 Jun 2007
9.00.3161 SQL Server 2005 SP2 CU1            15 Apr 2007
9.00.3152         SQL Server 2005 SP2 Cumulative Hotfix                    7 Mar 2007
9.00.3077         SQL Server 2005 Security Update                    10 Feb 2009
9.00.3054         SQL Server 2005 KB934458                    5 Apr 2007
9.00.3042.01 SQL Server 2005 "SP2a"        5 Mar 2007
9.00.3042 SQL Server 2005 SP2            1 Feb 2007
9.00.2047 SQL Server 2005 SP1    18 April  2006
9.00.1399 SQL Server 2005 RTM        1 Nov 2005
SQL Server 2000
8.00.2039 SQL Server 2000 SP4        6 May 2005 
8.00.0760 SQL Server 2000 SP3           27 August 2003 
8.00.0532 SQL Server 2000 SP2        4 February 2003 
8.00.0384 SQL Server 2000 SP1          11 June 2001 
8.00.0194 SQL Server 2000 RTM             
SQL Server 7
7.00.1063 SQL Server 7 SP4 - SQL Server 7.0 Service Pack 4 (SP4)  
7.00.0961 SQL Server 7 SP3 - SQL Server 7.0 Service Pack 3 (SP3) 15 Dec 2000
7.00.0842 SQL Server 7 SP2 - SQL Server 7.0 Service Pack 2 (SP2) 20 Mar 2000
7.00.0699 SQL Server 7 SP1 - SQL Server 7.0 Service Pack 1 (SP1) 15 Jul 1999
7.00.0623 SQL Server 7 RTM            27 Nov 1998
SQL Server 6.5
6.50.416 SQL Server 6.5 SP5a - 197176 Microsoft SQL Server 6.5 Service Pack 5a (SP5a)  
6.50.415 SQL Server 6.5 SP5             
6.50.281 SQL Server 6.5 SP4 - 178295 Microsoft SQL Server 6.5 Service Pack 4 (SP4)  
6.50.258 SQL Server 6.5 SP3             
6.50.240 SQL Server 6.5 SP2 - 160727 Microsoft SQL Server 6.5 Service Pack 2 (SP2)  
6.50.213 SQL Server 6.5 SP1 - 153096 Microsoft SQL Server 6.5 Service Pack 1 (SP1)  
6.50.201 SQL Server 6.5 RTM             30 June 1996

Search