Post reply

export list of logins and passwords

  • July 28, 2008 at 2:48 pm

    #123380

    Hey,

    Is there a way to export a list of logins and passwords from a SQL Server?

  • July 28, 2008 at 3:10 pm

    #849479

    http://support.microsoft.com/kb/246133

  • July 28, 2008 at 4:44 pm

    #849512

    There are two three ways you could probably do that.

    1. You can go for scripting the logins and then run the script on the new server.

    Database>right click...>tasks>generate script> script wizard opens up> select the database >go to the option tab> you have the check the logins>passwords etc what ever you require.>

    it will ask for where to save. save the file and run that script on the other server.

    this may create some orphan user.....you may have to fix that later.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply