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.
Auto Close option is enabled for databases.
It is recommended to disable 'AUTO_CLOSE' option if database is used often, on production environment.
Execute the following query for
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