Microsoft SQL Server Installation

(H-Sphere 2.5.0+)


MS SQL, like other commercial third party products, is purchased and installed separately from H-Sphere.

MS SQL Server is a fully Web-enabled database with the ability to query the database through a browser and rich Extensible Markup Language (XML) support. In addition, MS SQL Server holds benchmark records for scalability and reliability, both of which are crucial for the success of an enterprise database.

This document explains how to install MS SQL database software and integrate it with the H-Sphere system.

H-Sphere 2.5.0 and higher supports Microsoft SQL Server

MS SQL server can be installed on H-Sphere Windows server. This means the server must be added to the H-Sphere configuration.

To add MS SQL to winbox with H-Sphere installed:

  1. Install ASP.NET 2.0 and check the version of ASP.NET.
    RootVer must be 2.0.XXXX, not 1.1.XXXX in the registry HKLM/Software/Microsoft/ASP.NET.
    If RootVer is 1.1.XXXX:
    • Go to C:\Windows\Microsoft.NET\Framework\v2.0.5xx\ through command line
    • Run from command line:
      aspnet_regiis -r
    • Restart IIS :
      iisreset /restart
  2. Install MS SQL server following the directions of the installation wizard. You should also install SQL Server Management Studio Express.
  3. In SQL Server Managment Studio Express create login with system administrator privileges for the MS SQL server. As a rule, login 'sa' is used.
  4. Configure H-Sphere connection settings to work with MS SQL server.
  • For H-Sphere 3.0 and higher:
    H-Sphere 3.0 + uses Windows authetication method in order to connect to MSSQL server. Therefore MSSQL server should be installled locally on the same server with H-Sphere.
    Go to / file and make sure the NAME_OF_YOUR_SQL_SERVER is set correctly in:
    prop name="server" value="NAME_OF_YOUR_SQL_SERVER" description="MSSQL server name or IP"
  • For H-Sphere before 3.0:
    Go to / file and set the following three values for MS SQL Server variables:
      -- prop name="server" value="NAME_OF_YOUR_SQL_SERVER" description="MSSQL server name or IP"
      -- prop name="salogin" value="MSSQL_LOGIN" description="Administrative login to MSSQL server"
      -- prop name="sapassword" value="PASSWORD_FOR_USER_SA" description="Password for administrative login to MSSQL server"
  • Go to SQLServer Properties -> Security. Chose SQL Server Authentication and Windows Authentication to allow H-Sphere and your customers to access MS SQL server remotely.
  • Make sure that MS SQL server IP set as a logical server IP in the E.Manager menu is set in Start -> Programs -> MSSQL Server -> Configuration Tools -> SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER -> TCP/IP(enabled) -> Properties -> IP Addresses tab. Make sure this IP is there with Active and Enabled set to Yes.
  • In your CP add MS SQL server group to the physical winboxes with MS SQL installed.
  • Add logical MS SQL servers in CP and add IP addresses for it.
  • On winboxes run the following commands:
      net stop hsphere
      net start hsphere
  • Turn on MS SQL servers in the user's Plan Edit Wizard. After that, try creating MS SQL databases from user's CP.

  • © Copyright. . PSOFT. All Rights Reserved. Terms | Site Map