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.
We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.