Installing SQL and Zinform - Revision history

Andrew at 20:14, 24 October 2024

2024-10-24T20:14:01Z

← Older revision		Revision as of 20:14, 24 October 2024
Line 62:		Line 62:
	# Run Server Manager		# Run Server Manager
	# Open Tools and click Active Directory Users and Computers		# Open Tools and click Active Directory Users and Computers
	# Expand ~~you~~ Domain and click on Users		# Expand your Domain and click on Users
	# Right click the Zinform group and click Properties		# Right click the Zinform group and click Properties
	# Click on the Members tab		# Click on the Members tab

Andrew: /* Installation of SQL */

2024-10-16T20:53:13Z

Installation of SQL

← Older revision		Revision as of 20:53, 16 October 2024
Line 42:		Line 42:
	Once added you can easily add or remove Users by drilling down to the Zinform group.		Once added you can easily add or remove Users by drilling down to the Zinform group.

	'''To add the Zinform Security Group for Windows versions'''		'''To add the Zinform Security Group for other Windows versions'''

	# Run Server Manager		# Run Server Manager

Andrew: /* Installation of SQL */

2024-10-13T23:02:12Z

Installation of SQL

← Older revision		Revision as of 23:02, 13 October 2024
Line 2:		Line 2:
	These instructions are for new installations of SQL. Existing SQL installations for emPOWER or Zinform do not require any changes.		These instructions are for new installations of SQL. Existing SQL installations for emPOWER or Zinform do not require any changes.

	SQL Server can be downloaded from Microsoft at: https://www.microsoft.com/en-us/sqlserver/sql-server-downloads. SQL 2019 is recommended as this is compatible with more servers/PCs than later versions.		SQL Server can be downloaded from Microsoft at: [https://www.microsoft.com/en-nz/sql-server/sql-server-downloads https://www.microsoft.com/en-us/sqlserver/sql-server-downloads]. SQL 2019 is recommended as this is compatible with more servers/PCs than later versions.

	If installing the Express Edition:		If installing the Express Edition:
Line 20:		Line 20:
	Once complete you should install SQL Server Management Studio (SSMS), this will be required for backups and other database maintenance functions.		Once complete you should install SQL Server Management Studio (SSMS), this will be required for backups and other database maintenance functions.

	* ~~If you still have the SQL Server Installation Centre open then click Install SQL Server Manager Tools.~~		* Go to https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16 to download.
	* If not, go to https://~~docs~~.microsoft.com/en-us/sql/ssms/download-sql-~~servermanagement~~-studio-ssms?view=sql-server-~~ver15~~ to download.


Line 224:		Line 223:
	# Once complete a “Success” message will appear.		# Once complete a “Success” message will appear.
	# Zinform requires the database name to be prefixed with Accounts_ so rename the database post upsizing.		# Zinform requires the database name to be prefixed with Accounts_ so rename the database post upsizing.


	WARNINGS.		WARNINGS.
Line 277:		Line 275:
	# Open SQL Server Management Studio and add a new user ZinformDB, this requires a password Exodesk will provide. Use the settings as follows.[[File:ZinformDB user fig. 1.png\|none\|thumb\|ZinformDB user fig. 1]][[File:ZinformDB user fig. 2.png\|none\|thumb\|ZinformDB user fig. 2]][[File:ZinformDB user fig. 3.png\|none\|thumb\|ZinformDB user fig. 3]]		# Open SQL Server Management Studio and add a new user ZinformDB, this requires a password Exodesk will provide. Use the settings as follows.[[File:ZinformDB user fig. 1.png\|none\|thumb\|ZinformDB user fig. 1]][[File:ZinformDB user fig. 2.png\|none\|thumb\|ZinformDB user fig. 2]][[File:ZinformDB user fig. 3.png\|none\|thumb\|ZinformDB user fig. 3]]
	# Install Zinform Accounts 6.		# Install Zinform Accounts 6.

	'''First time running'''		'''First time running'''

Andrew: /* Installation of Zinform 6 */

2024-10-11T04:07:05Z

Installation of Zinform 6

← Older revision		Revision as of 04:07, 11 October 2024
Line 275:		Line 275:
	Once Zinform Accounts v5 has been installed go ahead and install v6.		Once Zinform Accounts v5 has been installed go ahead and install v6.

	# Open SQL Server Management Studio and add a new user ZinformDB, this requires a password Exodesk will provide. Use the settings as follows.		# Open SQL Server Management Studio and add a new user ZinformDB, this requires a password Exodesk will provide. Use the settings as follows.[[File:ZinformDB user fig. 1.png\|none\|thumb\|ZinformDB user fig. 1]][[File:ZinformDB user fig. 2.png\|none\|thumb\|ZinformDB user fig. 2]][[File:ZinformDB user fig. 3.png\|none\|thumb\|ZinformDB user fig. 3]]
	# Install Zinform Accounts 6.		# Install Zinform Accounts 6.


	'''First time running'''		'''First time running'''

	* Upon first run it will ask you if you want to set up a new connection.		* Upon first run it will ask you if you want to set up a new connection.
	* You will get the following:		* You will get the following:[[File:Setup Connection fig. 1.png\|none\|thumb\|Setup Connection fig. 1]]
	* Click Yes and you will get the following.
			* Click Yes and you will get the following.[[File:Setup Connection fig. 2.png\|none\|thumb\|Setup Connection fig. 2]]

	* Enter the SQL Server Name and click refresh to see the database. Check “Trusted Windows Connection” and then click Open Organisation.		* Enter the SQL Server Name and click refresh to see the database. Check “Trusted Windows Connection” and then click Open Organisation.
	* It should then present you with a licence screen.		* It should then present you with a licence screen.
	* Search for the licence in the emData folder		* Search for the licence in the emData folder

Andrew: /* Installation of SQL */

2024-10-10T22:59:46Z

Installation of SQL

Show changes

Andrew: /* Installation of SQL */

2024-10-10T22:41:51Z

Installation of SQL

Show changes

Andrew at 21:31, 10 October 2024

2024-10-10T21:31:42Z

Show changes

Andrew at 20:01, 10 October 2024

2024-10-10T20:01:56Z

← Older revision		Revision as of 20:01, 10 October 2024
Line 1:		Line 1:
	Installation of SQL		== Installation of SQL ==
	These instructions are for new installations of SQL. Existing SQL installations for emPOWER or Zinform do not require any changes.		These instructions are for new installations of SQL. Existing SQL installations for emPOWER or Zinform do not require any changes.

Andrew: Created page with "Installation of SQL These instructions are for new installations of SQL. Existing SQL installations for emPOWER or Zinform do not require any changes."

2024-10-10T20:00:30Z

Created page with "Installation of SQL These instructions are for new installations of SQL. Existing SQL installations for emPOWER or Zinform do not require any changes."

New page

Installation of SQL
These instructions are for new installations of SQL. Existing SQL installations for emPOWER or Zinform do not require any changes.