SQL ERROR Cant start services

[tanos77]

SQL errors:
people I'm having problems with the server because my SQL is falling; and it won't let me start the server. This has already happened to me on several occasions, having to uninstall everything. And reinitialize the database load and configurations. It has already happened to me 3 times. I leave the error that I mentioned in the images, I already tried several options, configure the waiting time in the registry, modify the load of the sql file, change the configuration of the session start to Buil-in-account, and other assumptions Solutions that fail to solve the problem could help me or guide me on the right path. Thank you.

[ThunderNikk]

Which SQL version are you running

What is your OS

Maybe some of your computer specs could be helpful

The event log that it asks you to look at could be nice

Are you set up as an administrative account

Does SQL server run with elevated or administrative privileges

Pretty much we know nothing about your set up and now we have to try and tell you why your SQL services dont start.

I have no idea

[tanos77]

Hello I answer you:
What version of SQL are you running? 2014
What is your operating system: Windows 10 64x

The event log that it asks you to look at could be good: It doesn't give me a log report, since it doesn't even start.
Is it configured as an administrative account? YEAH

Does the SQL server run with elevated or administrative privileges? Administrator always.

The problem is that the connection usually drops, I already tried to add to the registry the line that many tutorials suggest to avoid this but it keeps happening. ( is the following, ServicesPipeTimeout). But it usually happens that both SQL SERVER AND SQL SERVER AGENT are turned off.
When trying to start it, the mentioned errors appear.

I appreciate your help, and I know it can be tedious having to answer questions from new people on this, but whenever you've responded to any message, (which I appreciate) you've always made some kind of comment as if everyone else were experts on it. issue. It tends to be that many of us are BEGINNING in this and that's why we usually ask, but I always feel that it bothers you to answer because of the kind of comments that you usually make to all of us (I'm talking about the forum in general since I've read a lot here) so If the questions we ask cause you anger or frustration, please let someone else answer. Thank you.

[ThunderNikk]

You are not changing the default SQL TCP/IP ports from 1433 are you?

I am not familiar with registry edits suggested by tutorials sorry. I have never had to edit the registry for SQL to work but then again I am running MY SQL server on my personal gaming desktop. I do not connect remotely. (I will take a look and see if I can find what you are talking about)

I also run SQL at work though for other things with nothing but remote connections.

Maybe someone else might know if 2014 is still a valid SQL seems a little old. Im only thinking some support may no longer be there.

You probably dont need server agent running but if the other one doesnt start it would sure leave you down and out.

Take a look at your client protocols and protocols in the configuration manager listing and make sure they are all still enabled?

My "log on as" are quite different from yours also I have the following...

NT Service\MSSQLSERVER
NT Service\SQLSERVERAGENT
Browser is LOCALSERVICE

Im not sure if it is because you named your SQL installation instead of default but having the $ there when it is not in the server name seems odd to me

My server name is exactly the same as the "Log on as"

SQL Server (MSSQLSERVER)

Log on as

NT Service\MSSQLSERVER

Since your server name column states...

SQL Server (RAPPELZCALIXTO)

It makes me think yours should be...

NT Service\RAPPELZCALIXTO

[tanos77]

Yes i changing. i follow the server tutorial step by step. Server work fine two, three days then its down. I try different options before i ask here. Only work uninstall and install all sql again.

[ThunderNikk]

You arent using a trial install of SQL are you?

[tanos77]

no, full version. tomorrow i try to reinstall all, and leave the default server installation path.

[tanos77]

Well I have reinstalled everything, and configured everything again, version 9.5 is running correctly. Now I want to know how I add the resources to obtain more items (set lava, for example) I take as an example dark rappelz who has very good items.

[tanos77]

Again the same error, SQL configurator services got down, and not start Server Agent, and Sql server..