Deploying SQL Server 2016 Management Tools

TL;DR SSMS is now a separate 800MB+ download. https://msdn.microsoft.com/en-us/library/mt238290.aspx

Long story (Begin Rant):

As much as I can, I always deploy Windows features and products using either direct to command line or with a configuration XML or INI file. In this case, I am installing SQL Server.

image

On previous version of SQL Server you can use the INI file to indicate what features you are going to install. Syntax is FEATURES=<FEATURE><,><FEATURE>

image

And before you can add the SSMS feature by adding SSMS –or- ADV_SSMS for Management Tool Basic –or- Advanced, respectively.

There seems to be a change with SQL Server 2016 as adding the SSMS will throw an install error.

So I saw the Management Tools now  located in the installation tab and under the new stand-alone link. I remember that in order for me to add SSMS before, it is under the add features to an existing installation. But now it seems that SSMS has its own link. But be warned, it is an actual “HREF” to a webpage. https://go.microsoft.com/fwlink/?LinkId=531355

image

Yes. You guess it right, you have to download SSMS as a separate installer.

image

https://msdn.microsoft.com/en-us/library/mt238290.aspx

That link, Download SQL Server Management Studio (16.5.3): https://go.microsoft.com/fwlink/?LinkID=840946 is 898MB. Surprise!

image

Now using Philippine internet connection: See you after 3 hours or more.

image

So after downloading we can now launch the installer.

image

Next time, I will be using /Install /Quiet as my command line parameters based on the MSDN article here: https://msdn.microsoft.com/en-us/library/bb500441.aspx but for now, lets do a GUI install.

image

Wait for the setup to finish. This will not ask for your install location nor what tool to install – it will install everything on your C:\Program Files so be careful if you have SSD. Hope in the future, since this is a standalone product that we can choose which drive to use. But for now its just a straight forward install.

image

image

So after installation, launch..

image

We now have SSMS back!

image

Advertisements

Cool DevLife Hack on VS2015–Paste Special!

So I saw this post on MSDN Philippines and Philippine .NET Users Group Facebook feed about “cool #DevLifeHacks” that nobody else knows about. So may as well contribute to this fun.

image

And my entry! Visual Studio 2015 Paste Special! Oh Yea!

image

Simply copy any XML or JSON and turn it into instant C# Classes!

image

I am not kidding. From Weather.gov Json result, instant C# classes, complete with getters and setters from primitive types to objects.

image

How’s that for a “cool #DevLifeHack”?

SCOM: The Data Access service is either not running or not yet initialized.

Microsoft.EnterpriseManagement.Common.ServiceNotRunningException: The Data Access service is either not running or not yet initialized. Check the event log for more information. —> System.ServiceModel.EndpointNotFoundException: Could not connect to net.tcp://scom01.XXXXX.net:5724/DispatcherService. The connection attempt lasted for a time span of 00:00:02.0029072. TCP error code 10061: No connection could be made because the target machine actively refused it XX.XX.1.10:5724.  —> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it

 

1

So, I got an error today on my SCOM lab. It seems some service are failing on start-up. Its been a long while since I touched SCOM and right now I wanted to “get back in the horse” since I will be doing a lot of monitoring for a new project. Might as well go back to System Center.

4

This time its fairly easy, error says the connection “Actively refused”. Basically as a developer myself, I am just going to say that the endpoint is down or is in faulted state.

I checked IIS if SCOM uses any WCF endpoint and it struck me, its TCP. Duh. Maybe its a self hosted WCF service and is running as a “Service”. Low and behold, there are a couple System Center services that are not running but its on “automatic” which is weird.

5

Started both service and viola! I can go back to my console.

6

Now back to my lab. Cheers!

image