Hi Programmers, welcome to new post Microsoft SQL Server Management Studio 18 version in Windows operating system.First we need to download SQL server 2019 and ssms 18.8(any latest version). For installation , let’s follow the following steps. Step1.click setup file of SQL server 2019 –>installation –> click New SQL server stand-alone installation. see below image.
Step2: Specify types of edition(Developer) –> Next –>Accept term and condition –>Next. see below image.
Step3: Select “Database Engine Service” and “Analysis Service” — >click Next. see below image.
Step4: Select “Default Instance” –>Next –>Grant Perform volume –>Next. see below image.
Step5: You can use Windows authentication mode , for mixed mode specify password for sa user. see below image.–>Add current user –> next –>tabular mode –>next.
see below image if any doubt.
step6: Ready to install –> install Progress — > install suceesfull.
finally sql server 2019 install correctly. see below image.
Step7: Download any latest version of ssms. click SSMS-Setup-ENU file –> click Install button. see below image.
Step8: progress status of Microsoft SQL server management studio . see below image.
Step9: the installation of Microsoft SQL server management studio has been completed successfully. click close. see below image.
Step10: write in search-box “ssms”. click Microsoft SQL server management studio 18. see below image.
Step11: the Microsoft SQL server management studio console open , select authentication,windows or SQL server authentication . login with sa. click connect.see below image
Enjoy using ssms.
Happy Programming …Thanks.
