I see this on almost all SQL Server instances I work on – existing user in a database with dbo permissions yet they could not access anything in the database. This is because SQL Server doesn’t really look at the user or login name but rather the SID values (I’ve talked about this in here). […]
I was supposed to blog about this sometime last year when we we’re called in to be standby engineers for a large government organization in Singapore as they were trying to change their hardware for one of their SQL Server clusters (I had another similar incident today which reminded me to blog about it). When […]
I was configuring one of our customer’s Windows Server 2008 to capture PerfMon counters for our analysis when I accidentally ended up storing the log file in binary format. Now, I didn’t like the idea of reading the binary file as I will be importing it in a SQL Server database for Reporting Services to […]
I’ve spent a couple of hours trying to troubleshoot a clustered SQL Server 2008 installation. All I know is that it throws this error message after the installation process and does not give me any clue at all The cluster resource ‘SQL Server (MSSQLSERVER)’ could not be brought online. Error: The group or resource is […]
Here’s one idea I got from this blog post. It came from KB 920730: How to disable and re-enable hibernation on a computer that is running Windows Vista. It certainly was not Windows Vista, but who would want to let their servers hibernate? Besides, Windows Server 2008 is listed on the Applies To section of […]