The Reporting Server Instance could not be found

The error The Reporting Server Instance could not be found is appearing when I attempt to connect to a newly installed SQL Server Reporting Services Instance . The service is appearing as started , but then when I attempt to connect The Reporting Server Instance could not be found How can I troubleshoot this error message? Answer: The error message The Reporting Server Instance could not be found occurs mainly when the SSRS configuration has not completed. Or the configuration has completed - but for some reason some errors have occurred You will need to use the Reporting Services Configuration... Read more →

How can I tell if hyperthreading is on Windows 2012

Question: One of the prerequisites of an application install is to have SQL Server 2012 Enterprise Installed .There are also some OS based prerequisites. One of these is to have hyperthreading turned off. I’ve spoken to the server engineers who’ve confirmed hyperthreading is turned off from the BIOS. How can I check from the OS if hyperthreading is turned off? When I check in the SQL Server Error Logs there is an entry at SQL Server start up which although gives some information doesn't fully answer my question : SQL Server detected 1 sockets with 14 cores per socket and... Read more →

How to turn AUTO_SHRINK off

I run a daily health check across SQL Servers . One of the checks made is whether the SQL Server configurable AUTO_SHRINK is turned ON. Unless there is a clear reason why AUTO_SHRINK needs to be turned ON then keeping AUTO_SHRINK OFF can assist in keeping contention lower. As part of a SQL Server set up I use a SQL Server database files configuration checklist. One of the items on the list is AUTO_SHRINK OFF Configuring AUTO_SHRINK to OFF – means the files are not automatically shrunk – when checks occur for unused space. I execute an Shrink when a... Read more →

Set owner failed for database an exception occurred in smo - Msg 15110, Level 16, State 1, Line 1

Question : I’m trying to change the database owner on a user database to sa, but I am receiving an error message: ALTER AUTHORIZATION ON DATABASE::myDatabase TO [sa] Msg 15110, Level 16, State 1, Line 1 The proposed new database owner is already a user or aliased in the database How can I fix this error? Answer: It is possible that the login used in the RESTORE of the database is not equal to the owner which was previously the owner of the database. The database owner is defined as the sys.server_principals login owning the database. The first thing to... Read more →

BT and Oracle cloud link up

BT are marketing a “cloud of clouds” idea. They already offer access to Office 365 , Amazon Web Services, and a bunch of other Services including Cisco and Salesfore. They announced a deal with Oracle Cloud. With Oracle Cloud , a subscriber can access Oracle technology. From a DBA perspective there are some aspects to note: There are a number of major vendors in the Cloud – Microsoft, IBM, Amazon. From a pricing and licensing perspective , how do they compare? Organisations are reviewing database platforms – based on licensing costs. Management of database servers in the cloud? Cloud –... Read more →