Looking at the generated ssms.exe log file, it consisted of multiple tags and some of them were Errors showing 80004005 - E_FAIL. When the application fails to open again, find the log file and open it using a text editor, like notepad.Įxamining the content of the SSMS log file.Simply modify it to the path of your choice. This will create a log file at d:\log.txt.
#Create local server sql server management studio 17 full#
We need to specify the full path to the log file, something like this: We do this by using -log argument, followed by the location and the name of the log file. The executable file for the SQL Server Management Studio is ssms.exe and we need to run it with the logging enabled.
![create local server sql server management studio 17 create local server sql server management studio 17](http://www.maxtblog.com/wp-content/uploads/2018/01/Cache_SQLPS_02_2017-11-08_19-18-55-1024x597.png)
![create local server sql server management studio 17 create local server sql server management studio 17](https://blog.sqlauthority.com/i/d/agt-miss-01.jpg)
Using the SQL Server Management Studio log file.