Support
- Advanced Backup
- Client Side
- Cloud Enterprise
- ColdFusion
- Control Panel
- cPanel
- Customer Portal
- DNS Information
- Dedicated Servers
- DirectAdmin
- Domain Name
- dotDefender
- Dreamweaver
- FileCatalyst
- Front Page
- FTP
- General Information
- Hosted Exchange & SharePoint
- IIS6
- IIS7
- Juniper Netscreen Firewalls
- Linux
- List Server
- MIVA Merchant
- MySQL
- Patching / Server Updates
- phpMyAdmin
- Plesk
- Policies and Procedures
- Premium Spam Filtering
- Programming
- Ruby on Rails
- Search Engine Submission
- SharePoint 3
- SharePoint 2010
- SiteDesigner
- SmarterMail 3
- SmarterMail 4
- SmarterMail 5
- SmarterMail 6
- SmarterMail 7
- SmarterStats
- SmarterTrack
- SQL Server
- Accesstosql
- Addsqldatabase
- Addsqlpremium
- Aspenterprisemanager
- Backup2000
- Backup2005
- Enterprise Manager
- Expressdb
- Logfull
- Long Load
- Managementstudio
- Tcp Ip
- Userpermissions
- Whatsnew
- Sql
- Connect to a remote SQL Express server using SQL Management Studio Express
- Set up SQL 2005 Reporting Services
- Identifying SQL Injection
- SQL Server Tuning
- Back up all MS SQL databases at once
- Install SQL Reporting Services
- Restore a SQL 2005 database
- What is SQL Injection
- Server Principle Error when using SQL Management Studio 2008 to connect to your database
- Migrate Databases from SQL 2005 to SQL 2008 between Virtual or Dedicated Servers
- Configure Query Timeout Period in SQL Management Studio
- Automated SQL2005 Backups
- Automated SQL2008 Backups
- Large MSSQL Transaction Log
- How To Validate A SQL 2008 Cluster
- Microsoft SQL Cluster 2008 Private Heartbeat Connection
- Determining when SQL Server 2008 was Last Restarted
- Secure Socket Layer (SSL)
- Uploading Your Website
- Video Tutorials
- Windows Server 2003
- Windows Server 2008
- Web Design
- WordPress
- Advanced Monitoring
- MediaWiki
- Enkompass
- Microsoft Outlook 2010
- Android
- Outlook Web Access
- Critical Availability Service
- NAS Data Transfer
- Customer Portal Demos
- Joomla
- Moodle
- Cloud Dedicated
- Gallery CMS
- phpBB
- Standard Monitoring
- Righteous Restore
- NAS (Network Attached Storage)
- Networking
- SmarterMail 8
- PCI Security Scan
- LinkTiger
- Windows Cloud VPS
- Linux Cloud VPS
- Linux VPS
- Windows VPS
- Hyper V
- ENSIM
- Alert Logic
- Webmin
- e107
- Vbulletin
- VPN
- Visual Vault
- Mozilla Thunderbird
- PyroCMS
- Active Directory
- Vmware Related
- Drupal
Install SQL Reporting Services
Note: SSRS is not currently available on SQL Express edition. The server needs to have SQL Workgroup or higher.
Note: If you need to do this on a dedicated server, it must be done via console by Hosting.com. Attempting to install it via Remote Desktop will fail and the error message will inform you that you cannot install SQL Reporting Services via RDP. Additionally, remote desktop-ing in as /console won't work either because you still have a terminal session open.
- Connect to the server via Remote Desktop
-
Click Start > Control Panel > Add/Remove Programs
- Locate "Microsoft SQL Server 2005" and click Change
- Click the blue link that says "To install a new component, click here"
-
Browse to the SQL Server version's setup.exe, click OK
The installation will run through a few checks after you accept the agreement. Keep clicking next until you get to the Feature Selection page (dont worry if installed components say they aren't installed, that's normal)
-
Select Reporting Services, and choose the first option, "Will be installed on local hard drive"
-
Click next and complete the installation
You can test that it is working by connecting using the SSRS Config Tool from the SQL Server folder in the Start menu.
Configuring SSRS
For the most part this is the easy step. Just run the Report Server Config tool and fill in the blanks. This is fairly well documented at http://msdn.microsoft.com/en-us/library/ms159624.aspx
Common Errors and other problems you may encounter when installing
- SSRS 64-bit requires the 64-bit Asp.Net framework to be installed and configured. 32bit .Net will fail the SSRS install
- The default website (or another site with an identifier of "1") should be in IIS to complete the installation
- If nothing seems to work in RS after installing, youre probably missing a service pack. SSRS needs to be patched the same as the database engine it's connecting to. You can run SELECT @@version in SQL to see which service packs are applied - they will also need to be installed on report server.
- SP1 will not run on Windows Server 2008. WMI Errors when opening the Configuration manager are common if this is the case. http://msdn.microsoft.com/en-us/library/ms156468.aspx
Common Errors and other problems you may encounter when using the RS Config tool
- COMExceptions usually suggest a permissions problem. Setting up an execution account in RS config will usually get around these (just an NT user with admin privs)
- The RS virtual directories seem work best with anon access disabled, and integrated windows auth enabled
- The SQL user account for RS config should be set up as 'sysadmin' to avoid security errors