• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

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