|
top |
| 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. |
|
top |
| 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:
- Install and launch SQLpermissions
- Select a login method
- If you select SQL Server
Authentication, please enter your
username and password.
- Select (or type in) the name of the
SQL Server that you want to copy
permissions FROM
- Select (or type in) a single
database name or select ALL for
database(s) that you want to copy
permissions FROM.
- Select the User account whose
permissions you would like to copy. Use
CTRL + Shift to select multiple
accounts.
- 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.
- To run the TSQL script, locate the
saved SQLpermission.sql file.
- Move the file to the server where
you wish to replicate the user logins
and permissions.
- Double click the SQLpermission.sql
file. Microsoft SQL Server Management
Studio will be launched.
- When prompted, enter the server name
and credential information to connect to
the SQL Server you wish to apply the
logins and permissions to.
- 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. |
|
top |
| 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. |
|
top |
