[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


SBS 2008 Post Installation Issues, WSUS, SQL

Posted on 2009-04-06
Medium Priority
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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

649 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