Page 32 - DCAP508_DATABASE_ADMINISTRATION
P. 32

Database Administration




                    Notes
































                                   24.  Microsoft SQL Server provides a default user named sa. To prepare that user for database
                                       authentication, click the Mixed Mode
                                   25.  Type a password in the Enter Password text box. For this exercise, you can use P@assword1
                                       and press Tab
                                   26.  Enter the same password in the Confirm Password text box
                                   27.  To add an additional account, click Add...

                                       A dialog box would display. In the bottom text box, type the (complete) user name of a
                                       user and click Check Names. In the same way, you can add as many users as possible

































          26                                LOVELY PROFESSIONAL UNIVERSITY
   27   28   29   30   31   32   33   34   35   36   37