WHS/WSUS and SQL Remote connection problems!

[XBoxLPU]

I have a Windows Home Server box that I would like to deploy WSUS however it only has 512Mb of memory and from what I can gather performance will be hampered using an internal local SQL database for WSUS. So I thought it would be pretty easy to just install SQL Server Express 05 on my desktop which is running Vista x64 SP1. It installs fine and I have enabled remote connections and forwarded ports should be set right. It is not really a connection problem, I am just confused as to why when WSUS tries to connect to the SQL Server it wants to login as guest.

I have searched for documentation for this and can't find anything to help me.Even MS's site that has the deployment instructions do not mention adding the guest account, I already tried to make my local Users/Guest account a super SQL user and WSUS will connect and establish fine but the instllation fails eventually.

I guess what I am asking, is how do I get my windows home server/WSUS to properly connect to my SQL Server 05 Express? (The network has no domains either)

http://img45.imageshack.us/img45/6292/loginsnt5.jpg

http://img522.imageshack.us/img522/7500/sqlrag7.jpg

http://img135.imageshack.us/img135/2262/wsusme6.jpg

 

[Genx87]

afaik WSUS does need AD to work properly, or at all. Secondly WSUS has its own MSDE version that can install locally. I suggest using that.

Or you can go the easy route and turn on Windows Update tp pull from MS on the clients. WSUS in a home environment is overkill. Unless you just want to toy around with it of course.

 

[XBoxLPU]

Originally posted by: Genx87
afaik WSUS does need AD to work properly, or at all. Secondly WSUS has its own MSDE version that can install locally. I suggest using that.

Or you can go the easy route and turn on Windows Update tp pull from MS on the clients. WSUS in a home environment is overkill. Unless you just want to toy around with it of course.

I just want to toy around with it

Is there any way to get around not having to have an AD? As I said I would install a local DB on the WHS box but with 512Mb it is going to be bogged down.

 

[RebateMonger]

Wikipedia.org: Windows Server Update Services

"Administrators can use WSUS with Active Directory Group Policy for client-side configuration of the Automatic Updates client, ensuring that end-users can't disable or circumvent corporate update policies. WSUS does not require the use of Active Directory, client configuration can also be applied by local group policy or by modifying the Windows registry."

If you just want to play with WSUS, you might just set up a virtual Server 2003 (using a 180-day trial version of Server 2003) and install WSUS on that. It can be done on any XP box with some spare memory.

 

[loup garou]

Originally posted by: RebateMonger
If you just want to play with WSUS, you might just set up a virtual Server 2003 (using a 180-day trial version of Server 2003) and install WSUS on that. It can be done on any XP box with some spare memory.

Agreed, this is probably your best bet...installing WSUS on WHS sounds like a bad idea to me.

 

[XBoxLPU]

Originally posted by: RebateMonger
Wikipedia.org: Windows Server Update Services

"Administrators can use WSUS with Active Directory Group Policy for client-side configuration of the Automatic Updates client, ensuring that end-users can't disable or circumvent corporate update policies. WSUS does not require the use of Active Directory, client configuration can also be applied by local group policy or by modifying the Windows registry."

If you just want to play with WSUS, you might just set up a virtual Server 2003 (using a 180-day trial version of Server 2003) and install WSUS on that. It can be done on any XP box with some spare memory.

But the way I understand, in enable for WSUS to establish a remote SQL connection an active directory must exist

http://technet2.microsoft.com/...ce2d1033.mspx?mfr=true

 

[loup garou]

Originally posted by: XBoxLPU

Originally posted by: RebateMonger
Wikipedia.org: Windows Server Update Services

"Administrators can use WSUS with Active Directory Group Policy for client-side configuration of the Automatic Updates client, ensuring that end-users can't disable or circumvent corporate update policies. WSUS does not require the use of Active Directory, client configuration can also be applied by local group policy or by modifying the Windows registry."

If you just want to play with WSUS, you might just set up a virtual Server 2003 (using a 180-day trial version of Server 2003) and install WSUS on that. It can be done on any XP box with some spare memory.

But the way I understand, in enable for WSUS to establish a remote SQL connection an active directory must exist

http://technet2.microsoft.com/...ce2d1033.mspx?mfr=true

Just use a local SQL install on the Server 2003 VM.

 

[XBoxLPU]

Originally posted by: loup garou

Originally posted by: XBoxLPU

Originally posted by: RebateMonger
Wikipedia.org: Windows Server Update Services

"Administrators can use WSUS with Active Directory Group Policy for client-side configuration of the Automatic Updates client, ensuring that end-users can't disable or circumvent corporate update policies. WSUS does not require the use of Active Directory, client configuration can also be applied by local group policy or by modifying the Windows registry."

If you just want to play with WSUS, you might just set up a virtual Server 2003 (using a 180-day trial version of Server 2003) and install WSUS on that. It can be done on any XP box with some spare memory.

But the way I understand, in enable for WSUS to establish a remote SQL connection an active directory must exist

http://technet2.microsoft.com/...ce2d1033.mspx?mfr=true

Just use a local SQL install on the Server 2003 VM.

I understand that, I was just referring back to my WHS box