• The service is authenticated by verifying the credentials provided in the logon account and the service is started.

• PID is allocated at windows level

• Authentication mode details are verified i.e either MIXED or WINDOWS

• Information of the startup parameters is captured i.e mdf location of master database, SQL Server error log location and ldf file location

• Some memory and CPU settings done at windows level, this is an informational message only

• Starts the master database

• model is the next database to start

• set the port related information

• Tempdb is recreated each time when we restart sql server

• Start msdb and other user databases based on dbid