Configure SQL Server With SQL Server Authentication
Configure SQL Server With SQL Server Authentication
Open the Microsoft SQL Server Management Studio.
Log in to the target database as a database administrator.
Create a new database named GADATA.
Create a new database login named GADATA and set the default database for this login to the database created in the step 3.
Create a new user named GADATA under the database created in step 3. During this user creation, make sure to attach this user to the login created in step 4. Set the default schema for this user as GADATA (we will create this schema in the later steps), and assign this user the role of db_owner.
Create a new schema named GADATA under the database created in step 3. While creating this schema, make sure to set the schema owner as gadata that was created in step 5.