2 sql server – Campbell Scientific LNDB LoggerNet Database Software User Manual

Page 12

Advertising
background image

LNDB

SQL Server Compact is an embedded database that just requires the selection
of a filename. The default location of the database will be <working
directory
>\LNDB.sdf. LNDB does not support any encryption or security
options on the SQL Server Compact database. When selecting the database
within the LNDB Manager, the database will be created when the OK button is
pressed.

2.3.2 SQL Server

To configure a connection to SQL Server you must select a SQL Server
instance. The list of published SQL Server instances is shown in the Data
Source combo box. You can also type into the Data Source combo box,
because the desired server might not be published. Windows Authentication or
SQL Server Authentication can be selected. Windows Authentication does not
require a username and password, but rather uses Windows user accounts to
authenticate valid users. SQL Server Authentication requires a login ID and
Password and is independent of Windows user accounts. You can select the
<default> database or select a specific database from the Database combo box.

6

Advertising