7 Replies Latest reply on Mar 31, 2011 3:14 PM by JWK

    SA vs. Windows Authentication

      Which one should I use? If I use Windows Authentication, the password could change for the user and this could cause problems, but I don't see how to set a password for the SA account. Is there a best practice for this or recommendation in a guide somewhere?

        • 1. Re: SA vs. Windows Authentication
          hem

          If you are using windows authentication then when password of the user will change then automatically that will not be applied to ePO server.

           

          Manually you have to write the NT password to ePO \core\config page.

           

          For setting the SA password, please follow the below steps.

           

           

          1. Please download SQL management studio from (http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-9 4b8-5a0f62bf7796).

           

          2. Install on the machine. This will give you the GUI interface.

           

          3. Please connect to the database server. Under security=>Login=>right click on SA user=>property and set the password.

           

          4. If you would like to use this user then you have enable Mixed mode in SQL.

           

          5. On the top where machine name is listed=>right click property.  Under security tab, please select the radio button 'SQL server and windows authentication mode', Apply the settting and restart the SQL server.

           

          6. Upon restart, you will be able to use SA user.

           

           

          Message was edited by: Hem Bihari on 11/2/11 6:02:37 AM IST
          1 of 1 people found this helpful
          • 2. Re: SA vs. Windows Authentication

            Thanks. So I take it that you have to install SQL Express 2005 prior to installing ePO in order to use an SA user account?

            • 3. Re: SA vs. Windows Authentication
              joeleisenlipz

              You need to have a version of SQL somewhere, before you can complete the ePO installer.

               

              You can always change the credentials that are used post-install.

              • 4. Re: SA vs. Windows Authentication
                hem

                You can change the credentials after installing ePO in its \core\config page (https://localhost:8443/core/config).

                 

                Under user name, write the sql user and its password. Domain field can be blank if the ePO DB is in the same domain.


                Click on 'Test Connection' then Apply. Restart the ePO services.

                1 of 1 people found this helpful
                • 5. Re: SA vs. Windows Authentication

                  I always get this Test failed: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

                   

                  Here is what I followed exactly

                   

                  1.    Click Start | All Programs | Microsoft SQL Server 2005 | SQL Server Management Studio Express

                  2.    Select the SVR\EPOServer and click Connect.

                  3.    Under Security | Logins, right click on the SA user and select properties.

                  4.    Set the password

                  5.    Change the default database to ePO4_SVR and click OK.

                  6.    Right click on SVR\EPOServer(SQL Server 9.0.1399) and select properties.

                  7.    Click on Security.

                  8.    Change the radio button to SQL Server and Windows Authentication mode.

                  9.    Right click on SA and click Properties.

                  10.    Select General.

                  11.    Change the default database to ePO4_SVR.

                  12.    Select Status.

                  13.    Change the login to Enabled and click OK.

                  14.    Restart the server.

                   

                   

                  1.    Type in https://localhost:8443/core/config

                  2.    Log in using the administrator username and password.

                  3.    Change the Username to sa and enter the password.

                  4.    Click test credentials.

                  5.    Click Apply

                  6.    Restart the server.

                  1 of 1 people found this helpful
                  • 6. SA vs. Windows Authentication

                    Hi,

                    When you tried : test credentiels via the /core/config, does the tests succeded ?

                    Also please be sure that the domain field is blank in this configuration.

                     

                    Regards

                     

                    Damien

                    • 7. Re: SA vs. Windows Authentication

                      Sorry for the late reply. My steps above and leaving it blank seem to have done the trick. Thanks bro!