How to install SQL Server Express Edition - Revision history

Konstantinos Kontogiannis at 11:27, 8 June 2018

2018-06-08T11:27:36Z

Konstantinos Kontogiannis at 08:21, 4 June 2018

2018-06-04T08:21:13Z

Konstantinos Kontogiannis at 13:24, 27 August 2015

2015-08-27T13:24:18Z

Konstantinos Kontogiannis at 13:22, 27 August 2015

2015-08-27T13:22:12Z

Konstantinos Kontogiannis at 13:21, 27 August 2015

2015-08-27T13:21:29Z

Konstantinos Kontogiannis at 13:19, 27 August 2015

2015-08-27T13:19:12Z

Konstantinos Kontogiannis at 12:38, 27 August 2015

2015-08-27T12:38:58Z

Konstantinos Kontogiannis at 12:38, 27 August 2015

2015-08-27T12:38:09Z

Konstantinos Kontogiannis at 12:51, 10 July 2015

2015-07-10T12:51:57Z

Konstantinos Kontogiannis at 12:36, 10 July 2015

2015-07-10T12:36:30Z

← Older revision		Revision as of 11:27, 8 June 2018
Line 33:		Line 33:


−	8. In '''Server Configuration''', you can specify service startup and authentication.Under the '''Service Account''' tab, for services '''SQL Server Agent''' and '''SQL Server Database Engine''', enter the data of that user which the DLS nodes utilize for connecting to the database. This user must be part of the administrators group. In Startup Type, select "Manual" for the SQL Server Agent, and "Automatic" for the SQL Server Database Engine.	+	8. In '''Server Configuration''', you can specify service startup and authentication.Under the '''Service Account''' tab, for services '''SQL Server Agent''' and '''SQL Server Database Engine''', enter the data of that user which the DLS nodes utilize for connecting to the database. This user must be part of the administrators group. In '''Startup Type''', select '''Manual''' for the '''SQL Server Agent''', and '''Automatic''' for the '''SQL Server Database Engine'''.

	[[File:SQL_server_acc2.jpg]]		[[File:SQL_server_acc2.jpg]]

← Older revision		Revision as of 08:21, 4 June 2018
Line 73:		Line 73:
	The Express Edition is configured by Microsoft this way because it is supposed to be an SQL Server edition for home or single computer use where TCP/IP networking is not necessarily required.		The Express Edition is configured by Microsoft this way because it is supposed to be an SQL Server edition for home or single computer use where TCP/IP networking is not necessarily required.
	However, DLS requires TCP/IP connectivity even when the SQL Server is locally installed.The TCP/IP enabling procedure and SQL Browser service configuration is required only for the SQL Server Express Edition. For higher editions,e.g. DLS remote database and multi-node deployments, the TCP/IP is enabled by default.		However, DLS requires TCP/IP connectivity even when the SQL Server is locally installed.The TCP/IP enabling procedure and SQL Browser service configuration is required only for the SQL Server Express Edition. For higher editions,e.g. DLS remote database and multi-node deployments, the TCP/IP is enabled by default.
−
−	'''IMPORTANT:''' In a '''Windows 2012''' server when installing an '''SQL 2012 Express Edition''',you need to refer to DLS service and under the properties area add the user account i.e., '''.\Administrator'''.

@@ Line 33: / Line 33: @@
-. In '''Server Configuration''', under the '''Service Account''' tab, for services '''SQL Server Agent''' and '''SQL Server Database Engine''', enter the data of that user which the DLS nodes utilize for connecting to the database. This user must be part of the administrators group. In Startup Type, select "Manual" for the SQL Server Agent, and "Automatic" for the SQL Server Database Engine.
+. In '''Server Configuration''', you can specify service startup and authentication.Under the '''Service Account''' tab, for services '''SQL Server Agent''' and '''SQL Server Database Engine''', enter the data of that user which the DLS nodes utilize for connecting to the database. This user must be part of the administrators group. In Startup Type, select "Manual" for the SQL Server Agent, and "Automatic" for the SQL Server Database Engine.
 [[File:SQL_server_acc2.jpg]]
 Customize the SQL Server Database Engine collation.
-In '''Server Configuration''', you can specify service startup and authentication.Click on the '''Collation''' tab and then click the '''Customize''' button to specify the collation for your Database Engine and Analysis Services instance that best matches your application need.For the collation, select '''Windows collation designator and sort order'''. Under '''Collation''' designator, select "Latin1_General_BIN". The Binary option is activated.
+Click on the '''Collation''' tab and then click the '''Customize''' button to specify the collation for your Database Engine and Analysis Services instance that best matches your application need.For the collation, select '''Windows collation designator and sort order'''. Under '''Collation''' designator, select "Latin1_General_BIN". The Binary option is activated.
 [[File:customize_SQL.jpg]]

@@ Line 35: / Line 35: @@
 . In '''Server Configuration''', under the '''Service Account''' tab, for services '''SQL Server Agent''' and '''SQL Server Database Engine''', enter the data of that user which the DLS nodes utilize for connecting to the database. This user must be part of the administrators group. In Startup Type, select "Manual" for the SQL Server Agent, and "Automatic" for the SQL Server Database Engine.
-[[File:Example.jpg]]
+[[File:SQL_server_acc2.jpg]]
 Customize the SQL Server Database Engine collation.

@@ Line 35: / Line 35: @@
 . In '''Server Configuration''', under the '''Service Account''' tab, for services '''SQL Server Agent''' and '''SQL Server Database Engine''', enter the data of that user which the DLS nodes utilize for connecting to the database. This user must be part of the administrators group. In Startup Type, select "Manual" for the SQL Server Agent, and "Automatic" for the SQL Server Database Engine.
-[[File:SQL_server_acc.jpg]]
+[[File:Example.jpg]]
 Customize the SQL Server Database Engine collation.

← Older revision		Revision as of 13:19, 27 August 2015
Line 33:		Line 33:


−	8. Customize the SQL Server Database Engine collation.	+	8. In '''Server Configuration''', under the '''Service Account''' tab, for services '''SQL Server Agent''' and '''SQL Server Database Engine''', enter the data of that user which the DLS nodes utilize for connecting to the database. This user must be part of the administrators group. In Startup Type, select "Manual" for the SQL Server Agent, and "Automatic" for the SQL Server Database Engine.
		+
		+	[[File:SQL_server_acc.jpg]]
		+
		+
		+	Customize the SQL Server Database Engine collation.
	In '''Server Configuration''', you can specify service startup and authentication.Click on the '''Collation''' tab and then click the '''Customize''' button to specify the collation for your Database Engine and Analysis Services instance that best matches your application need.For the collation, select '''Windows collation designator and sort order'''. Under '''Collation''' designator, select "Latin1_General_BIN". The Binary option is activated.		In '''Server Configuration''', you can specify service startup and authentication.Click on the '''Collation''' tab and then click the '''Customize''' button to specify the collation for your Database Engine and Analysis Services instance that best matches your application need.For the collation, select '''Windows collation designator and sort order'''. Under '''Collation''' designator, select "Latin1_General_BIN". The Binary option is activated.

← Older revision		Revision as of 12:38, 27 August 2015
Line 37:		Line 37:

	[[File:customize_SQL.jpg]]		[[File:customize_SQL.jpg]]
−
−	~~[[File:Latin1_General_BIN.jpg]]~~

@@ Line 34: / Line 34: @@
 . Customize the SQL Server Database Engine collation.
-In '''Server Configuration''', you can specify service startup and authentication.Click on the '''Collation''' tab and then click the '''Customize''' button to specify the collation for your Database Engine and Analysis Services instance that best matches your application need.For the collation, select '''Windows collation designator and sort order'''. Under '''Collation designator''', select "Latin1_General_BIN". The Binary option is activated.
+In '''Server Configuration''', you can specify service startup and authentication.Click on the '''Collation''' tab and then click the '''Customize''' button to specify the collation for your Database Engine and Analysis Services instance that best matches your application need.For the collation, select '''Windows collation designator and sort order'''. Under '''Collation''' designator, select "Latin1_General_BIN". The Binary option is activated.
 [[File:customize_SQL.jpg]]
@@ Line 41: / Line 41: @@
-. Review the Error Reporting settings.
+. Review the '''Error Reporting''' settings.
 . Once the installation progress completes click '''Close''' to exit the SQL Server Express Edition setup.

← Older revision		Revision as of 12:51, 10 July 2015
Line 9:		Line 9:


−	1. Visit the relevant Microsoft web page ( http://www.microsoft.com/en-us/download) and search for the SQL Server Express Edition. Choose your preferable package file and click '''Download'''. A popup box shall appear asking you if you want to run the installation,or save the file to your computer. Click '''Run''' .	+	1. Visit the relevant Microsoft web page ( http://www.microsoft.com/en-us/download) and search for the SQL Server Express Edition.
		+
		+	'''IMPORTANT:SQL Server 2014 is not applicable to DLS.'''
		+
		+	Choose your preferable package file and click '''Download'''. A popup box shall appear asking you if you want to run the installation,or save the file to your computer. Click '''Run''' .

	2. The Installation Center will launch. In the left hand menu click '''Installation''', then click '''New installation or add features to an existing installation''' at the top of the screen to start the installation wizard.		2. The Installation Center will launch. In the left hand menu click '''Installation''', then click '''New installation or add features to an existing installation''' at the top of the screen to start the installation wizard.