Applicable to:
- Plesk for Windows
Symptoms
-
MyLittleAdmin shows "Retrieving data.." instead of a list of databases. The following error message appears in Windows Event viewer:
CONFIG_TEXT: URL that was requested does not exist.
The page isn't redirecting properly. -
SQL Server 2008 R2 or newer is installed.
Cause
The Auto Close option is enabled for databases.
Resolution
It is recommended to disable the 'AUTO_CLOSE' option if a database is used often on a production environment.
-
Connect to the Plesk server via RDP.
-
Start SQL Management Studio (if it is not installed, download and install it).
-
Run the following query:
CONFIG_TEXT: ALTER DATABASE model SET AUTO_CLOSE OFF
-
Run this script to disable AUTO_CLOSE on all databases:
CONFIG_TEXT: 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
Comments
3 comments
Hi,
will it impact the sever performance?
Plesk for windows does not show mylittleadmin for SQL SERVER 2019 as it shows myPHPadmin for marioDB.So i am unable to reach to the Host URL ? kindly assist me on this.Thanks
Hi there Arslaan Mazhar,
myLittleAdmin works fine with Microsoft SQL Server 2019 in Plesk.
It might be that myLittleAdmin is not installed on your Windows server.
Check out this KB article for installation instructions.
Please sign in to leave a comment.