DESlock+ Support DESlock+ Support
Knowledgebase
Can I use my own SQL server with the DESlock+ Enterprise Server?
Article ID: KB167 email a link to this article

The DESlock+ Enterprise Server pre-install ships with a version of Microsoft SQL Server Express. Under normal circumstances this will be perfectly adequate for use. However if you wish to use your own version of Microsoft SQL Server for any reason you can do so, even if you are using the pre-install.

During the Enterprise Server setup, you will be prompted to enter details for your SQL server. If you have used the pre-install, by default these will be pre-filled with the values already configured by the pre-install.

Setup wizard

If you need to enter values, or if you wish to change the values to use your own SQL server (rather than the one provided in the pre-install), the following notes should be considered.

SQL Server Name This should be the proper instance name of the SQL server instance. The pre-install SQL server installs an instance called 'deslocksql' on the local machine. If you wish to enter your own instance name you should enter the full name including the instance name (unless you are using an unnamed instance).

SA Username / SA Password

This should be the username and password for the 'sa' database login, or any login which is a member of the sysadmin group. This login is used to create a new login for the Enterprise Server to use, creates a new Database on the specified instance, and configures the login with db_owner, db_datareader and db_datawriter access to that database.

These details are not stored, and are never used again.

The new login created during this step will have a username of dlpenterpriseuser. The password will be a randomized 16 character password using upper and lowercase alpha numeric characters, including symbols.

Database Name This is the name of the database that will be created on the specified instance. You may change this if you wish to use a different name.

Database Size Limits

Please note that SQL Server 2005 and 2008 Express Editions have a 4GB database maximum size limit. In large installations you may find this limit is too small. In such cases consider upgrading to SQL Server 2008 R2 Express (or later) which has a 10GB limit. Or alternatively you can supply your own non-express version of SQL which has no such limit.

 

 

 

 

Keywords: own sql instance server pre-install express


We use cookies on our website to enhance your browsing experience. Read more