SQL query of isolated users

After a database of SQL Server 2000 is backed up, after restoration, it is found that the original user cannot connect to the database. This is because the restored database user has not logged on to SQL. solution:

Use in query Analyzer

Sp_change_users_login 'report'

View the isolated username and Sid.

The username and USERSID are queried.

SS 0x40b8125724fef14994ebdf83b0cbdf24

Then use

Sp_addlogin 'ss', 'pubuser', 'pmdb6', 'simplified China', 0x40b8125724fef14994ebdf83b0cbdf24

To add a login to the SS, the password is pubuser, the database is pmdb6, the default language in the Enterprise Manager, right-click the database server --> properties --> database settings to view the default database language.

Then you can log on to the database with the user name SS and password pubuser.