Creating server logins and changing roles for users and groups through ScfUtils (Model Explorer)
ScfUtils provides a command line interface for performing Model Explorer functions.
You can create and change a server login through ScfUtils.
If you have installed Modeler to the default locations, ScfUtils resides in the following location:
C:\Program Files (x86)\PTC Integrity Modeler\Modeler\Exe\SCFUtils.exe
To create a server login through ScfUtils
Syntax:
ScfUtils -createlogin Enterprise "<instance-name>" "<user/group>" "<isAdmin>"
Where:
• <instance-name> specifies the SQL Server instance on which the login will be created.
Enter the instance name in the following format: Server[@Instance]
• <user/group> specifies a name for the user or group to add.
Type the domain followed by the Windows user or group name.
• <isAdmin> specifies whether the user or group is created as an instance administrator.
Type 1 to create an administrator login that has the instance administrator role.
Type 0 to create a standard user or group login.
Example:
ScfUtils -createlogin Enterprise "Server1@MODELER" "domain\user" "1"
To change a server login role through ScfUtils
Syntax:
ScfUtils -changeloginrole Enterprise "<instance-name>" "<user/group>" "<isAdmin>"
Where:
• <instance-name> specifies the SQL Server instance on which the login role will be changed.
Enter the instance name in the following format: Server[@Instance]
• <user/group> specifies a name for the user or group to change.
Type the domain followed by the Windows user or group name. For example: <domain>\<user/group>
• <isAdmin> specifies whether or not the user or group login is set as an instance administrator.
Type 1 to change the login role to an instance administrator.
Type 0 to change the login role to a standard user or group.
Example:
ScfUtils -changeloginrole Enterprise "Server1@MODELER" "domain\user" "0"