WSUS 3.0 sp2 looking at the wrong DB location in SBS 2008

Got an SBS 2008 installation I imaged to diffrent hardware while original hardware was being repaired. Previously I had movesd the WSUS DB to a diffrent drive using the wizard. Just before imaging back to the original Hardware I used the wizard to move WSUS DB back to C drive. (All files are there)
Error I get: WSUS 364: Content file download failed: Reason: Error calling (Kernel32.dll) : Create directory G;|wsus\Wsuscontenet\CA Source file: Destination File.
G; Drive doesn't exist anymore.
I can't access \\.\pipe\mssql$microsoft##ssee\sql\query to make manual changes to the DB location. (Not as SBS admin or the reenabled admin account)
Tried reinstall:<DVD Drive>:\CMPNENTS\wsus\wsussetup.exe /q DEFAULT_WEBSITE=0 CREATE_DATABASE=1 CONTENT_LOCAL=1 CONTENT_DIR=C:\WSUS WYUKON_DATA_DIR=C:\WSUS....................... but no go.
Anyone with possible answers?
Regards
Olaf
LVL 22
Olaf De CeusterAsked:
Who is Participating?
 
Cris HannaConnect With a Mentor Commented:
Sorry was also working a question on WSS SP2.
Troubleshooting WSUS 3.0 on SBS 2008 http://msmvps.com/blogs/bradley/archive/2009/08/27/repairing-wsus-3-on-sbs-2008.aspx
0
 
Olaf De CeusterAuthor Commented:
Thanks CrisHanna,

My issue is with WSUS. Sharepoint is going OK thankfully.(Companyweb, RWW)
In the meantime I reinstalled WSUS and SBS thinks all is OK (In the console) but no computers are turning up and I also lost the SUS Database?
I'll leave it sit overnight to see if I get any errors in te Eventlog. Nothing as of yet.
Only installed it 4 hours ago.
Thanks for your interest.
Olaf
0
 
Olaf De CeusterAuthor Commented:
Thanks CrisHanna,
Ended up removing WSUS and reinstalling.
A few thing people might find interesting:
In order to open the database you need to run as admin.
In order to get around the:"Content file download failed: Reason: Error calling (Kernel32.dll) : Create directory G;|wsus\Wsuscontenet\CA Source file: Destination File.
G; Drive doesn't exist anymore" I added a harddrive G: and this made the  WSUS DB accessible again, so I culd detach, move, reattach.
Hope this helps someone else.
Olaf
0
 
Olaf De CeusterAuthor Commented:
Thanks Cris for being the only person answering.
Olaf
0
All Courses

From novice to tech pro — start learning today.