IntelliTrack WMS – Warehouse Management System - Manual (Page 277)

Chapter 11
WMS System Maintenance
251
Connecting to
the Database
with SQL
Server
Management
Studio SQL Server or SQL Express is an application that manages and runs your
IntelliTrack database. (If you do not have a full version of SQL Server on
your system, WMS installation will run and install SQL Express.) Part of
the SQL Server and SQL Express 2008 installation includes the Microsoft
SQL Server Management Studio. You are able to use the Management Stu-
dio to access the server (data engine type) and database for your Intelli-
Track application. It can be a useful tool in monitoring and maintaining
your database. By default the SQL Server Management Studio is installed
on C:\Program Files\Microsoft SQL
Server\100\Tools\Binn\VSShell\Common7\IDE.
To connect to your database in SQL Server Management Studio, please
refer to the steps that follow.
1. To open the SQL Server Management Studio, click Start > All Pro-
grams > Microsoft SQL Server Management Studio.
2. The Microsoft SQL Server Management Studio opens. The Connect to
Server dialog also appears onscreen.
3. It contains the server name, authentication, and database name of your
IntelliTrack database. If all necessary information is entered correctly,
including server type (Database Engine), server name (name of your
IntelliTrack server/instance), authentication (logon method), username
and password, you will be able to connect to your IntelliTrack database
engine when you click the Connect button. (If you are unable to con-
nect to your database, verify all of this information with your system
administrator. It is possible that a piece of information is entered incor-
rectly.)
4. Once SQL Server Management Studio is connected to the database, go
to the Object Explorer section in the left pane of the window and
expand the databases and locate your IntelliTrack database. The screen