Can't start SQL Server (MSSQLSERVER) service

This is a multi-part message in MIME format.

------=_NextPart_000_0008_01C84158.AE20C5D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi All,

Sorry if this is not the right NG.

I can't get the SQL Server (MSSQLSERVER) service to start on my =
sharepoint server and I believe this is stopping sharepoint from =
working. We are running 2003 std SP2 and windows sharepoint services v2

In the event log I am getting the below errors. Can anyone help me =
troubleshoot this? Am more than happy to provide further info.

Thanks,
-H

Event ID -1000
#50070: Unable to connect to the database STS_Config_TFS on pluto. =
Check the database connection information and make sure that the =
database server is running.

Event ID - 3014

TF53010: An unexpected condition has occurred in a Team Foundation =
component. The information contained here should be made available to =
your site administrative staff.

Technical Information (for the administrative staff):

Date (UTC): 12/18/2007 9:26:17 AM

Machine: PLUTO

Application Domain: /LM/W3SVC/2/Root/services-5-128424435624349443

Assembly: Microsoft.TeamFoundation.Server, Version=3D8.0.0.0, =
Culture=3Dneutral, PublicKeyToken=3Db03f5f7f11d50a3a; v2.0.50727

Process Details:

Process Name: w3wp

Process Id: 1892

Thread Id: 5608

Account name: SCAFFTAG_HQ\SafetrakSVR

Detailed Message: TF30059: Fatal error while initializing web service

Web Request Details

Url: http://pluto:8080/Services/v1.0/ServerStatus.asmx [method: POST]

User Agent: Team Foundation (TFSServerScheduler.exe, 8.0.50727.147)

Headers: =
Content-Length=3D354&Content-Type=3Dtext%2fxml%3b+charset%3dutf-8&Accept-=
Encoding=3Dgzip&Accept-Language=3Den-US&Expect=3D100-continue&Host=3Dplut=
o%3a8080&User-Agent=3DTeam+Foundation+(TFSServerScheduler.exe%2c+8.0.5072=
7.147)&X-TFS-Version=3D1.0.0.0&SOAPAction=3D%22http%3a%2f%2fschemas.micro=
soft.com%2fTeamFoundation%2f2005%2f06%2fServices%2fServerStatus%2f03%2fCh=
eckAuthentication%22

Path: /Services/v1.0/ServerStatus.asmx

Local Request: True

Host Address: 161.161.161.180

User: SCAFFTAG_HQ\SafetrakSVR [authentication type: NTLM]

Exception Message: An error has occurred while establishing a =
connection to the server. When connecting to SQL Server 2005, this =
failure may be caused by the fact that under the default settings SQL =
Server does not allow remote connections. (provider: Named Pipes =
Provider, error: 40 - Could not open a connection to SQL Server) (type =
SqlException)

SQL Exception Class: 20

SQL Exception Number: 2

SQL Exception Procedure:=20

SQL Exception Line Number: 0

SQL Exception Server:=20

SQL Exception State: 0

SQL Error(s):

Exception Data Dictionary:

HelpLink.ProdName =3D Microsoft SQL Server

HelpLink.EvtSrc =3D MSSQLServer

HelpLink.EvtID =3D 2

HelpLink.BaseHelpUrl =3D http://go.microsoft.com/fwlink

HelpLink.LinkId =3D 20476

Exception Stack Trace: at =
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection =
owningObject)

at =
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection =
owningConnection)

at =
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection =
outerConnection, DbConnectionFactory connectionFactory)

at System.Data.SqlClient.SqlConnection.Open()

at =
Microsoft.TeamFoundation.RegistrationDataAccessor.GetRegisteredTools(Stri=
ng toolId, String connectionString)

at=20

------=_NextPart_000_0008_01C84158.AE20C5D0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16544" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV>Hi All,</DIV>
<DIV> </DIV>
<DIV>Sorry if this is not the right =
NG.</DIV>
<DIV> </DIV>
<DIV>I can't get the SQL Server =
(MSSQLSERVER) service to=20
start on my sharepoint server and I believe this is stopping sharepoint =
from=20
working. We are running 2003 std SP2 and windows sharepoint services=20
v2</DIV>
<DIV> </DIV>
<DIV>In the event log I am getting the below =
errors. Can=20
anyone help me troubleshoot this? Am more than happy to provide further=20
info.</DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV>-H</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Event ID -1000</DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
#50070: Unable to connect to the =
database=20
STS_Config_TFS on pluto. Check the database connection information and =
make=20
sure that the database server is running.</BLOCKQUOTE>
Event ID - 3014
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
TF53010: An unexpected condition has =
occurred in a=20
Team Foundation component. The information contained here should be =
made=20
available to your site administrative staff.
Technical Information (for the =
administrative=20
staff):
Date (UTC): 12/18/2007 9:26:17 =
AM
Machine: PLUTO
Application Domain:=20
/LM/W3SVC/2/Root/services-5-128424435624349443
Assembly: =
Microsoft.TeamFoundation.Server,=20
Version=3D8.0.0.0, Culture=3Dneutral, =
PublicKeyToken=3Db03f5f7f11d50a3a;=20
v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 1892
Thread Id: 5608
Account name: =
SCAFFTAG_HQ\SafetrakSVR
Detailed Message: TF30059: Fatal error =
while=20
initializing web service
Web Request Details
Url:=20
http://pluto:8080/Services/v1.0/ServerStatus.asmx [method: =
POST]
User Agent: Team Foundation=20
(TFSServerScheduler.exe, 8.0.50727.147)
Headers:=20
=
Content-Length=3D354&Content-Type=3Dtext%2fxml%3b+charset%3dutf-8&amp=
;Accept-Encoding=3Dgzip&Accept-Language=3Den-US&Expect=3D100-cont=
inue&Host=3Dpluto%3a8080&User-Agent=3DTeam+Foundation+(TFSServerS=
cheduler.exe%2c+8.0.50727.147)&X-TFS-Version=3D1.0.0.0&SOAPAction=
=3D%22http%3a%2f%2fschemas.microsoft.com%2fTeamFoundation%2f2005%2f06%2fS=
ervices%2fServerStatus%2f03%2fCheckAuthentication%22
Path: =
/Services/v1.0/ServerStatus.asmx
Local Request: True
Host Address: =
161.161.161.180
User: SCAFFTAG_HQ\SafetrakSVR =
[authentication type:=20
NTLM]
Exception Message: An error has =
occurred while=20
establishing a connection to the server. When connecting to SQL Server =
2005,=20
this failure may be caused by the fact that under the default settings =
SQL=20
Server does not allow remote connections. (provider: Named Pipes =
Provider,=20
error: 40 - Could not open a connection to SQL Server) (type=20
SqlException)
SQL Exception Class: 20
SQL Exception Number: 2
SQL Exception Procedure: 
SQL Exception Line Number: 0
SQL Exception Server: 
SQL Exception State: 0
SQL Error(s):
Exception Data Dictionary:
HelpLink.ProdName =3D Microsoft SQL =
Server
HelpLink.EvtSrc =3D =
MSSQLServer
HelpLink.EvtID =3D 2
HelpLink.BaseHelpUrl =3D=20
http://go.microsoft.com/fwlink
HelpLink.LinkId =3D 20476
 
Exception Stack Trace: at=20
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection=20
owningObject)
at=20
=
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection=20
owningConnection)
at=20
=
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection=20
outerConnection, DbConnectionFactory connectionFactory)
at=20
System.Data.SqlClient.SqlConnection.Open()
at=20
=
Microsoft.TeamFoundation.RegistrationDataAccessor.GetRegisteredTools(Stri=
ng=20
toolId, String connectionString)
at =
</BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0008_01C84158.AE20C5D0--

Mike
Tue Dec 18 04:05:50 CST 2007

This (which I thought was only for SBS 2003 and its WSS 2.0) might help

http://wss.asaris.de/sites/walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=198

Mike Walsh
WSS FAQ www.wssfaq.com / wss.collutions.com
no private e-mail questions please

H wrote:
> Hi All,
>
> Sorry if this is not the right NG.
>
> I can't get the SQL Server (MSSQLSERVER) service to start on my
> sharepoint server and I believe this is stopping sharepoint from
> working. We are running 2003 std SP2 and windows sharepoint services v2
>
> In the event log I am getting the below errors. Can anyone help me
> troubleshoot this? Am more than happy to provide further info.
>
> Thanks,
> -H
>
>
> Event ID -1000
>
> #50070: Unable to connect to the database STS_Config_TFS on pluto.
> Check the database connection information and make sure that the
> database server is running.
>
> Event ID - 3014
>
> TF53010: An unexpected condition has occurred in a Team Foundation
> component. The information contained here should be made available
> to your site administrative staff.
>
> Technical Information (for the administrative staff):
>
> Date (UTC): 12/18/2007 9:26:17 AM
>
> Machine: PLUTO
>
> Application Domain: /LM/W3SVC/2/Root/services-5-128424435624349443
>
> Assembly: Microsoft.TeamFoundation.Server, Version=8.0.0.0,
> Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
>
> Process Details:
>
> Process Name: w3wp
>
> Process Id: 1892
>
> Thread Id: 5608
>
> Account name: SCAFFTAG_HQ\SafetrakSVR
>
> Detailed Message: TF30059: Fatal error while initializing web service
>
> Web Request Details
>
> Url: http://pluto:8080/Services/v1.0/ServerStatus.asmx [method: POST]
>
> User Agent: Team Foundation (TFSServerScheduler.exe, 8.0.50727.147)
>
> Headers:
> Content-Length=354&Content-Type=text%2fxml%3b+charset%3dutf-8&Accept-Encoding=gzip&Accept-Language=en-US&Expect=100-continue&Host=pluto%3a8080&User-Agent=Team+Foundation+(TFSServerScheduler.exe%2c+8.0.50727.147)&X-TFS-Version=1.0.0.0&SOAPAction=%22http%3a%2f%2fschemas.microsoft.com%2fTeamFoundation%2f2005%2f06%2fServices%2fServerStatus%2f03%2fCheckAuthentication%22
>
> Path: /Services/v1.0/ServerStatus.asmx
>
> Local Request: True
>
> Host Address: 161.161.161.180
>
> User: SCAFFTAG_HQ\SafetrakSVR [authentication type: NTLM]
>
> Exception Message: An error has occurred while establishing a
> connection to the server. When connecting to SQL Server 2005, this
> failure may be caused by the fact that under the default settings
> SQL Server does not allow remote connections. (provider: Named Pipes
> Provider, error: 40 - Could not open a connection to SQL Server)
> (type SqlException)
>
> SQL Exception Class: 20
>
> SQL Exception Number: 2
>
> SQL Exception Procedure:
>
> SQL Exception Line Number: 0
>
> SQL Exception Server:
>
> SQL Exception State: 0
>
> SQL Error(s):
>
> Exception Data Dictionary:
>
> HelpLink.ProdName = Microsoft SQL Server
>
> HelpLink.EvtSrc = MSSQLServer
>
> HelpLink.EvtID = 2
>
> HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
>
> HelpLink.LinkId = 20476
>
>
>
> Exception Stack Trace: at
> System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
> owningObject)
>
> at
> System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
> owningConnection)
>
> at
> System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
> outerConnection, DbConnectionFactory connectionFactory)
>
> at System.Data.SqlClient.SqlConnection.Open()
>
> at
> Microsoft.TeamFoundation.RegistrationDataAccessor.GetRegisteredTools(String
> toolId, String connectionString)
>
> at
>

Winmai
Fri Jan 25 05:30:02 CST 2008

"H" wrote:

> Hi All,
>
> Sorry if this is not the right NG.
>
> I can't get the SQL Server (MSSQLSERVER) service to start on my sharepoint server and I believe this is stopping sharepoint from working. We are running 2003 std SP2 and windows sharepoint services v2
>
> In the event log I am getting the below errors. Can anyone help me troubleshoot this? Am more than happy to provide further info.
>
> Thanks,
> -H
>
>
> Event ID -1000
> #50070: Unable to connect to the database STS_Config_TFS on pluto. Check the database connection information and make sure that the database server is running.
>
> Event ID - 3014
>
> TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.
>
> Technical Information (for the administrative staff):
>
> Date (UTC): 12/18/2007 9:26:17 AM
>
> Machine: PLUTO
>
> Application Domain: /LM/W3SVC/2/Root/services-5-128424435624349443
>
> Assembly: Microsoft.TeamFoundation.Server, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
>
> Process Details:
>
> Process Name: w3wp
>
> Process Id: 1892
>
> Thread Id: 5608
>
> Account name: SCAFFTAG_HQ\SafetrakSVR
>
> Detailed Message: TF30059: Fatal error while initializing web service
>
> Web Request Details
>
> Url: http://pluto:8080/Services/v1.0/ServerStatus.asmx [method: POST]
>
> User Agent: Team Foundation (TFSServerScheduler.exe, 8.0.50727.147)
>
> Headers: Content-Length=354&Content-Type=text%2fxml%3b+charset%3dutf-8&Accept-Encoding=gzip&Accept-Language=en-US&Expect=100-continue&Host=pluto%3a8080&User-Agent=Team+Foundation+(TFSServerScheduler.exe%2c+8.0.50727.147)&X-TFS-Version=1.0.0.0&SOAPAction=%22http%3a%2f%2fschemas.microsoft.com%2fTeamFoundation%2f2005%2f06%2fServices%2fServerStatus%2f03%2fCheckAuthentication%22
>
> Path: /Services/v1.0/ServerStatus.asmx
>
> Local Request: True
>
> Host Address: 161.161.161.180
>
> User: SCAFFTAG_HQ\SafetrakSVR [authentication type: NTLM]
>
> Exception Message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (type SqlException)
>
> SQL Exception Class: 20
>
> SQL Exception Number: 2
>
> SQL Exception Procedure:
>
> SQL Exception Line Number: 0
>
> SQL Exception Server:
>
> SQL Exception State: 0
>
> SQL Error(s):
>
> Exception Data Dictionary:
>
> HelpLink.ProdName = Microsoft SQL Server
>
> HelpLink.EvtSrc = MSSQLServer
>
> HelpLink.EvtID = 2
>
> HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
>
> HelpLink.LinkId = 20476
>
>
>
> Exception Stack Trace: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
>
> at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
>
> at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
>
> at System.Data.SqlClient.SqlConnection.Open()
>
> at Microsoft.TeamFoundation.RegistrationDataAccessor.GetRegisteredTools(String toolId, String connectionString)
>
> at
>

Winmai
Fri Jan 25 05:32:01 CST 2008

Hello At,

Did you have teh right solution to fix your problem? Is 'yes' can you share"

I have a similar, if not the same, problems as yours. To-date I have many
and the problems persist. I checked my settings and permissions and I think
they are all in order. So I'm puzzled!!!

I don't want to be thinkering and cause more problems for myself (..which
perhaps I am not ablt to 'roll-back')

Cheers,
Winmai

Can't start SQL Server (MSSQLSERVER) service

Re: Can't start SQL Server (MSSQLSERVER) service by Mike

RE: Can't start SQL Server (MSSQLSERVER) service by Winmai

RE: Can't start SQL Server (MSSQLSERVER) service by Winmai