how to transfer logins between 2k5 instances

Hello,
I am wondering if there is a kb article on how to transfer logins
between two sql2k5 instances? I have seen one for sql2k but not for sql2k5.
Thanks.
JakeHi Jake,
You can use a SSIS package to transfer logins. Also you can check my blog. I
updated the MS procedure to SQL Server 2005. it is in Spanish, but the code
is T-SQL, of course :-)
http://solidqualitylearning.com/blo...02/25/1618.aspx
Regards
Antonio Soto
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Jake" <noreply@.nowhere.com> escribi en el mensaje
news:enqPtusQGHA.5036@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I am wondering if there is a kb article on how to transfer logins
> between two sql2k5 instances? I have seen one for sql2k but not for
> sql2k5. Thanks.
> Jake
>|||Antonio,
Thanks alot for the help.
Jake
"Antonio Soto" <antoniosotorodriguez@.gmail.com> wrote in message
news:OsSMC92QGHA.4608@.tk2msftngp13.phx.gbl...
> Hi Jake,
> You can use a SSIS package to transfer logins. Also you can check my blog.
> I updated the MS procedure to SQL Server 2005. it is in Spanish, but the
> code is T-SQL, of course :-)
> http://solidqualitylearning.com/blo...02/25/1618.aspx
> Regards
> Antonio Soto
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
> "Jake" <noreply@.nowhere.com> escribi en el mensaje
> news:enqPtusQGHA.5036@.TK2MSFTNGP12.phx.gbl...
>|||You can still do it using SSIS (as opposed to DTS) . One thing to watch out
for is that for SQL logins the account is disabled and the password set to
random value as per Books Online "Transfer Logins Task"
Apart from that pretty sure the same rules applies - ie have to fix up with
sp_change_users_login
cheers,
Andy.
"Jake" <noreply@.nowhere.com> wrote in message
news:enqPtusQGHA.5036@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I am wondering if there is a kb article on how to transfer logins
> between two sql2k5 instances? I have seen one for sql2k but not for
> sql2k5. Thanks.
> Jake
>

How to sync data between MSDE

Is there any article/help/doc on how to sync data between MSDE2000? I have installed MSDE on two XP machine, would like to sysnc the data bwteeen them.
Thanks
Look in the BOL about SQL Server replication.
Depending on your synchronization needs, there are a variety of options. If
you don't have the Developer's Edtion of SQL Server then I recommend that
you get it so that you can use EM to develope any replication DTS packages
you may need.
Jim
"Henry" <anonymous@.discussions.microsoft.com> wrote in message
news:39504051-7ECA-4EC2-BF34-562271854B62@.microsoft.com...
> Is there any article/help/doc on how to sync data between MSDE2000? I have
installed MSDE on two XP machine, would like to sysnc the data bwteeen them.
> Thanks
|||Thanks, Jim.
I try to EM config the replication, use one machine as distributor and publisher, but it kept tell me can not connect to server because 'distributor_admin' is not defined as a remote login at the server. Do you know how to define this user? I tried creati
ng db and windows user, wouldn't work. These two machines are in a workgroup.
In my application, one MSDE(1) is collecting data, the other MSDE(2) get the data published from the (1) and read the data only. I plan to use (1) as publisher & distributor, (2) as subscriber. these two machines are not always online. Which way to sync i
s better, push or pull?
Henry