Troubleshooting: VE Search Does Not Work
The VE Search functionality may fail if the project database encounters an error when adding an assembly. This typically occurs because the database user lacks the necessary permissions to add assemblies in the project database.
You will see the following error message in such cases.
To resolve this issue, grant the required permissions to the database user. After ensuring permissions are correctly assigned, follow the step-by-step instructions below to fix the search functionality.
Step-by-Step Solution
Step 1: Verify and Update Settings in Visual Expert
- Open Visual Expert.
- Navigate to the Project where the Search functionality is not working.
- Click on the Settings tab.
- Select More Settings to open the Settings dialog.
- Go to the Maintenance tab.
- Click on Install SQL Server Macro.
Upon successful installation, you will receive a confirmation message as shown below:
Step 2: Handle Additional SQL Server Errors
If you encounter an error dialog during Step 6, execute the following SQL queries in SQL Server Management Studio (SSMS) to fix the issue:
EXEC sp_configure 'show advanced options', 1; RECONFIGURE; EXEC sp_configure 'clr strict security', 0; RECONFIGURE;
After running the above commands, go back to Visual Expert and re-execute the Install SQL Server Macro option from the Maintenance tab.
Step 3: Reset Security Settings
Once the macro is installed successfully, reset the clr strict security option to its original value by running the following commands in SSMS:
EXEC sp_configure 'show advanced options', 1; RECONFIGURE; EXEC sp_configure 'clr strict security', 1; RECONFIGURE;
The Basic Support Level provides essential assistance, ideal for Visual Expert Basic license users seeking standard support and regular updates.
Additional Notes
- Always ensure the database user has adequate permissions before starting the resolution process.
- Resetting the clr strict security option is essential to maintain secure configurations post-resolution.