Solved

accessing companyweb with SBS 2008, IIS7, sharepoint 3.0

Posted on 2011-03-02
17
1,464 Views
Last Modified: 2012-06-27
Hi Guys,

I have an SBS 2008 Server running. Can access RWW remotely. Cannot access companyweb internally or remotely. I run the connect to internet wizard fine. The Setup an Internet address does not complete. Fix my network wizard only finds, cannot configure router - which is fine - all ports are open correctly.

On the SBS, if I try and access companyweb (http://companyweb/) it asks for username and password. If I try on a client PC, it just comes up The Website cannot be found - error 404.

I have run the Sharepoint Products and technology wizard and I removed it from the server and then run the wizard again and now it just completes fine with no errors.

Any help would be great.

Thanks, Matt
0
Comment
Question by:m_r_r
  • 9
  • 8
17 Comments
 
LVL 13

Expert Comment

by:connectex
Comment Utility
Can you access the SharePoint Central Administration from the server console?
0
 

Author Comment

by:m_r_r
Comment Utility
hi connectex - yep no problems. open up sharepoint 3.0 central administration.
0
 
LVL 13

Expert Comment

by:connectex
Comment Utility
Are the workstations pointing to the SBS server for DNS? Can you ping companyweb from a workstation and does it return the IP of the SBS server?
0
 

Author Comment

by:m_r_r
Comment Utility
Yep they are. Ping company web from a workstation/terminal server and returns the IP of the sbs server.
0
 
LVL 13

Expert Comment

by:connectex
Comment Utility
I'm seen some SharePoint updates cause issues like this. Please run this command from a command prompt:

"C:\Program Files\Common Files\Microsoft Shared\Web server extensions\12\BIN\psconfig" -cmd upgrade -inplace b2b -wait -force
0
 

Author Comment

by:m_r_r
Comment Utility
ran the command - all seemed to go through ok.

still the same page comes up - company web not working still.
Command-Prompt.jpg
0
 
LVL 13

Expert Comment

by:connectex
Comment Utility
Can you confirm all services set for automatic start are running? If so you could try a reboot of the server. Also are there any SharePoint related errors in the event logs?
0
 

Author Comment

by:m_r_r
Comment Utility
all services that are automatic start are running except SQL Server Agent (SQLEXPRESS). It wont start. We are running SQL 2008 on the server.

Can't connect microsoft##SSEE database.

connect to other and has suspect databases.

images attached.
 ms##SSEEsuspect-databases.jpg
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 13

Expert Comment

by:connectex
Comment Utility
I'm just curious what happens if you logon as administrator at a workstation. And then try going to companyweb?
0
 

Author Comment

by:m_r_r
Comment Utility
log onto terminal server as administrator and try and browse to companyweb - same thing - 404 error
0
 

Author Comment

by:m_r_r
Comment Utility
i am wondering if it is SQL error or IIS permissions... anyone...???
0
 
LVL 13

Expert Comment

by:connectex
Comment Utility
Have you confirmed in IIS Manager that the all web sites are started?
0
 

Author Comment

by:m_r_r
Comment Utility
sharepoint - 80 isnt. it wont start because port 80 is used on companyweb.  IIS Sites
0
 
LVL 13

Expert Comment

by:connectex
Comment Utility
There's basically two SharePoint installations. It looks like the first installation left somethings behind ( web sites and databases) and the second installation added new ones instead of reusing the stuff from the first one. Is there anything in your SharePoint databases yet? If not I'd like to remove it completely. Make sure it's completely cleaned up and then reinstall. Is this possible?
0
 

Author Comment

by:m_r_r
Comment Utility
Hi, yeah there is stuff on the old companyweb website - can I somehow back that up and then remove, do a full reinstall and then restore the company web?
0
 
LVL 13

Accepted Solution

by:
connectex earned 500 total points
Comment Utility
My desire is to get you back to standardize SBS 2008 installation. And right now it's hosed as far as SharePoint's concerned. I'm afraid that even backing up your data via stsadm.exe or other methods may not work right now as seems to be pointing a newer database set that may not actually have any data. To verify I'd recommend you stop the SBS SharePoint web site. Configure SharePoint - 80 identical to SBS SharePoint and start it. If it starts access it from a workstation and verify if your data is there. Then a backup woud be possible. If it's not we have a tougher road.
0
 

Author Comment

by:m_r_r
Comment Utility
Hi Connectex - thanks for you help. I stopped the SBS Sharepoint got the Sharepoint - 80 going with the same details as the sbs sharepoint. Company web is backup and running but not the data that was there before. Ok because the client will just put back in the data.

thanks.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
This video discusses moving either the default database or any database to a new volume.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now