Troubleshooting - User instance error in SQL Server 2005 Express

Generating user interfaces in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instance.

1. Download SQL Server Management Studio Express. You can download this software for free from Microsoft website.
2. Press Ctrl+N or Click File->New->Query with Current Connection and input query and execute:

    exec sp_configure