WSI requires the following SQL Server databases:
| Database Name | Purpose |
| es_manager_xxx | Main database for IMP.net. Used to store all hospital data. Note: The last 3-4 characters represent the hospital nickname or pneumonic used to differentiate hospital databases. |
| esm_import | Temporary database used for upgrade purposes only. Provides an additional way to interface with the main database should we need to migrate something unusual. Normal upgrades utilize an XML file to synchronize system tables. |
WSI requires the following SQL Server users:
| User Name | Database Role | Purpose |
| wsi_admin | db_owner | Used by WSI support staff |
| esm_server | db_esm_server_role | Used by IMP.net Windows Services |
| budman | db_esm_export_role | Read-only user used by Budman to pull select data from ESM.net (such as the reporting trees) |
WSI requires the ability to connect to the IMP.net database(s) in order to perform data fixes, upgrades, or perform other support related tasks. The best approach for this is to have SQL Server Management studio available on the app server where WSI would typically have access. Everything could then be managed from the App Server.
Note: Certain database operations may require the assistance and coordination with the site Database Administrator if WSI does not have sufficient access. This includes database backup and restores.
Suggested results: