How to Connect to a SQL Server While Installing SourceAnywhere Server with SQL Server Authentication mode

Please click the image below to view the full workflow chart of SourceAnywhere Server installation.



Here are the steps to install SourceAnywhere Server with SQL Server Authentication mode.

  1. Create a New SQL Server User on the Server Machine

    Please create a new SQL Server user. Then, add the user into sysadmin in SQL Server -> Server Roles.

    Don't forget to enable SQL Server and Windows Authentication mode in SQL Server.
    Otherwise SourceAnywhere would be unable to connect to SQL Server while installing in this case.

    NOTE: You will need this role to create database for SourceAnywhere in SQL Server. You can remove the user from the sysadmin list in step #V as long as the installation is done.

  2. Run the SourceAnywhere Server Installer

    Run the EXE installer as a Windows administrator,
    and select Connect to my own SQL Server at the Database Settings step .

  3. Select or Add Your SQL Server Machine

    If you are using the Standard Edition of SQL Server, please enter the server name only. If you are using the Express Edition, please enter
    {server name}\SQLEXPRESS.

    Please make sure Use SQL Server authentication is selected.

  4. Create a Password for the Built-in Admin User

    There is a built-in user Admin in SourceAnyhwere. You will need this user to
    create other regular users, admin users and groups.

  5. [Optional] Change User Role in SQL Server

    After the installation, open SQL Server and change the SQL Server user role from sysadmin to public.
    Then, make sure this user is the db_owner of the new database SourceAnywhere.

Once these steps have been competed, SourceAnywhere Server should be running successfully.




If you need any extra assistance or have any problems, please feel free to contact us.