November 3, 2015 at 7:24 am
Hello all,
As we all know logins and jobs aren't replicated when using AllwaysOn. What i wanna know is if the "tranfer login taks" will be enough to cover the transfer of logins between servers.
Regards,
November 3, 2015 at 8:27 am
The transfer logins task can copy the logins and SIDs, but not the passwords. It copies the logins with a random password and it also disables the login.
The best thing to look at would be sp_help_revlogin
November 3, 2015 at 8:31 am
Ok, tks.
Thats how iam doing it right now.
Just looking for a better solution 🙂
November 3, 2015 at 9:14 am
This tool might be what you're looking for:
https://www.sqlskills.com/blogs/jonathan/synchronize-availability-group-logins-and-jobs/
-- Gianluca Sartori
November 3, 2015 at 10:35 am
That looks awesome but has 2 problems.
First one is that its and .exe
Second one is that iam using sqlserver 2014.
November 3, 2015 at 10:54 am
First one is that its and .exe
I don't see a problem with that. The source is trustworthy.
Second one is that iam using sqlserver 2014.
Will probably work with 2014 as well. SSMS is almost identical.
Don't like it? Don't use it. There's still sp_help_revlogin.
-- Gianluca Sartori
November 3, 2015 at 2:20 pm
Arestas (11/3/2015)
Hello all,As we all know logins and jobs aren't replicated when using AllwaysOn. What i wanna know is if the "tranfer login taks" will be enough to cover the transfer of logins between servers.
Regards,
Which versions of SQL Server are you transferring logins between?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2015 at 2:28 am
Both databases are 2014
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply