Blog

Immer aktuell informiert sein in unserem Blog!

The VMware vCloud Director needs a MSSQL or an Oracle Database server to run. This article will describe how to install a MSSQL Server Express on RHEL/CentOS for testing and developing purposes.

1. Add the MSSQL server repository for RHEL

wget https://packages.microsoft.com/config/rhel/7/mssql-server.repo -O /etc/yum.repos.d/mssql-server.repo 
2. Install the MSSQL Server to your RHEL or CentOS
2. Install Microsoft MSQL server to your RHEL or CentOS

yum install mssql-server –y
3. Run the MSSQL configuration script

/opt/mssql/bin/mssql-conf setup
Select MSSQL Express. Its free and vCloud Director runs fine with it (only test&dev).

If you get this error:

ValueError: unknown locale: UTF-8
Add locales and try again.

export LC_ALL=en_US.UTF-8
export LANG=en_US.UTF-8
source ~/.bash_profile
4. Add the MSSQL tools repository for RHEL

wget https://packages.microsoft.com/config/rhel/7/prod.repo -O /etc/yum.repos.d/prod.repo
5. Install MSSQL tools and unixODBC developer package

yum install -y mssql-tools unixODBC-devel
6.  Make the MSSQL command tool (sqlcmd) usable directly in shell

echo ‘export PATH=”$PATH:/opt/mssql-tools/bin”‘ >> ~/.bash_profile
echo ‘export PATH=”$PATH:/opt/mssql-tools/bin”‘ >> ~/.bashrc
source ~/.bashrc
7. Now open port 1433 in the integrated firewall or stop the firewall service (firewalld)

firewall-cmd –zone=public –add-port=1433/tcp –permanent

OR

systemctl stop firewalld
systemctl disable firewalld
8. Connect to your local MSSQL Server using your Credentials

sqlcmd -S 127.0.0.1 -U SA
9. Run the following scripts to create and configure the database. /YOURPATH/ must be owned by the mssql user.

USE [master]
GO
CREATE DATABASE [vcloud]ON PRIMARY
(NAME = N’vcloud’, FILENAME = N’/YOURPATH/vcloud.mdf’, SIZE = 100MB, FILEGROWTH = 10% )
LOG ON
(NAME = N’vcdb_log’, FILENAME = N’/YOURPATH/vcloud.ldf’, SIZE = 1MB, FILEGROWTH = 10%)
COLLATE Latin1_General_CS_AS
GO

USE [vcloud]
GO
ALTER DATABASE [vcloud] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE [vcloud] SET ALLOW_SNAPSHOT_ISOLATION ON;
ALTER DATABASE [vcloud] SET READ_COMMITTED_SNAPSHOT ON WITH NO_WAIT;
ALTER DATABASE [vcloud] SET MULTI_USER;
GO
10. Create the Service User for vCloud Director and make him owner of the vCloud Database

USE [vcloud]
GO
CREATE LOGIN [vcloud] WITH PASSWORD = ‘vcloudpass’, DEFAULT_DATABASE =[vcloud], DEFAULT_LANGUAGE =[us_english], CHECK_POLICY=OFF
GO
CREATE USER [vcloud] for LOGIN [vcloud]
GO

USE [vcloud]
GO
sp_addrolemember [db_owner], [vcloud]
GO
Now you can use this for your vCloud Director. Have fun!

Unseren Newsletter abonnieren