Azure SQL Server

Follow the steps below to manually create an empty database on SSMS (SQL Server Management Studio) portal.

1. Log in to the SSMS server.
   1. Add the Server name, Login and Password.
   2. Click Connect.
      
      
2. Right-click Databases and select New Database.
   
   
3. Add the Database name and click OK.
   
   
   Database is created.

1. Right-click the created database and select New Query.

   NOTE:

   Use created database and fire all the queries against the created database. USE [<DATABASE_NAME>];

2. Create schema usch_aese as default schema.
   CREATE SCHEMA usch_aese;
3. Grant role to users.

• For Single Server Deployment:
  1. Create database user for the database with the name of server hostname. 
     CREATE USER [<SERVER_HOSTNAME>] FROM EXTERNAL PROVIDER;

     NOTE:

     The server hostname is the machine for which system-assigned managed identity is enabled.

  2. Grant role to the database user, as database owner, database reader and database writer.
     EXEC sp_addrolemember db_owner, " ";
     EXEC sp_addrolemember db_datareader, "< SERVER_HOSTNAME>";
     EXEC sp_addrolemember db_datawriter, "< SERVER_HOSTNAME>";

• For Clustered Deployment:
  If a cluster setup is required, repeat the steps below for all the cluster nodes.
  1. Create database user for the database with the name of server hostnames.
     CREATE USER [<SERVER_HOSTNAME>] FROM EXTERNAL PROVIDER;
  2. Grant role to the database user, as database owner, database reader and database writer.
     EXEC sp_addrolemember db_owner, "<SERVER_HOSTNAME>";
     EXEC sp_addrolemember db_datareader, "< SERVER_HOSTNAME>";
     EXEC sp_addrolemember db_datawriter, "< SERVER_HOSTNAME>";
     User is granted the required access.
     
     

1. Assign the schema (created in step 1) as the default schema for this user.
   ALTER USER "< SERVER_HOSTNAME_1>" WITH DEFAULT_SCHEMA = usch_aese;

   NOTE:

   Execute this query for one time and for all cluster nodes.