Wednesday, February 17, 2016

VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’.

With one of the application I have seen below error when working with SQL Server

VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’ ( Microsoft SQL Server , Error: 300)

The issue is user don’t have VIEW SERVER STATE permission. Note that this will allow an auditing process to view all data or all database states on the instance of SQL Server.

The below command should solve the issue, but before you grant make sure you understand the implications of granting the below permission.

USE MASTER
GO
GRANT VIEW SERVER STATE TO <username>


Regards,
Satishbabu Gunukula



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