Announcement

Collapse
No announcement yet.

WSUS question

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • WSUS question

    Hi guys.. i need your help. I am installing WSUS 3.0 SP1. do i need to install SQL server for this? because im having problems with the DAtabase option window. in the guide its different from whats in my actual installation window.

    Thanks
    Ronuel
    MCP
    There is only one way to find Out..Its to try it and/or Do it...

  • #2
    Re: WSUS question

    found the following article:

    Selecting a database
    Use the following information to determine what database software is right for your organization. Once you have made a selection, see if there are any additional tasks you need to complete to set up the database software to work with WSUS. You can use database software that is 100-percent compatible with Microsoft SQL. There are two options that have been tested extensively for use with WSUS:

    Windows Internal Database ships with WSUS 3.0. This version of SQL Server does not have a user interface or tools. Administrators are meant to interact with these products through WSUS.

    Microsoft SQL Server 2005 is the full-featured database software from Microsoft. WSUS 3.0 requires SQL Server 2005 with Service Pack 1. If you use the full version of SQL Server, the SQL Server administrator should enable the nested triggers option in SQL Server. Do this before the WSUS administrator installs WSUS and specifies the database during the setup process. WSUS Setup enables the recursive triggers option, which is a database-specific option; however, it does not enable the nested triggers option, which is a server global option.


    WSUS does support running database software on a computer separate from WSUS, but there are some restrictions. See Appendix B: Configure Remote SQL for more information.
    http://technet2.microsoft.com/window....mspx?mfr=true

    Michael
    Michael Armstrong
    www.m80arm.co.uk
    MCITP: EA, MCTS, MCSE 2003, MCSA 2003: Messaging, CCA, VCP 3.5, 4, 5, VCAP5-DCD, VCAP5-DCA, ITIL, MCP, PGP Certified Technician

    ** Remember to give credit where credit is due and leave reputation points sigpic where appropriate **

    Comment


    • #3
      Re: WSUS question

      What is different?

      From the readme:

      WSUS 3.0 will install Windows Internal Database for you if a compatible version of SQL Server is not installed already. If you plan to use a full SQL Server database, you must use (at a minimum) SQL Server 2005 SP1 (available on the Microsoft Download Center (http://go.microsoft.com/fwlink/?LinkId=66143) on Windows Server 2003, or SQL Server 2005 SP2 (available on the Microsoft Download Center at http://go.microsoft.com/fwlink/?LinkId=84823) for on Windows Server "Longhorn".

      EDIT: Too slow...
      cheers
      Andy

      Please read this before you post:


      Quis custodiet ipsos custodes?

      Comment


      • #4
        Re: WSUS question

        OK.. So what would be your advice.. Do i just install Windows internal Database or Install SQL first before installing WSUS. What wold be the best Practise?
        Ronuel
        MCP
        There is only one way to find Out..Its to try it and/or Do it...

        Comment


        • #5
          Re: WSUS question

          I can't find anything at the moment for database recommendations but how many computers are you talking about roughly?
          cheers
          Andy

          Please read this before you post:


          Quis custodiet ipsos custodes?

          Comment


          • #6
            Re: WSUS question

            Originally posted by AndyJG247 View Post
            I can't find anything at the moment for database recommendations but how many computers are you talking about roughly?
            about a 100 machines sir.
            Ronuel
            MCP
            There is only one way to find Out..Its to try it and/or Do it...

            Comment


            • #7
              Re: WSUS question

              The cost of SQL may be prohibitive for 100 users and if you already have SQL there are requirements on it:

              (neck on the line, personally in this situation, I would probably go for the windows database.)


              From:
              http://technet2.microsoft.com/window....mspx?mfr=true

              Selecting a database

              Use the following information to determine what database software is right for your organization. Once you have made a selection, see if there are any additional tasks you need to complete to set up the database software to work with WSUS. You can use database software that is 100-percent compatible with Microsoft SQL. There are two options that have been tested extensively for use with WSUS:

              Windows Internal Database ships with WSUS 3.0. This version of SQL Server does not have a user interface or tools. Administrators are meant to interact with these products through WSUS.

              Microsoft SQL Server 2005 is the full-featured database software from Microsoft. WSUS 3.0 requires SQL Server 2005 with Service Pack 1. If you use the full version of SQL Server, the SQL Server administrator should enable the nested triggers option in SQL Server. Do this before the WSUS administrator installs WSUS and specifies the database during the setup process. WSUS Setup enables the recursive triggers option, which is a database-specific option; however, it does not enable the nested triggers option, which is a server global option.

              WSUS does support running database software on a computer separate from WSUS, but there are some restrictions. See Appendix B: Configure Remote SQL for more information.
              cheers
              Andy

              Please read this before you post:


              Quis custodiet ipsos custodes?

              Comment


              • #8
                Re: WSUS question

                Thanks for the help sir. Ill try your advice. Any way our office is small and probably can accomodate not mor than one hundred machines. So for now ill go with Windows internal database. Appreciate the help Sir..
                Ronuel
                MCP
                There is only one way to find Out..Its to try it and/or Do it...

                Comment

                Working...
                X