Server Authentication

See Also


ArchiOffice stores your company data in an SQL database. The SQL Server enables ArchiOffice to connect to the server and your database file via two different modes: SQL Server Authentication and Windows Authentication. You must select one of these modes when opening an existing ArchiOffice company file or creating a new one. The following information discusses the differences between the two authentication methods.


SQL Server Authentication Mode/Standard Security

A member of the sysadmin fixed server role first specifies to SQL Server all the valid SQL Server login accounts and passwords. These are not related to your Microsoft Windows account or network account. You must supply both the SQL Server login and password when you connect to SQL Server. You are identified in SQL Server by your SQL Server login.


Windows Authentication Mode/Trusted Connection

A member of the SQL Server sysadmin fixed server role must first specify to SQL Server all the Microsoft Windows accounts or groups that can connect to SQL Server. When using Windows Authentication, you do not have to specify a login ID or password when you connect to SQL Server. Your access to SQL Server is controlled by your Windows account or group, which is authenticated when you log on to the Windows operating system on the client. When connecting, the SQL Server client software requests a Windows trusted connection to SQL Server. Windows will not open a trusted connection unless the client has logged on successfully using a valid Windows account. The properties of a trusted connection include the Windows group and user accounts of the client that opened the connection. Because it is impossible for a trusted connection to be completed without Windows having first authenticated the user, SQL Server does not have to do anything to authenticate your accounts. SQL Server gets the user account information from the trusted connection properties and matches it against the Windows accounts defined as valid SQL Server log-ins. If the SQL Server finds a match, it accepts the connection. Your Windows group or user account identifies you in SQL Server.


When SQL Server is running on Windows, members of the sysadmin fixed server role can specify one of two authentication modes:

These modes are specified during the setup of a company file or with SQL Server Enterprise Manager.


One of the properties of a login is the default database. When a login connects to SQL Server, this default database becomes the current database for the connection, unless the connection request specifies that another database be made the current database. For any query, please contact