Welcome to Sign in | Join | Help
in Search

Migrare SQL Server Login bazat pe Asimetryc Key

Last post 08-23-2012, 8:05 AM by step. 1 replies.
Sort Posts: Previous Next
  •  08-22-2012, 4:22 PM 9370

    Migrare SQL Server Login bazat pe Asimetryc Key

    Salut,

    Am o baza de date pe o instanta de SQL Server 2008 R2 si doresc s-o migrez pe o alta instanta SQL Server 2008 R2 pana aici toate bune.
    Am facut full backup respectiv restor pe instanta destinatie.
    dar am o problema cu un login ce se bazeaza pe asimetrical key si nu stiu cum sa-l replic sau migrez, stie cineva?

    Multumesc mult.
  •  08-23-2012, 8:05 AM 9371 in reply to 9370

    Re: Migrare SQL Server Login bazat pe Asimetryc Key

    Nu stiu exact cat te poate ajuta, dar poate poate

    EXEC dbo.sp_help_revlogin

    http://www.sqlhammer.com/blog/2012/08/20/how-to-transfer-logins-to-a-new-server

    sau pt hash ul
    LOGINPROPERTY ( 'login_name' , 'property_name' ) cu property_name setat la PasswordHash

    SELECT name, LOGINPROPERTY([name], 'PasswordHash') AS 'PasswordHash'
    FROM sys.sql_logins
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems