Windows Sharepoint Services 3.0 SP2 problem

I recently applied SP2 to WSS 3.0 and came across the problem that from what I can find has been pretty widespread.

I'm currently getting "Cannot connect to configuration database"

I have:

* Restarted Microsoft##SSEE service, W3C service and Sharepoint Service
* Rebooted the server (required to apply updates)
* Run "psconfig -cmd upgrade -inplace b2b -wait -force"
* Been through http://support.microsoft.com/kb/944154 which failed, see below:

<snip>
Performing configuration task 3 of 4
Upgrading SharePoint Products and Technologies...

Failed to upgrade SharePoint Products and Technologies.

An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown.
  Additional exception information: Upgrade completed with errors.  Review the u
pgrade.log file located in C:\Program Files\Common Files\Microsoft Shared\Web Se
rver Extensions\12\Logs\Upgrade.log.  The number of errors and warnings is liste
d at the end of the upgrade log file.

Total number of configuration settings run: 3
Total number of successful configuration settings: 2
Total number of unsuccessful configuration settings: 1
Successfully stopped the configuration of SharePoint Products and Technologies.
Configuration of SharePoint Products and Technologies failed.  Configuration mus
t be performed before you use SharePoint Products and Technologies.  For further
 details, see the diagnostic log located at C:\Program Files\Common Files\Micros
oft Shared\Web Server Extensions\12\LOGS\PSCDiagnostics_6_15_2010_11_1_53_312_19
65996320.log and the application event log.

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsa
dm -o upgrade -inplace -url http://intranet

Database state cannot be changed while other users are using the database 'Share
Point_Config_3f2203a2-d36f-4784-86bf-bc80a30428c2'
ALTER DATABASE statement failed.
sp_dboption command failed.

* Checked DB permissions in Microsoft SQL Server Management Studio Express, Sharepoint_Config database seems to be inaccessible, see below.

===================================

The database SharePoint_Config_3f2203a2-d36f-4784-86bf-bc80a30428c2 is not accessible. (Microsoft.SqlServer.Express.ObjectExplorer)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DatabaseNavigableItem.GetChildren()
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SummaryView.get_Items()
   at Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage.CopyItems(ISummaryView summaryView)
   at Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage..ctor(ISummaryView summaryView, List`1 columnDescriptors)
   at Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneListViewer.PopulateView()

Event log shows the following, I know this can be a permission problem but since it doesn't mention the login details maybe something else?

SQL Database 'SharePoint_Config_3f2203a2-d36f-4784-86bf-bc80a30428c2' on SQL Server instance 'SERVER\Microsoft##SSEE' not found. Additional error information from SQL Server is included below.

Cannot open database "SharePoint_Config_3f2203a2-d36f-4784-86bf-bc80a30428c2" requested by the login. The login failed.

I also get the following but have had these for a while and they've never caused issues although getting a lot more of them at the moment especially when trying any operations on the databases.

The description for Event ID ( 17137 ) in Source ( MSSQL$MICROSOFT##SSEE ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Lansweeper32.

I'm no database/Sharepoint guru so if anyone out there with more knowledge of this problem can point me in the right direction would be greatly appreciated.