Dec 21, 2010

Great New Reporting Documentation for SCOM Published

http://technet.microsoft.com/en-us/library/gg508710.aspx
Covers the following:
  • Custom Reporting Overview
  • Setting Up the Environment
  • Creating Custom Reports
  • Data Warehouse Schema
  • Inside a Generic Report
  • Custom Report Queries

Test a remote SQL Connection very quickly and easy

I ran across a very useful MSDN blog post today and thought I’d share it. It explained a very quick and easy way to test a SQL connection and verify if you can logon with a specified account.
Here’s how:


Go to any folder on the system from where you want to test the connection, and create a new file














 Then change the extension to .UDL






 When you open that up you can easily see any SQL server within your reach







 



And then easily test the connection for a specified account (is the case the Windows Integrated) by just opening the database list, or pressing Test Connection




I think this is a very usefull way to quickly check a connection without having to configure or install anything.