Verifying database connection, Intellitrack database, Sql server logon information – IntelliTrack WMS – Warehouse Management System User Manual

Page 346: Intellitrack database sql server logon information, Sql server 2008 login strong password requirements

Advertising
background image

I

NTELLI

T

RACK

WMS: W

AREHOUSE

M

ANAGEMENT

S

YSTEM

V

8.1

User Manual

320

Verifying Database Connection

Your IntelliTrack application contains a database that stores your data and
all data transactions. It is located on a PC or network server. In IntelliTrack
v8.x applications, the database is managed by SQL Server or SQL Express.
During application installation, SQL login is set and your IntelliTrack
database is created. To verify database creation and connection, you must
know your SQL Login information (including server name and/or
instance) and your IntelliTrack database name.

IntelliTrack
Database

The database is created during application installation. When you use the
database that is created during application installation, it is automatically
given a name. The default database name for each application is found in
the table below.

SQL Server
Logon
Information

During application installation, the default logon information for SQL
Server is set as username “sa” and password IntelliTrack#2008. You are
able to change the database name and SQL Server logon information.
However, for SQL 2008, a strong password is required. For more informa-
tion on the SQL login password requirements, see

“SQL Server 2008 Login

Strong Password Requirements” on page 320

for more information.

SQL Server 2008 Login Strong Password Requirements

The default IntelliTrack password for SQL Server 2008 login is
IntelliTrack#2008. It is set during application installation. It is a strong
password. If you want to use another password for SQL login, be aware

TABLE 28.

Default Names of Application Databases

Application

Default Database Name

Check In-Out

DATACHE80

Fixed Assets

DATAFIE80

Inventory

DATAINE80

Stockroom

DATASTE80

Package Track

PTSQL80

WMS

WMS80

ISRP

ISRP80

Advertising