Author |
Topic |
beachtime1999
Starting Member
25 Posts |
Posted - 2007-08-03 : 09:19:07
|
Hellois it safe to script out SQL user accounts, passwords and permissions?can i Just copy data from one sysuser to another?how can I transfer the passwords and permission?select * from sysuser and where isnull(sid,1)<>1 andsid <> '0x00'--guest and sid <> '0x01'-- |
|
beachtime1999
Starting Member
25 Posts |
Posted - 2007-08-03 : 09:52:34
|
Can I copy the data from syslogin to new server? |
|
|
beachtime1999
Starting Member
25 Posts |
Posted - 2007-08-03 : 09:52:34
|
Can I copy the data from syslogin to new server? |
|
|
beachtime1999
Starting Member
25 Posts |
Posted - 2007-08-03 : 09:52:34
|
Can I copy the data from syslogin to new server? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-03 : 10:34:28
|
Yes, use copy logins task in sql2k dts or in sql2k5 ssis. |
|
|
beachtime1999
Starting Member
25 Posts |
Posted - 2007-08-03 : 13:58:12
|
Great Thanks a bundle.Steve |
|
|
stephe40
Posting Yak Master
218 Posts |
Posted - 2007-08-03 : 15:25:36
|
SMO will not script out login passwords. It will generate code to create the login with a random password. Which sucks, because I used DMO in the past to script out logins with the encrypted passwords, as a disaster recovery measure.- Eric |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-03 : 15:35:13
|
Just use this: http://www.sqlmag.com/articles/index.cfm?articleid=16090&It grabs the login id, password, and sid information. You just need to run it on the 2000 server, copy the output, possibly edit out some logins, then paste the code into your 2005 server and run it. All logins and passwords are now on your 2005 server and you don't even need to unorphan them since the sid was copied over.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-08-04 : 07:02:08
|
is there a way to grab the password in 2005 like in 2000?i get random characters generated--------------------keeping it simple... |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-04 : 20:18:33
|
SSIS package copies password over. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-05 : 00:08:05
|
The link that I posted works for 2005 too. It grabs the passwords plus sids. I hate using external packages for logins when a simple script can do it.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|