You can only create a new SQL Server database within EZLease if you have the dbcreator role assigned in the Security settings for this SQL Server instance.
In keeping with legal and recommended naming conventions for SQL Server, an EZLease database name must start with a letter and can contain letters, digits, and the symbols _, @, $, and #. Embedded spaces are not permitted. If you do not have the “Create any database” permission on a server, the Create button is disabled, but you can still create Access databases (typically used for test or temporary databases). Use of Access databases is governed by file system privilege settings (that is, if a user has read & write privileges for the folder in which the Access database is created, he can use that database).
When a new SQL database is created, the creator has full read/write access to the database. No other users have access (including the creator if logged in differently, such as SQL Server authentication instead of Windows authentication). To enable access to the database by other users, see the Permissions section below.
See the Installation section of this manual to create a new database using SSMS (for example, if new databases must be created by people who do not have access to EZLease).
EZLease does not include a capability to delete SQL databases. Use SSMS or a similar application to delete (DROP) an unneeded database.
Any user, regardless of their SQL permissions, can create an Access database, such as for a temporary database that doesn’t require shared usage. To create an Access database, click on Use Access Database or hold down the Shift key while choosing File/New.
You can still create an Access database, such as for a temporary database that doesn’t require shared usage. To create an Access database, click on Use Access Database or hold down the Shift key while choosing File/Open.
See also
SQL Server usage