Please click the image below to view the full workflow chart of SourceAnywhere Server installation.
- How to Connect to a Remote SQL Server While Installing SourceAnywhere Server with Windows Authentication mode?
- How to Connect to a SQL Server While Installing SourceAnywhere Server with SQL Server Authentication mode?
Here are the steps to install SourceAnywhere Server on the SQL Server machine with Windows Authentication mode.
Create a New Windows User on the Server Machine
Please create an administrative Windows user. Then, add the Windows user into sysadmin in SQL Server -> Server Roles. Like this:
Run the SourceAnywhere Server Installer
Run the EXE installer as the new Windows administrator,
and select Connect to my own SQL Server at the database settings step .
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
Please make sure Use Windows authentication is selected.
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.
[Optional] Change User Role in SQL Server
After the installation, open SQL Server and change the Windows 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.