Create a New Database

See Also

 

When you want to create a new company, in the Admin Options screen, you are provided the following options:

 

The fields that display are dependent on the database selected—Standard (Microsoft Access Database) or SQL.

 

Company Name:

Enter the company name here. The company name is a required field for maintaining a licensed Web Suite database. The field size cannot exceed 95 characters. This field will appear on all invoices. Your Web Suite license key is based on your company name. You can purchase a license from BQE Software or through an authorized re-seller of Web Suite to obtain your license key, contact BQE Software at 888-245-5669 or email Sales@bqe.com.

 

If you have purchased a Web Suite license, you must enter the licensed company name in this field as it appears on the licensing and registration instructions, provided upon your purchase of Web Suite. The exact spelling, spacing and punctuation are required, although it is not case sensitive. If the company name is changed after the database is licensed, the result will be an unlicensed Web Suite database. Please consult Web Suite technical support, support@bqe.com, if you must change the company name.

 

Data File Name:

Click image\Select_template_icon.gif to choose the database, used by the Web Suite. This could be different from your company file name.

 

Use SQL Server:

Click this check box to use SQL server authentication to access your Company's database.

 

Server Name:

Type in the appropriate Server Name.

 

Use Windows Authentication:

Select this option to have to establish a connection to the SQL Server using the Windows Logon credentials (that is, Windows User and Password) when accessing the Company's database.

 

SQL Server User ID:

Enter your user ID when using the default authentication method.

 

SQL Server Password:

Enter your password for the SQL server.

 

Folder for Attachments:

The location used by Attachments screen to save the linked files. Click image\Select_template_icon.gif to choose that location for the attached files.

 

By default, this location is X:\BillQuickData\2014\File Attachment\ (X is the letter of the drive in which your Web Suite is installed). If the folder location is on a different machine other than the web server, you need to specify the UNC path. E.g.,

 

\\server\MyfolderLocation\

 

Folder for Reports:

Specify the location of customized report templates in this field.

 

Folder for Invoices:

Specify the location of invoices templates in this field.

 

Log File Location:

Click image\GS_Icon.gif to choose the location, where the log file will be stored automatically. By default, Web Suite automatically fills this field with X:\BillQuickData\2014\ (X is the letter of the drive in which your Web Suite is installed).

 

Automatically log actions to a log file:

Mark the option to view all the events taking place in Web Suite, in the Log Viewer screen. In other words, the log file will maintain a record of all the events of Web Suite.

 

By default, Read and Write permissions for NETWORK SERVICE or ASPNET account is given to the folder. However, if folder is on a different machine, then permissions need to be implemented via impersonation technique.

 

For more details, visit our Knowledge Base and do a keyword search for impersonation.

See Also