Assignment Instructions Start by creating your database: Open Microsoft SQL Server Management Studio. Log in using the sa account to the Database Engine server. After you successfully connect in, you...

Assignment Instructions

Start by creating your database:

• Open Microsoft SQL Server Management Studio.
• Log in using the sa account to the Database Engine server.
• After you successfully connect in, you should see the object explorer on the left side.
  • Right-clickDatabasesand selectNew Database.
  • Set theDatabase Nameas DB4731.
  • Set theOwneras [sa] by clickingBrowseunder the object names.
  • Under your database connection (not DB4731), expandSecurity.
  • Right-clickLoginsand selectNew Login.
  • Enteradmin4731for the Login Name.
  • SelectSQL Server authenticationwith the password as Password1.
  • ClickOK.
• Expand the database DB4731.
  • You should seeSecurityas the last item in the list.
  • Right-clickSecurityand selectNew>User.
  • SelectSQL userwithLogin
  • Set the username as admin4731 with the Login Name set as admin4731.
  • UnderMembership, select db_owner, db_accessadmin, db_datareader, db_ddladmin, and db_datawriter.
• You can now test this account by disconnecting to the database by right-clicking the database connection under the object explorer and choosing disconnect. Then you can test your created account right-clickingConnect, selectingDatabase Engine. Under theAuthentication, selectSQL Server Authenticationand enter your credentials you have used.
• Once you have logged in again, you will create a regular user named user1 with Password1 as the password. The user should only have db_datareader and db_datawriter for membership.

The next step is to load the database with a script as the admin4731 account.

• Open the connection in Microsoft SQL Server Management Studio and go toFile>Open.
  • ClickFileand choose the load_sample.sql file provided.
  • You should see it load under the Query Editor Window tool.
  • ClickExecuteto execute the script.
  • You should see the script entirely run with all of the tables created.
  • To view the tables in an ERD format, right-clickDatabase Diagramsand clickNew Database Diagram. Select all of the tables that are available and clickOK.

Under the connection, take a screenshot of the table list, the users underSecurity, and the resulting ERD. You will save the screenshot for submission to be included with your database setup guide using the template provided in the resources area. Complete all other areas of the database setup guide template. Submit your database setup guide to the assessment area.