Sunday 31 March 2013

annot open database "DATABASENAME" requested by the login. The login failed. Login failed for user 'DATABASEUSER\IWAM_plesk(default)'.

If your website shows following error while accessing, then refer to the steps mentioned below to resolve it:

Cannot open database "DATABASENAME" requested by the login. The login failed.
Login failed for user 'DATABASEUSER\IWAM_plesk(default)'.

   1. On the windows server, right-click "My Computer" and select "Manage".

   2. Navigate to Local Users and Groups >> Users >> <Username>.


   3. Right-click on <User> and select Properties.


   4. Under the "Member Of" tab, click on Add >> Advanced >> Find Now.


   5. Select SQLServer2005MSSQLUser$<MachineName>$SQLExpress and click OK and OK to add this user to the group.


   6. Restart IIS services.

No comments:

Post a Comment