SPS2003 dead - "Site Under Construction"

[umbletech]

Hi All

Got a front end/back end sps2003 setup on VM workstation - was working on the site - then going to migrate the VMs over to a prod environment. The backend is sql2005 sp1. WSS SP2 and SPS SP2 have been applied - basically: install sps2003, install wss sp2, install SPS SP2 then create the config dbase.

I'd been changing my host workstation's IP troubleshooting and forgot to power down the VM.

When I went back in got the dreaded 'under construction'

Reverted to previous VM snapshots - no different. Over the weekend went back to a VM before IIS had even been installed. Reinstalled SPS as above - same result. The config db - SPS01_Config_db creates fine. I've used the same service a/c for all SPS settings - its a sysadmin in sql and a local admin on both servers. I'd also blown away the old config db in sql.

The only issue I had with the install is that SPS SP2 seemed to hang - left it alone for about an hour then killed it - the OS is win 2003 r2 so the windows installer 3.1 upgrade doesn't seem to be needed - although interestingly if I do a misiex /? at the commandline it reports as 3.01

Anyone got any ideas?

 

[PatricktheAnalyst]

I have gotton alot of different errors with SPS but anytime I had an "Under Construction" message was when I had accidently pointed the site to the default Windows IIS site. Do you use host headers or ip addresses to differentiate the sites?

Thanks!

Patrick

 

[umbletech]

No I don't (well least I think I don't). How can I point the site back to the sharepoint one?

 

[umbletech]

There is only the default website and sharepoint central administration (which works) showing under websites.

I thought SPS took over the default website?

 

[PatricktheAnalyst]

Take a look at the setup log files in your windows\temp directory. If you don't see anything, post it.

Thanks!

Patrick

 

[umbletech]

Thanks Patrick

Setup looks fine:

23/10/2006 4:09:55 AM: End CreateShortcuts()
23/10/2006 4:09:55 AM: Start PreLoadStartingAspxPage()
23/10/2006 4:10:10 AM: HTTPRequest (GET,

http://localhost:21839/sps/FarmDatabase.aspx,

text/html,,) Status=200
23/10/2006 4:10:10 AM: End PreLoadStartingAspxPage()
23/10/2006 4:14:12 AM: Setup LCID is 1033
23/10/2006 4:14:19 AM: ******************Setup has completed successfully******************

But in the appPool log getting unable to connect to configuration database.

Now the appPool user is a domain account with local admin rights on both servers. Made them a sysadmin server role in SQL. I have applied sp1 to the sql2005 box - anyone know of any issues with this or post-sp2 for SPS patches you need?

 

[umbletech]

My bad - I'd rebuilt the VM last night and forgot to add the appPool user to local admins did that and get past - 'unable to connect to config dbase'.

While trouble shooting I did change the appPool identity user from IWAM to my service a/c guy.

Now I get: 0 10/24 09:59:23 3380 The virtual server that is referenced here is not in the config database. There's no data in this site and security is not a big concern. Any ideas on how to get it up quickly?

 

[umbletech]

Arrgh I ran the sharepoint config analyzer and it told me WSS wasn't installed. it was dated 2004 - does this thing still work?

 

[umbletech]

K I'm giving up - I can only think the VMs must have got hosed somehow. I'm going to run up the real one from scratch and see what happens. Does anyone have a fool proof recipe for installing SPS2003 with a remote SQL2005 database?

 

[umbletech]

Aw c'mon guys somebody must have one.

 

[Yeagermeister]

I'm very new to Share Point, so I'm just learning how it all works.

Is there any way to stand up a brand new WSS 2 server with MS SQL 2000 using an EXISTING content and configuration database? I'm trying to build a Share Point site that looks exactly like our live site looked like a couple of months ago. I have the two databases restored from tape.

Thanks!