Difference between revisions of "Install SQL Server on Windows"

From Lianjapedia
Jump to: navigation, search
(Managing Lianja ODBC Data Sources)
 
(19 intermediate revisions by the same user not shown)
Line 1: Line 1:
'''Before you start...'''
+
==See Also==
Do not run the Lianja SQL Server installer if you have already installed the Lianja Cloud Server.  The Lianja Cloud Server installer includes both the Lianja Cloud Server and the Lianja SQL Server.
+
* [http://www.lianja.com/component/rsfiles/files?folder=Windows Downloads for Windows]
 +
* [[Lianja Server Manager on Windows]]
 +
* [[Lianja ODBC Driver on Windows]]
 +
* [[Lianja ODBC Manager on Windows]]
 +
* [[:Category:Lianja Server|Lianja Server]]
 +
* [[:Category:License Management|License Management]]
 +
 
 +
==Before you start...==
 +
Do not run the Lianja SQL Server installer if you have already installed the Lianja Cloud Server or the Lianja App Builder (includes the Lianja Cloud Server).  The Lianja Cloud Server installer includes the Lianja Cloud Server, the Lianja SQL Server and the Lianja ODBC Driver.
 +
 
 +
The Lianja SQL Server installer includes the Lianja SQL Server and the Lianja ODBC Driver.
  
 
==Installation==
 
==Installation==
* Double-click on the downloaded installer to run it
+
* Double-click on the downloaded installer to run it.
* Click '''Next >''' to continue
+
* Click '''Next >''' to continue.
 
[[File:Install_ss1.png|link=|Lianja SQL Server Installation]]
 
[[File:Install_ss1.png|link=|Lianja SQL Server Installation]]
 
<br clear=all>
 
<br clear=all>
* Read the License Agreement
+
* Read the License Agreement, using the scrollbar to display the full text.  Click a radio button to accept or reject the License Agreement then click '''Next >'''.
* Use the scrollbar to display the full text
+
 
[[File:License.png|link=|Lianja SQL Server Installation]]
 
[[File:License.png|link=|Lianja SQL Server Installation]]
 
<br clear=all>
 
<br clear=all>
* Click a radio button to accept or reject the License Agreement
+
If you select '''I accept the agreement''', the installation will continue.
* Click '''Next >'''
+
If you select '''I do not accept the agreement''', you will be prompted to abort the installation: if you click '''Yes''' the installation will stop, if you click '''No''' you will be returned to the License Agreement. After accepting the License Agreement, the installation will continue.
* If you select '''I accept the agreement''', the installation will continue
+
* Select the Installation Directory in the format DRIVE:\lianja, the default Installation Directory 'C:\lianja'.  Then click '''Next >'''.
[[File:License_yes.png|link=|Lianja SQL Server Installation]]
+
<br clear=all>
+
* If you select '''I do not accept the agreement''', you will be prompted to abort the installation
+
[[File:License_no.png|link=|Lianja SQL Server Installation]]
+
<br clear=all>
+
* If you click '''Yes''', the installation will stop
+
* If you click '''No''', you will be returned to the License Agreement
+
[[File:License_no2.png|link=|Lianja SQL Server Installation]]
+
<br clear=all>
+
* After accepting the License Agreement, the installation will continue
+
* Select the Installation Directory in the format DRIVE:\lianja
+
* Click '''Next >''' to accept the default Installation Directory 'C:\lianja'
+
* Note: if you have an existing installation in 'C:\Lianja' (uppercase 'L') this will be displayed and will be the valid default
+
 
[[File:Install_ss2.png|link=|Lianja SQL Server Installation]]
 
[[File:Install_ss2.png|link=|Lianja SQL Server Installation]]
 
<br clear=all>
 
<br clear=all>
* To install to an alternative drive, specify the drive letter, but leave the directory as '\lianja'
+
To install to an alternative drive, specify the drive letter, but leave the directory as '\lianja', e.g.
* Note: if you specify an alternative drive, please follow the instructions for copying the licenses folder at the bottom of this page
+
<pre>E:\lianja</pre>
* Click '''Next >'''
+
* Make sure 'Lianja SQL Server' is checked, then click '''Next >'''.
[[File:Install_ss2alt.png|link=|Lianja SQL Server Installation]]
+
<br clear=all>
+
* Make sure 'Lianja SQL Server' is checked
+
* Click '''Next >'''
+
 
[[File:Install_ss3.png|link=|Lianja SQL Server Installation]]
 
[[File:Install_ss3.png|link=|Lianja SQL Server Installation]]
 
<br clear=all>
 
<br clear=all>
* Click '''Next >''' to begin the installation
+
* Click '''Next >''' to begin the installationIf you do not want the installation to begin, click '''Cancel'''.
* If you do not want the installation to begin, click '''Cancel'''
+
 
[[File:Install_ss4.png|link=|Lianja SQL Server Installation]]
 
[[File:Install_ss4.png|link=|Lianja SQL Server Installation]]
 
<br clear=all>
 
<br clear=all>
* Uncheck the box if you do not want to view the Readme File
+
* Uncheck the box if you do not want to view the Readme File, then click '''Finish''' to complete the installation.
* Click '''Finish'''
+
[[File:Install_ss5.png|link=|Lianja ODBC Driver Installation]]
[[File:Install_ss5.png|link=|Lianja SQL Server Installation]]
+
 
<br clear=all>
 
<br clear=all>
* Double-click the Lianja Server Manager desktop shortcut to manage Lianja SQL Server
+
 
 +
==Managing the Lianja Server==
 
[[File:ServerShortcut.png|link=|Lianja Server Manager Shortcut]]
 
[[File:ServerShortcut.png|link=|Lianja Server Manager Shortcut]]
 
<br clear=all>
 
<br clear=all>
 +
Double-click the Lianja Server Manager desktop shortcut to [[Lianja Server Manager on Windows|manage the Lianja Server]].
  
===Alternative Installation Drive===
+
==Managing Lianja ODBC Data Sources==
After the installation completes, if you have installed to a drive other than C:, please copy the ''drive'':\lianja\licenses folder and contents to '''C:\lianja\licenses''' to ensure that licenses are handled correctly.
+
[[File:ODBCManagerShortcut.png|link=|Lianja ODBC Manager Shortcut]]
 +
<br clear=all>
 +
The Lianja ODBC Driver is also installed. Lianja ODBC data sources can be managed in the Windows 32 bit ODBC Data Source Administrator or using the [[Lianja ODBC Manager on Windows|Lianja ODBC Manager]].
  
==See Also==
+
Third party ODBC data sources for use from Lianja can be set up in the Windows 32 bit ODBC Data Source Administrator.
[[:Category:SQL Server|Lianja SQL Server]], [[:Category:License Management|License Management]]
+
 
[[Category:Installation]]
+
[[Category:Installation| ]]
 +
[[Category:Installation on Windows| Lianja SQL Server]]
 +
[[Category:Lianja SQL Server]]

Latest revision as of 08:44, 31 August 2017

See Also

Before you start...

Do not run the Lianja SQL Server installer if you have already installed the Lianja Cloud Server or the Lianja App Builder (includes the Lianja Cloud Server). The Lianja Cloud Server installer includes the Lianja Cloud Server, the Lianja SQL Server and the Lianja ODBC Driver.

The Lianja SQL Server installer includes the Lianja SQL Server and the Lianja ODBC Driver.

Installation

  • Double-click on the downloaded installer to run it.
  • Click Next > to continue.

Lianja SQL Server Installation

  • Read the License Agreement, using the scrollbar to display the full text. Click a radio button to accept or reject the License Agreement then click Next >.

Lianja SQL Server Installation
If you select I accept the agreement, the installation will continue. If you select I do not accept the agreement, you will be prompted to abort the installation: if you click Yes the installation will stop, if you click No you will be returned to the License Agreement. After accepting the License Agreement, the installation will continue.

  • Select the Installation Directory in the format DRIVE:\lianja, the default Installation Directory 'C:\lianja'. Then click Next >.

Lianja SQL Server Installation
To install to an alternative drive, specify the drive letter, but leave the directory as '\lianja', e.g.

E:\lianja
  • Make sure 'Lianja SQL Server' is checked, then click Next >.

Lianja SQL Server Installation

  • Click Next > to begin the installation. If you do not want the installation to begin, click Cancel.

Lianja SQL Server Installation

  • Uncheck the box if you do not want to view the Readme File, then click Finish to complete the installation.

Lianja ODBC Driver Installation

Managing the Lianja Server

Lianja Server Manager Shortcut
Double-click the Lianja Server Manager desktop shortcut to manage the Lianja Server.

Managing Lianja ODBC Data Sources

Lianja ODBC Manager Shortcut
The Lianja ODBC Driver is also installed. Lianja ODBC data sources can be managed in the Windows 32 bit ODBC Data Source Administrator or using the Lianja ODBC Manager.

Third party ODBC data sources for use from Lianja can be set up in the Windows 32 bit ODBC Data Source Administrator.