Enable CLR Integration in SQL Server 2008

By default the common language runtime (CLR) integration feature is turned off. If it is turned off, SQL server won't be able to access the custom assemlies that are part of your database (if the database contains objects that are coded to use CLR integration). CLRmust be enabled in order to use objects that are coded to use CLR integration.

To check :
Open SQL Management Studio, click on the "New Query" button. In the query window paste the following and click the "Execute" button :

Code: 

SELECT * FROM sys.configurations
WHERE name = 'clr enabled'

To enable CLR integration, use the clr enabled option of the sp_configure stored procedure:

Execute the below query :

Code: 

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO

Then click the "Execute" button to run the stored procedure.

In the SQL Server "Messages" window you should see messages similar to below ones :

Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
Configuration option 'clr enabled' changed from 0 to 1. Run the RECONFIGURE statement to install.

That's all..!!

READ FULL STORY

Kentico, unable to update/modify and save Master page

Find the following line in your web.config file :

<httpRuntime maxRequestLength="2097151" waitChangeNotification="1" maxWaitChangeNotification="3600" />

Change it to:

<httpRuntime requestValidationMode="2.0" maxRequestLength="2097151" waitChangeNotification="1" maxWaitChangeNotification="3600" />

Request Validation Mode property gets or sets a version number that indicates which ASP.NET version-specific approach to validation will be used.

Let me know if it works for you..!!

READ FULL STORY

How to Use the Net User Command to Manage Users - Windows

To add a new user :
net user /add username
Eg : net user /add tom
To delete a user :
net user /delete username
Eg : net user /delete tom
To change password of a user :
net user username {password}
Eg: net user tom pass123
To allow a user to change his own password :
net user username /passwordchg:yes
Eg: net user tom /passwordchg:yes
To specify that a user should have a password :
net user username /passwordreq:{yes|no}
Eg: net user tom /passwordreq:yes
To set expiration :
net user username /expires:{date|never}
Eg: net user tom /expires:06/29/2013

READ FULL STORY

Your PHP installation appears to be missing the MySQL extension which is required by WordPress - Windows

If you already have php and Mysql installed in your system/server and still getting the error, some changes need to be made in your php.ini file,
Open your php.ini file and search for extension=php_mysql.dll, uncomment the line (remove the semicolon in the beginning of the line)
Then search for extension_dir in php.ini file and change extension_dir =”C:\php\ext” if it is not.
Note : You need two sql dll files, php_mysql.dll and libmysql.dll which together provide you PHP mysql extension, first check in ext folder (C:\php\ext) in your PHP installation location.
if you don’t have ext folder, you need to download PHP zip version (http://windows.php.net/download/) containing those required files. Then copy ext folder to your PHP installation location,also copy libmysql.dll to your PHP installation location.
libmysql.dll should be reachable in your system, so copy it to c:\windows\system32.

Once you have done the above steps, restart IIS. That will work...

READ FULL STORY