Copy user to reporting environment 1

[JSHoltsIT]

I am running a separate SQL server to run reports against and to serve as an audit for our daily backup.

I need some assistance with copying user names and passwords over to the reporting sql server (different machine) and would like to automate the update process with scripting if possible.

TIA

Jason

 

[mrdenny]

What version of SQL Server?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[JSHoltsIT]

My apologies, both environments are SQL 2005.

Production: 9.00.1399.06 RTM Enterprise Edition
Reporting: 9.00.1399.06 RTM Standard Edition

Jason

 

[mrdenny]

SSIS includes a transfer logins task which can be used to copy logins from one server to another.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog