Skip to main content

Default Services and programs Installed in SQL Server 2012

Q:- What are the Default Services in SQL Server 2012 ?

If this questions is related for Interview then this can be tricky because as per configuration manager the default services related to SQL server are 4 (DB Engine, Full text, Browser and Agent Service).
To check run  compmgmt.msc from CMD Prompt and select SQL Server Configuration Property. Then List of Services will show like below


 

But when we check Control Panel or OS Internal will show many more. When we install SQL Server 2012 there are some certain program which will install and we can find out all these from control panel. Below is the list of service names installed in SQL server web edition under windows 8 Desktop System.


We can also use PowerShell to get it
Start Power-shell form application list and run below Command.
PS: C:\User\Suman> Get-WmiObject Win32_Product | select name >>abc.txt
Now give next Command
PS: C:\User\Suman> Notepad abc.txt
Then List of Services related to SQL Server Display Look like below:-


1.Microsoft SQL Server 2005 Compact Edition [ENU]
2.Microsoft SQL Server 2008 R2 Management Objects
3.Microsoft SQL Server 2008 Setup Support Files  
4.Microsoft SQL Server 2012 Command Line Utilities
5.Microsoft SQL Server 2012 Data-Tier App Framework
6.Microsoft SQL Server 2012 Express LocalDB        
7.Microsoft SQL Server 2012 Management Objects     
8.Microsoft SQL Server 2012 Management Objects  (x64) 
9.Microsoft SQL Server 2012 Native Client           
10.Microsoft SQL Server 2012 Policies                
11.Microsoft SQL Server 2012 Setup (English)         
12.Microsoft SQL Server 2012 Transact-SQL Compiler Service 
13.Microsoft SQL Server 2012 Transact-SQL ScriptDom     
14.Microsoft SQL Server 2012 T-SQL Language Service     
15.Microsoft SQL Server Compact 4.0 SP1 x64 ENU         
16.Microsoft SQL Server Data Tools – Database Projects – Web installer entry point  
17.Microsoft SQL Server Data Tools - enu (11.1.20627.00)   
18.Microsoft SQL Server Data Tools Build Utilities - enu (11.1.20627.00) 
19.Microsoft SQL Server System CLR Types    
20.Microsoft SQL Server System CLR Types (x64) 
21.Microsoft System CLR Types for SQL Server 2012 
22.SQL Server 2012 BI Development Studio        
23.SQL Server 2012 Client Tools                 
24.SQL Server 2012 Common Files                 
25.SQL Server 2012 Data quality client          
26.SQL Server 2012 Database Engine Services     
27.SQL Server 2012 Database Engine Shared       
28.SQL Server 2012 Distributed Replay           
29.SQL Server 2012 Documentation Components     
30.SQL Server 2012 Full text search             
31.SQL Server 2012 Management Studio            
32.SQL Server 2012 Reporting Services           
33.SQL Server 2012 SQL Data Quality Common      
34.SQL Server Browser for SQL Server 2012       
35.SQL Server Customer Experience Improvement Program 


Labels:

Comments

Post a Comment

Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757

Popular posts from this blog

History of MySQL from AB Corp to Cloud Database

MySQL was created by a Swedish company, MySQL AB, founded by David Axmark, Allan Larsson and Michael "Monty" Widenius. Original development of MySQL by Widenius and Axmark began in 1994. The first version of MySQL appeared on 23 May 1995. Its name is a combination of "My", the name of co-founder Michael Widenius's daughter,and "SQL", the abbreviation for Structured Query Language. ·          23 May 1995 - First internal release ·          Year 1996 - Version 3 o     Simple CRUD operations o     January 1997 Windows version was released on 8 January 1998 for Windows 95 and NT o     production release 1998, from www.mysql.com ·          Year 2002 - Version 4 o     MyISAM o     unions o     Tracking o     B-trees o     s...
34 comments
Read more

How to add an article in Transactional Replication

If we have a set-up of Transactional Replication for Data Distribution running and wanting to add new object to replication on other server we can follow below process. To add an article In Transaction replication with PUSH Subscription 
29 comments
Read more

Configure Impersonation Authentication in IIS8 for MVC Application

Impersonation is when ASP.NET executes code in the context of an authenticated and authorized client. By default, ASP.NET does not use impersonation and instead executes all code using the same user account as the ASP.NET process, which is typically the ASPNET account. There are 5 below steps by which we can establish Impersonation configuration in our secured application environment. 1.)    Creation of Application/Proxy user where Application is hosted. 2.)    Give appropriate access to the user. 3.)    Create Database Login user on database. 4.)    Authenticate User and provide credential on IIS. 5.)    Then Configure web.config on Application.
28 comments
Read more