Table of Contents

Search

  1. Preface
  2. Informatica Managed File Transfer Welcome Overview
  3. Dashboard
  4. Resources
  5. Workflows
  6. Task Reference
  7. Services Overview
  8. Users
  9. Logs and Reports
  10. Encryption
  11. System
  12. Appendix
  13. Glossary Terms

Configure SQL Server With SQL Server Authentication

Configure SQL Server With SQL Server Authentication

  1. Open the Microsoft SQL Server Management Studio.
  2. Log in to the target database as a database administrator.
  3. Create a new database named GADATA.
  4. Create a new database login named GADATA and set the default database for this login to the database created in the step 3.
  5. 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.
  6. 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.

0 COMMENTS

We’d like to hear from you!