Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Not able to restart the MSSQL Server Services


Not able to restart the MSSQL Server Services

Author
Message
Swapnil Saurav
Swapnil Saurav
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 2

Hi,

I am working on SQL Server 2005 June CTP on Windows 2003 Server SP 1. I restarted my computer but now I am not able to start the MSSQLServer service. When I try to start the service I get this message The SQL Server (MSSQLSERVER) service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service.

Other services Analysis services, Browser, Integration Services, Reporting services, VSS writer, all are running.

I have checked the Event Viewer, 4 error meesages are seen all related to MSSQLServer, they are:

1&2. Event ID 17182: TDSSNIClient initialization failed with error 0x7e, status code 0x3a.

3. Event ID 17826: Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

4. Event ID 17120: SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

Please help me!

Thanks a ton in advance,

Swapnil



david russell-253790
david russell-253790
SSC Veteran
SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)

Group: General Forum Members
Points: 256 Visits: 1

It seems that all bets are off as far as the June CTP goes. Get the current product and do a fresh install. My experience has been that a new OS install is in order, too. I understand that MS has released, as of last Tuesday or so, yet another new cleanup tool that cleans up after all versions of the CTPs. It hasn't been tried here, and by now we're smart enough to have Ghosted versions of clean and patched OS installations.

It just does not make sense to try to support an old Beta.




Cheers,

david russell

Hendra Eka Putra
Hendra Eka Putra
SSC-Enthusiastic
SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)

Group: General Forum Members
Points: 115 Visits: 77
Happened to me, on testing environment using SQL Server 2005 Enterprise. Anybody knows how to solve this problem other than re-install?
Balmukund Lakhani-269523
Balmukund Lakhani-269523
Old Hand
Old Hand (346 reputation)Old Hand (346 reputation)Old Hand (346 reputation)Old Hand (346 reputation)Old Hand (346 reputation)Old Hand (346 reputation)Old Hand (346 reputation)Old Hand (346 reputation)

Group: General Forum Members
Points: 346 Visits: 367

Can you please post recent ErrorLog? If SQL is not coming up, error log is the first place to start.


benimposta
benimposta
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 0
OPEN THE SQL SERVER CONFIGRATION MANAGER
CLICK THE SQL SERVER 2005 NETWORK CONFIGRATION

DISABLED VIA.
amiller.hcgo
amiller.hcgo
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 0
This also happen to me just recently, looking for solutions, the work around I found was to disable the TCP setting and go with name pipe. Not the best solution but works. I would like to go back to TCP/IP but when ever I enable the setting and restart SQL I get the following errors:

* Event Time: 10/6/2008 10:05:10 AM

* MSSQLSERVER Error Event

* Event ID: 17182

* TDSSNIClient initialization failed with error 0x2740, status code 0xa.



* Event Time: 10/6/2008 10:05:10 AM

* MSSQLSERVER Error Event

* Event ID: 17182

* TDSSNIClient initialization failed with error 0x2740, status code 0x1.



* Event Time: 10/6/2008 10:05:10 AM

* MSSQLSERVER Error Event

* Event ID: 17826

* Could not start the network library becasue of an internal error in the network library.

To determine the cause, review the errors immediately proceding this one in the error log.



* Event Time: 10/6/2008 10:05:10 AM

* MSSQLSERVER Error Event

* Event ID: 17120

* SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

Need help other then reinstalling SQL....


Thanks,

Aaron
jamesvgeorge
jamesvgeorge
SSC Journeyman
SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)

Group: General Forum Members
Points: 90 Visits: 93
Even I had faced the same problem. I disabled VIA Protocol (Server) through configuration manager and reboot the server. Agree with benimposta.
MANU-J.
MANU-J.
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1714 Visits: 8766
Seems like you might have something listening on TCP port configured for this instance or might be its blocked somehow.

Do you have more than one SQL Server instance on your machine? Did you install the instance you are having trouble with as a default instance?

MJ
khushbu
khushbu
SSC Veteran
SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)

Group: General Forum Members
Points: 287 Visits: 747
Hi

This problem usually arise when there are 2 instances of SQL Server and both are listening to same port.

Just change the port number for one of the instances and things would work fine!

HTH
elangooo
elangooo
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 11
Dear All,

1. Export "Regedit - HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\Tcp\IP1" registry

2. Open the exported file in Notepad

3. Change the IP1 as IP2

4. Change the IP address of the current machine IP address in "IpAddress" REG_SZ value - Save and close the file

5. Start the SQL service

IMPORTANT NOTE:If the current IP address is available in IP1, Please add as 127.0.0.1 in IP2

---
All is well
ElanGovan Panchatcharam
http://gofrugal.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search