login / password scripting - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Author

Topic

MonsterZero
Starting Member

11 Posts

Posted - 2007-05-18 : 03:15:19

Hi guys, trying to run a script to transfer the logins / passwords to a new server. I have followed the article at http://support.microsoft.com/kb/246133/

when i run the script, the result says it is completed successfuly. When i run the EXEC master..sp_help_revlogin procedure, it produces a result:

/* sp_help_revlogin script

DECLARE @pwd sysname

-- Login: BUILTIN\Administrators
EXEC master..sp_grantlogin 'BUILTIN\Administrators'

-- Login: ears
SET @pwd = CONVERT (varbinary(256), 0x0100711FBD74DE578174BDAF75354C247B01728AFE924B1CA6FDB8C81CCD79BA6A1AE7EC70DA9A057EA572261B84)
EXEC master..sp_addlogin 'ears', @pwd, @sid = 0x601AE9FB0D961D41BD4446A7B21AB762, @encryptopt = 'skip_encryption'

There should be at least 20 other logins.
Am i missing something here?
The ears logon is for a another database.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-18 : 12:01:40

Don't think it transfers logins based on db name. Anyway, you can do that with dts task.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources