MyLittleAdmin does not show databases list: Retrieving data

Created:

2016-11-16 12:56:51 UTC

Modified:

2017-08-08 13:33:20 UTC

0

Was this article helpful?


Have more questions?

Submit a request

MyLittleAdmin does not show databases list: Retrieving data

Applicable to:

  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

Symptoms

MyLittleAdmin does not show databases list. Event viewer contains the following errors:

URL that was requested does not exist.
The page isn't redirecting properly.

Retrieving data.. is shown

SQL Server 2008 R2 or older is installed.

Cause

Auto Close option is enabled for databases.

Resolution

It is recommended to disable 'AUTO_CLOSE' option if database is used often, on production environment.

Execute the following query for model database:

 ALTER DATABASE model SET AUTO_CLOSE OFF

Execute this script to disable AUTO_CLOSE on all databases:

USE MASTER
declare
@isql varchar(2000),
@dbname varchar(64)

declare c1 cursor for select name from master..sysdatabases where name not in ('master','model','msdb','tempdb')
open c1
fetch next from c1 into @dbname
While @@fetch_status <> -1
begin
select @isql = 'ALTER DATABASE @dbname SET AUTO_CLOSE OFF'
select @isql = replace(@isql,'@dbname',@dbname)
print @isql
exec(@isql)

fetch next from c1 into @dbname
end
close c1
deallocate c1

Additional information available in this article: https://support.microsoft.com/en-us/kb/2160685

Have more questions? Submit a request
Please sign in to leave a comment.