• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Can't execute sp_configure to enable clr option on plesk

hamid

New Pleskian
Hi.
I need to add a dll assembly file to my website in plesk, so i have to introduce this assembly to SQL Server. But first i should enable CLR in SQL Server by executing the sp_configure store procedure. In webadmin of plesk, i wrote this query on query manager.
//
exec sp_configure 'clr enabled', '1'
go
reconfigure
//
but nothing happens after running the query.when check the sys.configuration table using (select * from sys.configuration where name='clr enabled'), i see that the value field of retrieved record is still remained 0. I guess i need to have the execution grant on this store procedure.please help and guide me what should i do.
By regards
 
Back
Top