The SQL Server Administrator must create a login of a user or a group with
Modeler System Database Administrator role through Model Explorer. These Modeler System Database Administrators can create logins for
Database Administrators and
Modeler Application Users. For more information on how to do this, see
Creating server logins for users and groups (Model Explorer)
If you are using a remote SQL Server Instance, follow the steps mentioned here
Working with a remote SQL Server to connect to a remote SQL Server.