So you want to know what version of SQL you are running on SBS 2008
So you want to know what version of SQL you are running on SBS 2008... run this query in your SQL management studio express...
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition'), SERVERPROPERTY('InstanceName')
Connect to the monitoring database and you get.... 9.00.4035.00, SP3, and Express Edition with Advanced Services, SBSMONITORING
Now you need to use the string \\.\pipe\mssql$microsoft##ssee\sql\query to connect to the rest of the databases on the server.
The Sharepoint is based on Windows Internal database and is 9.00.4035.00 SP3, Windows Internal Database (64bit) MICROSOFT##SSEE
Kewl huh?!
Read the complete post at http://msmvps.com/blogs/bradley/archive/2009/09/21/so-you-want-to-know-what-version-of-sql-you-are-running-on-sbs-2008.aspx