This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
The sentence translated to English is: After installing the DBMS and SSMS, every time I run SSMS and try to create a query, it points to the following error:
Follow the video: https://www.youtube.com/watch?v=qiSrBGXf-BE
The sentence translated to English is: TITLE: Microsoft SQL Server Management Studio------------------------------
Unable to apply connection settings. Detailed error message: Incorrect syntax near the keyword ‘SET’.
BUTTONS: OK
The sentence translated to English is: The error occurs at the startup of SSMS. In an attempt to resolve it, I have already uninstalled SQL Server and SSMS, reinstalled them, and had no success. However, even with the error, I can execute the codes during the classes, but I have not found any solution so far.
Thank you for the help!
Answer accepted by question author
The error appears to be benign. That is, while you get an error, you should be able to use the query window.
When you open a new query window, SSMS will submit a number of SET commands, as configured on these tabs:
I don't see why any combination would yield syntax error, and if they do that would be a bug. But you may want to check your settings.
hi!
Thank you for your help. However, I still haven't been able to solve the problem. I tried the configuration that was mentioned and couldn't solve it. I have two machines with SSMS installed, at first the error pointed only on one of them, however today it pointed on the second machine. I'm trying to identify if it's some update. If anyone else has any suggestion I appreciate it!
If you want to investigate more, you could use Profiler to see what commands SSMS emits. But making sure that you have SSMS 19.1, the latest version is probably a good start.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 8%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPL%3C/text%3E%3C/svg%3E)
I believe this is an error in SSMS.
The problem is with "SET TRANSACTION ISOLATION LEVEL", which is not translated, check my answer here
Seems like a bug with the Portuguese version. Could you file a bug here: https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 40%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
This bug is also reproduced in the Russian version. The SSMS configuration stores the localized value of the parameter. This can be temporarily corrected by editing the configuration file %APDATA%\Microsoft\SQL Server Management Studio\19.0\UserSettings.xml (parameter name "SetTransactionIsolationLevel"). But it will break every time you open the SSMS options window, so it’s better to make a backup of the corrected file.