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.
| Author |
Topic |
|
Elidas
Starting Member
33 Posts |
 Posted - 2008-05-07 : 05:06:09
|
| What is the correct way to import the logins and DTS from a normal SQL Server 2000 to a clustered SQL Server 2000?Do I backup-restore master and model database to all nodes? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-07 : 11:58:18
|
| To transfer logins :you can use microsoft sp_revolvelogin and sp_hexadecimal SP.to transfer DTS package:http://www.sqldts.com/204.aspx |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-07 : 14:44:34
|
| DTS has copy sql logins task. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-07 : 15:34:00
|
| That doesn't copy SID. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-07 : 16:53:27
|
| You may unable to copy sid anyway if target server has lot of sql logins already. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-07 : 17:26:28
|
| It should. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-07 : 21:02:11
|
| How if sid is used on target server already? |
|
|
|
Elidas
Starting Member
33 Posts |
Posted - 2008-05-08 : 07:15:13
|
| I have copied the logins using a DTS task, but how do I copy the DTSs? I don't see a DTS task to copy DTS |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-08 : 11:02:36
|
| Did you check the link i have provided? |
|
|
|
|
|
|
How do I import DTS and logins to a cluster