Uninstall named instance SQL 2008


How do I remove a named instance of sql server 2008 on the same mssql server?
If you have two instance in SQL Server 2008 and what are are the steps to remove one instance from SQL Server?

To remove a named instance of sql server 2008, follow these steps

1. Navigate to Control Panel->Add/Remove Programs

2. Select Microsoft SQL Server 2008

3. Select Change/Remove

4. Select Remove

5. At Select Instance spefify the instance of SQl Server to modify

Select the instance of SQl Server to remove. To remove management tools and shared features only, select “Remove shared features only” and then click next

uninstall named instance sql 2008

uninstall named instance sql 2008

Removal progress will go through and remove named instance of sql server 2008 on the same mssql server

Microsoft Kerberos Configuration Manager for SQL Server


Source:http://blogs.msdn.com/b/farukcelik/archive/2013/05/21/new-tool-quot-microsoft-kerberos-configuration-manager-for-sql-server-quot-is-ready-to-resolve-your-kerberos-connectivity-issues.aspx

You can download “Microsoft Kerberos Configuration Manager for SQL Server” from here

Microsoft Kerberos Configuration Manager for SQL Server is a diagnostic tool that helps troubleshoot Kerberos related connectivity issues with SQL Server.

Kerberos authentication provides a highly secure method to authenticate client and server entities (security principals) on a network.  To use Kerberos authentication with SQL Server, a Service Principal Name (SPN) must be registered with Active Directory, which plays the role of the Key Distribution Center in a Windows domain.  In addition, many customers also enable delegation for multi tier applications using SQL Server.  In such a setup, it may be difficult to troubleshoot the connectivity problems with SQL Server when Kerberos authentication fails.

The Kerberos Configuration Manager for SQL Server is a diagnostic tool that helps troubleshoot Kerberos related connectivity issues with SQL Server.   It can perform the following functions:

  • Gather information on OS and Microsoft SQL Server instances installed on a server.
  • Report on all SPN and delegation configurations on the server.
  • Identify potential problems in SPNs and delegations.
  • Fix potential SPN problems.
Supported Operating System

Windows 7, Windows 8, Windows Server 2008 R2 SP1, Windows Server 2012

The following are required on the machine where the Kerberos Configuration Manager for SQL Server is launched:

    • .Net framework 4.0 or higher

To Install:

  1. Download the 32bit or 64bit version of the Kerberos Configuration Manager installer that matches your computer’s OS architecture.
  2. Click Open to start the installation immediately or click Save to save the installation .msi file to disk and install it later.
  3. Accept the license term of this tool.
  4. Click Next to complete the installation.

To Launch the Tool:

  1. After the installation is complete successfully, double click the KerberosConfigMgr.exe  to launch the application.

To Generate SPN List from Command Line:

  1. Go to command line.
  2. Switch to the folder where KerberosConfigMgr.exe is.
  3. Type KerberosConfigMgr.exe -q -l
  4. For more command line option, type KerberosConfigMgr.exe -h

To Save a Server’s Kerberos Configuration Information:

  1. Connect to the target windows server.
  2. Click on Save button on the toolbar
  3. Specify the location where you want the file to be saved at.  It can be on a local drive or network share.
  4. The file will be saved as .XML format.

To View a Server’s Kerberos Configuration Information from Saved File:

  1. Click on the Load button on the toolbar.
  2. Open the XML file generated by Kerberos Configuration Manager.

To Generate a Script to Fix SPN from Command Line:

  1. Click on the Generate button for the SPN entry.
  2. The generated script can be used by a user who has privilege to fix the SPN on the server.

To See the Log Files for this Tool:

  1. By default, one log file is generated in the user’s application data folder.

To Get Help:
Option 1: Hover the mouse cursor over the command for tooltip.
Option 2:  Run KerberosConfigMgr.exe –h from command line
Option 3: Click the Help button in the toolbar.

Kerberos Configuration Manager for SQL Server


Kerberos Configuration Manager for SQL Server (KerberosConfigMgr) was released on May 15th 2013, and is available for download at the Microsoft Download Center at http://www.microsoft.com/en-us/download/details.aspx?id=39046.

How to remove/uninstall SQL Server 2008 from Windows 7/2008


I installed SQL Server 2008 R2 in my Windows 7 to configure SharePoint 2010 as a Farm.  After trying many options, I am still having problem to install SharePoint 2010 in Windows 7 as a farm using SQL Server 2008 instead of SQL Server 2008 Express Edition. 

It’s time to remove SQL Server 2008 from Windows 7 so that I can use SQL Server 2008 Express to install SharePoint as stand alone installation.

To Remove SQL Server 2008 from Windows 7, do the following steps

1. Go to Control Panel | Program | Uninstall Programs |Microsoft SQL Server 2008 R2 (64-bit) | and click on Uninstall

Uninstall SQL Server 2008 from Windows

 

2. You will get option to Add/Repair and Remove SQL Server 2008 . Click Remove

Remove/uninstall SQL 2008 Server

3.  Once Setup Support Rules completed, click OK  

Setup support rules to uninstall SQL Server 2008

 

4. Select Instance to remove

Select the instance of SQL Server to remove. To remove Management Tools and Shared Features only, Select
Remove Shared Features only and then click next.

Select Instance to remove SQL Server 2008

 

5. Select the features to remove
The SQL Server Features on this computer are shown below. To remove a feature, select the checkbox next to the feature name

Select Features to Uninstall SQL 2008 Server

6.  Click next to Removal Rules and your system is ready to Remove SQL Server 2008

Ready to Uninstall SQL 2008 Server

7. Removal of SQL Server 2008 R2 from Windows 7 computer

Removal of SQL Server 2008 R2

 

8.  Complete: Your SQL Server 2008 R2 Removal Completed Successfully.

 

your-slq-server-2008-r2-removal-completed-successfully

Introducing Microsoft SQL Server 2008 R2


Introducing Microsoft SQL Server 2008 R2

PART I   Database Administration

CHAPTER 1   SQL Server 2008 R2 Editions and Enhancements 3
CHAPTER 2   Multi-Server Administration 21
CHAPTER 3   Data-Tier Applications 41
CHAPTER 4   High Availability and Virtualization Enhancements 63
CHAPTER 5   Consolidation and Monitoring 85

PART II   Business Intelligence Development

CHAPTER 6   Scalable Data Warehousing 109
CHAPTER 7   Master Data Services 125
CHAPTER 8   Complex Event Processing with

 

You can download the ebook in XPS format here and in PDF format here.