in

myITforum.com
All Tags » SMS 2003 » Microsoft SQL Server (RSS)

Browse by Tags

  • Linking SMS And MOM Server Databases For Distributed Queries

    This post will show you how to retrieve data that resides on a remote MOM database server from an SMS database server for writing distributed queries. SMS and MOM both capture and record into their respective SQL databases a great deal of information about networked resources among other things. You...
    Posted to Don Hite (Weblog) by dhite on 03-15-2007
    Filed under: SQL Queries, SMS 2003, Microsoft SQL Server, MOM 2005

  • Configuring SMS And SQL Server Together To Use Windows Authentication Security

    For SQL server Windows Authentication is the security mode recommended by Microsoft. To enable SMS to access SQL in Windows Authentication mode you must first set SQL server to use Windows Authentication security and then you need to configure SMS to use it as well. For SQL 2000 and SQL 2005 follow the...
    Posted to Don Hite (Weblog) by dhite on 11-07-2006
    Filed under: SMS 2003, Microsoft SQL Server

  • Preparing SQL Server For SMS 2003

    The two main requirements to have an SMS site is obviously you must have SMS installed and the other is that SMS must have a database backend. SQL server is the only backend that you can have however you can have SQL 2000 or SQL 2005 as the database backend depending on the SMS 2003 service pack you...
    Posted to Don Hite (Weblog) by dhite on 09-17-2006
    Filed under: SMS 2003, Microsoft SQL Server

  • Querying The Automatic Updates Service State

    One of the prerequisites for ITMU is that the automatic update services must be running on your client machines. If it is not ITMU will not work as expected. Use the query below to find those machines that have the Automatic Updates Service ( Wuauserv) servivces state set to runing. SQL Query: Select...
    Posted to Don Hite (Weblog) by dhite on 07-23-2006
    Filed under: SMS 2003, Microsoft SQL Server

  • Running Your SMS 2003 Infrastructure With A Microsoft SQL Sever 2005 Backend

    If you are currently running either Microsoft SQL server 7.0 Service Pack 4 or later or Microsoft SQL sever 2000 Service Pack 3 or later and your SMS server(s) have been upgraded to SMS 2003 Service Pack 2 you can upgrade your SMS 2003 infrastructure to use Microsoft SQL server 2005 (SQL 2K5) as its...
    Posted to Don Hite (Weblog) by dhite on 05-21-2006
    Filed under: SMS 2003, Microsoft SQL Server

  • Quick SMS Component Status Check

    For those people that have only one SMS primary site server to manage opening the SMS administrations console and looking at the System Status leaf is usually not much of a time consuming chore. However if you have a parent site with several sites below it that task can start to become a taxing operation...
    Posted to Don Hite (Weblog) by dhite on 04-10-2006
    Filed under: SQL Queries, SMS 2003, Microsoft SQL Server
Page 1 of 1 (6 items)
Copyright - www.myITforum.com, Inc. - 2007 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems