Could not access the Search administration database, SharePoint 2010

Could not access the Search administration database. A generic error occurred while trying to access the database to obtain the schema version info.

I encounterd this error before but forgot to blog about it, when I search the internet I do find several solutions.
http://www.google.co.uk/url?sa=t&rct=j&q=could%20not%20access%20the%20search%20administration%20database&source=web&cd=1&ved=0CFoQFjAA&url=http%3A%2F%2Fsureshsundar21.blogspot.com%2F2010%2F07%2Fcould-not-access-search-administration.html&ei=-7_oT-C4KcrW8QO_26CkCg&usg=AFQjCNEp5r6GolVYkb3RqsNQoA-GSWA75w

http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/71f0de97-6245-4dfd-80d0-75a55d3bc498

But what is causing this? In my case it's that I'm using a Named Instance with Dynamic IP-Port settings. The simple way to get rid of this error is by changing the Dynamic Port to the default port 1433 for all available IP entries in SQL Server Configuration Manager.

1. Click Protocols for <INSTANCE>
2. Right click TCP/IP and select Properties
3. Remove the 0 on the TCP Dynamic Ports
4. Enter the 1433 port number on the TCP Port
5. Click OK and restart the SQL Server (<INSTANCE>) Service