Solved

SQL 2005 errors

Posted on 2010-08-24
1
269 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

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

Suggested Solutions

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 …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

895 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