Thank you for your feedback.

Was this useful?

Recreating the PTP logins following a database restore

Article ID
kba-03297
Article Name
Recreating the PTP logins following a database restore
Created Date
20th June 2014
Product
Problem
When an SQL Database has been restored it will be necessary to recreate the PTP Logins so the Accounts Production Software can connect to the correct database.
Resolution

The steps below will take you through the process of recreating these logins

For Windows 7 or Server 2008 Users:

Click the Start button
Type CMD into the Search Box and press Enter

For Windows 8 or Server 2012 Users:

Press the Windows Key and type CMD
Click on the Command Prompt Icon

Recreating the Logins

Once the command prompt is open, you need to change to the installation folder.  It is assumed you are using the default C:IRIS
Type CD and press Enter
Type CD IRIS and then press Enter
Type Hostname and press Enter.  This will display the name of the machine
Type createpracticelogin hostnamePTPACCOUNTS PTPACCTS and press Enter.  Hostname will be the result provided from the previous step, PTPACCOUNTS is the SQL Instance name used for PTP and PTPACCTS is the database name.

It should now be possible to use PTP Accounts Production in the normal way.

Thank you for your feedback.

Was this useful?