The database user account that creates the repository must have privileges to perform the following operations:

ALTER TABLE

CREATE CLUSTERED INDEX

CREATE INDEX

CREATE PROCEDURE

CREATE TABLE

CREATE VIEW

DROP PROCEDURE

DROP TABLE

INSERT INTO

If the repository must store metadata in a multibyte language, set the database collation to that multibyte language when you install Microsoft SQL Server. For example, if the repository must store metadata in Japanese, set the database collation to a Japanese collation when you install Microsoft SQL Server. This is a one-time configuration and cannot be changed.