Product(s):		Promis.e CONNECT Edition
	Version(s):		10.00.XX.XX to 10.10.XX.XX
	Environment:		NA
	Area:		Database Platform Support
	Subarea:		SQL Permission

Background:

When the user is trying to create new Project Database using Promis.e CONNECT they get the error "In order to create the database you must have the 'sysadmin' role permission". This article will help in resolving this issue. 

The above Error Message indicates that the user's SQL user profile does not have "sysadmin" in Server Role. The user need the Sysadmin role to be able to create Project Database. Hence the SQL/Database Administrator has to create Project Database or they need to add the "sysadmin" role to the SQL user profile. The below steps needs to be followed if the user needs to have sysadmin role else the SQL/ Database Admin can follow the below wiki link steps to create Project Database and then give the user just the minimum permission.

communities.bentley.com/.../minimum-sql-user-permission-for-promis-e-users---promis-e-connect

Steps to Accomplish

1. In SQL Server Management Studio, connect to the server where the Promis.e CONNECT Project Database is located. If you dont have SQL Server Management Studio(SSMS) installed you can download and install it from below link. 

learn.microsoft.com/.../download-sql-server-management-studio-ssms

2. In the Object Explorer tree expand Security > Logins > select the user name > click Properties.  

3. select Server Role and then check the server role "sysadmin" and click OK. 

Also see

communities.bentley.com/.../creating-and-updating-project-database---promise-ce

Original Author:

Satish Saptasagar