SSRS Report Manager Configuration Wizard failed when Applying Connection Rights

The SQL Server 2012 SSRS Report Manager Configuration Wizard failed when Changing Database on step “Applying Connection Rights” Error Message: Cannot alter the role ‘RSExecRole’, because it does not exist or you do not have permission. Solution: The login used to connect to the database server did not have sufficient privileges on MSDB and Master….

0

Windows Server 2012 / 2012 R2 – Logon restricted to members of Local Administrators group

Within one of the SQL Server environments that I support, we recently experienced a Windows Server 2012 operating system crash followed by a situation where the SQL Server 2012 service was unable to start with the following error message: Error message 7038 – The MSSQLSERVER service was unable to log on as NTSERVICE\MSSQLSERVER with the currently configured password…

0

Transparent Data Encryption (TDE) stuck in State 2 – Encryption in Progress

Another day, another interesting troubleshooting scenario with SQL Server 2012.  In this case, a customer was attempting to enable Transparent Data Encryption (TDE) on a couple SQL Server 2012 databases.  The process went smoothly until they encountered an issue with a single database.  The problem database in this case was about 50 GB in size,…

5

SQL Server 2014 Service Pack 1 Unattended Setup Error – "The specified value ‘Upgrade’ is invalid"

SQL Server 2014 Service Pack 1 Unattended Setup Error – “The specified value ‘Upgrade’ is invalid”   I was recently sent a question regarding a failed unattended install of SQL Server 2014 Service Pack 1.  The customer had spent some time searching online for the error message, but found surprisingly little detailed information for unattended…

4

TechNet Guru Awards – December 2013

The TechNet Guru Awards celebrate the technical articles on TechNet, contributed from valued wiki authors like YOU! Each month, the contributions are scored by a panel of judges (5 per category, 2-3 in each are MS experts), and the winners of each category are showered with love and attention from all corners of TechNet.   The December results are…

1

TechNet Guru Awards – November 2013

The TechNet Guru Awards celebrate the technical articles on TechNet, contributed from valued wiki authors like YOU! Each month, the contributions are scored by a panel of judges (5 per category, 2-3 in each are MS experts), and the winners of each category are showered with love and attention from all corners of TechNet.   The November results are…

0

TechNet Guru Awards – October 2013

I’m a bit behind on posting the TechNet Guru award winners for the past few months, so I’m catching up today.  These awards represent many hours of contribution from each of the contributors, not just the winners, and the community benefits greatly from these articles.  Thanks again to all who participate each month and I…

0

EOMONTH() Equivalent in SQL Server 2008 R2 and below

  SQL Server 2012 introduced several new system functions pertaining to the date and time data types.  In my opinion, I’ve found the EOMONTH(), “end of month”, function to be one of the most useful.  The EOMONTH() function returns the final day of the calendar month, thus greatly simplifying a common calculation, taking into account…

10

TechNet Guru Competition – Show off your SQL Server skills!

  Over the past few months, I’ve had the opportunity to help judge a great new online competition on TechNet Wiki spanning many Microsoft technologies and including several SQL Server categories.  The contest requirements are very basic and contribute to the overall SQL Server community by increasing the amount of user contributed content on TechNet…

1

SQL Server 2012 Discovery Report – Determining what SQL Server Components are Installed

How can I determine which SQL Server features and versions are on my computer?   This continues to be one of the more frequently asked questions on the MSDN Forums and is important for many reasons, including patching, security, compatibility with other applications, network compliance, and even troubleshooting failed installs.  Over the years, I’ve pointed many people…

4