[OBIEE 11g] Repository On MS-SQL

 

OBIEE11g repository on MS-SQL

Create a repository database:

 

*Enable case-sensitive collation 

ALTER DATABASE Repositories COLLATE Latin1_General_CS_AS

*Enable Row versioning

ALTER DATABASE Repositories SET READ_COMMITTED_SNAPSHOT ON

*Allow TCP/IP access to the database:

(Bounce the service if you changed it!)

*If you have a firewall running check if the ms-sql port is open (1433 for a default instance)

*Create a user (fi: REP_OWN)

*make  the default database repositories:

*Set the public and sysadmin role:

 

*Now we can start with the actual repository:

*Download and unzip de RCU. 

*Start the RCU.bat (..\rcuHome\BIN)

*On the database connection details page:

*Select the BI components:

*Enter the passwords

*Success:

*You can disable the REP_OWN account, the RCU has create dedicated logins: