Product(s):	APM Implementation and Performance Management
	Version(s):	Pro 2.0
	Environment:	Standalone computer
	Area:	N/A
	Subarea:	N\A

Problem

ODBC exception when installing EXP Pro 2.0 on a 64-bit computer, with Windows 7 OS.

ODBC Exception Caught:

Index #0
Message:[Microsoft][SQL Native Client][SQL Server]Login failed for user 'Ivara'.
NativeError: 18456
Source:
SQL State: 28000
Index #1
Message:[Microsoft][SQL Native Client][SQL Server]Login failed for user 'Ivara'.
NativeError: 18456
Source:
SQL State: 28000

Solution

You will need to manually install the database. If you do not have SQL Server Management Studio installed on your PC, you will need to install it, and the complete the following steps.

Restore the EXP Professional Database

• • Launch SQLServer Management Studio  - Connect using Windows Authentication

• • Restore Database - RMBC on Databases, select Restore Database:

• • Set To Database = EXPProfessional
  • Select From device, and Browse to find the database bak file that you want to use.
  • If starting from fresh, locate the “install_exppro.bak” file in the unzipped EXP PRO package:

• • Check the Restore checkbox and  Click OK – the database will be created and restored within a minute.

• • Click OK on the completion dialogue.

Run the initialization query

• • Expand the Databases node and RMBC on the EXPProfessional db, select New Query:

• • Use the Open file icon to locate the init_exppro.sql file from the EXPPRO package, and select Open:

• • On return to the main screen, select Execute:

• • The following messages indicates success:

Adding login 'ivara'.   *** Remember to change the password. ***
Dropping view oq.IvaraSchema
Creating view oq.IvaraSchema
Changing db owner to 'ivara'.

Note:  Please ignore the part about changing the password, this is not required.

• • Exit Management Studio.

Install the EXP Client

• • Locate the EXP Professional install files and launch setup application:

• • Allow SQL 2005 Native client and SMO to be installed.
  • Click Next, accept the terms of the license agreement, click Next again
  • Select Network Setup type:

• • Click Next to the ODBC DSN setup screen and ensure it is set to Create new ODBC datasource:

• • Click Next to the Database Server screen, do not change authentication type, enter ‘ivara’ as the password and click Next.

• • Select the EXPProfessional db from the list presented and click OK

• • Continue the install by clicking Next until you get to the end and click finish:

• • An Icon is created on the Desktop, you can launch the application from there.

• • Enter your license Key, and EXP Professional is ready to be used.

See Also

N/A.

Original Author:

Roy Suthers