Mon, Sep 21 2009 22:05
bradley
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?!
Filed under: SQL Server
![[There's a reason that Yoda is the unofficial mascot of SBS. Size indeed matters not.]](http://www.sbslinks.com/images/headertop.png "There's a reason that Yoda is the unofficial mascot of SBS. Size indeed matters not!")