One problem I am experiencing is that I canâ€™t restore master DB of SQL Server 2005 to another SQL Server 2005, the SQL Server seems doesnâ€™t like that. This is what is difference from SQL Server 2000. Right now I have setup SQL Server 2005 log shipping to another servers and it is working well. The only thing left is how to sync SQL login to the target server. This link http://msdn2.microsoft.com/en-us/library/ms175535.aspx says that â€œYou can restore the master database only from a backup that is created on an instance of SQL Server 2005â€, this means that this is the option by default. I can't script out the login with permissoin I need on target server but I find it doesnâ€™t work on target server. This action doesnâ€™t script out the database the user can access. I want to grant another user in the target DB to the read only log shipping DB on target server. It seems not possible other than granted SQL sysadmin prilvilege. Any suggestion?