Belajar PLC dan SCADA

Just another Blog about Programmable Logic Controller & SCADA.

Configuring MSDE 2000 SP3 for Historical Alarms and Events in InTouch® 7.11 and Later

Written by Kang Abu on 7:32 PM

Introduction

InTouch 7.11 and later require an instance of Microsoft® SQL Server™ to record historical alarms and events using the Alarm DB Logger utility. Once the Alarm DB Logger Manager has been configured to connect with a valid instance of SQL Server, alarms and events will be written to the WWALMDB database. InTouch 7.11 and later can then use the AlarmDBViewer ActiveX control to view these historical alarms from within an application.

Which version of Microsoft SQL Server you should install depends on your operating system. Any valid instance available on the LAN will work, but in general, for standalone InTouch systems you will want to install the Microsoft SQL Server 2000 Desktop Engine with Service Pack 3 (MSDE SP3).

Operating System

Valid SQL Server 2000 Version

Windows 2000 Professional Service Pack 3

MSDE SP3 or SQL Server 2000 Personal Edition SP3

Windows XP Professional Service Pack 1

MSDE SP3 or SQL Server 2000 Personal Edition SP3

Windows 2000 Server or Advanced Server Service Pack 3

MSDE SP3 or SQL Server 2000 Standard Edition SP3

The InTouch 7.11 and 8.0 (no SP) installation CDs have a version of MSDE 2000 (no SP). When installing InTouch 7.11 or InTouch 8.0 (no SP), the setup will offer to install MSDE if an existing SQL Server or MSDE instance is not detected on the local machine.

However, beginning with InTouch 8.0 SP1, the setup for MSDE 2000 is not included on the InTouch installation CD. Instead, it is included on the FactorySuiteA²™ Prerequisite CD version 1.1.

The Prerequisite CD also has a fix to protect against the Slammer Virus which should be applied to MSDE/MSSQL 2000 SP2 and prior. It is located at:

[CD-Drive]:\mssql2000\slammer\click-n-patch\English\SQLCritUpdWiz_ENU.msi

The Slammer Virus fix does not need to be applied to MSDE/MSSQL 2000 SP3 or later.

Note: For more information on what is included in the SQL Server Service Packs see the Microsoft Support Web site.

This Tech Note explains various upgrade scenarios. For more information about installing or upgrading MSDE please choose the appropriate link:

  • How to Tell What Version of MSDE is Installed
  • To Install a New Instance of MSDE SP3
  • To Upgrade an Existing Instance of MSDE to Service Pack 3

How to Tell What Version of MSDE is Installed

  1. From the Control Panel, select Add/Remove Programs.

    If MSDE is installed, you should see it listed in the Currently installed programs pane (Figure 1, below):


    Figure 1: Add/Remove Programs

  2. If you click on the support information link, the following dialog box should appear (Figure 2, below):


    Figure 2: Support Info Dialog Box

The following table lists the MSDE version number:

Release

MSDE Version

MSDE RTM (no SP)

8.00.194

MSDE SP1

8.00.384

MSDE SP2

8.00.534

MSDE SP3

8.00.760

To Extract the Setup Files for MSDE SP3

  1. Run SQL2KDeskSP3.exe. It is located on the FactorySuite A² Prerequisite CD version 1.1:

    [CD-Drive]:\MSSQL2000\MSDE SP3\SQL2KDeskSP3.exe

  2. Specify a local directory for the MSDE SP3 setup files. The default location is: C:\sql2ksp3.

    You will now have:C:\sql2ksp3\msde.

To Install a New Instance of MSDE SP3

DO NOT run the setup.exe executable located in the setup folder. Instead:

  1. Enter the following in the Start/Run command-line:

    C:\sql2ksp3\Msde\setup.exe securitymode=sql sapwd=mysqlpassword

    where mysqlpassword is a password of your choosing. Be sure to record this password in a secure place for future reference.

  2. Skip to the section After Installing MSDE SP3

To Upgrade an Existing MSDE Instance to SP3

  1. Start the MSSQLServer Service (if it is not already started). Figure 3 shows the MSSQLSERVER service in the Services window:


    Figure 3: Start MSSQLSERVER Service

    You must change the sa password so it is not blank. This can be done from the command prompt (Figure 4 below).

  2. Enter:

    osql -E (use a capital E)

  3. Enter the following on separate lines:

    sp_password @old=null, @new='mysqlpassword', @loginame='sa'

    go


    (Where 'mysqlpassword' is a password of your choice.Remember to make note of this password!)

    You will receive the message Password changed.


    Figure 4: Command Prompt Entries

  4. Type exit and press the Enter key to quit osql.

  5. Enter the following at the command-prompt:

    c:\sql2ksp3\msde\setup /upgradesp sqlrun securitymode=sql upgradeuser='sa' upgradepwd='mysqlpassword'

    Be sure to change mysqlpassword to the password that you created in Step 3.


    Figure 5: Desktop Engine Configuration Dialog Box

After Installing MSDE SP3

Change the security authentication to mixed mode (i.e. SQL Server and Windows authentication). This is a requirement for connectivity to the WWALMDB.

  1. Restart your machine.

  2. Run Regedit or Regedt32.

  3. Expand the key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer.

  4. Change the LoginMode value to 2.

Confirm MSSQL2000/MSDE SP3 Was Successfully Applied

  1. Start the MSSQLServer Service (if it isn't already started).

  2. From the Command Prompt, enter the following:

    osql -E

    OR

  3. Connect to the MSDE from another query tool such as SQL Query Analyzer (from a remote SQL Server).

  4. Execute the following query:

    select @@version

    go

Related Posts by Categories



Widget by Hoctro | Jack Book
Related Posts with Thumbnails

Our Advertising

Bantuan Pencarian

Jika anda seorang pemula dan tertarik untuk belajar PLC silahkan cek artikel di arsip artikel atau gunakan bantuan pencarian artikel di bawah ini. TQ Bro..

Email Subscribe

Dapatkan informasi dan artikel yang update dari situs ini. Jika anda barminat silahkan masukan email address anda di bawah ini. Terimakasih! (Please write email to subscribe our news).

Enter your email address:

Delivered by FeedBurner

Disclaimer (Privacy Policy)

No PDF Files stored in this site. http://belajarplc.co.nr are not responsible if you download and distribute files or links. Noted that http://belajarplc.co.nr not related in any way with upload files with a copyright material that available for download. Just we collects the information using google search and other search engines links hosted or posted by other website. The link Free Book Download available here are for EDUCATIONAL PURPOSES ONLY... and its recommended to buy the products from the original Owner or Publisher.

For Detail Please Click Here!

Jika anda mempunyai artikel sepurtar dunia automation (PLC dan SCADA) dan ingin sharing buat teman-teman blogger silahkan kirim ke duniaengineering@gmail.com
Terimakasih.

Jika anda menginginkan semua berita yang ada disitus dan links yang ada di situs ini menjadi bagian dari situs yang anda punyai silahkan masukan address ini (copy & paste):
http://feeds2.feedburner.com/belajarplcdanscadaok di fungsi RSS Feeder situs anda.