installation issue-services

Question

installation issue-services

db8

Right there with Babe

Points: 728
More actions
April 1, 2016 at 6:59 pm

#399962

Hi all
could you please suggest what is the error in installation,all the services are installed but i am unable to connect,please see the images.
i cant find the analysis services engine to start , i have installed 2012 sql server evaluation edition
https://www.microsoft.com/en-us/download/details.aspx?id=29066

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

PB_BI SSCoach Points: 17463 More actions · Answer 1

You seem to have installed SQL Server Express. This does not include SSAS unless it is the "Advanced Services" version, which this doesn't seem to be.

I'm on LinkedIn

db8 Right there with Babe Points: 728 More actions · Answer 2

do i need to install the advanced edition or

https://www.microsoft.com/en-my/download/details.aspx?id=35579

please suggest

aprathour.89 Default port Points: 1495 More actions · Answer 3

Express doesn't support Analysis Services , you will not able to get Analysis services even after installing Advance features.

-----------------
Aditya Rathour
SQL DBA

Not Everything that is faced can be changed,
but nothing can be changed until it is faced.

db8 Right there with Babe Points: 728 More actions · Answer 4

please suggest how to work on analysis services which one i need to install ?

PB_BI SSCoach Points: 17463 More actions · Answer 5

You need the full version of SQL Server, not Express. I was mistaken about Advanced Services.

I'm on LinkedIn

db8 Right there with Babe Points: 728 More actions · Answer 6

can some one help me in uninstalling there are many folders in C drive for MSSQL server

i want to uninstall unrelated things(multiple sql server folders in C drive) and so that the present instance can be used to work.

can someone suggest good link for uninstalling...

PB_BI SSCoach Points: 17463 More actions · Answer 7

From BOL:

To Uninstall an Instance of SQL Server
To begin the uninstall process, go to Control Panel and then Programs and Features.
Right click Microsoft SQL Server 2012 and select Uninstall. Then click Remove. This starts the SQL Server Installation Wizard.
Setup Support Rules runs to verify your computer configuration. To continue, click Next.
On the Select Instance page, use the drop-down box to specify an instance of SQL Server to remove, or specify the option to remove only the SQL Server shared features and management tools. To continue, click Next.
On the Select Features page, specify the features to remove from the specified instance of SQL Server.
Removal rules runs to verify that the operation can complete successfully.
On the Ready to Remove page, review the list of components and features that will be uninstalled. Click Remove to begin uninstalling
Immediately after you uninstall the last SQL Server 2012 instance, the other programs associated with SQL Server 2012 will still be visible in the list of programs in Programs and Features. However, if you close Programs and Features, the next time you open Programs and Features, it will refresh the list of programs, to show only the ones that are actually still installed.

Just make sure you only uninstall the instances that you want to uninstall and not the ones you want to keep.

I'm on LinkedIn

EdVassie SSC Guru Points: 60476 More actions · Answer 8

If you sign up to the free Visual Studio Dev Essentials program then you can download and install SQL Server Developer Edition for free. This will give you Analysis Services for non-production use.

If you need Analysis Services for production use then you will have to pay for an edition of SQL Server that includes it.

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara