PANTHEON™ manual

 Categories
 Скласти тех карту
[Expand]User Manual for DataLab PANTHEON 5.5
[Collapse]Datalab PANTHEON 5.5
 [Expand]Orders
 [Expand]Settings
 [Expand]Manufacturing
 [Expand]Goods
 [Expand]Service
 [Expand]Financials
 [Expand]Personnel
 [Expand]ZEUS Business Intelligence System
 [Expand]Desktop
  Web Portals
  Extra
 [Collapse]Datalab Software System Environment
  [Expand]Security Policy
  [Collapse]Installation
    Windows Vista
    Windows Terminal Server
    Installing PANTHEON on Linux and Oracle Database
   [Collapse]MS SQL Server
     MS SQL Server Installation
     Changing SQL Sort Order
     SQL Server Agent
    [Expand]MS SQL Server Security
    [Expand]Useful SQL Queries
   [Expand]Oracle Database
   [Expand]ODBC
  [Expand]Task Scheduling
  [Expand]PANTHEON System Environment
  [Expand]Database Administration
  [Expand]Datalab Utilities
 [Expand]Messages and Warnings
 [Expand]Additional Programs
 90632
[Expand]Pantheon RA (android POS) guide
[Expand]Довідник користувача Datalab PANTHEON Farming
[Expand]User Site

Load Time: 517.213 ms
print   |
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!