Differences

This shows you the differences between two versions of the page.

--- ssms_notes [2022/12/21 19:44] – created raju
+++ ssms_notes [2022/12/21 19:50] (current) – prasanthi
@@ Line 3: / Line 3: @@
     * For other versions see https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms
   * Put the file in C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Backup
-  * To install start SSMS -> object explorer -> Databases -> right click -> "Restore Database..." -> Device -> ... -> Backup media type: -> choose "File" -> Add -> Choose the .bak file -> OK -> OK
+  * To install start SSMS -> object explorer -> Databases -> right click -> "Restore Database..." -> Device -> ... -> Backup media type: -> choose "File" -> Add -> Choose the .bak file -> OK -> OK -> OK
   * For other users to access it
-    * SSMS -> Object explorer -> Security -> Logins -> DESKTOP-CRLPVE5\<username> -> double click -> Server Roles -> check "public" and "sysadmin"
+    * SSMS -> Object explorer -> Security -> Logins -> DESKTOP-CRLPVE5\<username> -> double click -> Server Roles -> check "sysadmin"
+{{tag>["give access rights to users in microsoft sql server management studio"]}}