Feeds:
Posts
Comments

Posts Tagged ‘Sql Server 2012’

Interesting one today:

During one of the Sql Cluster set up in our lab environment, we ran into this interesting (and common) error message.

The Sql Server failover cluster instance name '' already exists as a clustered resource. 
Specify a different failover cluster name.
Sql Cluster Set up Error

Sql Cluster Set up Error

Resolution

Turns out, the sysadmins created a Resource Group with the same name and allocated all the cluster disks to it. So, when I attempt to create a new Resource Group (for Sql Server resources), it throws this error.

 

SqlCluster Install Resolution

SqlCluster Install Resolution

 

Solution: Once the dummy resource group was removed, the cluster set up wizard progressed without any errors.

The moral of the story is, when we are about to create a resource group, make sure a resource group by the same name does not already exist.

 

 

Hope this helps,
_Sqltimes
Advertisements

Read Full Post »

Quick one today:

Ran into an interesting version of the familiar error message. When installing Sql Server 2012 on a Windows Server 2012 R2, this error appeared.

Please note that, during pre-install checks, it just highlighted lack of .Net 3.5 it as a warning, but not as a failure. When installation is attempted, it fails asking for .Net 3.5.

TITLE: Microsoft SQL Server 2012 Setup
 ------------------------------

The following error has occurred:

Error while enabling Windows feature : NetFx3, Error Code : -2146498298 , 
Please try enabling Windows feature : NetFx3 from Windows management tools 
and then run setup again. For more information on how to enable Windows features, 
see http://go.microsoft.com/fwlink/?linkid=227143

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.5058.0&EvtType=0x681D636F%25401428%25401

net3-5_error

It seems like a cryptic error message, but its just a different variation of the same old “Missing .Net 3.5” error message. To resolve follow these steps:

Step 1:

From Task Bar, open Server Manager. Go to Manage, Add Roles and Features.

server_manager_add_roles_and_features

Step 2:

In the Add Roles and Features Wizard, click through the initial screen; When you are in ‘Installation Type’ tab, choose ‘Role-based or Feature-based installation’.

add_roles_and_features_wizard

 

Step 3:

Under Server Selection tab, choose the appropriate server name. If you are running it on the server, its name will be displayed in the Server Pool section.

server_selection_wizard

Step 4:

Skip the next section (Server Roles). Installation of .Net 3.5 is under Features. In the Features section, click the check box to install .Net 3.5.

install_net35

Step 5:

Components necessary to install .Net 3.5 are usually not readily available, so having access to Windows Server 2012 DVD or ISO would be necessary.

Windows_2012_ISO.png

In the Confirm Installation Selections step, at the bottom of the screen, click on Specify an alternate source path link to specify the path to Windows Server 2012 ISO.

Once necessary binaries are identified, installation will progress to completion.

Then reattempt, Sql Server installation.

 

Hope this helps,
_Sqltimes

Read Full Post »

Quick one today:

Not often, but once in a while, we need to check what Sql Components are installed on a given virtual machine; so we could replicate (install the same components) on any dependent database virtual machines. Very rarely do we get opportunities to appreciate the multiple features made available through the Sql Installer. Microsoft provides awesome tools to achieve this fashionably.

Follow these steps:

Step 1:

To open the Sql Installer, go to

  • Start
  • Microsoft Sql Server
  • Configuration Tools
  • Sql Server Installation Center
Sql Server Installation Center

Sql Server Installation Center

 

Step 2:

Under Sql Server Installation Center, open Tools. Go to Installed Sql Server Features Discovery Report.

 

Sql Install Discovery Report

Sql Install Discovery Report

 

Step 3:

When you click on it, Sql Server Installation Center will generate the report.

Running Discovery Report

Running Discovery Report

Once the report completes, it shows the output in, an easy to use, HTML format in a browser. Sample report is attached below:

Installed Components (Discovery Report)

Installed Components (Discovery Report)

Note: The same report is saved as SqlDiscoveryReport.htm under Program Files\Microsoft SQL Server\…\Setup Bootstrap\Log\…

 

Hope this helps,
_Sqltimes

Read Full Post »