Error 29114. Cannot connect to DB

[Suri786]

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. 

[Suri786 · Accepted solution]

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

[netjammr]

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.