SQL Server Service: The database engine runs under this service. Entire SQL server operations are controlled by this service. It is responsible for running databases and system stored procedures
user logins information and passwords.
SQL Server Agent Service: This service is responsible for automation purposes. All the scheduled jobs will be executed only if this service is up and running.
SQL Server Browser Service: It is a service that will help us connect to SQL Server dynamically by an application. (front-end application is connecting to the backend server by a concept called connection string.)
Connection String; it contains DB name, username, password, and port number. (.Net)
The browser service will help to find out what instances are available and which instances are active and perform an operation.
Full Text Search Service: This service keeps all the repeated keywords and important keywords in a server called as catalog. When we use search, it goes to catalog and retrieves data from the database.
DTC (distributed transaction coordinator): It is responsible for moving data among instances, i.e., one DB to another DB.
How can you troubleshoot if installation failed?
In summary.txt and details.txt, all information about installation will be stored located in Path: C:\Program Files\Microsoft SQL Server\setup boot strap\log
How can you change the port number?
From Configuration Manager->SQL Server Network Configuration, we can change the default TCP/IP port number.
How to find the SQL Server version:
Select @@version.
Click on server summary report—server dashboard—configuration details.
How to find which bit SQL Server is running:
Right click on serveràproperties X86—32bit
X64— 64bit
Do you face any errors while installing?
No, because before installing we check all prescriptions, like pre-requisites, binary file locations, and so on.
How you will know that when SQL Server started:
By seeing TEMPDB creation date – rclk—properties By seeing ERRORLOG
What are the port numbers used for SQL Server services?
- The default SQL Server port is 1433, but only if it’s a default install. Named instances get a random port number.
- The browser service runs on port UDP
- Reporting services is a web service, so it’s port 80, or 443 if it’s SSL
- Analysis service is on 2382 but only if it’s a default Named instances get a random port number.