Appboard/old/configuration database/example mssql - Revision history

imported>Jason.nicholls at 09:18, 18 July 2014

2014-07-18T09:18:00Z

← Older revision		Revision as of 09:18, 18 July 2014
Line 1:		Line 1:
	{{DISPLAYTITLE:Microsoft SQL Server}}		{{DISPLAYTITLE:Microsoft SQL Server}}
			[[Category:AppBoard old]]

	This section describes the following tasks that must be performed in order to use SQL Server with enPortal:		This section describes the following tasks that must be performed in order to use SQL Server with enPortal:

imported>Jason.nicholls: moved Configuring Databases/MS SQL Server to appboard/old/configuration database/example mssql

2014-07-18T09:17:42Z

moved Configuring Databases/MS SQL Server to appboard/old/configuration database/example mssql

← Older revision	Revision as of 09:17, 18 July 2014
(No difference)

imported>David.moore at 20:14, 25 November 2013

2013-11-25T20:14:32Z

← Older revision		Revision as of 20:14, 25 November 2013
Line 63:		Line 63:
	#For Log On As, select System Account.		#For Log On As, select System Account.
	#Click OK.		#Click OK.

			=== Installing Microsoft SQL Server JDBC Driver ===

			To install the Microsoft JDBC Driver, do the following:

			#Download the Microsoft SQL Server JDBC Driver from Microsoft: http://www.microsoft.com/sql/downloads
			#Install the JDBC Driver.
			#Copy the three JAR files within the lib directory where the driver was installed, to the %PORTAL_HOME%\class-custom directory (where %PORTAL_HOME% is the directory where enPortal was installed). There should be three JAR files, and they are named msbase.jar, mssqlserver.jar and msutil.jar.
			#Proceed with the steps to configure the database.

			{{Note\|If the DBSetup utility is already running, you must re-start it so that it can successfully test the
			database connection.}}

imported>David.moore at 20:12, 25 November 2013

2013-11-25T20:12:58Z

← Older revision		Revision as of 20:12, 25 November 2013
Line 53:		Line 53:
	##Right-click sa and select Properties.		##Right-click sa and select Properties.
	##Enter a password and click OK.		##Enter a password and click OK.

			=== Configuring Automatic Startup ===

			To configure a Microsoft SQL database for automatic startup:

			#From the Windows Start menu, select Settings→Control Panel.
			#Open Services and double-click MSSQLServer.
			#For Startup Type, ensure that Automatic is selected.
			#For Log On As, select System Account.
			#Click OK.

imported>David.moore: /* Creating a Database and Configuring Security */

2013-11-25T20:12:05Z

Creating a Database and Configuring Security

← Older revision		Revision as of 20:12, 25 November 2013
Line 50:		Line 50:
	#Select OK.		#Select OK.
	#Because the default is blank, it is recommended that you change the password for the sa account.		#Because the default is blank, it is recommended that you change the password for the sa account.
	#*Click Logins.		##Click Logins.
	#*Right-click sa and select Properties.		##Right-click sa and select Properties.
	#*Enter a password and click OK.		##Enter a password and click OK.

imported>David.moore: /* Creating a Database and Configuring Security */

2013-11-25T20:11:31Z

Creating a Database and Configuring Security

← Older revision		Revision as of 20:11, 25 November 2013
Line 48:		Line 48:
	#*db_datareader		#*db_datareader
	#*db_datawriter		#*db_datawriter
	Select OK.		#Select OK.
	#Because the default is blank, it is recommended that you change the password for the sa account.		#Because the default is blank, it is recommended that you change the password for the sa account.
	#*Click Logins.		#*Click Logins.
	#*Right-click sa and select Properties.		#*Right-click sa and select Properties.
	#*Enter a password and click OK.		#*Enter a password and click OK.

imported>David.moore: /* Creating a Database and Configuring Security */

2013-11-25T20:11:15Z

Creating a Database and Configuring Security

← Older revision		Revision as of 20:11, 25 November 2013
Line 51:		Line 51:
	#Because the default is blank, it is recommended that you change the password for the sa account.		#Because the default is blank, it is recommended that you change the password for the sa account.
	#*Click Logins.		#*Click Logins.
	– Right-click sa and select Properties.		#*Right-click sa and select Properties.
	– Enter a password and click OK.		#*Enter a password and click OK.

imported>David.moore at 20:10, 25 November 2013

2013-11-25T20:10:51Z

← Older revision		Revision as of 20:10, 25 November 2013
Line 27:		Line 27:
	#On the Services Accounts screen, select Use the same account for each service. Autostart SQL Server Service. For Service Settings, select Use the local system account. Then click Next.		#On the Services Accounts screen, select Use the same account for each service. Autostart SQL Server Service. For Service Settings, select Use the local system account. Then click Next.
	#Click Next until you reach the final screen and then click Finish when the installation is complete.		#Click Next until you reach the final screen and then click Finish when the installation is complete.

			=== Creating a Database and Configuring Security ===

			To create and configure a Microsoft SQL database, do the following:

			#From the Windows Start menu, select SQL Server – Enterprise Manager.
			#Expand SQL Servers.
			#Expand SQL Server Group.
			#Expand your host name (to get to the local databases).
			#Right-click Databases and select New Database.
			#Enter portal in the Name field and click OK.
			#Expand Security.
			#Right-click Logins and select New Login.
			#Enter portal in the Name field.
			#Select SQL Server Authentication and enter a password for the portal user.
			#For Defaults, select portal as the database.
			#Click the Database Access tab and select portal as the permitted database.
			#For Database roles for portal select:
			#*db_ddladmin
			#*db_datareader
			#*db_datawriter
			Select OK.
			#Because the default is blank, it is recommended that you change the password for the sa account.
			#*Click Logins.
			– Right-click sa and select Properties.
			– Enter a password and click OK.

imported>David.moore at 20:08, 25 November 2013

2013-11-25T20:08:57Z

← Older revision		Revision as of 20:08, 25 November 2013
Line 13:		Line 13:
	#Locate the file jtds-1.2.jar within the downloaded zip file.		#Locate the file jtds-1.2.jar within the downloaded zip file.
	#Extract the file jtds-1.2.jar and place it in the folder PORTAL_HOME/classes-custom/		#Extract the file jtds-1.2.jar and place it in the folder PORTAL_HOME/classes-custom/

			=== Installing Microsoft SQL Server ===

			These installation instructions apply to SQL Server 2000. To install Microsoft SQL Server:

			#Select Install SQL Server 2000 Components.
			#Select Install Database Server. The InstallShield begins.
			#On the first screen, select Local Install. Click Next or Yes on the following screens until the Setup Type screen opens.
			#On the Setup Type screen, select Custom and click Next.
			#On the Select Components screen change or accept the default settings and click Next.
			#On the Character Set/Sort Order/Unicode Collation screen, in the Sort Order field, select Dictionary Order, Case Sensitive. Keep the other default settings and click Next.
			#On the Network Libraries screen, accept the defaults and click Next.
			#On the Services Accounts screen, select Use the same account for each service. Autostart SQL Server Service. For Service Settings, select Use the local system account. Then click Next.
			#Click Next until you reach the final screen and then click Finish when the installation is complete.

imported>David.moore: Created page with '{{DISPLAYTITLE:Microsoft SQL Server}} This section describes the following tasks that must be performed in order to use SQL Server with enPortal: === Downloading the Microsoft …'

2013-11-25T20:07:29Z

Created page with '{{DISPLAYTITLE:Microsoft SQL Server}} This section describes the following tasks that must be performed in order to use SQL Server with enPortal: === Downloading the Microsoft …'

New page

{{DISPLAYTITLE:Microsoft SQL Server}}

This section describes the following tasks that must be performed in order to use SQL Server with enPortal:

=== Downloading the Microsoft SQL JDBC Driver ===

After you have installed enPortal, you must download a JDBC driver that will enable enPortal to establish a connection to your Microsoft SQL Server database.

To install the JDBC driver:

#Access the jTDS driver files at the following location: http://jtds.sourceforge.net/
#Download the file jTDS-1.2-dist.zip to your local file system.
#Locate the file jtds-1.2.jar within the downloaded zip file.
#Extract the file jtds-1.2.jar and place it in the folder PORTAL_HOME/classes-custom/