Thursday, June 21, 2012

Install SQL Server Reporting Services and the Reporting Services Role on SCCM 2012

Mostly posting for my own notes. This post lists step-by-step instructions on how to install MS SQL Server Reporting Services and adding the Reporting Services role on SCCM 2012
Keep in mind - Some settings that I list below could be different from your network or situation and may not necessarily apply to best practices.

Install SQL Server Reporting Services and the Reporting Services Role on SCCM

  1. Run SQL Setup from iso
  2. Add Features to an existing instance of SQL Server 2008 R2
    1. Choose MSSQLSERVER
  3. Feature Selection
    1. [x] Reporting Services
    2. For this feature, I could not specify the D: drive to install, this option was greyed out
  4. Service Accounts
    1. Choose SYSTEM (add other accounts later)
  5. (o) Install, but do not configure the report server (other options were greyed out)
  6. Next til finished

Login as payneb\Administrator and Open “Reporting Services Configuration Manager” and connect to database

  1. Verify service has started
    1. Check SQL Server Instance Product Version, should read “10.50.2500.0”
    2. If reads “10.50.1600”, then you need to reinstall SQL 2008 R2 SP1, otherwise the Reporting Services role in SCCM will NOT WORK!!!!
      2. An explanation is provided here:
  2. Database tab
    1. Change database
    2. Create a new report server database
    3. Database Name: ReportServer  (go w/ defaults)
      1. (o) Native Mode
    4. Finish
  3. Still logged in as payneb\Administrator, go to http://systemcenter/Reports (Use IE)
    1. Click on Site Settings
    2. Security tab > Add New Role Assignment as needed
      1. Add sccm.reporting user and other desired users
  4. Open SQL Management Studio and grant sccm.reporting user rights (and whoever else) to the new ReportServer databases

Add the Reporting Services role in SCCM. At this point, I logged in as myself on the SCCM server

  1. Administration tab > Servers and Site System Roles > Add Site System Role
  2. [x] Reporting Services Point
  3. Verify all information is correct, then click on Verify button
  4. UN: sccm.reporting, enter password
  5. Next, Finish
  6. [OPTIONAL] You can verify that the role installs successfully by using CMTrace and open the SRSRP.LOG and/or SRSRPSetup.log file

Monitoring tab > Reports

  1. Wait a few minutes and SCCM will populate this area w/ about 423 items
  2. At this point you can log back into http://systemcenter/Reports provided you gave yourself permission from the steps above. When using Internet Explorer, choose Run As Administrator. or use a different browser. You should also see reports listed here as well.

From here on, you can view reports, create subscriptions, etc.

Tuesday, June 19, 2012

Two Printers to One Print Server Port

A while back, the idea of duplex printing for our computer labs was thrown around. Once approved we had to come up with an easy way to implement this while still giving the student an option to print simplex. To make things easier, we have a print manager software called Papercut. There is a duplex feature to turn on duplex printing for the specified printer, however, from there on - duplex is strictly enforced, even if a student turned off duplex in their favorite program. This presented a challenge as most of our labs only contain one physical printer. So, to get around that challenge, we setup a "new printer" using an existing port on the print server. Essentially this is like having two virtual printers to one physical printer.

So as you can see, I have printer 1C05-1 with Duplex enforced (on Papercut side). To add a "Simplex" printer, using the same port click on "Add a printer." 

Next, click on "Add a local printer"

Choose the same port, in this case "1C05P1" which is the dns name in which printer 1C05-1 is assigned

Once the printer is added, you now have two virtual printers, using the same port. So essentially, a student can now choose the "1C05-1-Simplex" printer to print 1-sided print jobs, while leaving 1C05-1 as the default, duplex virtual printer. Keep in mind, this is still one - physical printer.

On the server, if you go to Print Server Properties, you can see two (virtual) printers are assigned to the one port.