Microsoft SQL

Top  Previous  Next

About Microsoft SQL


Microsoft SQL Server (Structured Query Language) is a proprietary relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet). Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent user

 

For more information please visit Microsoft SQL web site.  Microsoft has paid professional and free edition of SQL Server.

SQL Server Express is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications.

 
Microsoft SQL in our program


In our program Microsoft SQL is an optional database system you can use. Before use, you must have Microsoft SQL server installed on your computer.

If you have it installed then our Databases Maintenance feature will take care about everything else, it can create our databases for you on Microsoft SQL server and transfer data from other database systems.
You do not have to do anything else, however there is a tool named Microsoft Server Management Studio, which is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, manage, administer, and develop all components of SQL Server.
You can download and install it if you want to use the server for advanced use.

 
Microsoft SQL can be used locally, or Microsoft SQL database files may be shared across a network using a network file-system.

Microsoft SQL Server can be used for all software databases.

 

Microsoft SQL Configuration


The software is already preconfigured to use Microsoft SQL database, you can change the following options:

On Network
You can check here if you want to connect to the database on network.

Server
In Microsoft SQL Server, the server's name is the name assigned to the instance of SQL Server during installation.
This name uniquely identifies the SQL Server instance within the network. The server name can be used to connect to the SQL Server instance from various clients, management tools, or applications. when you are setting up server instance and set the credentials, its username and password must be used with Server Authentication mode.
Usually you enter the sever's name instance with preface .\ and then follows the server's instance name.
Also, you can enter the full server name not an instance, like for example MYCOMPUTER\MYSQLSERVER

Authentication Mode

In Microsoft SQL Server, there are two primary authentication modes: Windows Authentication Mode and SQL Server Authentication.
When you install SQL Server, you have the option to choose the authentication mode. It's generally recommended to use Windows Authentication Mode whenever possible due to its security benefits and integration with Windows domains. However, Mixed Mode is often necessary in environments with diverse authentication requirements. 
With our software we recommenced to use Windows Authentication,
 

Windows Authentication
Windows Authentication (also known as Integrated Security) is a method of authenticating users in Microsoft SQL Server. It allows users to connect to SQL Server using their Windows credentials, such as their Windows username and password, rather than providing a separate SQL Server username and password.
If using this mode Windows integrate security is used and Login and Password are ignored.

Server Authentication
SQL Server Authentication allows users to connect to SQL Server using a username and password stored within SQL
With SQL Server Authentication, users provide a specific SQL Server username and password when connecting to the SQL Server instance. 
These credentials are stored within SQL Server's security system, and they are independent of Windows user accounts.

 

Username

When using SQL Server Authentication you need to enter a specific SQL Server username.
 

Password
When using SQL Server Authentication you need to enter a specific SQL Server password.

Confirm Password
Reenter here your password

Data Folder
Here you can set database's local data folder. Once set and database is created you cannot change this location later.
Even if you are using the database on the network, this property must be set and database in this local folder must be present too.
This is done for the purpose when you are starting the software and the software is unable to connect to the database on network, then the connection will fall back to the local connection.

Backup Location
Here you can set database backup folder. After you change database backup folder it is advisable to move existing backup files to that new folder or create new backup.
Backup location can be a local folder, network folder or ftp server address.
 
If you want to use ftp server as your backup location then you must configure ftp server in software main options in FTP section
If you have it already configured enter into Backup Location text box a server address.

Notes:
Do not enter or look for any database names, software manages it, you only must set or select folder names.
After changing any settings here please do not forget to click the Save Settings button to save the changes.