vCenter

I am trying to install vCenter Server Single Sign On using existing Database option but i am receiving error message " Error 29114. Cannot Connect to DB.

I have create new Database on MS SQL Server 2012 Standard Edition with the name of RSA and its table names are RSA_DATA with file-group PRIMARY & RSA_INDEX with file-group RSA_INDEX and its log name is translog.

Database Users are also created with the Name of RSA_USER & RSA_DBA before executing the setup file.

Note:- I am using vCenter Serve 5.1 Uc1 Setup file for installing vCenter Server.

Please help out....that  how can fix the addressed issue. 

My issue has been resolved. Actually, some thing is wrong with ownership and access rights on RSA_SUSER & RSA_DBA. I remove the database "RSA" & users "RSA_DBA & RSA_USER" and recreate using below script.

For Creating Database

**********************************

USE MASTER

GO

CREATE DATABASE RSA ON PRIMARY(

NAME='RSA_DATA',

FILENAME='K:\Microsoft SQL Server\MSSQL\Data\RSA_Data.mdf',

SIZE=10MB,

MAXSIZE=UNLIMITED,

FILEGROWTH=10%),

FILEGROUP RSA_INDEX(

NAME='RSA_INDEX',

FILENAME='K:\Microsoft SQL Server\MSSQL\Data\RSA_Index.mdf',

SIZE=10MB,

MAXSIZE=UNLIMITED,

FILEGROWTH=10%)

LOG ON(

NAME='translog',

FILENAME='L:\Microsoft SQL Server\MSSQL\Data\Logs\RSA_Log.ldf',

SIZE=10MB,

MAXSIZE=UNLIMITED,

FILEGROWTH=10% )

GO

ALTER DATABASE [RSA] SET RECOVERY SIMPLE

GO

CHECKPOINT

GO

**********************************************************\

For creating Users

**********************************************************

USE MASTER

GO

CREATE LOGIN RSA_DBA WITH PASSWORD = Netsolpk1, DEFAULT_DATABASE = RSA

GO

CREATE LOGIN RSA_USER WITH PASSWORD = Netsolpk1, DEFAULT_DATABASE = RSA

GO

USE RSA

GO

ALTER AUTHORIZATION ON DATABASE::RSA TO RSA_DBA

GO

CREATE USER RSA_USER FOR LOGIN RSA_USER

GO

CHECKPOINT

GO

Did your create login commands work?

"CREATE LOGIN RSA_DBA WITH PASSWORD = Netsolpk1, DEFAULT_DATABASE = RSA"

I believe your passwords have to be surrounded by single quotes -

"CREATE LOGIN RSA_DBA WITH PASSWORD = 'Netsolpk1', DEFAULT_DATABASE = RSA"

as well as meet password complexity rules.