A client recently upgraded a server, and then started receiving this error when they tried to access the SSRS Reports page at http://MyServerName\Reports: The service is not available. The report server isn’t configured properly. Contact your system administrator to resolve the issue. System administrators: The report server Web Portal URLs and Web Service URLs don’t […]
Category: Admin
Management Studio Shortcut – Change Connection
One of the most common things I do within SSMS is to change connection for the current query editor window, from one SQL Server instance to another: I’m a huge fan of keyboard shortcuts (see exhibit 1, exhibit 2, and exhibit 3). So let’s create a shortcut for “Change Connection” today. The basic method for creating keyboard shortcuts is: […]
SQL Saturday Colorado Springs, and a full-day class with the MidnightDBAs!
Edit: Now with discount code! We’ll be speaking at SQL Saturday Colorado Springs on Saturday March 24. The day before that, we bring you a full day class about the most important job a DBA has: managing and maintaining the SQL Server enterprise. Yes, this applies to you even if you have a little enterprise. Sign up now! Use […]