April 9, 2003 at 8:26 am
Is there a dts job or something to match login passwords between servers.
I have about 5 servers that i am needing to get the passwords matched on each server.
I also need also to get the actual table rights also if they change. Primarily between production servers and replicated servers.
April 9, 2003 at 8:35 am
Might look at this KB article to give you and idea on how to keep the passwords in sync with a since server. This KB article deals with moving logins from one server to the next.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
April 9, 2003 at 8:40 am
Check http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
This Stored procedure will not only transfer the password, but also the user id SQL uses internally. The output of the stored procedure is the t-sql commands needed to create the logins in another server.
April 9, 2003 at 8:47 am
Sorry Greg, you posted the message while I was still writting...
April 9, 2003 at 9:03 am
sorry guys that sp i use all the time but that creates the passwords and users. If the user already exists with database rights
Example:
John doe password hello
initially
set to john doe on sql1 and sql2
with rights to managers role on northwind db
on sql1 he changes his password
and changes to users role on northwind db
on sql2 is there a option other than scripting out the role for the northwind db
to change his passwords and roles
quote:
Check http://support.microsoft.com/default.aspx?scid=kb;en-us;246133This Stored procedure will not only transfer the password, but also the user id SQL uses internally. The output of the stored procedure is the t-sql commands needed to create the logins in another server.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply