Solved

Sharepoint companyweb wont display

Posted on 2011-03-22
8
652 Views
Last Modified: 2012-05-11
Companyweb on Server 2003 SBS not working. In IIS if I try to browse the companyweb it fails to display. Likewise users unable to view in IE. Errors started occurring around 10pm Friday night and they have not been able to view since. Database files are present in the default location. I have looked at the various eventlogs but not found anything that might explain how to fix.
ebrerrro.png
0
Comment
Question by:duncaninnz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
8 Comments
 
LVL 3

Expert Comment

by:quinks
ID: 35195907
Hang on... what are all those errors in the log about?

It looks like the SQL database broke, at first glance.
0
 

Author Comment

by:duncaninnz
ID: 35195982
Looks that way. It cant connect to the database. The files are there. I dont know how to get into SQL to check anything. Its the standard install of SBS 2003 and unlike SQL 2005+ there is no management console. Is there one I can download. Tehre are many repeated errors referring to the problem. The one attached refers to the database issue.
event.png
0
 

Author Comment

by:duncaninnz
ID: 35195983
All services are running and can be restarted
0
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 
LVL 3

Expert Comment

by:quinks
ID: 35196024
If you have R2, then SQLRun_Tools.exe on the SBS CD.

Else, you can check Add/Remove Programs for the SQL Tools and if not that, then get Microsoft SQL Server Management Studio Express, which I know should work on R2.
0
 

Author Comment

by:duncaninnz
ID: 35196056
Not R2
0
 
LVL 12

Accepted Solution

by:
Hairbrush earned 500 total points
ID: 35198957
The 32-bit version of SQL Server Management Studio Express can be downloaded from here: http://go.microsoft.com/?linkid=9729744

The 64-bit version is at http://go.microsoft.com/?linkid=9729745

Your SQL Server Express instance will be hidden, so when you run Management Studio you will need to type the following in to the server name field: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

This assumes that your instance of SQL Server Express is actually running. If it is not, you won't be able to connect as above.  Type services.msc from a command prompt or the "run box" then look down the list for "SQL Server (SQLEXPRESS)" - what is the status of the service?

0
 

Author Closing Comment

by:duncaninnz
ID: 35310524
Was able to resolve through SQL managerment express. didnt realise this would work with 2003. Very usefull. Thanks
0
 
LVL 12

Expert Comment

by:Hairbrush
ID: 35312050
What did you use Management Studio to do?
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

624 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