User Tools

Site Tools

Trace:
ssms_notes

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
ssms_notes [2022/12/21 19:46] – rajussms_notes [2022/12/21 19:49] – prasanthi
Line 5: Line 5:
   * 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   * 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   * 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" 
 + 
 +{{tags>["give access rights to users in microsoft sql server management studio"]}}
  
ssms_notes.txt · Last modified: 2022/12/21 19:50 by prasanthi