WSUS Problem - Error connecting to the Windows Server Update Servi

Hello,

I'm trying to set up a 2000 SP4 Server for WSUS. I followed the step by step
guide line by line. But I keep getting an error message when I try to
administer WSUS. I keep getting "Error connecting to the Windows Server
Update Services database" I checked the event log, and I don't get any
errors in either the Application, or System area's.

I can't find much info on how to check the connection of the WSUS service
and the SQL database. I'm running both on the same machine. I installed the
MSDE and the patch during the install of WSUS.

Anyone else trouble shoot this similar situation or know how to check the
connection between WSUS and SQL? I'm sure I'm one step away from getting this
thing running...

Thanks in advance!

Jeff

What exactly are you trying to do when you get this error? Just
opening the WSUS Admin page, or while trying to view updates, or
something else?

On Thu, 7 Jul 2005 13:24:03 -0700, "Jeff Baublitz"
<JeffBaublitz@discussions.microsoft.com> wrote:

>Hello,
>
>I'm trying to set up a 2000 SP4 Server for WSUS. I followed the step by step
>guide line by line. But I keep getting an error message when I try to
>administer WSUS. I keep getting "Error connecting to the Windows Server
>Update Services database" I checked the event log, and I don't get any
>errors in either the Application, or System area's.
>
>I can't find much info on how to check the connection of the WSUS service
>and the SQL database. I'm running both on the same machine. I installed the
>MSDE and the patch during the install of WSUS.
>
>Anyone else trouble shoot this similar situation or know how to check the
>connection between WSUS and SQL? I'm sure I'm one step away from getting this
>thing running...
>
>Thanks in advance!
>
>Jeff

I get the error right when I open the admin page. I can't get into WSUS at
all.

"JeffG" wrote:

> What exactly are you trying to do when you get this error? Just
> opening the WSUS Admin page, or while trying to view updates, or
> something else?
>
> On Thu, 7 Jul 2005 13:24:03 -0700, "Jeff Baublitz"
> <JeffBaublitz@discussions.microsoft.com> wrote:
>
> >Hello,
> >
> >I'm trying to set up a 2000 SP4 Server for WSUS. I followed the step by step
> >guide line by line. But I keep getting an error message when I try to
> >administer WSUS. I keep getting "Error connecting to the Windows Server
> >Update Services database" I checked the event log, and I don't get any
> >errors in either the Application, or System area's.
> >
> >I can't find much info on how to check the connection of the WSUS service
> >and the SQL database. I'm running both on the same machine. I installed the
> >MSDE and the patch during the install of WSUS.
> >
> >Anyone else trouble shoot this similar situation or know how to check the
> >connection between WSUS and SQL? I'm sure I'm one step away from getting this
> >thing running...
> >
> >Thanks in advance!
> >
> >Jeff
>
>

Jeff,

What is the instance name of the MSDE database? For WSUS, the instance has
to be named as %machine-name%\wsus. Please refer the deployment guide for
more info.

"Jeff Baublitz" <JeffBaublitz@discussions.microsoft.com> wrote in message
news:56209BA9-B426-4AA1-95B2-32450DE32096@microsoft.com...
> I get the error right when I open the admin page. I can't get into WSUS at
> all.
>
> "JeffG" wrote:
>
> > What exactly are you trying to do when you get this error? Just
> > opening the WSUS Admin page, or while trying to view updates, or
> > something else?
> >
> > On Thu, 7 Jul 2005 13:24:03 -0700, "Jeff Baublitz"
> > <JeffBaublitz@discussions.microsoft.com> wrote:
> >
> > >Hello,
> > >
> > >I'm trying to set up a 2000 SP4 Server for WSUS. I followed the step by
step
> > >guide line by line. But I keep getting an error message when I try to
> > >administer WSUS. I keep getting "Error connecting to the Windows Server
> > >Update Services database" I checked the event log, and I don't get any
> > >errors in either the Application, or System area's.
> > >
> > >I can't find much info on how to check the connection of the WSUS
service
> > >and the SQL database. I'm running both on the same machine. I installed
the
> > >MSDE and the patch during the install of WSUS.
> > >
> > >Anyone else trouble shoot this similar situation or know how to check
the
> > >connection between WSUS and SQL? I'm sure I'm one step away from
getting this
> > >thing running...
> > >
> > >Thanks in advance!
> > >
> > >Jeff
> >
> >

Hi.

I am running into the same problem. My WSUS server had been running
perfectly fine until now.

The instance name of the MSDE database is just as it should be
%machine-name%\wsus.

Here is the error right out of Event Viewer:

Event Type: Error
Event Source: Windows Server Update Services
Event Category: Update Services Service
Event ID: 421
Date: 7/12/2005
Time: 10:16:29 AM
User: N/A
Computer: TAISVR4
Description:
Connection to database failed. Reason=Cannot open database requested in
login 'SUSDB'. Login fails.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.. Connection string:
Data Source=TAISVR4\WSUS;Initial Catalog=SUSDB;Connection
Timeout=60;Application Name=WSUS SQL
Connection;Trusted_Connection=Yes;Pooling='true'; Max Pool Size = 100

Any ideas?

Thanks.

->Jeff

"Siva Shanmugam [MSFT]" wrote:

> Jeff,
>
> What is the instance name of the MSDE database? For WSUS, the instance has
> to be named as %machine-name%\wsus. Please refer the deployment guide for
> more info.
>
> "Jeff Baublitz" <JeffBaublitz@discussions.microsoft.com> wrote in message
> news:56209BA9-B426-4AA1-95B2-32450DE32096@microsoft.com...
> > I get the error right when I open the admin page. I can't get into WSUS at
> > all.
> >
> > "JeffG" wrote:
> >
> > > What exactly are you trying to do when you get this error? Just
> > > opening the WSUS Admin page, or while trying to view updates, or
> > > something else?
> > >
> > > On Thu, 7 Jul 2005 13:24:03 -0700, "Jeff Baublitz"
> > > <JeffBaublitz@discussions.microsoft.com> wrote:
> > >
> > > >Hello,
> > > >
> > > >I'm trying to set up a 2000 SP4 Server for WSUS. I followed the step by
> step
> > > >guide line by line. But I keep getting an error message when I try to
> > > >administer WSUS. I keep getting "Error connecting to the Windows Server
> > > >Update Services database" I checked the event log, and I don't get any
> > > >errors in either the Application, or System area's.
> > > >
> > > >I can't find much info on how to check the connection of the WSUS
> service
> > > >and the SQL database. I'm running both on the same machine. I installed
> the
> > > >MSDE and the patch during the install of WSUS.
> > > >
> > > >Anyone else trouble shoot this similar situation or know how to check
> the
> > > >connection between WSUS and SQL? I'm sure I'm one step away from
> getting this
> > > >thing running...
> > > >
> > > >Thanks in advance!
> > > >
> > > >Jeff
> > >
> > >
>
>
>

Hi Siva,

How can I check the instance name for the MSDE database? Is it the service
that runs for SQL? If so the service name is MSSQL$WSUS. It's started and
running.

As a side note, when I click on the SQL icon in the task bar, it shows
nothing conected. When I click on 'open SQL server service manager' nothing
is connected. And when I try to connect to the server name nothing happens...

Any ideas what I can check, or any more info I can get you?

Thanks

Jeff



"Siva Shanmugam [MSFT]" wrote:

> Jeff,
>
> What is the instance name of the MSDE database? For WSUS, the instance has
> to be named as %machine-name%\wsus. Please refer the deployment guide for
> more info.
>
> "Jeff Baublitz" <JeffBaublitz@discussions.microsoft.com> wrote in message
> news:56209BA9-B426-4AA1-95B2-32450DE32096@microsoft.com...
> > I get the error right when I open the admin page. I can't get into WSUS at
> > all.
> >
> > "JeffG" wrote:
> >
> > > What exactly are you trying to do when you get this error? Just
> > > opening the WSUS Admin page, or while trying to view updates, or
> > > something else?
> > >
> > > On Thu, 7 Jul 2005 13:24:03 -0700, "Jeff Baublitz"
> > > <JeffBaublitz@discussions.microsoft.com> wrote:
> > >
> > > >Hello,
> > > >
> > > >I'm trying to set up a 2000 SP4 Server for WSUS. I followed the step by
> step
> > > >guide line by line. But I keep getting an error message when I try to
> > > >administer WSUS. I keep getting "Error connecting to the Windows Server
> > > >Update Services database" I checked the event log, and I don't get any
> > > >errors in either the Application, or System area's.
> > > >
> > > >I can't find much info on how to check the connection of the WSUS
> service
> > > >and the SQL database. I'm running both on the same machine. I installed
> the
> > > >MSDE and the patch during the install of WSUS.
> > > >
> > > >Anyone else trouble shoot this similar situation or know how to check
> the
> > > >connection between WSUS and SQL? I'm sure I'm one step away from
> getting this
> > > >thing running...
> > > >
> > > >Thanks in advance!
> > > >
> > > >Jeff
> > >
> > >
>
>
>

I am having the exact same problem. Except I am in a frontend/backend
configuration and SQL server 2000 Enterprise in the backend. Also my login
failed says for NT Authority\anonymous logon in the event id 421.
Any help would be much appreciated.

Thanks,

Josh Warcop
jwarcop@nspi.com

"Jeff Mesch" <Jeff Mesch@discussions.microsoft.com> wrote in message
news:1AFB6455-9B97-40C1-930D-7C88C65E83FD@microsoft.com...
> Hi.
>
> I am running into the same problem. My WSUS server had been running
> perfectly fine until now.
>
> The instance name of the MSDE database is just as it should be
> %machine-name%\wsus.
>
> Here is the error right out of Event Viewer:
>
> Event Type: Error
> Event Source: Windows Server Update Services
> Event Category: Update Services Service
> Event ID: 421
> Date: 7/12/2005
> Time: 10:16:29 AM
> User: N/A
> Computer: TAISVR4
> Description:
> Connection to database failed. Reason=Cannot open database requested in
> login 'SUSDB'. Login fails.
> Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.. Connection string:
> Data Source=TAISVR4\WSUS;Initial Catalog=SUSDB;Connection
> Timeout=60;Application Name=WSUS SQL
> Connection;Trusted_Connection=Yes;Pooling='true'; Max Pool Size = 100
>
> Any ideas?
>
> Thanks.
>
> ->Jeff
>
> "Siva Shanmugam [MSFT]" wrote:
>
>> Jeff,
>>
>> What is the instance name of the MSDE database? For WSUS, the instance
>> has
>> to be named as %machine-name%\wsus. Please refer the deployment guide for
>> more info.
>>
>> "Jeff Baublitz" <JeffBaublitz@discussions.microsoft.com> wrote in message
>> news:56209BA9-B426-4AA1-95B2-32450DE32096@microsoft.com...
>> > I get the error right when I open the admin page. I can't get into WSUS
>> > at
>> > all.
>> >
>> > "JeffG" wrote:
>> >
>> > > What exactly are you trying to do when you get this error? Just
>> > > opening the WSUS Admin page, or while trying to view updates, or
>> > > something else?
>> > >
>> > > On Thu, 7 Jul 2005 13:24:03 -0700, "Jeff Baublitz"
>> > > <JeffBaublitz@discussions.microsoft.com> wrote:
>> > >
>> > > >Hello,
>> > > >
>> > > >I'm trying to set up a 2000 SP4 Server for WSUS. I followed the step
>> > > >by
>> step
>> > > >guide line by line. But I keep getting an error message when I try
>> > > >to
>> > > >administer WSUS. I keep getting "Error connecting to the Windows
>> > > >Server
>> > > >Update Services database" I checked the event log, and I don't get
>> > > >any
>> > > >errors in either the Application, or System area's.
>> > > >
>> > > >I can't find much info on how to check the connection of the WSUS
>> service
>> > > >and the SQL database. I'm running both on the same machine. I
>> > > >installed
>> the
>> > > >MSDE and the patch during the install of WSUS.
>> > > >
>> > > >Anyone else trouble shoot this similar situation or know how to
>> > > >check
>> the
>> > > >connection between WSUS and SQL? I'm sure I'm one step away from
>> getting this
>> > > >thing running...
>> > > >
>> > > >Thanks in advance!
>> > > >
>> > > >Jeff
>> > >
>> > >
>>
>>
>>

Yes. It is the service that is running. You have installed the instance as
%machinename%\wsus.

When you use the service manager, enter #machinename#\wsus against the
server name. Replace #machinename# with the real machine name and try to
refresh the services (by clicking on the refresh services button).



"Jeff Baublitz" <JeffBaublitz@discussions.microsoft.com> wrote in message
news:75D90108-A42C-4CDE-BC40-ABC0DA344942@microsoft.com...
> Hi Siva,
>
> How can I check the instance name for the MSDE database? Is it the service
> that runs for SQL? If so the service name is MSSQL$WSUS. It's started and
> running.
>
> As a side note, when I click on the SQL icon in the task bar, it shows
> nothing conected. When I click on 'open SQL server service manager'
> nothing
> is connected. And when I try to connect to the server name nothing
> happens...
>
> Any ideas what I can check, or any more info I can get you?
>
> Thanks
>
> Jeff
>
>
>
> "Siva Shanmugam [MSFT]" wrote:
>
>> Jeff,
>>
>> What is the instance name of the MSDE database? For WSUS, the instance
>> has
>> to be named as %machine-name%\wsus. Please refer the deployment guide for
>> more info.
>>
>> "Jeff Baublitz" <JeffBaublitz@discussions.microsoft.com> wrote in message
>> news:56209BA9-B426-4AA1-95B2-32450DE32096@microsoft.com...
>> > I get the error right when I open the admin page. I can't get into WSUS
>> > at
>> > all.
>> >
>> > "JeffG" wrote:
>> >
>> > > What exactly are you trying to do when you get this error? Just
>> > > opening the WSUS Admin page, or while trying to view updates, or
>> > > something else?
>> > >
>> > > On Thu, 7 Jul 2005 13:24:03 -0700, "Jeff Baublitz"
>> > > <JeffBaublitz@discussions.microsoft.com> wrote:
>> > >
>> > > >Hello,
>> > > >
>> > > >I'm trying to set up a 2000 SP4 Server for WSUS. I followed the step
>> > > >by
>> step
>> > > >guide line by line. But I keep getting an error message when I try
>> > > >to
>> > > >administer WSUS. I keep getting "Error connecting to the Windows
>> > > >Server
>> > > >Update Services database" I checked the event log, and I don't get
>> > > >any
>> > > >errors in either the Application, or System area's.
>> > > >
>> > > >I can't find much info on how to check the connection of the WSUS
>> service
>> > > >and the SQL database. I'm running both on the same machine. I
>> > > >installed
>> the
>> > > >MSDE and the patch during the install of WSUS.
>> > > >
>> > > >Anyone else trouble shoot this similar situation or know how to
>> > > >check
>> the
>> > > >connection between WSUS and SQL? I'm sure I'm one step away from
>> getting this
>> > > >thing running...
>> > > >
>> > > >Thanks in advance!
>> > > >
>> > > >Jeff
>> > >
>> > >
>>
>>
>>

Can you check the following in registry?

Under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Update Services\Server\Setup,
check to see if the value of "SqlServerName" key is %computername%\WSUS





"Jeff Baublitz" <JeffBaublitz@discussions.microsoft.com> wrote in message
news:75D90108-A42C-4CDE-BC40-ABC0DA344942@microsoft.com...
> Hi Siva,
>
> How can I check the instance name for the MSDE database? Is it the service
> that runs for SQL? If so the service name is MSSQL$WSUS. It's started and
> running.
>
> As a side note, when I click on the SQL icon in the task bar, it shows
> nothing conected. When I click on 'open SQL server service manager'
> nothing
> is connected. And when I try to connect to the server name nothing
> happens...
>
> Any ideas what I can check, or any more info I can get you?
>
> Thanks
>
> Jeff
>
>
>
> "Siva Shanmugam [MSFT]" wrote:
>
>> Jeff,
>>
>> What is the instance name of the MSDE database? For WSUS, the instance
>> has
>> to be named as %machine-name%\wsus. Please refer the deployment guide for
>> more info.
>>
>> "Jeff Baublitz" <JeffBaublitz@discussions.microsoft.com> wrote in message
>> news:56209BA9-B426-4AA1-95B2-32450DE32096@microsoft.com...
>> > I get the error right when I open the admin page. I can't get into WSUS
>> > at
>> > all.
>> >
>> > "JeffG" wrote:
>> >
>> > > What exactly are you trying to do when you get this error? Just
>> > > opening the WSUS Admin page, or while trying to view updates, or
>> > > something else?
>> > >
>> > > On Thu, 7 Jul 2005 13:24:03 -0700, "Jeff Baublitz"
>> > > <JeffBaublitz@discussions.microsoft.com> wrote:
>> > >
>> > > >Hello,
>> > > >
>> > > >I'm trying to set up a 2000 SP4 Server for WSUS. I followed the step
>> > > >by
>> step
>> > > >guide line by line. But I keep getting an error message when I try
>> > > >to
>> > > >administer WSUS. I keep getting "Error connecting to the Windows
>> > > >Server
>> > > >Update Services database" I checked the event log, and I don't get
>> > > >any
>> > > >errors in either the Application, or System area's.
>> > > >
>> > > >I can't find much info on how to check the connection of the WSUS
>> service
>> > > >and the SQL database. I'm running both on the same machine. I
>> > > >installed
>> the
>> > > >MSDE and the patch during the install of WSUS.
>> > > >
>> > > >Anyone else trouble shoot this similar situation or know how to
>> > > >check
>> the
>> > > >connection between WSUS and SQL? I'm sure I'm one step away from
>> getting this
>> > > >thing running...
>> > > >
>> > > >Thanks in advance!
>> > > >
>> > > >Jeff
>> > >
>> > >
>>
>>
>>

Just FYI.

It seemed to be corruption with the database on my end. I tried reinstalling
WSUS and leaving the database alone, but that didn't fix it.

As soon as I whacked the database and reinstalled, it was fine. Only
downside of course is re-doing all the approvals etc.

->Jeff

"Jeff Mesch" wrote:

> Hi.
>
> I am running into the same problem. My WSUS server had been running
> perfectly fine until now.
>
> The instance name of the MSDE database is just as it should be
> %machine-name%\wsus.
>
> Here is the error right out of Event Viewer:
>
> Event Type: Error
> Event Source: Windows Server Update Services
> Event Category: Update Services Service
> Event ID: 421
> Date: 7/12/2005
> Time: 10:16:29 AM
> User: N/A
> Computer: TAISVR4
> Description:
> Connection to database failed. Reason=Cannot open database requested in
> login 'SUSDB'. Login fails.
> Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.. Connection string:
> Data Source=TAISVR4\WSUS;Initial Catalog=SUSDB;Connection
> Timeout=60;Application Name=WSUS SQL
> Connection;Trusted_Connection=Yes;Pooling='true'; Max Pool Size = 100
>
> Any ideas?
>
> Thanks.
>
> ->Jeff
>
> "Siva Shanmugam [MSFT]" wrote:
>
> > Jeff,
> >
> > What is the instance name of the MSDE database? For WSUS, the instance has
> > to be named as %machine-name%\wsus. Please refer the deployment guide for
> > more info.
> >
> > "Jeff Baublitz" <JeffBaublitz@discussions.microsoft.com> wrote in message
> > news:56209BA9-B426-4AA1-95B2-32450DE32096@microsoft.com...
> > > I get the error right when I open the admin page. I can't get into WSUS at
> > > all.
> > >
> > > "JeffG" wrote:
> > >
> > > > What exactly are you trying to do when you get this error? Just
> > > > opening the WSUS Admin page, or while trying to view updates, or
> > > > something else?
> > > >
> > > > On Thu, 7 Jul 2005 13:24:03 -0700, "Jeff Baublitz"
> > > > <JeffBaublitz@discussions.microsoft.com> wrote:
> > > >
> > > > >Hello,
> > > > >
> > > > >I'm trying to set up a 2000 SP4 Server for WSUS. I followed the step by
> > step
> > > > >guide line by line. But I keep getting an error message when I try to
> > > > >administer WSUS. I keep getting "Error connecting to the Windows Server
> > > > >Update Services database" I checked the event log, and I don't get any
> > > > >errors in either the Application, or System area's.
> > > > >
> > > > >I can't find much info on how to check the connection of the WSUS
> > service
> > > > >and the SQL database. I'm running both on the same machine. I installed
> > the
> > > > >MSDE and the patch during the install of WSUS.
> > > > >
> > > > >Anyone else trouble shoot this similar situation or know how to check
> > the
> > > > >connection between WSUS and SQL? I'm sure I'm one step away from
> > getting this
> > > > >thing running...
> > > > >
> > > > >Thanks in advance!
> > > > >
> > > > >Jeff
> > > >
> > > >
> >
> >
> >

I had the same problem. I just figured it out about an hour ago.

Do you currently have SUS installed?? Uninstall it, and reinstall WSUS.

This was the case for me. I think it has to do witht the open ports. You
can try opening up port 8530 to see if you can get both WSUS ans SUS running
at the same time.

"Jeff Baublitz" wrote:

> Hello,
>
> I'm trying to set up a 2000 SP4 Server for WSUS. I followed the step by step
> guide line by line. But I keep getting an error message when I try to
> administer WSUS. I keep getting "Error connecting to the Windows Server
> Update Services database" I checked the event log, and I don't get any
> errors in either the Application, or System area's.
>
> I can't find much info on how to check the connection of the WSUS service
> and the SQL database. I'm running both on the same machine. I installed the
> MSDE and the patch during the install of WSUS.
>
> Anyone else trouble shoot this similar situation or know how to check the
> connection between WSUS and SQL? I'm sure I'm one step away from getting this
> thing running...
>
> Thanks in advance!
>
> Jeff
>

Siva,

I checked the registry, and the key has "%computername%\WSUS" I did notice
the SUSusername key is blank. I'm not sure if something is needed there or
not. Just wanted to pass this info to you...

You are more then welcome to remote terminal in and take a look. Or let me
know any other info I can get you...

Thanks for trying...

Jeff

"Siva Shanmugam [MSFT]" wrote:

> Can you check the following in registry?
>
> Under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Update Services\Server\Setup,
> check to see if the value of "SqlServerName" key is %computername%\WSUS
>
>
>
>
>
> "Jeff Baublitz" <JeffBaublitz@discussions.microsoft.com> wrote in message
> news:75D90108-A42C-4CDE-BC40-ABC0DA344942@microsoft.com...
> > Hi Siva,
> >
> > How can I check the instance name for the MSDE database? Is it the service
> > that runs for SQL? If so the service name is MSSQL$WSUS. It's started and
> > running.
> >
> > As a side note, when I click on the SQL icon in the task bar, it shows
> > nothing conected. When I click on 'open SQL server service manager'
> > nothing
> > is connected. And when I try to connect to the server name nothing
> > happens...
> >
> > Any ideas what I can check, or any more info I can get you?
> >
> > Thanks
> >
> > Jeff
> >
> >
> >
> > "Siva Shanmugam [MSFT]" wrote:
> >
> >> Jeff,
> >>
> >> What is the instance name of the MSDE database? For WSUS, the instance
> >> has
> >> to be named as %machine-name%\wsus. Please refer the deployment guide for
> >> more info.
> >>
> >> "Jeff Baublitz" <JeffBaublitz@discussions.microsoft.com> wrote in message
> >> news:56209BA9-B426-4AA1-95B2-32450DE32096@microsoft.com...
> >> > I get the error right when I open the admin page. I can't get into WSUS
> >> > at
> >> > all.
> >> >
> >> > "JeffG" wrote:
> >> >
> >> > > What exactly are you trying to do when you get this error? Just
> >> > > opening the WSUS Admin page, or while trying to view updates, or
> >> > > something else?
> >> > >
> >> > > On Thu, 7 Jul 2005 13:24:03 -0700, "Jeff Baublitz"
> >> > > <JeffBaublitz@discussions.microsoft.com> wrote:
> >> > >
> >> > > >Hello,
> >> > > >
> >> > > >I'm trying to set up a 2000 SP4 Server for WSUS. I followed the step
> >> > > >by
> >> step
> >> > > >guide line by line. But I keep getting an error message when I try
> >> > > >to
> >> > > >administer WSUS. I keep getting "Error connecting to the Windows
> >> > > >Server
> >> > > >Update Services database" I checked the event log, and I don't get
> >> > > >any
> >> > > >errors in either the Application, or System area's.
> >> > > >
> >> > > >I can't find much info on how to check the connection of the WSUS
> >> service
> >> > > >and the SQL database. I'm running both on the same machine. I
> >> > > >installed
> >> the
> >> > > >MSDE and the patch during the install of WSUS.
> >> > > >
> >> > > >Anyone else trouble shoot this similar situation or know how to
> >> > > >check
> >> the
> >> > > >connection between WSUS and SQL? I'm sure I'm one step away from
> >> getting this
> >> > > >thing running...
> >> > > >
> >> > > >Thanks in advance!
> >> > > >
> >> > > >Jeff
> >> > >
> >> > >
> >>
> >>
> >>
>
>
>

Hey Rob,

Nope, this server has never had sus installed on it before. I still have my
sus server running on my network on a different box. I didn't want to screw
that up while I get wsus running... =)

Jeff

"Rob" wrote:

> I had the same problem. I just figured it out about an hour ago.
>
> Do you currently have SUS installed?? Uninstall it, and reinstall WSUS.
>
> This was the case for me. I think it has to do witht the open ports. You
> can try opening up port 8530 to see if you can get both WSUS ans SUS running
> at the same time.
>
> "Jeff Baublitz" wrote:
>
> > Hello,
> >
> > I'm trying to set up a 2000 SP4 Server for WSUS. I followed the step by step
> > guide line by line. But I keep getting an error message when I try to
> > administer WSUS. I keep getting "Error connecting to the Windows Server
> > Update Services database" I checked the event log, and I don't get any
> > errors in either the Application, or System area's.
> >
> > I can't find much info on how to check the connection of the WSUS service
> > and the SQL database. I'm running both on the same machine. I installed the
> > MSDE and the patch during the install of WSUS.
> >
> > Anyone else trouble shoot this similar situation or know how to check the
> > connection between WSUS and SQL? I'm sure I'm one step away from getting this
> > thing running...
> >
> > Thanks in advance!
> >
> > Jeff
> >

Jeff,

I'm having very similar issues. I've got a freshly built W2K3 SP1 server
that I've installed all the required IIS components as documented in the
"ReadMe For Windows Server Update Services."

The WSUS installing is very straight forward and says is sucessfully
installed but if I try to launch the web management interface the recieve a
"Services Unavailable" message. Reboots didn't fix the issues. If I look at
the WMSDE instance that is running the MSDE$WSUS service is started but is
reporting "Not Connected to \\". I've checked out the registry entries
recommended to look at in the prior reply and I'm seeing the same exact
values as you are.

When I checked the System event logs I was receiving 'WSUSPool' terminated
unexpectedly errors. And "The application-specific permission settings do not
grant Local Activation permission for the COM Server application" messages.
I've since uninstalled WSUS and removed all of IIS and rebooted along with
deleting the WSUS directory structure that was left behind after the
uninstall.

At this poing I've reinstalled IIS and have received none of the system
errors at this point. I am going to proceed with installing WSUS again next.
I'll let you know how it goes.
"Jeff Baublitz" wrote:

> Siva,
>
> I checked the registry, and the key has "%computername%\WSUS" I did notice
> the SUSusername key is blank. I'm not sure if something is needed there or
> not. Just wanted to pass this info to you...
>
> You are more then welcome to remote terminal in and take a look. Or let me
> know any other info I can get you...
>
> Thanks for trying...
>
> Jeff
>
> "Siva Shanmugam [MSFT]" wrote:
>
> > Can you check the following in registry?
> >
> > Under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Update Services\Server\Setup,
> > check to see if the value of "SqlServerName" key is %computername%\WSUS
> >
> >
> >
> >
> >
> > "Jeff Baublitz" <JeffBaublitz@discussions.microsoft.com> wrote in message
> > news:75D90108-A42C-4CDE-BC40-ABC0DA344942@microsoft.com...
> > > Hi Siva,
> > >
> > > How can I check the instance name for the MSDE database? Is it the service
> > > that runs for SQL? If so the service name is MSSQL$WSUS. It's started and
> > > running.
> > >
> > > As a side note, when I click on the SQL icon in the task bar, it shows
> > > nothing conected. When I click on 'open SQL server service manager'
> > > nothing
> > > is connected. And when I try to connect to the server name nothing
> > > happens...
> > >
> > > Any ideas what I can check, or any more info I can get you?
> > >
> > > Thanks
> > >
> > > Jeff
> > >
> > >
> > >
> > > "Siva Shanmugam [MSFT]" wrote:
> > >
> > >> Jeff,
> > >>
> > >> What is the instance name of the MSDE database? For WSUS, the instance
> > >> has
> > >> to be named as %machine-name%\wsus. Please refer the deployment guide for
> > >> more info.
> > >>
> > >> "Jeff Baublitz" <JeffBaublitz@discussions.microsoft.com> wrote in message
> > >> news:56209BA9-B426-4AA1-95B2-32450DE32096@microsoft.com...
> > >> > I get the error right when I open the admin page. I can't get into WSUS
> > >> > at
> > >> > all.
> > >> >
> > >> > "JeffG" wrote:
> > >> >
> > >> > > What exactly are you trying to do when you get this error? Just
> > >> > > opening the WSUS Admin page, or while trying to view updates, or
> > >> > > something else?
> > >> > >
> > >> > > On Thu, 7 Jul 2005 13:24:03 -0700, "Jeff Baublitz"
> > >> > > <JeffBaublitz@discussions.microsoft.com> wrote:
> > >> > >
> > >> > > >Hello,
> > >> > > >
> > >> > > >I'm trying to set up a 2000 SP4 Server for WSUS. I followed the step
> > >> > > >by
> > >> step
> > >> > > >guide line by line. But I keep getting an error message when I try
> > >> > > >to
> > >> > > >administer WSUS. I keep getting "Error connecting to the Windows
> > >> > > >Server
> > >> > > >Update Services database" I checked the event log, and I don't get
> > >> > > >any
> > >> > > >errors in either the Application, or System area's.
> > >> > > >
> > >> > > >I can't find much info on how to check the connection of the WSUS
> > >> service
> > >> > > >and the SQL database. I'm running both on the same machine. I
> > >> > > >installed
> > >> the
> > >> > > >MSDE and the patch during the install of WSUS.
> > >> > > >
> > >> > > >Anyone else trouble shoot this similar situation or know how to
> > >> > > >check
> > >> the
> > >> > > >connection between WSUS and SQL? I'm sure I'm one step away from
> > >> getting this
> > >> > > >thing running...
> > >> > > >
> > >> > > >Thanks in advance!
> > >> > > >
> > >> > > >Jeff
> > >> > >
> > >> > >
> > >>
> > >>
> > >>
> >
> >
> >

"Jeff Baublitz" <JeffBaublitz@discussions.microsoft.com> wrote in message
news:7444E129-C61C-4BAA-B86A-CF14B302CFE1@microsoft.com...
> Siva,
>
> I checked the registry, and the key has "%computername%\WSUS" I did notice
> the SUSusername key is blank. I'm not sure if something is needed there or
> not. Just wanted to pass this info to you...
>
[Siva] Is that SUSUserName or SQLUserName? The sqlusername needs to be
blank.

> You are more then welcome to remote terminal in and take a look. Or let me
> know any other info I can get you...
>
[Siva] Please reply directly to me and I can help you resolve this issue.
> Thanks for trying...
>
> Jeff
>
> "Siva Shanmugam [MSFT]" wrote:
>
>> Can you check the following in registry?
>>
>> Under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Update Services\Server\Setup,
>> check to see if the value of "SqlServerName" key is %computername%\WSUS
>>
>>
>>
>>
>>
>> "Jeff Baublitz" <JeffBaublitz@discussions.microsoft.com> wrote in message
>> news:75D90108-A42C-4CDE-BC40-ABC0DA344942@microsoft.com...
>> > Hi Siva,
>> >
>> > How can I check the instance name for the MSDE database? Is it the
>> > service
>> > that runs for SQL? If so the service name is MSSQL$WSUS. It's started
>> > and
>> > running.
>> >
>> > As a side note, when I click on the SQL icon in the task bar, it shows
>> > nothing conected. When I click on 'open SQL server service manager'
>> > nothing
>> > is connected. And when I try to connect to the server name nothing
>> > happens...
>> >
>> > Any ideas what I can check, or any more info I can get you?
>> >
>> > Thanks
>> >
>> > Jeff
>> >
>> >
>> >
>> > "Siva Shanmugam [MSFT]" wrote:
>> >
>> >> Jeff,
>> >>
>> >> What is the instance name of the MSDE database? For WSUS, the instance
>> >> has
>> >> to be named as %machine-name%\wsus. Please refer the deployment guide
>> >> for
>> >> more info.
>> >>
>> >> "Jeff Baublitz" <JeffBaublitz@discussions.microsoft.com> wrote in
>> >> message
>> >> news:56209BA9-B426-4AA1-95B2-32450DE32096@microsoft.com...
>> >> > I get the error right when I open the admin page. I can't get into
>> >> > WSUS
>> >> > at
>> >> > all.
>> >> >
>> >> > "JeffG" wrote:
>> >> >
>> >> > > What exactly are you trying to do when you get this error? Just
>> >> > > opening the WSUS Admin page, or while trying to view updates, or
>> >> > > something else?
>> >> > >
>> >> > > On Thu, 7 Jul 2005 13:24:03 -0700, "Jeff Baublitz"
>> >> > > <JeffBaublitz@discussions.microsoft.com> wrote:
>> >> > >
>> >> > > >Hello,
>> >> > > >
>> >> > > >I'm trying to set up a 2000 SP4 Server for WSUS. I followed the
>> >> > > >step
>> >> > > >by
>> >> step
>> >> > > >guide line by line. But I keep getting an error message when I
>> >> > > >try
>> >> > > >to
>> >> > > >administer WSUS. I keep getting "Error connecting to the Windows
>> >> > > >Server
>> >> > > >Update Services database" I checked the event log, and I don't
>> >> > > >get
>> >> > > >any
>> >> > > >errors in either the Application, or System area's.
>> >> > > >
>> >> > > >I can't find much info on how to check the connection of the WSUS
>> >> service
>> >> > > >and the SQL database. I'm running both on the same machine. I
>> >> > > >installed
>> >> the
>> >> > > >MSDE and the patch during the install of WSUS.
>> >> > > >
>> >> > > >Anyone else trouble shoot this similar situation or know how to
>> >> > > >check
>> >> the
>> >> > > >connection between WSUS and SQL? I'm sure I'm one step away from
>> >> getting this
>> >> > > >thing running...
>> >> > > >
>> >> > > >Thanks in advance!
>> >> > > >
>> >> > > >Jeff
>> >> > >
>> >> > >
>> >>
>> >>
>> >>
>>
>>
>>