PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Expand]Guide for PANTHEON
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Collapse]User Manual for PANTHEON
   [Collapse]Getting Started
     First steps with PANTHEON
    [Expand]PANTHEON Installation
    [Expand]PANTHEON Basics
    [Collapse]PANTHEON System data
     [Expand]PANTHEON System data
     [Collapse]MS SQL Server
       Download and install MS SQL Server
       Upgrading the SQL Server to the newer version
       MS Management Studio - Download and install
       Restoring database onto SQL server
       Adding users to server level (AddUser_PAX)
       Installing SQL for external access
       Installing PANTHEON clients
      [Expand]MS SQL Server Security
      [Expand]Useful SQL Queries
       SQLExecute
      [Expand]SQL Server Jobs
     [Expand]Microsoft Windows Utilities
     [Expand]Security Policy
     [Expand]Database Administration
    [Expand]PANTHEON Security
    [Expand]Using PANTHEON at Tecta, a fictional company
    [Expand]Frequently asked questions about Pantheon (F.A.Q.)
   [Expand]User Manual for eBusiness
   [Expand]Settings
   [Expand]Orders
    Creating new invoice
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]Service
   [Expand]Help
   [Expand]Personnel
   [Expand]Financials
   [Expand]Analytics
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
[Expand]User Site

Load Time: 1296.9108 ms
"
   8132 | 8646 | 339911 | Updated_DRAFT
Label

MS SQL Server Security

MS SQL Server Security

MS SQL Server Security

MS SQL Server can operate in two security modes: Windows Authentication (Windows logon) and Mixed Mode (Windows and SQL Server logon).

In Mixed Mode, you can logon to an instance of the SQL Server through a Windows NT or SQL Server user account. Logging on with a Windows user account will allow you to use trusted connections. After logon to the SQL Server, the security mechanism works the same in both modes.

SQL Server logins employ user names and passwords and are easier to manage than a Windows NT system of users and user groups, especially for non-critical data. In such cases, you can create only one SQL Server user account for all users, but you will not be able to track individual user activity.

 

Read more:

 

Windows Authentication

SQL Server Authentication

Creating Server Logins

Fixed Server Role

Fixed Database Role

SQL Server Service Settings

 

 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!