PRB: ?? "??????? ????? ?????????? ???" ????? ?? ???????? ??????

?????? ????????? ?????? ?????????
???? ???????: 274188 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

??? ??????? ????? ??????? ?????? ?????? ??? ???? ??? ?? ????? ????? ?? ?????????? ???????. ?? ????? ??????? ????? ??? ?????????? ?? "??? SQL Server ???????" ?? ???? ?????? ??????? ??????? ???????? ??? ???????.

???? ??? ??????? ????? ??????? ?????????? ???????.

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ????? ??? ???????.

??????? ????

??? ????? ?? ??? ??? ?????? ??????? ????? ?????? ???? ????????? ???????? ? ??? ?????? ????. ??? ??????? ????? ???? ??????? ???????? ??????? ???? ?????? ????? ?????? ?????? ?? ??? ?????? ????????? ?????? ????????. ????? ??????? ???? ?????????? ?????? ????? ?????? (SID). ????? ????? ???? ?????? ??? ???? SQL Server. ???? ????? ?????? ?? ??? ????? ???? ????? "????????". ??? ?? ???? ??? ????? ?????? ??????? ?????? ????? ?????? SQL Server. ??????? ???? ???????? ?????? ??????? ???? ?? ??????? ?? ????? ????????. ?? ???? ???? ???????? ????? ?? ????? ?????? ????? ???? ?????, ????? ??? ???????? ???? ?????? ??? ????? ?????? ?????? ??? ????? ?????? ??? ????? ?? ?? ???????? ?? ????? ?? ??????? ????? SQL Server. ???? ????????? ???? ??? ??? ?????? ????? ????? ????? ???????? ??? ???? ???????? "?????". ?? ????? ????? ???? ??? ??? ???? ?????? ????? ???????? ????? (Guest). ???? ?????? ?? ???? ???? ?????? ????? ?????? ???? ?? ???? ?? ????? ?????? ??????? ???????? ??? ???? ??? ????? ?????? ??? ???? SQL Server.

??? ??????? ????? ?????? ??? ???? ??? ????? ??? ?????? ?? ?????????? ????????? ???? ?? ?? ???? ??? ??????? ?????? ??????? ?? ?? ?? ???? ??????? ?????? ????? ???? ??????????. ????? ??? ????? ?????? "??? ??????????."

??????? ????? ?????????? ????????

??? ??????? ????? ??????? ?????? ?????? ??? ???? ??? ?? ????? ????? ?? ?????????? ???????. ????????? ?????? ???? ??????? ?? ???? ????? ????.
  1. ????? ??? ????? ???? ??? ????? ???????? ???????? ?? ??? ????? ???????? ?????????? ??? Northwind:
    Use master go sp_addlogin 'test', 'password', 'Northwind'
    						
  2. ??? ?? ?????? ??? ???????? ???? ??? ??????? ????:
    Use Northwind go sp_grantdbaccess 'test'
    						
  3. ????? ????????? ?????? ????????.
    BACKUP DATABASE Northwind
    TO DISK = 'C:\MSSQL\BACKUP\Northwind.bak'
    						
  4. ??????? ????? ???????? ??? ???? SQL Server ???:
    RESTORE DATABASE Northwind
    FROM DISK = 'C:\MSSQL\BACKUP\Northwind.bak'
    						
    ?????? ???? "??????" ????? ??? ????? ???????? ??? ????????? ??? ???? ??????? ???? ???? ?? "??????" ??? ???.
  5. ????? ????? ?? ?????????? ??????? ????? ??? ????????? ????????:
    Use Northwind go sp_change_users_login 'report'
    						
    ??????? ???? ??????? ???? ?? ??????, ????? ???? ??? ????? ??? ????????? ?? ???? ?????? sysusers ?? ????? ?????? Northwind ??????? ?????? sysxlogins ?? ????? ???????? ????????.

??????? ?? ?????????? ????????

  1. ?? ?????? ????? ?????? ???????? ??????? ?? ?????? ???????:
    Use Northwind
    go
    sp_change_users_login 'update_one', 'test', 'test'
    						
    ??? relinks ???? ????? ?????? "??????" ?? Northwind ????? ?????? ???????? "??????". ????? ????? ????? ??????? sp_change_users_login ????? ????? ???? ?????????? ??????? ?? ??????? "auto_fix" ???? ?? ????? ???? ??? SQL Server ????? ?????? ??????? ?????? ??????????? ??? ?????. ?????? ??? ???? ??????? ???? ???; ??? ???? ??? ????? ?? ?????? ????? ?????? ??? ???? ?? ???? ???????? ?????? ??? ?????.
  2. ??? ????? ????????? ???????? ?? ?????? ??????? ???? ???????? ?????? ??? ????? ????????. ?? ?? ???????? ????? ???? ?????? ?? ??????? sp_password ?????:
    Use master 
    go
    sp_password NULL, 'ok', 'test'
    						
    ?? ???? ??????? ??? ??????? ?????? ?????? ?????? Microsoft Windows NT. ?????? ?????????? ??????? ????? SQL Server ?? ???? ???? ???? ????? Windows NT ?????? ??? ?????? Windows NT; ????? ????? ?????? ?????? ??? ???? ????? ??? ?? Windows NT.

    ???? ??? ?????? ??? ????? ?????? ????? ???? ???? ????? ???? ?????? ???.

?????

?????? ??? ??????? ?????? ??? ????? ?? ???????? ???????? ??? ??? ??? ????? ?????? ??? ?????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
240872INF: ????? "?? ??? ??????? ??? ?????" ?? ??? ??? ?????? SQL

???????

???? ???????: 274188 - ????? ??? ??????: 05/?????/1424 - ??????: 3.2
????? ???
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbcodesnippet kbpending kbprb KB274188 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????274188

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com