Launch “SQL Server Installation Center” > Installation > “New SQL Server stand-alone installation or add features to an existing installation”. Now, to fix the issue we need to add “Management Tools – Complete”. Once setup completes, you would see same behavior which for which I am writing the blog. To repro the issue, I selected only Basic and this is what you would see in ConfigurationFile If you want to find what was the option you selected, then SQL setup logs are your friend! Ĭ:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\ DateTimeStamp\ConfigurationFile.ini I guess the feature description explains the behavior. here is the screenshot of setup screen with both features highlighted. While doing some more research, I remember setup screen had option for Management Tools – Basic and Complete. Microsoft Analysis Services Client Tools. I thought that this might be due to SSMS Express but looking at “Help” > “about” in Management Studio showed that it was full version. A picture is worth a thousand words, so here it is:Īnalysis Services, Integration Services, Reporting Services are grayed out/disabled. This blog is an outcome of one of internal email thread where SQL Server Management Studio was allowing to connect only “Database Services” and “SQL Azure”.
0 kommentar(er)
