How to recreate the database Logins after a database restore

Introduction

This topic explains the necessary steps to recreate the IRIS logins after a database restore.

 

For Windows XP

  1. Click Start and select Run – type cmd into the search bar and click OK.

 

 

For Vista or Windows 7

  1. You will need to locate the Command Prompt from the Start Menu ( Start, Programs, Accessories).

  2. Right-click on Command Prompt and select Run as administrator:

 

  1. This will open a command prompt. You now need to change to the IRIS or TT folder.

  2. If the Iris folder is in C:\IRIS\ type in “ cd\IRIS“ and press Enter.

  3. If the Iris folder is in C:\Apps\IRIS\ then type in "cd \APPS\IRIS" and press Enter.

 

  1. Type "createpracticelogin computername\instancename databasename" and press Enter.

 

  1. Once complete this will say “…Reconnect to existing Iris Practice Database…Common login created… Process complete ",


It should now be possible to load IRIS.