Create a new Windows user account called WinHoal. Create a new SQL Server that u

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

Explanation / Answer

1. Choose user accounts from control panel (start>Ctrl Panel) and there click new user (WinHoa1) and you can add one.

2. This is simple..just use SQL server GUI AND IT WOULD HELP.:

Meanwhile, it would be like this:

CREATE LOGIN login_name

PASSWORD =
WINDOWS [ WITH <windows_options>[ ,... ] ]
| DEFAULT_LANGUAGE = language

3. Its same you could use either GUI, internalley it would be :

CREATE LOGIN login_name

PASSWORD =
SID = sid
  
WINDOWS [ WITH <windows_options>[ ,... ] ]

DEFAULT_DATABASE = database
| DEFAULT_LANGUAGE = language

4. Simply, test it..

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.