Solved

SQL 2005 errors

Posted on 2010-08-24
1
270 Views
Last Modified: 2012-05-10
Windows 2003 r2 Standard sp2
SQL 2005 SP3

After a 18 hours power failure this past weekend i was able to restrt the servers

now I am getting these errors

Type :            Error
Date :            8/24/2010
Time :            5:01:20 PM
Event :            107
Source :            Report Server Windows Service (MSSQLSERVER)
Category :      Management
User :            N/A
Computer :      TGCS001
Description:
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

Type :            Error
Date :            8/24/2010
Time :            5:01:23 PM
Event :            27745
Source :            Windows SharePoint Services 3
Category :      General
User :            N/A
Computer :      TGCS001
Description:
The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) could not be found. It contains the following insertion string(s): .
#50071: Unable to connect to the database SharePoint_Config on tgcs001.  Check the database connection information and make sure that the database server is running.

event id 27745 was repeated 4 times

All the sql server serices are started

Any ideas
0
Comment
Question by:Inserachof
1 Comment
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 33517890
>> Check the database connection information and make sure that the database server is running.

Are you able to connect to the databases from SSMS or other SQL Server client.
If so, then check whether the connection credentials provided in Sharepoint are correct or not.

>> The description for Event ID ( 27745 )

Try executing the below commands from Command prompt..

net stop “Windows SharePoint Services Timer”
net start “Windows SharePoint Services Timer”
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

810 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