• Show convenient version of this site
  • Deutsch
  • English
Contact
Newsletter
  • Products
    • ALS
      • Across Language Server
        • Translation Management
        • Terminology Management
        • Translation Memory
      • Editions
      • Interfaces
    • ATE
      • Across Translator Edition
      • Editions
      • Download
      • Across Account
    • Elanion
      • Overview
      • Login
  • Solutions
    • Customers
      • Enterprises
      • Language Service Providers
      • Translators
    • Industries
      • E-Commerce & Trade
      • Pharmaceuticals & medicine
      • IT & Software
    • Departments
      • Marketing & E-Commerce
      • Technical Documentation
      • Software User Interfaces
  • Services
    • Hosting
    • Training
    • Consulting
  • Partners
    • Language Service Providers
    • Universities
    • Organisations
  • Company
    • Across Systems
    • News
    • Events
    • Career
    • Contact
  • Knowledge
    • Blog
    • Video Library
    • Case Studies
    • White Papers
    • Fact Sheets
    • File Formats
    • Expert Features
  • Support
    • Online Help
    • FAQ
    • Support Request
    • Updates
      • New from Across v7.0 15911 - ALS
      • New from Across v7.0 15911 - ATE
    • New Functions
Schedule Consultation
  • Online-Help
  • ALS Admin
  • Introduction
  • Installation of the Microsoft SQL Server
  • Authentication
  • Introduction
    • The Across Language Server
    • Across Standard Components
    • Databases
    • Across Access Modes
    • Installation Scenarios
    • Installation of the Microsoft SQL Server
      • Authentication
      • Network Settings
    • Customer Product Key and Product Activation
      • Offline Product Activation
      • Subsequent Product Activation (Online)
      • Subsequent Product Activation (Offline)
      • Transmitting License
  • Installation
    • Main Installation
    • Dedicated Server
      • Execution
    • Client Installation
      • Windows Terminal Server/Citrix Environments
      • Online Client
  • crossAdmin
    • Across Server
      • Database
      • Server
      • Softkeys
      • Licenses
      • Object Locks
    • crossTerm Server
      • Database
      • Server
    • crossTank Server
      • Database
      • Server
    • crossVPN Server
      • Configuration
    • crossConnect
      • Configuring Connectors
        • Main configuration
        • LAN Settings
        • FTP Options
        • Default Settings
    • crossWeb
      • Login with Windows Authentication
      • Configuration
        • Browser
        • Troubleshooting
      • crossWeb Spell-Checks
        • Sentry Spelling Checker Engine
        • Hunspell Spell-Check
          • Adding Dictionaries
    • crossVPN Proxy
      • Configuration
    • crossAPI SI
    • crossTerm Web
      • Login with Windows Authentication
      • Configuration
        • Timeout
      • Determining Default Language Combination
      • crossTerm Web Suggestion Module
        • Setup Requirements
        • Configuration
        • Setup
        • Troubleshooting
        • Access Control
        • Localizing crossTerm
        • Customizing
    • crossAnalytics
      • Troubleshooting
      • Reporting Services Troubleshooting
    • Settings
      • General
      • E-Mail Configuration
      • Format
  • Setting up Across Modes
    • crossLAN
    • crossWAN online
    • crossWAN load
    • crossWAN classic
    • crossGrid
  • Softkeys
    • Creation
    • Softkey Wizard
  • Generating crossGrid Certificates
  • Creating Generic Softkeys
  • Changing the Across Database User
  • Defragmenting Database Files
  • Running a Backup
  • Auto-Deployment
  • Automatic Client Update
  • Windows Authentication
    • Creating Users
    • Login to Online Client
    • Login to crossWeb and crossTerm Web
    • Switching to Windows Authentication
    • Troubleshooting
  • Uninstalling
  • Reference: Menus in crossAdmin
  • Appendix
    • crossTank Performance Counter
    • SQL Server Optimization
    • Integration in Other Programs
    • Web-based Components with HTTPS
      • Configuring and Testing crossTerm Now
      • Configuring and Testing crossTerm Web
      • Configuring and Testing crossWeb
    • E-Mail Transmission in Across
      • E-Mail Transmission in crossWeb
    • Integration Into the Network
      • Network Configuration
      • Testing Connections
        • Internal IP Address
        • Checking the Across services (internal)
    • Across Support and Across Services
    • Across SDK
    • The Toolbox: Useful Tools for Across

Authentication

By default, the security settings of the SQL Server are configured to allow access to the server via an existing Windows user account. To enable the setup of the Across databases during the installation of the Across Server, the so-called mixed mode must be activated in the SQL authentication settings. Additionally, you need to activate the sa user. Both are possible with a user-defined installation of the Microsoft SQL Server (Express). If necessary, you can also activate the mixed mode and the sa user retroactively.

Tip

For the retroactive adjustment, we recommend using the Microsoft SQL Server Management Studio. You can get it free of charge from Microsoft.

Adjusting the Authentication Mode Retroactively

  1. If the SQL Server has already been installed without activating the mixed mode, proceed as follows to adjust the authentication settings:
  2. Open the Microsoft SQL Server Management Studio.
  3. Connect to the database engine and select the server and, if necessary, the instance.
    Tip

    When installing MS SQL Server Express, an instance called SQLEXPRESS is created by default.

  4. Select your SQL Server in the tree view.
  5. From the context menu of the server, select Properties.
  6. Open the Security section and select the setting SQL Server and Windows Authentication mode under Server authentication.
  7. Confirm and close the server properties with OK.

Activating the sa User

  1. Proceed as follows:
  2. Open the Microsoft SQL Server Management Studio.
  3. Connect to the respective instance.
  4. Select your SQL Server in the tree view.
  5. Under Security > Logins, select the Properties entry from the context menu of the sa user.
  6. Under General, check whether a password has been set. If not, set a password.
    Tip

    While configuring Across, you will need the data of the sa user.

  7. Check whether the permission to establish a connection to the database engine has been granted in the Status area and set the option Login to Enabled.
  8. Confirm and close the login properties with OK.
  9. Across can now be installed and configured.
Register for our Newsletter now

Our newsletter provides you with exclusive news about the Across Language Server, often even before the official announcement. The newsletter also provides you with early information on events, webinars, and training sessions.

  • Legal Notice
  • GTC
  • Privacy Statement
  • Cookies
  • info@across.net