SQL permissions

General Issues

Product Feature Questions

Technical Questions

General Issues
What is SQLpermissions?
Idera’s SQLpermissions is a freeware tool for copying or moving logins and permissions settings across SQLservers. SQLpermissions automates the time consuming job of configuring logins and permissions on one server to match another by generating a customizable TSQL script to do this for you. SQLpermissions also offers the flexibility to move one login or a group of logins and apply permissions across all databases on the target server, or a single database.
Does Idera offer other tools for SQL Server security & compliance?
Yes, in addition to SQLpermissions, Idera also offers SQL compliance manager and SQLsecure
  • SQL compliance manager automates the entire compliance process from data gathering to reporting and alerting. Download a 14 day of SQL compliance manager here.
  • SQLsecure analyzes users’ permissions across SQL Server, Active Directory and Windows to tell you exactly who can access what on your SQL servers. Download a 14 day evaluation copy of SQLsecure here.
What is Idera Freeware?
Idera Freeware applications are tools developed by the engineering team at Idera to alleviate common, day-to-day DBA headaches. They are yours to use anywhere you like, completely free of charge. All the support materials that you need to install, configure and use Idera Freeware tools are provided via FAQs on the Idera website.
Can I give feedback on Idera Freeware?
We’d love to hear what you think about our freeware tools, so if you have comments, feedback or ideas for other cool tools then drop us an email at freeware@idera.com.
Why is Idera offering SQLpermissions?
Moving permissions from one server to another is a pain to do manually, so a tool like SQLpermissions can save DBAs lots of time.

And…we think that if you like SQLpermissions then you’ll love our other products like SQL compliance manager and SQL secure.

How are Idera Freeware tools supported?
Idera Freeware products are supported differently than our licensed software products – support is available only via online FAQs vs. 24x7 phone support, and upgrades come when they come vs. regular maintenance upgrades.
Product Feature Questions
How do I install SQLpermissions?
Installation of SQLpermissions is very easy and takes only minutes. Simply download the installation package and follow the prompts. Refer to the product Quick Start Guide for help getting started using the product.
How do I use SQLpermissions to copy permissions from one server to another?
SQLpermissions generates a customizable TSQL script to move user logins and permissions from one server to another. To generate the TSQL script, follow these easy steps:
  1. Install and launch SQLpermissions
  2. Select a login method
  3. If you select SQL Server Authentication, please enter your username and password.
  4. Select (or type in) the name of the SQL Server that you want to copy permissions FROM
  5. Select (or type in) a single database name or select ALL for database(s) that you want to copy permissions FROM.
  6. Select the User account whose permissions you would like to copy. Use CTRL + Shift to select multiple accounts.
  7. Click “Generate” to produce the TSQL script. You will be prompted to enter a path and file name where you would like to save the script. You can then edit the TSQL script as needed to customize it further.
  8. To run the TSQL script, locate the saved SQLpermission.sql file.
  9. Move the file to the server where you wish to replicate the user logins and permissions.
  10. Double click the SQLpermission.sql file. Microsoft SQL Server Management Studio will be launched.
  11. When prompted, enter the server name and credential information to connect to the SQL Server you wish to apply the logins and permissions to.
  12. Once connected, select Query > Execute to run the script.
What type of user interface is provided for SQLpermissions?
SQLpermissions provides a graphical user interface (GUI) where you can enter the information required and generate your TSQL script.
Does SQLpermissions install any code on the database server?
No, SQLpermissions does not install any code on the database server.
Is SQLpermissions a stand-alone product, or is it part of another product?
SQLpermissions is a stand-alone product and it not dependent on any other Idera product. However, SQLpermissions provides a valuable complement to the security analysis capabilities of Idera SQLsecure.
What benefits would I get by using SQLsecure in addition to SQLpermissions?
While SQLpermissions helps you transfer logins and permissions from one server to another, it cannot verify that users have the appropriate access rights on your SQL Server. Idera SQLsecure is a permissions analysis tool that analyzes users’ rights across SQL Server, Active Directory and Windows to determine exactly who can do what on your SQL Servers. You may download a free 14 day evaluation version of SQLsecure here.
Technical Questions
What are the system requirements and prerequisites for SQLpermissions?
SQLpermissions requires SQL DMO 8 or higher, Microsoft .NET 2.0, and a supported OS:
  • Microsoft Windows 2000 SP4
  • Microsoft Windows 2003
  • Microsoft Windows XP
  • Microsoft Windows Vista
What Windows security permissions are required?
A windows domain account with local administrator privileges is required to install and run SQLpermissions. This account must also have login access to the SQL Servers from which you want to copy logins and permissions.
What SQL Server security permissions are required to use SQLpermissions?
The account you use to connect to a SQL Server should have administrator privileges.
What versions of Microsoft SQL Server does SQLpermissions support?
SQLpermissions supports the following versions of Microsoft SQL Server:
  • SQL Server 2000 (SP3a+)
  • SQL Server 2005 (SP1+)
Does SQLpermissions offer International language support?
No. SQLpermissions does not currently offer International language support.
Do I need to make any changes to the script before I apply it to the target server?
On occasion, the scripts created by SQLpermissions may need editing before they can be applied to the target server. Please thoroughly review the script detail and make any necessary modifications before attempting to run the script on the target server.

NOTE: All SQL login accounts are generated as Disabled and with a random password.

Does SQLpermissions copy application role permissions?
No. SQLpermissions does not copy application role permissions.
Do we offer a 32- and 64-bit version of SQLpermissions?
We currently offer only a 32-bit version of SQLpermissions.

Copyright | SQL Tools | Legal | Privacy