Tag Info

New answers tagged

0

Since 2008, SQL Server answers on dynamic ports by default. You can set static ports in SQL Server Configuration Manager. To turn Dynamic Ports off, erase the 0 that appears on the right side, above the port number (in this case, 1433). Once you have static ports, you'll need to enable access to 1433 TCP and 1434 UDP.


1

Which version of SCOM are you using? In my 2007 install, its a view not a table. Use adtServer.dvAll5 which contains only the first 5 event params, or adtServer.dvAll which has ALL params, but it slower.



Top 50 recent answers are included