Product(s):		OpenUtilities Substation CONNECT Edition
	Version(s):		10.00.XX.XX to 10.13.XX.XX
	Environment:		NA
	Area:		Database Platform Support
	Subarea:		SQL Permission

Background:

What are the minimum permissions required for a user to successfully connect and use a SQL project database with OpenUtilities Substation (OUS) CONNECT? 

This article is to help New Users or SQL/Database Administrators to create/update SQL Server Login for users to connect with OUS Project Database.

Steps to Accomplish

1. In SQL Server Management Studio, connect to the server where the OUS 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 right click > New Login if the user dose not already have a login and go to step 4. If the Login for the user exists then go to Step 3.

3. For the user who already has a login Expand Logins > select the User and Right Click > Properties. 




4. Then if the user account new select all the required details in General and then go to Server Roles and check Public.

5. On the User Mapping page, select the database used by the software in the Database column. Specify "dbo" in the Default Schema column.

6. In the User Mapping's "Database role membership for" check the below options and click OK.

db.datareader 
db.datawriter

or 

db.owner

Also see

learn.microsoft.com/.../create-a-login

Original Author:

Satish Saptasagar