FAQ - Ways to access SQL Server in WebEdition

FAQ - Ways to access SQL Server in WebEdition

Question

By default WebEdition accesses SQL server database using 'SQL Server authentication'. How can I change that to 'Windows authentication'?

Answer

TBS server software is preconfigured to use 'SQL Server authentication' method when connecting to the SQL Server database. There are few reasons why this setup may not suffice in every installation (eg. to avoid disclosing database login passwords in configuration files).

To change WebEdition using database connections with 'Windows authentication' (using a Local Windows Account or Windows Domain account), the below pdf file guides you throught the steps required.


    • Related Articles

    • FAQ - WebEdition migration to another server machine

      Question How can I migrate the TBS WebEdition server software to another server machine? Answer This article describes how to migrate the TBS WebEdition (WE) server software to a different physical computer. The below steps should be followed in ...

    • FAQ - Basic backup/restore of WE database in the same MS SQL Server

      Question How can I simply backup and restore TBS WebEdition server database (in the same SQL Server installation)? Answer In order to prevent data loss, it is a good practice to regularly backup content of TBS WebEdition server database. This article ...

    • FAQ - Database migration to another MS SQL server

      Question How can I migrate complete TBS WebEdition server database to another MS SQL server? Answer This article describes how to move TBS WebEdition server database to another MS SQL database server. This may be useful e.g. in case you are moving or ...

    • FAQ - WebEdition server installation troubleshooting

      Question What are the most frequent problems when installing WebEdition server, and how can I solve them? Answer Installing all WebEdition server components is not a click-and-go experience. It requires several installation steps and skipping or ...

    • HowTo - Prevent WebEdition database log file from expanding continuosly

      Question How can I reduce the file size of TBS WebEdition database log, default name 'TBS_BAWSE.ldf'? NOTE: This logging is an inbuilt feature of MS SQL server itself and not created by TBS software. Its the responsibility of local DB server ...