Sql server administration

Advanced Tracker Technologies Inc.
SQL Server Administration

Note
Service packs and updates for MDAC are available for download direct from www.Microsoft.com Customers who prefer to use the Desktop version of SQL-Server 2000 must be prepared to perform all database maintenance using the command-line utility (see appendix A), as this version of SQL-Server does not come with graphicaladministration utilities.

1

Requirements
Server
• • • • SQL-Server 2000 (Enterprise, Standard or Desktop) version 8.00.760 (Service Pack 3). SQL Server 2005 (Enterprise, Standard, Workgroup, Express and Developer) version 9.0.1399. SQL Server 2008 (Enterprise, Standard, Workgroup, Express and Developer) version 10.0.1600.22. Microsoft Data Access Components (MDAC) 2.7 Service Pack 1 RefreshClient
• Microsoft Data Access Components (MDAC) 2.7 Service Pack 1 Refresh

Collation
All applications from Advanced Tracker will create their tables within a default database name of [Advanced Tracker] and this cannot be changed. The [Advanced Tracker] database must have a Collation setting of:
SQL_Latin1_General_CP1_CI_AS

If this is not the default collating setting for the server, seeAppendix B which discusses how to override the server default setting and ensure applications from Advanced Tracker maintain their required collation settings. See Appendix B of this document for information on Forcing Collation if your installation of SQL Server requires a collating setting other than the one mentioned above. There may be further operating system component updates needed forany of the base requirements of Advanced Tracker software listed above.

2

SQL Server Version Check
Enterprise Manager or Management Studio Connect to and locate the server and do a right-click->Properties. Version is identified as “Product Version”. Command Line Utilities Using the command line utilities, execute the following query on the computer running the database server: “Select@@Version" Version will be displayed on the line containing the following: Microsoft SQL Server 200? – ?.??.??? (Intel X86) Where “200?” could be 2000, 2005 or 2008 and “?.??.???” will denote the SQL Server version. Don’t be misled; the version identified on the last line of the output denotes the version of the operating system.

MDAC Version Check
Microsoft has a free utility which will check theversion of data components on your computer. Go to WWW.Microsoft.Com and search for “check for mdac version”. Your search results should include a HOW TO article where this utility can be downloaded.

3

The Server
SQL Server 2000 Desktop Edition
Base installation of SQL Server 2000 Desktop requires a couple of extra steps to ensure the database is accessible throughout the network. Onceinstallation has completed, restart the computer if required. Open Windows Explorer and browse to the folder “C:\Program Files\Microsoft SQL Server\80\Tools\Binn”. Within this folder are a couple of applications we will want to run.
SQLMANGR.EXE This application is the SQL Server service manager. It puts an icon in the system tray which indicates the status of the SQL Server. Users are also ableto start and stop the server, as well as tell Windows to auto-start the SQL Server service when the OS starts. SVRNETCN.EXE This application is the SQL Server Network Utility. The following protocols should be enabled for the server to accept client connections: • Named Pipes • TCP/IP • Multiprotocol

SQL Server 2000 Standard and Enterprise Editions
From within Enterprise Manager, right clickon the server->Properties. Ensure the following minimums: • • General tab, “Autostart SQL Server” must be on to ensure the server is always accessible, even after a restart of the computer. Security tab, authentication must be set to SQL Server and Windows. With update SQL Server components (see the Client Administration Application section below), the SQL Server can be set for Windows only...