Question: Create a new Windows user account called WinHoal. Create a new SQL Server that uses Windows suthentication and is mapped to the windows user WinHoal.

 Create a new Windows user account called WinHoal. Create a new

Create a new Windows user account called WinHoal. Create a new SQL Server that uses Windows suthentication and is mapped to the windows user WinHoal. Ensure that the SQL Server login is enabled and granted permission to connect to the SQLSERVERHOA instances. Map the new SQL Server login a new database user on the HandsOnOne database. Grant the database user the db_datareader role. Test the new SQL. Server login by logging on the your computer using the new Windown user account, WinHoal that you created in Step 1, and use SQL Server Management Studio to connect to the SQLSERVERHOA instance using Windows integrated authentication. In Object Explorer, confirm that you are able to browse the folders within the HandsOnOne database but not the adventure Works 2012 database. You will now test that the database user has read access to all tables in the HandsOnOne database. In SQL Server Management Studio logged on as the WinHoal user open a new Query Editor window, Write a SELECT statement to query all rows in the Customer and Address tales. Document this step by taking a screen shot of the Query Editor window after successfully executing the query. You willow test that the database user does not DELETE statement to delete a record from the Customer table. Document this step by taking a screen shot of the Query editor window after attempting to execute the query. Close SQL Server Management Studio and log off of your computer. Log back on using your usual administrator account and disable the WinHoal SQL Server login and the associated WinHoal Windows account

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!