Restore MSSQL User

Restore MSSQL User

Instructions for Customers needing to re-add and re-link database users:

As for the procedure, you must open ssms (SQL Managment Studio) and add the missing user to these 2 areas:

Databases > [database_name] > Security > Users > [username]

General:
user name -> the user name
login name -> the login name (same as user name)
default schema -> dbo

Membership:
(check all options except db_denydatareader and db_denydatawriter)



Security > Logins > [username]

General:
login name -> the user name
SQL Server authentication
Password/Confirm Password -> enter the password
Enforce password policy (deselect)
Default database -> select the associated database

Once the user is added, re-link the user with the login via New Query, plugging in the proper database name and user names:

use database_name
go
EXEC sp_change_users_login 'Update_One', 'theusername', 'theusername'
go

On success, user should now be created and linked correctly to the database.

    • Related Articles

    • MSSQL Admin Tools

      I would like to manage my MSSQL database. How can I do this? On some of our MSSQL servers we have installed a tool called MyLittleAdmin. This web application allows you to edit your database, back it up and restore it from a backup (MSSQL 2005 & 2008 ...
    • MSSQL Redirect Module

      Cartika has introduced an MSSQL redirect module available for all Reseller customers (including UR customers, VDC, VPS and Cloud customers with MSSQL enabled) This module can be found under E.Manager > 3rd party Tools > CPDevel in your reseller ...
    • Restoring MSSQL via MS SQL Studio - VPS/Cloud/Dedicated only

      To restore a MSSQL database to your VPS or dedicated server, you would do the following steps: 1) Login to MS SQL Studio via remote desktop -- you will want to use an admin login and if you do not have this please contact us. 2) Right click the ...
    • Restore Deleted Hsphere Account

      If a customer or reseller has deleted an Hsphere account, there is a $75 one time fee to work with the customer to restore service and restore the account If a customer has deleted a Hsphere account and needs it restored, follow the steps below. In ...
    • Restore Deleted Hsphere Account

      If a customer or reseller has deleted an Hsphere account, there is a $75 one time fee to work with the customer to restore service and restore the account If a customer has deleted a Hsphere account and needs it restored, follow the steps below. In ...