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?!


Comments are closed.