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...

1 answer below »

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.

Answered 2 days AfterApr 12, 2022

Solution

Shikha answered on Apr 15 2022
10 Votes
SRS Template
    
    
Database Installation Guide
fo
Smart Homes
Version 1.0
Prepared by Date
    
Contents
1.    Installation Guide    3
1.1    Creating SQL Server Admin Accounts    3
1.2    Creating SQL Server User Accounts    8
1.3    Entity Relationship Diagram    11
1.4    Table List    12
1.5    User List    13
Database Installation Guide
        Page iii
1. Installation Guide
1.1 Creating SQL Server Admin Accounts
The main steps for creating admin accounts in SQL Server are as following:
1. Open MS SQL Server Management Studio and login using inbuild sa...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here