SBS 2008 Post Installation Issues, WSUS, SQL

Posted on 2009-04-06
Last Modified: 2012-06-27
Hi Guys,

This is another sbs 2008 post install problem i'm having.

Everything installed nicely then I did updates and had a profile problem(with the default admin account created when installing sbs2008), so I renamed profile pathand deleted the reg entry...
HKLM\Software\Microsoft\Windows NT\Current Version\ProfileList relevant user entry...
logged off and logged on again (this fixed profile prob) then I noticed a few other things wrong.

So I'm not sure if the profile fix caused the problems or if it was the updates, as I simply hadnt noticed them while I was trying to fix profile issue.

The last update I installed was MS SQL Server Ex with adv Services service pack 3 (kb955706)

The first thing I noticed was WSUS was not reporting in the SBS console, I then noticed that the Security tab in the console wasnt reporting and the printer wasnt being listed in devices.

So I open Update services snap in in advanced management console, to find a big red X. So I tried to connect to server but couldnt.

So I then tried to open SQL Express Server management but it failed to open.

The event viewer shows the following, on server startup I get 2 identical warnings for SQLBrowser, "SBSMONITORING" and "MICROSOFT##SSEE"...

The configuration of the AdminConnection\TCP protocol in the SQL instace "" is not valid.

When SQL manager crases on startup I get the following info...

Prob event name:              appcrash
App name:                         ssmee.exe
app version:                      2005.90.4035.0
app timestamp:                  492b1643
fault module name:            kernel32.dll
fault module version:         6.0.6001.18000
fault module timestamp:        4791a81d
exception code:                e06d7363
exception offset:                0002f35f
os version:                         6.0.6001.

So back to security tab in console, when i click "view summary of virus protection or view summary of spyware protection I get the message, 'No computers were found'.

The reason I'm giving all this info is I cant help but think its all related to same issue, but that is where I become stuck.

Thanks for the help.
Question by:easiman
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 14

Expert Comment

ID: 24216625
Check which port SQL Server Express is running on?

Also can you connect locally by doing "sqlcmd -S.\sqlexpress" at the command prompt locally on the machine?

You could also try manually setting the following registry key:


NOTE: <MSSQL.x> is the SQL instance. The default instance is "MSSQL.1"

Please change the value "TcpDynamicPort" to 1434 and then click Start->Run,
type: Services.msc -> Restart the SQL Server Browser service and then check
if the error still appears.

NOTE: Using Registry Editor incorrectly can cause serious problems that may
require you to reinstall Windows. Microsoft cannot guarantee that problems
resulting from the incorrect use of Registry Editor can be solved. Use
Registry Editor at your own risk.
sqlcmd -S.\sqlexpress

Open in new window


Author Comment

ID: 24231939
Thanks for the help.

How do I check which port?

When I try to connect locally at the command prompt i get the following...

HResult 0x2, Level 16, State 1
Named pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An Error has occurred while establishing a connection to the server. When connecting to SQL Server 2005. this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

When I look up the registry key above the path stops at...


the only entry I have at this point is 'Np', nothing else.

I Hope this sheds some light.

Accepted Solution

easiman earned 0 total points
ID: 25354022
Turns out the profiles were corrrupt so i had to delete them and start again

Expert Comment

ID: 34340133
What profiles were corrupt and how did you delete them?  

Thanks, I am getting this exact same error and I want to clarify exactly what was done before I assume incorrectly.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor ( Top Charts is a view in which you can set seve…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question