After applying STIG to SQL Server 2016, SSMS said accessing this server via SQL Management Objects (SMO) is not permitted. Here is the cause and the fix.
SQL SERVER – Unable to Launch SSMS Error – Cannot Find One or More Components. Please Reinstall the Application
I had SSMS 17.1 installed on the machine and it was working fine. I don’t remember what I installed, but I started facing an SSMS error.
SQL SERVER – Error Due to Database Context – Error 208 – Invalid Object Name
Stuck on Error 208, Invalid Object Name, in SSMS? Often the object is fine and you are simply in the wrong database. Here is how database context causes it.
SQL SERVER – AlwaysOn Availability Group Listener – This TCP Port is Already in Use
Creating an AlwaysOn availability group listener in SSMS failed with error 19486: this TCP port is already in use. Here is what the ERRORLOG showed.
SQL SERVER – How to Get Updated Link for Code and Database Samples?
Some emails, indeed triggers blog posts such as the one I received the other day about database samples.
SQL SERVER – How to Install SQL Server Management Studio (SSMS) From Command Line?
Want to install SQL Server Management Studio silently from the command line, say with SCCM? Here is the one line batch command I shared with a reader.
SQL Server Management Studio (SSMS) – Unable to Connect to SSIS – The Specified Service Does Not Exist as an Installed Service
After installing SSMS 17.2, I was unable to connect to SSIS on my machine. The error said the specified service does not exist, which was misleading.