Install SQL Server Management Studio 2016 – SQL in Sixty Seconds #080

Earlier this week, I have published a blog post where I explained how to install SQL Server 2016. One of the most asked questions was Where is SQL Server Management Studio 2016? I totally understand why this particular question is being asked often. I have decided to create a video explaining the how to install SSMS 2016.

Read More

SQL SERVER Installation – FeatureUpgradeMatrixCheck (SQL Server 2016 Feature Upgrade) setup rule failed

One of the best ways to learn problems faced by individuals and organizations is to look at the forums for these issues. Often I have visited MSDN forums and see if there are some hot or interesting issues. Sometimes it is interesting to see some setup failures and investigate for the root cause. They might look trivial, but the best part is going the path of troubleshooting can be refreshing and gives you immense satisfaction to how things work inside SQL Server or Windows. This blog is inspired by one such error that encountered and I found it interesting enough to share it on this blog for the benefit of a larger audience. Let us learn about SQL Server Installation Error.

Read More

SQL SERVER 2016 – WARNING: Setup Limited to Reporting Services for SharePoint

I have a habit of generally reading the “What’s New” section whenever a new version is around in the block. This is a great way to actually check, learn everything that is getting released in a nutshell. These often don’t just mean we can master them in that single page, but it gives us enough information to start our journey for exploration. Let us learn about Setup Limited to Reporting Services for SharePoint warning.

Read More

SQL SERVER – Fix Error – 948 A downgrade path is not supported. The database cannot be opened because it is version.

These past weeks the number of errors I have been getting when attaching a database has been far too many. But the best part of this learning experience is that I get to write about them one after another. There are no right or wrong answers sometimes, but am learning every time. Here is an error which is related to a downgrade path not supported. I received while I was trying to attach database using below command:

Read More