Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't Start MSSQLServer Service

Status
Not open for further replies.
scottfindlay

scottfindlay

IS-IT--Management
Sep 25, 2001
4
GB
Help !

I can't start the MSSQLServer service. When I try and start the service I get a 2140 Error and the following in my event log :
The description for Event ID ( 17055 ) in Source ( MSSQLServer ) could not be found. It contains the following insertion string(s): 17130, initdata: no memory for kernel locks.

I have tried starting the server with sqlservr -c -f as per instructions from microsoft and changed some of the sp_configure settings (tempbd and memory), but this didn't work either.
I have also ran a Registry Rebuild for SQL but still no joy.

Regards

 
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
288
Andrzejek
Andrzejek
pabowen
  • Locked
  • Question
Determining Multiple 12 Month Term periods based on Start and End Date
Replies
3
Views
120
pabowen
pabowen
G12Consult
  • Locked
  • Question
Consume web service data daily
Replies
3
Views
80
gmmastros
gmmastros
mchambers
  • Locked
  • Question
Query to count patient with 2 or more visits within 90 days of first service
Replies
5
Views
100
johnherman
johnherman
BTrees
  • Locked
  • Question
Microsoft Reporting Services in Visual Studio-Add datasets through script
Replies
0
Views
63
BTrees
BTrees

Part and Inventory Search

Sponsor

Back
Top