How To Find Out What SQL Features Are Installed

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft SQL ServerNo day when you learn something new is a wasted day. I was onsite with a client recently to do some work with them on Microsoft Dynamics GP and got chatting to Den in their IT department.

It turns out that SQL Server has a report you can run which will show which features are installed.

The report is run from the SQL Server Installation Center which is available from the Windows Start menu. Click on Tools and then on Installed SQL Server features discovery report:

SQL Server Installation Center

Continue reading → How To Find Out What SQL Features Are Installed

● Categories: Microsoft, SQL Server ● Tags: , , ,  ● Permalink ● Shortlink ●

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

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThis 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

● Categories: Microsoft, SQL Server, SQL Server 2016, SSMS ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

How To Install Microsoft SQL Server 2016: SSIS Configuration For Named Instances

● Ian Grieve ●  ● 0 Comments   ● 

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

In the last post, I installed SSIS, but if you are using a named Instance of SQL Server, there is a configuration step required.

To make the change, there is a file called MsDtsSrvr.ini which, for SQL Server 2016, is located in C:\Program Files\Microsoft SQL Server\130\DTS\Binn. The ServerName needs to be changed to include the full SQL Server Instance Name (as highlighted below):

MsDtsSrvr.ini file in Notepad

Once the full SQL Server Instance Name was added and the file saved, SSIS is ready to use.

Click to show/hide the How To Install Microsoft SQL Server 2016 Series Index

● Categories: Microsoft, SQL Server, SQL Server 2016, SSIS 2016 ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

How To Install Microsoft SQL Server 2016: Installing SQL Server Integration Services

● Ian Grieve ●  ● 0 Comments   ● 

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

When I started the installation of the Analysis Cubes for Microsoft Dynamics GP as part of my ‘Hands On with GP 2016 R2 series, I knew I needed SQL Server Analysis Services (clue was in the name), but I didn’t initially realise that I was going to need SQL Server Integration Services (SSIS) although in retrospect it should have been obvious too.

The reason SSIS is needed, is that the Analysis Cubes in SSAS are populated by integration jobs from SSIS (scheduled using SQL Server Agent).

So I had to come back and install SSIS. You do this by launching the SQL Server setup utility and, under Installation click on New SQL Server stand-alone installation or add features to an existing installation:

SQL Server Installation Center

Continue reading → How To Install Microsoft SQL Server 2016: Installing SQL Server Integration Services

● Categories: Microsoft, SQL Server, SQL Server 2016, SSIS 2016 ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

How To Install Microsoft SQL Server 2016: Installing SQL Server Analysis Services

● Ian Grieve ●  ● 0 Comments   ● 

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

I typically don’t install SQL Server Analysis Services (SSAS), but decided to this time as I was installing all of the Microsoft Dynamics GP additional products for my Hands On with Microsoft Dynamics GP 2016 R2 series.

To install SSAS, launch the SQL Server setup utility and click on Installation and then on New SQL Server stand-alone installation or add features to an existing installation:

SQL Server Installation Center

Continue reading → How To Install Microsoft SQL Server 2016: Installing SQL Server Analysis Services

● Categories: Dynamics, GP, Microsoft, SQL Server, SQL Server 2016, SSAS 2016 ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

How To Install Microsoft SQL Server 2016: Configuring SQL Server Reporting Services

● Ian Grieve ●  ● 0 Comments   ● 

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

In the last post, I installed the SQL Server Database Engine and the Reporting Services, but I did not configure Reporting Services. I mentioned that I have had problems before when doing this, so always do it separately.

To configure SQL Server Reporting Services (SSRS), launch Reporting Services Configuration Manager from the Windows Start menu.

Select the Report Server Instance to connect to and click Connect:

Reporting Services Configuration Connection

Continue reading → How To Install Microsoft SQL Server 2016: Configuring SQL Server Reporting Services

● Categories: Dynamics, GP, Microsoft, SQL Server, SQL Server 2016, SSRS 2016 ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

How To Install Microsoft SQL Server 2016: Installing SQL Server Database Engine

● Ian Grieve ●  ● 0 Comments   ● 

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

In this post, I am going to step through the installation of the Microsoft SQL Server 2016 Database Engine. As most of my work is with Microsoft Dynamics GP, there will be a little focus on the installation required specifically for Dynamics GP, but the basic install is the same regardless of whether it is for Dynamics GP or not.

Launch the SQL Server setup utility (setup.exe), select Installation and click on New SQL Server stand-alone installation or add features to an existing installation:

SQL Server Installation Center

Continue reading → How To Install Microsoft SQL Server 2016: Installing SQL Server Database Engine

● Categories: Dynamics, GP, Microsoft, SQL Server, SQL Server 2016, SSRS 2016 ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

How To Install Microsoft SQL Server 2016: Series Index

● Ian Grieve ●  ● 13 Comments   ● 

Microsoft Dynamics GPA new version of SQL Server came out last year, and I’ve been creating some new demo machines for use at work. It has become habit to screenshot everything I install or configure, so I decided I might as well post a small series on how to install Microsoft SQL Server 2016 and it’s component parts.

The posts will be made over the coming days and show in the series index, below:

How To Install Microsoft SQL Server 2016
Installing SQL Server Database Engine
Configuring SQL Server Reporting Services
Installing SQL Server Analysis Services
Installing SQL Server Integration Services
SSIS Configuration For Named Instances
Installing SQL Server Management Studio

The installation of SQL Server has been broken down into different posts, as I don’t install all components all of the time, but only install the ones which are required at the time.

● Categories: Microsoft, SQL Server, SQL Server 2016, SSAS 2016, SSIS 2016, SSRS 2016 ● Tags: , , , , , , , , , ,  ● Permalink ● Shortlink ●

SmartList Wildcards

● Ian Grieve ●  ● 2 Comments   ● 

The Google-fu is weak with this one (this one being me). I read a post ages ago on the subject of SmartList wildcards which looked like it would be really useful, but then, after I’d forgotton the details, couldn’t find it again no matter what searches I tried.

Then, a couple of days ago, Tim Cruickshank, on the Rose Business Solutions blog, posted a few tips and tricks he’d picked up at Convergence, one of which was SmartList Wildcards.

Continue reading → SmartList Wildcards

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

How To Create A Microsoft Dynamics GP Installation Package

● Ian Grieve ●  ● 4 Comments   ● 

If you’re installing Microsoft Dynamics GP into a thin client environment then installing the clients isn’t that onerous a task, but if you’re installing GP into a thick client (or into a large thin client) environment then it can be a task that takes quite a while especially when the client has numerous features which need to be selected on each client.

Microsoft Dynamics GP includes an aid for this circumstance; the ability to create an installation package which allows you to easily and quickly install GP onto clients with exactly the same configuration each time.

The installation package is created from the Microsoft Dynamics GP setup;

Microsoft Dynamics GP setup

Continue reading → How To Create A Microsoft Dynamics GP Installation Package

● Categories: Dynamics, GP, Microsoft ● Tags: , , , ,  ● Permalink ● Shortlink ●