| Author |
Topic |
|
ricky_newbee
Posting Yak Master
126 Posts |
 Posted - 2004-09-28 : 13:41:21
|
| Hello I need solution for tranferring server logins from SQL 6.5 server to SQL 2000 Server. Catch: Some logins exist in 2000, but default database is different. Can some one help me with this issue.Guys Please!!! Its kind of urgent!!! If some can either divert me to any other sites where i can find answers to my questions |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-28 : 16:24:46
|
| Search the forums here for sp_help_revlogin. We use it to transfer logins between two 2000 servers. It may work for you for 6.5 to 2000. If not, use DTS transfer logins option. And if you just want to change the default databases, then use sp_defaultdb.Tara |
 |
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 2004-09-29 : 10:11:48
|
| Tara, Thanks for your reply. If i use DTS should they carry passwords along with logins? I need to transfer passwords aswell. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-29 : 12:06:57
|
| Yes.Tara |
|
|
|
Dinesh
Starting Member
10 Posts |
Posted - 2004-09-29 : 13:04:45
|
quote:
Originally posted by tduggan
Yes.Tara
Friends, I also ended up with similar requirement, In my case I need to do login syschronization between Primary server and Secondary Server.It seems DTS - Transfer Logins Task will not transfer SIDs,I need to Synchronize logins with same SIDS which are in Primary server. This process should be automatic., whenever a login ID was created in Primary, It should be automatically created in secondaryI too need this as an urgent.,Could you people please jump in and share your thoughtsThanks in advanceDinesh |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-29 : 14:01:42
|
| Search the forums for sp_help_revlogin. It does what you are asking except it isn't automatic. I'm sure you can make it automatic with dynamic sql though.Tara |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 2004-09-29 : 15:14:33
|
| Yes!! Dinesh, ITs the same in my case too. I have to sinc all the logins to new server and my problem is that few logins from old server already there in new server. Don't have any idea how to deal with this |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-29 : 15:18:34
|
| Drop them from the source. Then run DTS utility. This is for Ricky's scenario.Tara |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-30 : 04:11:05
|
quote:
Originally posted by ricky_newbee
Hello I need solution for tranferring server logins from SQL 6.5 server to SQL 2000 Server. Catch: Some logins exist in 2000, but default database is different. Can some one help me with this issue.Guys Please!!! Its kind of urgent!!! If some can either divert me to any other sites where i can find answers to my questions
sp_defaultdb will change the default database for the users, if it's synchronizing the logins, sp_change_users_login |
|
|
|
|
Transferring logins from SQL Server 6.5 to 2000