Wednesday, September 30, 2015

The cluster resource 'SQL Server (SQL2014)' could not be brought online due to an error bringing the dependency resource 'SQL Network Name (SQL2014)'


Users will face this common issue during SQL Server Failover Cluster installation. Note that SQL Server Engine service is always dependent on Network Name resource. The network resource failure can result the SQL Server resource not coming online.

User may see below messages in system log

Cluster network name resource 'SQL Network Name (SQL2014)' failed to create its associated computer object in domain sqlserver-expert.com' during: Resource online.

The text for the associated error code is: Access is denied.

Please work with your domain administrator to ensure that:
- The cluster identity 'SQL2014$' has Create Computer Objects permissions. By default all computer
objects are created in the same container as the cluster identity 'SQL2014$'.
- The quota for computer objects has not been reached.
- If there is an existing computer object, verify the Cluster Identity 'SQL2014$' has 'Full Control' permission to that computer object using the Active Directory Users and Computers tool.

The main cause for this error is insufficient permission to create computer objects. You have two options to resolve this error.

1. Ask your Windows Admin to grant permission “Read all properties” and “Create Computer Objects to the CNO via the container.

Or

2. Ask your Windows Admin to create required computer objects.

You can refer below link for more info

http://blogs.msdn.com/b/psssql/archive/2013/09/30/error-during-installation-of-an-sql-server-failover-cluster-instance.aspx

Regards,
Satishbabu Gunukula

Monday, September 14, 2015

User domain\user does not have required permissions during SSRS configuration

I have installed SQL Server Reporting Services and configuration went smoothly. But I have received below error while trying to open the Repots URL i.e http://servername/Reports

User domain\user does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed

Below posts helped me to resolve the issue.

https://social.msdn.microsoft.com/forums/sqlserver/en-US/9b5a8763-84ce-46d0-b011-067ad39223d1/does-not-have-required-permissions

https://social.technet.microsoft.com/Forums/systemcenter/en-US/313e2166-1956-4dd0-a694-0b506e1ddba9/srs-reporting-permission-error

I hope this will help for you.

Regards,
Satishbabu Gunukula



Thursday, September 10, 2015

Uninstall SQLServer Reporting Services

Reporting Service feature can be uninstalled though Control Panel, Program and Features. When you uninstall reporting service, the RS configuration files, database files, content and repots left in place. User need to cleanup manually.

To uninstall Reporting Services Native mode follow the steps

1. Control Panel, Click ‘Programs and Features’

2. Select ‘Microsoft SQL Server 2014 (64bit)’ click Uninstall/Change à Select Remove Option

3. Select the instance to remove from


4. Next screen select the Reporting Service that you want to remove


5. Complete the removal process.

Regards,
Satishbabu Gunukula

Tuesday, September 1, 2015

There are no SQL Server instances or shared features that can be updated on this computer


Recently I have installed a new instance (SQL Server 2008 ) on a 2 node SQL Server cluster. When I am trying to apply Cumulative update 7 for SP2, the check box is grayed out and not able to select the check box for newly created instance and received following error

There are no SQL Server instances or shared features that can be updated on this computer.

I didn’t not receive any error during the instance creation, didn’t see any error messages in the event viewer. It looks the issue is with version, need to find the version information.

When I click on the instance to find the version information, I see a version miss match message in the description.

The version of SQL Server instance TEST does not match the version expected by the SQL Server upgrade. The installed SQL Server product version is 10.1.2531.0, and the expected SQL Server version is 10.2.4000.0


 It is very clear that before installing the Cumulative update 7 for SP2, we need to bring the version up to 10.2.4000.0.

I have installed SP2 first and I was able to apply Cumulative update 7 for SP2 successfully.

Regards,
Satishbabu Gunukula

Tuesday, July 21, 2015

Free e-Book: Microsoft System Center: Optimizing Service Manager

This fee e-Book "Microsoft System Center: Optimizing Service Manager" written by Rushi Faldu, Manish Raval, Brandon Linton, Kaushal Pandey and series editor Mitch Tulloch

This book delivers a focused drilldown on using Configuration Manager for queries and custom reporting, with scenario-based guidance for deployment success. Written by experts on the Microsoft System Center team and with Microsoft MVP Mitch Tulloch as series editor, this title provides concise, from-the-field guidance as you step through key concepts and tasks.

You can download the e-Book 

1. PDF version of this title here
2. The EPUB format is here and Mobi for Kindle file here
Regards,
Satishbabu Gunukula
http://www.sqlserver-expert.com

Thursday, July 9, 2015

Introducing Windows 10 for IT Professionals, Preview Edition

This fee e-Book "Introducing Windows 10 for IT Professionals" written by Ed Bott .

Get a head start evaluating Windows 10—with early technical insights from award-winning journalist and Windows expert Ed Bott. This guide introduces new features and capabilities, providing a practical, high-level overview for IT professionals ready to begin deployment planning now. This book is a preview, a work in progress about a work in progress. It offers a snapshot of the Windows 10 Technical Preview as of April 2015, on the eve of the BUILD Developers’ Conference in San Francisco.

Chapter 1: An overview of Windows 10 Technical Preview
 

Chapter 2: The Windows 10 user experience

Chapter 3: Installing and deploying the Windows 10 Technical Preview

Chapter 4: Security in Windows 10

Chapter 5: Deploying and managing Windows Store apps

Chapter 6: Web browsing and Windows 10

Chapter 7: Windows 10 networking
 

Chapter 8: Visualization and remote access

Chapter 9: Backup and recovery options in Windows 10

Chapter 10: Windows 10 on phones and small tablets


You can download the e-Book 

1. PDF version of this title here
2. The EPUB format is here and Mobi for Kindle file here


Regards

Satishbabu Gunukula
http://www.sqlserver-expert.com

Thursday, May 14, 2015

Free e-Book: Introducing Microsoft SQL Server 2014

This fee e-Book "Introducing Microsoft SQL Server 2014" – by Ross Mistry and Stacia Misner .

Microsoft SQL Server 2014 is the next generation of Microsoft’s information platform, with new features that deliver faster performance, expand capabilities in the cloud, and provide powerful business insights.

In this book, we explain how SQL Server 2014 incorporates in-memory technology to boost performance in online transaction processing (OLTP) and data-warehouse solutions. We also describe how it eases the transition from on-premises solutions to the cloud with added support for hybrid environments.

SQL Server 2014 continues to include components that support analysis, although no major new features for business intelligence were included in this release. However, several advances of note have been made in related technologies such as Microsoft Excel 2013, Power BI for Office 365, HDInsight, and PolyBase, and we describe these advances in this book as well.

The book includes below chapters:

Database AdministrationChapter 1: SQL Server 2014 editions and engine enhancements
Chapter 2: In-Memory OLTP investments
Chapter 3: High-availability, hybrid-cloud, and backups enhancements

Business intelligence DevelopmentChapter 4: Exploring self-service BI in Microsoft Excel 2013
Chapter 5: Introducing Power BI for Office 365
Chapter 6: Big Data Solutions

You can download the e-Book 

1. PDF version of this title here
2. The EPUB format is here and Mobi for Kindle file here

Regards
Satishbabu Gunukula

Wednesday, May 13, 2015

Free ebook:Rethinking Enterprise Storage: A Hybrid Cloud Model

This fee e-Book "FREE e-Book: Rethinking Enterprise Storage: A Hybrid Cloud Model" by Marc Farley .

The author, Marc Farley, works at Microsoft on hybrid cloud storage solutions as a senior marketing manager. The book includes a Foreword by storage industry expert and noted blogger Martin Glassborow, better known in the industry as Storagebod.

The book includes seven chapters:

Chapter 1 Rethinking enterprise storage
Chapter 2 Leapfrogging backup with cloud snapshots
Chapter 3 Accelerating and broadening disaster recovery protection
Chapter 4 Taming the capacity monster
Chapter 5 Archiving data with the hybrid cloud
Chapter 6 Putting all the pieces together
Chapter 7 Imagining the possibilities with hybrid cloud storage

You can download the 
1. PDF version of this title here

Regards
Satishbabu Gunukula



Tuesday, May 12, 2015

Comprehensive list of O365 Tools and Diagnostics

This wiki contains information about tools that can be used to diagnose and troubleshoot issues with Office 365 services. This wiki also contains links to resources such as articles, videos, and training that show how the tools are used to diagnose and resolve Office 365 scenarios. We also recommend using the troubleshooting section of the Office 365 Community for additional troubleshooting content.


Item
URL
Description
Office 365 technical Blog and RSS Feed



Site to sign up for RSS feed to understand the latest changes to O365.  Important for Admins in the O365 tenant.
O365 Technology blog

Site to sign up for RSS feed to understand the latest changes to O365.
Important for Admins in the O365 tenant.
O365 Portal
Go into your O365 Portal
Sign up for RSS feed from the Service Health dashboard
Software Requirements for O365 site

Updates on the software requirements (browser, client and OS) for O365.
Service Descriptions site

Service Descriptions for O365.  Important for Admins in the O365 tenant.
Evergreen Readiness deck
SDE Deliverable from Cloud Vantage contract.  (PowerPoint deck)
Quarterly deck created by the SDE by working directly with the Microsoft PG to provide a roadmap of the upcoming changes to O365.  Only available to Cloud Vantage customers.
Office 365 URL and IPs



Site to sign up for a RSS feed to receive a updated list of URL and IPs that are used to connect to O365


Regards
Satishbabu Gunukula

Download:Office 2016 for Mac Preview Guide

We have a downloadable guide for reviewers of the Office 2016 for Mac Preview.

The new and modern Microsoft Office 2016 for Mac Preview is the Office you know and love, thoughtfully designed for the Mac. It is powered by the cloud via Office 365, so you can access documents anytime, anywhere on any device. With the newly designed Ribbon, tools and formatting are organized just like in all the Office apps across platforms and devices. The modernized user experience—optimized for the Mac with full support for retina displays—allows you to enjoy working on your Mac Through seamless integration with Office 365, OneDrive, OneDrive for Business, and SharePoint, you can access your files across devices by signing in with your Office identity (your Microsoft account or your work or school email).

The Office 2016 for Mac Preview has many exciting features, including:

· Newly designed Ribbon organizes tools and formatting in a manner similar to Office for Windows.

· Modernized user experience is optimized for the Mac, with full support for retina displays.

· Seamless integration with Office 365, OneDrive, OneDrive for Business, and SharePoint means you can access your files across devices by signing in with your Office identity.

· Format object task pane delivers greater object manipulation capabilities.

Download the .PDF (26 pages, 8.7MB) here:

DOWNLOAD: Office 2016 for Mac Preview Guide http://1drv.ms/1PbWzgg

Regards,
Satishbabu Gunukula

Thursday, May 7, 2015

Download:Free eBook, “Microsoft Azure Essentials: Azure Machine Learning”



This fee e-Book "FREE e-Book: Microsoft Azure Essentials: Azure Machine Learning " by by Jeff Barnes . This is the third ebook in Microsoft Press’s free Microsoft Azure Essentials series.
This book covers following Topics
Introduction
Chapter 1 Introduction to the science of data
Chapter 2 Getting started with Azure Machine Learning
Chapter 3 Using Azure ML Studio
Chapter 4 Creating Azure Machine Learning client and server applications
Chapter 5 Regression analytics
Chapter 6 Cluster analytics
Chapter 7 The Azure ML Matchbox recommender
Chapter 8 Retraining Azure ML models

Download the e-book using below Link
http://aka.ms/AzureML_pdf

Regards
Satishbabu Gunukula
http://www.sqlserver-expert.com

Backup failed with the following error: "xp_create_subdir() returned error 161


Users might receive below error when executing backup.

Executed as user: NT Service\SQLAgent$SQLTEST. Microsoft (R) SQL Server Execute Package Utility Version 12.0.2000.8 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 1:50:45 PM Progress: 2015-05-07 13:50:46.22 Source: {2FEF4D33-99C5-4CC6-9ECC-85EDDACC8E9E} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: 2015-05-07 13:50:46.41 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "EXECUTE master.dbo.xp_create_subdir N'\\SQLbackup\db..." failed with the following error: "xp_create_subdir() returned error 161, 'The specified path is invalid.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error

Error: 2015-05-07 13:50:46.60 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "BACKUP DATABASE [master] TO DISK = N'\\ SQLbackup \db..." failed with the following error: "Cannot open backup device '\\SQLbackup\SQLTEST\\Full_Backup\master\master_backup_2015_05_07_135046_3323057.bak'. Operating system error 5(Access is denied.). BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


If you see highlighted messages there are two reasons error

1. failed with the following error: "xp_create_subdir() returned error 161

First check SQL server or SQL Server Agent service running using the local or service account and the account should have enough privileges on the backup folder

2. Cannot open backup device. Operating system error 5(Access is denied.)

Check whether the account have read/write privileges on the backup folder.

In my case I see that SQL Server Agent running using a local account and that account don’t have permission on the backup folder. I have changed the SQL Server Agent “Log on As” account to service account which has permission and restarted the service.

Regards
Satishbabu Gunukula
http://www.sqlserver-expert.com