Cannot Launch SQL Server Management Studio

Microsoft SQL ServerI work on a variety of test and demo systems and recently stumbled across an oddity with SQL Server Management Studio (SSMS); when I tried to launch it using the shortcut, the splash screen would display, stay on screen for a few seconds before disappearing with SSMS never starting, but no error message appearing or showing in the logs.

If I tried to start it by typing ssms in a command prompt I received the following error:

ssms error

ssms1

Windows cannot find 'ssms'. Make sure you rtyped the name correctly, and then try again.

I did some exploring and found this article on Stackoverflow which resolved my problem.

Find the Ssms.exe.config file and erase the line <NgenBind_OptimizeNonGac enabled="1" />:

Noterpad.exe showing Ssms.exe.config

How To Install Microsoft SQL Server 2017: Install SQL Server Management Studio

Microsoft SQL ServerIn this short series of posts, I am going to be covering the installation of Microsoft SQL Server 2017; the installation process for this version is somewhat different to previous ones, in that SQL Server Management Studio and SQL Server Reporting Services have been separated out from the main installer.

The series index can be found here. I am not a SQL expert and this series of posts is intended only for use on demo or test environment and not production ones.

The next component to be installed, is SQL Server Management Studio (SSMS). This was the first of the components which Microsoft removed from the main installer. However, to install it, we can launch the download page from the Setup utility.

Once launched, click Installation and then select Install SQL Server Management Tools:

SQL Server Installation Center - Installation

Continue reading "How To Install Microsoft SQL Server 2017: Install SQL Server Management Studio"

How To Install Microsoft SQL Server 2017: Series Index

Microsoft SQL ServerWith a new version of Microsoft Dynamics GP about to be released, it's time to refresh my test environment; as well as the upcoming release of Microsoft Dynamics GP 2018, Microsoft SQL Server 2017 is also now available.

In this short series of posts, I am going to cover the installation of the SQL Server components needed for an installation of a demo/test Microsoft Dynamics GP 2018 (not including SSAS or SSIS).

I am not a SQL expert and this series of posts is intended only for use on demo or test environments and not production ones.

How to Install Microsoft SQL Server 2017
Install the Database Engine Services
How To Install Microsoft SQL Server 2017: Install SQL Server Management Studio
Install SQL Server Reporting Services
Configure SQL Server Reporting Services
Avoiding Max Request Length Error in SSRS
SSRS 2017 Not Supported on a Domain Controller
Download SSRS 2017

How To Install Microsoft SQL Server 2016: Installing SQL Server Management Studio

Microsoft SQL ServerThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

In previous versions of Microsoft SQL Server, SQL Server Management Studio (SSMS) was always part of the standard install, but it seems this has changed with SQL Server 2016.

Instead SSMS is now available as a separate download. I'd recommend downloading the GA rather than any release candidate which might be available:

Download SQL Server Management Studio (SSMS)

Continue reading "How To Install Microsoft SQL Server 2016: Installing SQL Server Management Studio"

Change SQL Query Results Length

Microsoft SQL ServerWhen you execute a query in Microsoft SQL Server Management Studio, you can chooe to output the result to text, but this is limited to 256 characters which can not always be enough (my next planned post will have an example of this).

The setting for this can be changed in Tools >> Options.

Change the field Maximum number of characters displayed in each column from 256 to 8000:

Click OK to save the change; you will need to click the New Query button for the change to take effect.