tag:blogger.com,1999:blog-126492372024-03-08T12:33:46.604-06:00Kevin Garner's Technology BlogKevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.comBlogger54125tag:blogger.com,1999:blog-12649237.post-58801326727732109972012-05-02T08:50:00.001-05:002012-05-02T09:18:22.103-05:00Using Papercut to test SCOM subscriptions<p>Have you ever needed to test a subscription in SCOM using the email channel, but don't access to a SMTP server and/or don't want the emails being sent out to the subscriber? I’ve run into this when testing out subscription criteria to ensure I've made the right selections. Since my SCOM development environment runs on Hyper-V and doesn't have access to the Internet my only option is to install an SMTP server, right? Not necessarily, a much easier solution is Papercut. <br><br><a href="http://papercut.codeplex.com/">Papercut</a> is a free simplified SMTP server. Here’s how to use it. </p> <p>1. First, download the Papercut zip file from Codeplex. <br>2. Then, unzip the download to a location on your SCOM server. Quick tip, this will be your Root Management Server in SCOM 2007. <br>3. Inside the unzipped folder you'll see 3 files. Launch Papercut.exe and click options.<a href="http://lh3.ggpht.com/-7w6Kh1_uXSA/T6E7nuhLKEI/AAAAAAAAE2U/nFNFEdPWcZE/s1600-h/clip_image002%25255B3%25255D.jpg"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="clip_image002" border="0" alt="clip_image002" src="http://lh3.ggpht.com/-5HK2tIZxqAE/T6E7oFr5VWI/AAAAAAAAE2c/xeuvzET4s-M/clip_image002_thumb.jpg?imgmax=800" width="244" height="132"></a> <br>4. In the options dialog, you can select the IP and Port that you want the SMTP server to listen on. I'll leave it on "Any", so that it will listen for SMTP traffic on the designated port for any of the IP's in the list. Check "Minimize automatically" if you want the application to always minimize when launched.<br> <a href="http://lh6.ggpht.com/-GNK4G5IRBkw/T6FCK1h5wPI/AAAAAAAAE4I/_CawiHjRMFA/s1600-h/image%25255B5%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/-bP-7Z9Ca5is/T6FCLWAZI2I/AAAAAAAAE4Q/uNBWoY5wXS4/image_thumb%25255B1%25255D.png?imgmax=800" width="132" height="52"></a><br>5. In SCOM you need to setup an SMTP channel. Launch the SCOM console and navigate to the Administration pane, then Notification -> Channels. Right-click channels, then click New--> E-Mail (SMTP). <br>6. Enter a channel name and description.<br><a href="http://lh5.ggpht.com/-V3PIztW6O-s/T6E7pC8PWAI/AAAAAAAAE20/izN7tdVhwBw/s1600-h/clip_image006%25255B3%25255D.jpg"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="clip_image006" border="0" alt="clip_image006" src="http://lh4.ggpht.com/-6Nu-UYmatlU/T6E7p30zq1I/AAAAAAAAE28/RIb3L8U0BJw/clip_image006_thumb.jpg?imgmax=800" width="244" height="206"></a> <br>7. Click Add and enter "localhost". Set the port number to whatever port you chose when you setup Papercut and click OK.<br><a href="http://lh4.ggpht.com/-HvjcZxuTh5U/T6E7qEUK8yI/AAAAAAAAE3E/95w1rxcbkUA/s1600-h/clip_image008%25255B3%25255D.jpg"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="clip_image008" border="0" alt="clip_image008" src="http://lh3.ggpht.com/-acJZB2Qo7OE/T6E7qjCXA6I/AAAAAAAAE3M/q7u5EbY3Jhk/clip_image008_thumb.jpg?imgmax=800" width="244" height="130"></a> <br>8. Enter a return address and click Next.<br><a href="http://lh5.ggpht.com/-ewyE3CEgCpU/T6E7q3pIq9I/AAAAAAAAE3U/Ck96_4GIjfQ/s1600-h/clip_image010%25255B3%25255D.jpg"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="clip_image010" border="0" alt="clip_image010" src="http://lh3.ggpht.com/-Qpzu2z0TFIo/T6E7rHql9JI/AAAAAAAAE3c/SIRXQ3KyBsA/clip_image010_thumb.jpg?imgmax=800" width="244" height="207"></a> <br>9. Setup your format as you like and click Finish. <br>10. All that's left is setting up a subscription that uses the new channel you just created. After that you can generate an alert in SCOM that matches your subscription criteria and it will appear in the Papercut window. Here's an example.<a href="http://lh6.ggpht.com/-V7Y-cSP8C2o/T6E7r8cd6_I/AAAAAAAAE3k/zWXKCmws6OU/s1600-h/clip_image012%25255B3%25255D.jpg"><br><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="clip_image012" border="0" alt="clip_image012" src="http://lh6.ggpht.com/-YMsX_Ay5pjM/T6E7soLOu3I/AAAAAAAAE3s/OEkAp6nRN28/clip_image012_thumb.jpg?imgmax=800" width="244" height="132"></a> <br><br>Another cool features is that Papercut retains all of the emails as .eml files in the folder that Papercut.exe runs from. So there you go, a very simple way to test SCOM subscriptions using the SMTP channel without all the work of setting up your own SMTP server.</p> Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-38312073693469122892011-04-12T08:45:00.001-05:002011-04-12T08:51:43.777-05:00Discovery and the Dell Windows Server MP for SCOM<p>Yesterday, I imported the Dell Server MP for SCOM (v4.1). My best practice is to first test the MP in a development environment. Once I have some run time on the MP and feel comfortable importing the MP into production, I create an override to disable the MP’s object discovery and I store the override in an overrides MP specific to the parent MP (ex. “Dell Windows Server (Scalable Edition)_OVERRIDES”). This ensures that when I import the Dell MP and the overrides MP into our production environment discovery will not automatically be run on all of our production Windows servers. This method allows me to more casually deploy the MP into our production environment, by creating additional overrides targets at a group of Windows servers or specific Windows servers. Much safer than the spray and pray approach. </p> <p>If you want to do the same, you need to create an override to disable the object discovery named “Dell Server Discovery”. This object discovery is targeted at Windows Computer. Make sure you import the Dell MP and the MP containing your overrides into your production environment at the same time. Ifyou don’t, you may not get the override created quickly enough to prevent the discovery from running on all of your Windows servers.</p> <p>Example:<br><a href="http://lh5.ggpht.com/_jv1NLkRP5V8/TaRXee67ClI/AAAAAAAAEpY/4PE5wAq7_uw/s1600-h/image%5B3%5D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/_jv1NLkRP5V8/TaRXegpIV0I/AAAAAAAAEpc/vGPb3y4PWMA/image_thumb%5B1%5D.png?imgmax=800" width="556" height="206"></a></p> <p>Once I am confident the Dell MP is not generating numerous false positives, script errors, etc., I will remove the override above to enable the discovery to run against all of our Windows servers.</p> <p>I’ll follow-up at a later date with my impressions of the Dell MP (v4.1).</p> Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-44905785942919651782010-08-26T15:38:00.002-05:002010-08-26T15:50:17.735-05:00SCCM Advertised Programs Don’t Appear on Windows 2008 Server RDP Sessions<p>Earlier today, I came across a strange issue that arises when advertising a program to Windows Server 2008 using SCCM.  The program advertisement appeared correctly on my Windows 2003 servers remote desktop console/admin session, but the same could not said when logging on to my Windows 2008 servers.  Instead, all I saw was as a message stating “No programs are available to run from a Terminal Services session”. <br /><a href="http://lh3.ggpht.com/_jv1NLkRP5V8/THbQ2s-KrTI/AAAAAAAAEns/ualvqxXo14I/s1600-h/image%5B8%5D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/_jv1NLkRP5V8/THbQ2z3C97I/AAAAAAAAEnw/r1rZA3qRHnc/image_thumb%5B4%5D.png?imgmax=800" width="482" height="331" /></a> <br /> <br />I logged off, launched the remote desktop admin session with “mstsc.exe /admin”, but still the problem existed.  Finally, after a small amount of troubleshooting I discovered why this issue was occurring.  In Windows 2008, unlike Windows 2003, there is no longer a session id 0.  Instead, for SCCM at least, the first user that logs on will be the only user able to see what is available via Run Advertised Programs or the “Install a program from the network” section in Add/Remove programs.  On both servers that I was logging in to, there were already Remote Desktop sessions as seen below: <br /><a href="http://lh4.ggpht.com/_jv1NLkRP5V8/THbQ3QHsaiI/AAAAAAAAEn0/u-6BylPg5aQ/s1600-h/image%5B9%5D%5B3%5D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image[9]" border="0" alt="image[9]" src="http://lh3.ggpht.com/_jv1NLkRP5V8/THbQ3hcCGpI/AAAAAAAAEn4/TS9Aqg_CLfg/image%5B9%5D_thumb%5B1%5D.png?imgmax=800" width="564" height="151" /></a></p> <p>In the screencap above, I’m the 2nd user with ID 3.  Notice there is no ID 0 as you would see when logging on to a Windows 2003 Server with “mstsc.exe /admin”.  As soon as I had the user with Session ID 1 log off, here’s what I saw.</p> <p><a href="http://lh4.ggpht.com/_jv1NLkRP5V8/THbQ30aSxgI/AAAAAAAAEn8/uygKTUfATR4/s1600-h/image%5B21%5D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/_jv1NLkRP5V8/THbQ4eSrSwI/AAAAAAAAEoA/6JyE04uF06g/image_thumb%5B11%5D.png?imgmax=800" width="562" height="525" /></a></p> <p>Notice that I still have the same session ID, but now the advertised program that I expected appears.</p> <p>For a better understanding of why Session 0 is no longer needed in Windows 2008 take a look at <a href="http://support.microsoft.com/kb/947723">KB947723</a>.</p> Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com7tag:blogger.com,1999:blog-12649237.post-13972934441096902372010-08-19T13:15:00.001-05:002010-08-19T13:30:55.720-05:00Windows Live Essentials 2011 beta refresh<p>Read more about it <a href="http://windowsteamblog.com/windows_live/b/windowslive/archive/2010/08/17/windows-live-essentials-2011-beta-refresh.aspx">here</a>.  Here’s to hoping they fixed the account lockout issue present with Live Sync.</p> <p>UPDATE:  I haven’t confirmed this myself, but comments on the Windows Team Blog indicate that the account lock-out issue still exists for Live Sync users on domain PCs.  Guess, I’ll refrain from installing Sync for now.  </p> Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-87276673164508932002010-08-18T16:50:00.002-05:002010-08-18T16:57:10.468-05:00Automating SQL 2005/2008 Express Backup in 5 Easy Steps<p>I was recently asked to backup all system and user databases on a SQL 2005 Express installation. Unfortunately, SQL 2005 Express native backup capabilities are not on par with SQL 2005 Standard/Enterprise. SQL Express includes functionality for backing up a single DB using SQL Server Management Studio Express, but this is only ideal for backing up a single database and it cannot be scheduled. So here are the steps for automating this process.  If you’d like more detailed information, check out this much more thorough article at <a href="http://www.sqldbatips.com/showarticle.asp?ID=27">http://www.sqldbatips.com/showarticle.asp?ID=27</a>.</p> <p><strong>Step 1:</strong></p> <p>Save the lines <a href="http://www.sqldbatips.com/displaycode.asp?ID=26">here</a> in a file called <strong>expressmaint.sql</strong> to <strong>C:\SQLScripts</strong>.</p> <p><strong>Step 2:</strong></p> <p>Open an administrator command prompt to “c:\SQLScripts\” and run “sqlcmd -S .\SQLExpress -i c:\sqlscripts\expressmaint.sql”. <br /> <br /><a href="http://lh6.ggpht.com/_jv1NLkRP5V8/TGxVpEipYNI/AAAAAAAAElM/4QtDNk89X5k/s1600-h/image%5B3%5D.png"><img style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/_jv1NLkRP5V8/TGxVpeKE8MI/AAAAAAAAElQ/9H9f8b8qJRg/image_thumb%5B1%5D.png?imgmax=800" width="615" height="113" /></a> </p> <p><strong>Step 3:</strong></p> <p>Save the lines below in a file called <strong>sqlbackup.sql</strong> and save it in <strong>C:\SQLScripts</strong>.  Be sure to change the variable contents for @reportfldr to whatever is appropriate for your environment.</p> <blockquote> <p><font face="Courier">exec expressmaint <br />   @database      = '$(DB)', <br />   @optype        = 'DB', <br />   @backupfldr    = '$(BACKUPFOLDER)', <br />   @reportfldr    = 'c:\SQLScripts', <br />   @verify        = 1, <br />   @dbretainunit  = '$(DBRETAINUNIT)', <br />   @dbretainval   = '$(DBRETAINVAL)', <br />   @rptretainunit = 'copies', <br />   @rptretainval  = 2, <br />   @report        = 1</font></p> </blockquote> <p><strong>Step 4:</strong></p> <p>Save the lines below in a file called <strong>sqlbackup.cmd</strong> and save it in <strong>C:\SQLScripts</strong>.  Be sure to change “.\SQLExpress” to the name of your SQL Express server and instance” and don’t forget to change the BACKUPFOLDER location to whatever is relevant in your environment.  NOTE: Each “sqlcmd” begins a new line.</p> <p><font size="2" face="Courier">sqlcmd -S .\SQLExpress -i"c:\SQLScripts\sqlbackup.sql" -v DB="ALL_USER" -v BACKUPFOLDER="e:\SQLBackups" -v DBRETAINUNIT="days" -v DBRETAINVAL="1" <br /> <br />sqlcmd -S .\SQLExpress -i"c:\SQLScripts\sqlbackup.sql" -v DB="ALL_SYSTEM" -v BACKUPFOLDER="e:\SQLBackups" -v DBRETAINUNIT="days" -v DBRETAINVAL="1"</font></p> <p><font face="Courier"><font face="Arial">If you were to run the 2nd sqlcmd above your output would be similar to this:</font> <br /> <br /><a href="http://lh5.ggpht.com/_jv1NLkRP5V8/TGxVpvDmHAI/AAAAAAAAElU/COKyUY26C8o/s1600-h/image%5B9%5D.png"><img style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/_jv1NLkRP5V8/TGxVqA9rOeI/AAAAAAAAElY/4jgfvLQhTYk/image_thumb%5B5%5D.png?imgmax=800" width="606" height="218" /></a> </font></p> <p><strong>Step 5:</strong></p> <p>Create a scheduled task to run “C:\SQLScripts\sqlbackup.cmd” at your desired backup frequency.</p>Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-22794281358289032892010-08-06T15:43:00.001-05:002010-08-06T15:43:30.171-05:00Windows System State Analyzer<p>“The basic functionality of the System State Analyzer tool is to allow you to compare two snapshots taken at different points in time. This allows you to compare the state of a machine both before and after an application install for instance.”  Read more <a href="http://blogs.technet.com/b/askperf/archive/2010/01/12/an-introduction-to-the-windows-system-state-analyzer.aspx">here.</a></p> Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-69981343502707622972010-08-06T11:04:00.001-05:002010-08-06T11:04:56.567-05:00Killing a hung service<p>Today I came across a system that was failing to heartbeat .  Opening services.msc on the box revealed that the System Center Management service status was “Starting”.   Stopping the service from services.msc didn’t work, so I had to resort to a more forceful option.</p> <p>Here’s how I did it.</p> <ol> <li>Open a command prompt </li> <li>Query for the state and PID by entering “sc queryex healthservice” <br /><a href="http://lh3.ggpht.com/_jv1NLkRP5V8/TFwxY4zrU6I/AAAAAAAAEkk/EYMh6mAEWFI/s1600-h/image%5B3%5D.png"><img title="image" border="0" alt="image" src="http://lh6.ggpht.com/_jv1NLkRP5V8/TFwxZKctBRI/AAAAAAAAEko/1W-U1ws__q4/image_thumb%5B1%5D.png?imgmax=800" width="538" height="161" /></a></li> <li>Now that we have the PID, we can use the Taskkill command by running “Taskkill /PID /1168 /F.  The /F switch will forcefully terminate our process.   <br /><a href="http://lh4.ggpht.com/_jv1NLkRP5V8/TFwygTQOm3I/AAAAAAAAEk8/w0geslHwCok/s1600-h/image%5B5%5D.png"><img style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" class="wlDisabledImage" title="image" border="0" alt="image" src="http://lh6.ggpht.com/_jv1NLkRP5V8/TFwyglJjzYI/AAAAAAAAElA/Vrb_LSwT9eA/image_thumb%5B3%5D.png?imgmax=800" width="342" height="80" /></a></li> </ol> <p>Now you can start the HealthService.</p> Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-18988619701368507052009-11-23T16:27:00.002-06:002010-08-18T12:52:42.419-05:00Adding SCOM R2 Report Models<p>SCOM R2 includes 2 new report models for Events and Performance.  For direction on how to add these models have a look at <a href="http://blogs.technet.com/momteam/attachment/3222196.ashx">http://blogs.technet.com/momteam/attachment/3222196.ashx</a></p> <div style="padding-bottom: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; float: none; padding-top: 0px" id="scid:0767317B-992E-4b12-91E0-4F059A8CECA8:f074b909-df33-4a8b-89a7-709d1eff9e8c" class="wlWriterEditableSmartContent">Technorati Tags: <a href="http://technorati.com/tags/SCOM" rel="tag">SCOM</a></div>Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-7943865081044239252009-11-15T08:59:00.001-06:002009-11-15T09:00:42.435-06:00New Tool: MDT 2010 Build-out/Hydration Evaluation<p>If you’re interested in checking out MDT 2010 you should take a look at the  <a href="http://deployment.xtremeconsulting.com/2009/11/13/new-tool-mdt-2010-build-outhydration-evaluation/">New Tool: MDT 2010 Build-out/Hydration Evaluation</a> from Xtreme Consulting Group.  This awesome tool was builds you out a complete test environment in Hyper-V with almost no effort at all.</p> Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-1175707738512943992007-04-04T12:28:00.000-05:002007-04-04T12:42:09.346-05:00Ask the Performance Team : Memory Management - Understanding Pool Resources<a href="http://blogs.technet.com/askperf/archive/2007/03/07/memory-management-understanding-pool-resources.aspx">Memory Management - Understanding Pool Resources</a> is a great blog post for understanding Pool Resources and Pool Resource Depletion in Windows 2000 and 2003 32-bit Operating Systems.Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-1175106007160648052007-03-28T13:20:00.000-05:002007-03-28T13:20:07.173-05:00Error message after you install the Systems Management Server 2003 site database on Microsoft SQL Server 2005: "Message ID : 619"As some of your may recall, there was a discussion on myitforum in August of last year regarding a Message ID 619 for SMS 2003 installs running on SQL Server 2005. I posted about this at the time and the fix that PSS offered, but forgot to update my one or two readers when the KB was updated in November. So here it is... <a href="http://support.microsoft.com/kb/923116/en-us">KB923116</a> updated.Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-1175104625926664252007-03-28T12:57:00.000-05:002007-03-28T12:57:05.983-05:00TechNet Magazine Active Directory Component Jigsaw PosterThis cool poster was featured in March-April 2006 edition of <a href="http://www.technetmagazine.com/">TechNet Magazine</a>. Check the <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=c236336d-ab43-44b1-ad6f-a2f668fb8c02&DisplayLang=en">TechNet Magazine Active Directory Component Jigsaw Poster</a> out for yourself.Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-1157056990799937832006-08-31T15:38:00.000-05:002006-08-31T15:46:03.020-05:00ACL Permission Error from IIS when installing SUS 1.0 on Windows 2003 SP1 serverAfter installing Software Update Services (SUS) 1.0 w/SP1 on my Windows 2003 Standard Server w/SP1 I was unable to view the SUSadmin webpage. The error message<br /><br />"You are not authorized to view this pageYou do not have permission to view this directory or page due to the access control list (ACL) that is configured for this resource on the Web server. "<br /><br />To fix this, navigate to Default Web Site-->SUSAdmin via IIS Manager and change the authentication methods for the SUSAdmin site to use Integrated Windows authentication. Refesh the SUSadmin page and you should now see the admin site.Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-1156850222138317922006-08-29T06:17:00.000-05:002006-08-29T06:18:33.080-05:00Error message after you install the Systems Management Server 2003 site database on Microsoft SQL Server 2005: "Message ID : 619"For those of you that have been experiencing a backlog of .sql files in Inboxes\Statmgr.box\Retry and seeing the error below, take a look at <a href="http://support.microsoft.com/kb/923116/en-us">KB923116</a>. You will need to call Microsoft Support to get the necessary changes (or take a look at this <a href="http://www.myitforum.com/forums/[42000][102][Microsoft][ODBC_SQL_Server_Driver][SQL_Server]Incorrect_syntax_near_">thread</a>). Microsoft has told me that a hotfix should follow shortly.<br /><br /><span style="color:#ff6666;">*** [42000][102][Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'd'. : sp_InsStatusMessageAttribute SMS_STATUS_MANAGER date time 4144 (0x1030) ERROR: Could not add a SQL command to the transaction. Most likely, there is a problem with the SQL server or our connection to it. The transaction will be rolled back. SMS_STATUS_MANAGER date time 4144 (0x1030)</span>Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-1156849833184054032006-08-29T06:10:00.000-05:002006-08-29T17:21:48.006-05:00Changes to the WSUSScan.cab fileFor better or worse the WSUSScan.cab is changing. In an attempt to reduce size, all superseded patches will now be removed because the maximum cab file size has been reached. The reduction in size should come as a welcomed relief to all those that have been seeing CPU levels holding steady at 100% during SMS ITMU or Windows/Microsoft Update scanning.<br /><br />The question right now becomes how customers that require the superseded patches (because the current version breaks LOB apps) will be able to scan for the superseded patches.<br /><br />For more info, <a href="http://support.microsoft.com/kb/924513">http://support.microsoft.com/kb/924513</a>.Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-1156346560965286542006-08-23T10:22:00.000-05:002006-08-23T10:22:40.966-05:00TechNet Magazine for FREETechnet magazine is a great resource for MOM, SMS, and Windows System Administrators and best of all it's free. <br /><br /><a href="http://www.microsoft.com/technet/technetmag/subscribe.aspx">Subscribe to TechNet Magazine</a>Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-1156346365017023972006-08-23T10:19:00.000-05:002006-08-23T10:20:34.826-05:00Customize SMS 2003 with Local PoliciesThere was a recent thread on Myitforum.com regarding the use of local policies. For more information, take a look at the SMS 2003 SDK or have a look at this recent article in Techet Magazine, <a href="http://www.microsoft.com/technet/technetmag/issues/2006/09/CustomizeSMS/default.aspx">Customize SMS Using Local Policies -- TechNet Magazine, September 2006</a>.Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-1156345708654403672006-08-23T10:08:00.000-05:002006-08-23T10:08:28.816-05:00Microsoft Virtual Server support policyIf you are wondering whether or not yoru Microsoft Server app is supported on MS Virtual Server, take a look at the <a href="http://www.support.microsoft.com/kb/897613">Microsoft Virtual Server support policy</a>.Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-1154529868977106322006-08-02T09:44:00.000-05:002006-08-02T09:44:29.043-05:00ITMU Updates Fail when Scan Tool fails to Run<a href="http://blogcastrepository.com/blogs/brian_tucker/archive/2005/11/08/197.aspx">Brian Tucker : ITMU Updates Fail when Scan Tool fails to Run</a><br /><br />Take a look at Brian's blog if you are having issues with the SMS 2003 ITMU scan tool failing on clients.Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-1154497890484734072006-08-02T00:51:00.000-05:002006-08-02T00:51:30.486-05:00How MS does patch managementTaken from Rod Trent's Blog...<br /><br />Thanks to Paul Thomsen at Microsoft for posting these to the SMS email discussion list!<br /><a title="http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=" eventcategory="3&culture=" countrycode="US" href="http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032288959&EventCategory=3&culture=en-US&CountryCode=US">Main presentation</a> – you have to sign in but that then leads to the live presentation, or the PowerPoint slides (or it should – it’s busted now), or the offline viewing download<br /><a title="http://download.microsoft.com/download/6/a/6/6a6af1d2-5542-4e1c-b566-97450c6f9745/bmo102505.wma" href="http://download.microsoft.com/download/6/a/6/6a6af1d2-5542-4e1c-b566-97450c6f9745/bmo102505.wma">WMA</a> – voice-over only (podcast, I suppose you could say)<br /><a title="http://download.microsoft.com/download/6/a/6/6a6af1d2-5542-4e1c-b566-97450c6f9745/bmo102505.mp3" href="http://download.microsoft.com/download/6/a/6/6a6af1d2-5542-4e1c-b566-97450c6f9745/bmo102505.mp3">MP3</a> – same thing but for devices that don’t support WMA<br /><a title="http://download.microsoft.com/download/a/2/0/a20d5c93-63c8-4e79-81e5-2e5866b7996b/PatchManagement_Ppt.ppt" href="http://download.microsoft.com/download/a/2/0/a20d5c93-63c8-4e79-81e5-2e5866b7996b/PatchManagement_Ppt.ppt">PowerPoint slidedeck direct download</a> - you don’t have to sign inKevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-1154497705827222392006-08-02T00:48:00.000-05:002006-08-02T00:48:25.873-05:00Webcast: ADMP for MOM2005<a href="http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032301942&EventCategory=5&culture=en-US&CountryCode=US">TechNet Webcast: Active Directory Management Pack for Microsoft Operations Manager 2005 (Level 200)<span id="link_tt" onmouseover="EditorButtonHoverOn(this);" title="CreateLink" onclick="CheckFormatting(event);CreateLink();EditorButtonClick(this);" onmouseout="EditorButtonHoverOff(this);"></span></a><br /><br />If you have questions on the configuration of the AD Management Pack for MOM 2005, this webcast is worth viewing.Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-1153886042003735952006-07-25T22:54:00.000-05:002006-07-25T22:54:02.003-05:00Logging Security Events in MOM 2005If you are looking to monitor security events in MOM 2005, you'll need to know the security event IDs. Below are two valuable links:<br /><a href="http://support.microsoft.com/kb/299475/">Windows 2000 Security Event Descriptions (Part 1 of 2)</a><br /><a href="http://support.microsoft.com/kb/301677/">Windows 2000 Security Event Descriptions (Part 2 of 2)</a>Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-1153884918843107722006-07-25T22:35:00.000-05:002006-07-25T22:35:18.853-05:00How to Use the Site Reset Functionality in Systems Management Server 2003<a href="http://support.microsoft.com/kb/828366/">How to Use the Site Reset Functionality in Systems Management Server 2003</a>Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-1153872280845317142006-07-25T19:04:00.000-05:002006-07-25T19:04:40.863-05:00A list of log files that are created in Systems Management Server 2003<a href="http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B867490">A list of log files that are created in Systems Management Server 2003</a><br /><br />Comprehensive list of SMS 2003 log files for both legacy and advanced clients, as well as site servers.Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0tag:blogger.com,1999:blog-12649237.post-1153087969002767522006-07-16T17:10:00.000-05:002006-07-16T17:14:02.506-05:00Dell 1600N Network Scan issueI've been having an issue on my Dell 1600N All-In-One printer where the network scan would initially work and then it would stop working. Opening the network scan manager and trying to find the scanner fails every time. After a searching the Dell forums it turns out that the problem is that I had an additional network adaptor configured as an MS Loopback Adaptor. As soon as I disabled this, the scanner is found. In my mind this is only a temporary workaround, but at least I know the issue and am able to resume scanning.Kevin Garnerhttp://www.blogger.com/profile/03141680601738079174noreply@blogger.com0