Companyweb and Sharepoint 3.0 Central Admin not Accessible on SBS 2008 after install of Moss 2007

rglover1168
rglover1168 used Ask the Experts™
on
Our company needed the use of electronic forms using info path so I did some research And found out that in order to make them accessible in sharepoint and able to be viewed through a web browser I needed some type of forms server software. I believed MOSS 2007 would do the trick but I found out immediately that it doesn't play well with exchange server, so I uninstalled it hoping to find another forms solution.

After the uninstall and maybe even before that I don't know, I could no longer access company web. http://companyweb/default.aspx gives me the "Cannot connect to the configuration database," error message.When trying to open companyweb
I've been trying to correct this problem for a couple weeks already (we haven't really used the internal website for more than just notifications and messages so there hasen't been much flack about it being down). That being said I can re-install companyweb or sharepoint without major consequence or loss of content, however I haven't been able to find the correct info on how to go about this.

What I've read and tried these past couple of weeks involved a full system restore, attempted reinstall of WSS, rebuilding Companyweb and attaching back up database, Many times i was instructed  to run the sharepoint products and technologies wizard and now it gives me this error  Products and Technologies wizard error. With this event log:  PSCDiagnostics-6-30-2010-12-17-1.log
I was previously getting an error on 9 of 12 then after running it a few times I started to get the error on 2 of 12.

I have already tried everything I could find on this website as well as googling and trying fixes from the microsoft website, most info I found was pertaining to a companyweb problem after an update , and all I was able to do was make matters worse. I lost RWW which was a huge problem that was fixed by a full system restore. Also during one attempt to recover companyweb I lost the ability to access sharepoint 3.0 central admin This is the error I see:
When trying to open Sharepoint 3.0 Central Administration
I am pretty good at following clear directions however I sometimes need an idiots guide  to sbs 2008. I'm stumped and have great need to fix this matter because I need to get the server back to it's original state so I can find a solution to our need for forms services, it doesn't seem like MOSS 2007 will work with sbs 2008 standard but first things first.

I'm not the greatest in explaining so hopefully these screen captures will aide in an answer.
ipconfig: ipconfig /all  on serverIIS Manager: IIS ManagerSharepoint Adv Settings: Adv settings  for sharepointDefault website Adv Settings: Adv settings for default website
Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
wow seems like you might have messed up your entire config. Do you have full backups of all of the dbs?
You said it wouldn't be a problem if you had to reinstall, that may be your only option at this point. To do this you would need to get rid of the db named SharePoint_Config, reinstall everything and then we can go back and attach your content dbs so that you get your files and stuff back. There will still be some manual work, and you will lose some things like settings in Central Administration. Does this seem like something that you can do?

My other suggestion is that if you have full backups of the dbs from before this started happening, or even right after but before you started doing things, then we can restore those and attempt to recover.

Author

Commented:
I have an external drive that gets backed up twice daily that was configured in sbs console when it was installed.  I'm guessing the standard setup includes full backups of the dbs or is there something extra I would have needed to configure.  How can I check and see if those files are available? Also if I need to reinstall what are the exact steps involved as in where to properly go and delete the SharePoint_Config file and then exactly how to reinstall everything. Everything being the operative word, is that just relating to sharepoint  or the OS as well. I have the component technologies for server repair disc is that what I need to reinstall?

I don't mind losing the settings in Central Admin or trying either of the suggestions you made to solve this problem. Just let me know which road I should take first and I'll start from there I am pretty green in this area but I can be dangerous with a good step by step.

open up sql management studio and under maintenance see if you have a maintenance plan. If not then you probably aren't backup uo your dbs which is bad and we'll fix that too.

reinstall of everything sorry for the confusion I was referring to just SharePoint. This article talks about moving to a new server, but the process is the same just don't move to a new sql server use the same one and follow the rest of the process.
http://mickey4nay.spaces.live.com/blog/cns!8983677073B13695!1484.entry

Author

Commented:
I do not have the maintenance plan and the link to the article provided was private and inaccessible even after windows live log in.
Ted BouskillSenior Software Developer
Top Expert 2009

Commented:
Uninstalling MOSS might have uninstalled key binaries in WSS 3.0 which is the foundation for MOSS 2007.

If you really need the data back, I'd strongly recommend you contact MS Support.  The cost of the support will be less than your time and your odds of recovering your data is better.

The original content databases are likely OK but the tricky bit is getting WSS working properly again.

Author

Commented:
There is no great need for me to get the data back I'd be happy just reinstalling and getting everything working again. My only fear is screwing up RWW again. If I can start fresh with sharepoint that would be fine. I just need to know the proper steps.
open SQL Management Studio and delete the SharePoint_Config database. Run the install for sharepoint again creating a new farm. Once you have reinstalled you should have a fresh clean sharepoint environment.

Create a new central admin site and everything. Once done create a new web application and site collection. After that is provisioned you can in central administration go to manage content databases and then add and you can add any of the WSS_Content dbs that you have in SQL and remove the one that was installed with the install. This will restore your sites and data. If you had more than 1 web application or site collection then you will have to create them new as well and then go through the add db method again.
here is a quick step by step as well. It is a good idea to take a backup of your SQL dbs just incase, but you don't need to go through the restore and everything since you are using the same sql server again.

Author

Commented:
Just to clarify I have SQL Server Management Studio Express if that makes any difference and it's not clear to me how to delete the Sharepoint_Config database when that opens.
sql-server-mse.bmp.jpg

Author

Commented:
I truly hope that my lack of knowledge in this area has not deterred those who would otherwise offer assistance. I feel that I may be close to a solution however I've caused enough problems with half understanding directions so I apologize for my need for more clarity. I've done a bit of google searching and I do see some differences in sql server studio express and sql studio. It would seem that with not only this but other Microsoft products the Express versions have slight differences. Please help me to understand what I need to do to delete  the SharePoint_Config database in sql studio express.
having express doesn't matter it is the exact same process. Click connect at the screen you showed. Then expand down the left hand side the servername, then the databases folder, and then you will see sharepoint_config.

Again I recommend backing all of this up first, and you are right you may be in way over your head. Unfortunately a complete sharepoint farm recovery is a little much to walk through step by step on this site.

Author

Commented:
When I expand servername/database I am presented with two folders System Databases and SBSMonitoring. Looking in system databases folder still can't locate this file. What am I missing?
Databases.bmp.jpg

Author

Commented:
After more research I believe I'm in the right folder. I used this article: http://technet.microsoft.com/en-us/library/dd548329(WS.10).aspx?ppud=4 to find this folder however I could use a bit more guidance on which folder/folders to delete. Thanks
Databases-np.jpg
wow that looks like you have 3 farms running on the same server. I'm willing to bet that is the reason nothing is working!
On each of those databases (they are the cylinder icon) right click select tasks and then backup. On the popup window choose where to save the backup to and make sure you have FULL database and logs selected.

After you have all of the backups done. I would go to start admin tools and sharepoint products....configuration wizard. Run through selecting to remove the server from the farm. After doing that check back here and see what databases remain. Delete any of the ones that start with SharePoint_ (3 config and 3 admincontent) then run the sp configuration wizard again creating a new farm and lets see if that is successful. If not you will have to do this again and then do an uninstall of sharepoint from add remove programs.

Author

Commented:
It appears my database is so screwed up I can't even back it up. I can't seem to catch a break with this thing. Here is the backup error. Also I can't get past 2 of 12 on the configuration wizard.Is it possible to just delete those databases and start over without affecting the remote web  workplace. I ask because I'm not concerned about saving any user created content I just want to start over with the internal site at this point.
backup-error.JPG
that is an access denied error message so if you try to delete it you are going to get access denied as well. You need to be an admin to do these tasks.
I really think that you are in over your head and going to do more harm then good. I don't think we are going to very successfull walking you through it on this site. I think you need to get somebody either microsoft support or some consultant to help you out.

Author

Commented:
I am the admin I setup the server and network so not sure why access is a problem. I was curious to see if I was able to delete one of the databases and oddly enough I was able to delete one. Before I look at trying to contact a microsoft support person I would like to know if looking at image in post # 2 of the configuration wizard. Is it possible these multiple databases are causing the error in that image. That being said if I delete those databases can I start fresh.

Author

Commented:
Looking at the last post it doesn't seem clear. I'm actually referring to image #2 in the first post. Also seeing how sbs 2008 loves wizards would the deletion of the db open up the products and technologies wizard.
yes getting rid of the databases should allow you to run the sharepoint configuration wizard successfully. your second screen shot is trying to UPGRADE when you don't want to be upgrading anything. To me that looks like you had WSS and then installed MOSS and ran that and it failed.

Author

Commented:
(Update) I was able to backup the databases successfully when using the default backup location. The problem with backup was because I was trying to backup to external drive. At this point I feel comfortable deleting whatever is necessary.
In reference to the post 5 post's back concerning the running of the wizard and deletion of the databases.
Since I'm getting the error with the products and technologies wizard do you think it would make a difference to just delete the sharepoint_config folders at this point.

Author

Commented:
I didn't see your post before I posted again. Trying to decided if I want to do this over the weekend or not.
Just to be clear. Your suggestion is just to delete the sharepoint_config files and re run the wizard or are you now referring to all of the database files. I'll be checking this post let me know.
I suggest that you run the wizard first and remove the server from the farm. THEN go and delete all databases that start with "SharePoint_" from the screenshot that is 3 config and 3 admin content.

You really should only have 1 of each of those.

Then rerun the wizard creating a NEW farm. That goes successfully and we can reattach those WSS_Content dbs to get data back.

Author

Commented:
I have successfully rerun the wizard at the end a new team site was launched http://servername/default.aspx. Feels like I cleared a major hurdle however I'm still without central admin and companyweb, which seems like the next step.

Author

Commented:
Correction central admin is working it's companyweb that needs configuration.
Can you go to central admin click on application mgmt and then web application list and post that screenshot?

If in that list you have a SharePoint 80 site or something other than central admin go back to application mgmt and click on content databases, in the web application dropdown select that sharepoint 80 (companyweb whatever it is called) and then click add a content database. Then add those WSS_Content. Looks like you had 3 different site collections, If I had to guess, the one you were probably using first was WSS_Content with no guid. So try that guy first

Author

Commented:
I have the web application screenshot and there is a Sharepoint 80 site. When I go to manage content databases the only drop down option is change web application. If I select that i'm presented with a select web application screen, upon selecting sharepoint 80 the screen returns to manage content databases with no change. If I then click on add content database same thing in web application drop down.
Web-application-list.jpg

Author

Commented:
Don't know if what I was saying was making sense so I'll add these screen shots as well.
change-web-app.jpg
select-web-app.jpg
add-content-db.jpg
on the last screenshot the add content database one that is where you will add the WSS_Content database. Specify servername (should be correct there already) and then in database name just WSS_Content

Author

Commented:
When trying to attach the WSS_Content db I receive an error that says "Attaching this database requres upgrade, which could time out the browser session. You must use the STSADM command 'addcontentdb ' to attach this database. Also tried one of the db with guid and got this message:

The attach operation cannot continue because another object in this farm already contains the same ID. Each object in a farm must have a unique ID. In order to proceed with the attach operation you must assign a new ID to this database. To attach this database with a new ID, use the "stsadm.exe -o addcontentdb" operation with the -assignnewdatabaseid parameter. Note that if this new database and an existing database contain the same site collections, attaching this database will likely result in orphaned site collections due to conflicts between the two databases.
open the command window (thats start -> run -> type cmd and press enter) navigate to
C:\program files\common files\microsoft shared\web server extensions\12\bin and then type


stsadm.exe -o addcontentdb -url "whatever the URL to that SharePoint80 site is" -databasename WSS_Content

Author

Commented:
Pardon my ignorance but you say navigate to c:\program files..... . and then type stsadm.exe..... ? This is not working for me.

So I've tried this in a command prompt as well as elevated command prompt and no joy.   Here is what I typed in the commmand prompt

c:\program files\common files\microsoft shared\web server extensions\12\bin (I tried typing enter here and got program not recognized)

Then tried:
c:\program files\common files\microsoft shared\web server extensions\12\bin stsadm.exe -o addcontentdb GRAMERCYSERVER\MICROSOFT##SSEE\Databases\WSS_Content

What am I doing wrong I also tried the same scenario in an elevated commmand prompt. Looked all over for exact syntax just to be sure found this:http://support.microsoft.com/kb/926961 but no help.
type cd c:\     then press enter
then cd program files\common files\microsoft shared\web server extensions\12\bin       then press enter
then type the command
Hey how you making out?

Author

Commented:
I'm out of the office til Monday so I'll Have to update then. I feel like I'm seeing the light at the end of the tunnel though.

Author

Commented:
Can you give me an example of a database name. I tried GRAMERCYSERVER\MICROSOFT##SSEE\Databases\WSS_Content
and I get an error Missing required argument: databasename.
server name GramercyServer
database name is just WSS_Content

Author

Commented:
It says the operation completed successfully however companyweb is still not accessible
what happens when you got to http://gramercyserver ? in a webbrowser

Author

Commented:
There is now a team site at that address.
gramercyserver-teamsite.jpg
ok then add the other WSS_Content DB and remove this one.

Author

Commented:
So you are saying to repeat the exact same process over again from command line with one of the other wss_content databases. (WSS_Content_8ed2697a5e574634a8bdf506653dde96)
yes just remove the WSS_Content one after you add the new one. Until you get the one that has your data

Author

Commented:
I have added all of the databases however unclear on removing wss_content(delete from sql? or remove from central admin?). Also I still don't see any of the content from companyweb. Does this image look correct?
content-databases.bmp.jpg
remove them from the screen in your screenshot.
From the picture it looks like the 2nd from the bottom is the one that you want. Since it is the only one with a site in it. So remove WSS_Content as well as the second and 4th.
You can remove them from that screen.

Author

Commented:
Done. So now I have one content db the one showing 1 site in it. How do I get my http://companyweb back?
what is on the default port now?

Author

Commented:
In llS Manager Default Web Site is not started. When I try to start Error message pops up with " This Web site cannot be started. Another Web site may be using the same port."
iis-manager.JPG
yes thats because you have it running on sharepoint 80

Author

Commented:
What would be the best course of action to rectify this? Can I make the sharepoint 80 site company web and have it point to that or is there a better way to restore the company web?
I'm not sure. I asked for you to restore 1 Content DB at a time and see what content you got to that. I am not sure whether you did that to the default web or to the sharepoint 80 site.
Unless you have something on the default website, in general that is a site that gets turned off when sharepoint is installed on the server and SharePoint 80 is used instead.

Author

Commented:
After adding each of the databases I still received a blank page when opening company web. I assume I have to recreate that page which is fine with me since it was never used. This whole mess started when we decided to use it for forms services. Prior to that it was blank. I'd be inclined to just start over.
ok so we are restoring a database that had nothing but a blank site?

companyweb is just a host header. We can put that back in after we find the actual site you were looking for. Just going to the servername as mentioned above is the same thing. I wanted you to restore 1 of those DBs at a time go to the page see if it was the site. If not then remove that db and add the next one until you found the site that had your content. But if it was just a blank site then they probably all match.

Just attach the WSS_Content db again get rid of the rest and recreate your page. The you can call it companyweb or whatever you want really if you have something more creative. All you do is add a host header and alternate access mapping. We can walk through that if you need to but lets start by getting a site with some content up first.

Author

Commented:
I attached the WSS_Content db again the question now is how do I recreate company web or Gramercy Web for that matter. Also when you say get rid of the rest do you mean to delete from sql?
You can delete them for sql if they aren't needed. It appears that they were created during your reinstall attempts and don't actually have any data. You can leave them until you are sure that you don't need them as well. But get rid I meant detaching them so sharepoint doesn't see them.

As far as recreating the web, I have no idea what you had and a complete walkthrough of creating and developing sites in sharepoint I'm afraid is way beyond the scope of your initial question

Author

Commented:
sharepointguru14 was amazingly patient with a sharepoint newbie. Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial