Update Failure - Login failed for user '$'
Article ID
ias-6038
Article Name
Update Failure - Login failed for user '$'
Created Date
11th April 2008
Product
Problem
It has been identified that when trying to update the IRIS Practice Suite the installation will fail.
On investigation of the DBCreate.log file the following error is apparent.
Set_Simple_Recovery_Model 0 It has not been possible to set the current database to simple recovery model Login failed for user <
Resolution
Following the steps below may help to resolve the issue.
IMPORTANT: Serious problems might occur if you modify the SQL Server pemissions incorrectly. The problems might require that you reinstall the operating system. IRIS cannot guarantee that these problems can be resolved. Modify the SQL Server permissions at your own risk
- Open Microsoft SQL Server Management Studio
- Click Connect
- Click + next to Security
- Right-Click Logins
- Click New Login
- In the Login Name box enter the login name detailed in the error.
- Click Server Roles
- Tick the Box sysadmin
- Click OK
- Close all screens and retry the installation
NOTE: IRIS cannot provide any further information on adding or amending user permissions with the SQL Server. Should additional assistance be required please contact your own IT Support provider.
Share This Page
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.
