You must run the following SQL Admin Toolset tools under the Administrator account for proper functionality:
|
The User Clone tool helps you create new logins by copying one or more existing SQL Server users to use as templates. You can immediately perform the clone operation through the tool, or generate a T-SQL script that you can preview and edit.
Use the User Clone tool to create new user accounts from one or more existing accounts. You can copy a SQL Server login across SQL Servers and keep the same access settings and specify a new default database or password during the clone. After creating a new account, you can set the new SQL Server login as enabled or disabled.
You also can generate a T-SQL script that you can integrate into your existing work flows.
By default, User Clone connects to the specified SQL Server instance using the credentials of your currently logged on Windows account. The User Clone tool then copies the specified source SQL Server login and recreates it on the target SQL Server instance and databases. By default, the new login shares the same password, server and database roles, permissions and database access of the source login.
| | | | | | | |