MSSQLSERVER service error when starting (timely fashion problem) :((

Hi All,

I would need your help please :((.

When i tried to start the SQL Server service theres an error sayin like this

"The MSSQLSERVER service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion. "

Do you have any web link for solution or you have any solutions, please kindly help :((.

Thanks a lot

Best Regards

Felix Adhitya

If you are using a local or domain account for SQL Server services startup then ensure the username and password has been supplied correctly to authenticate.

Is this a new installation of SQL Server?

If not check the SQL has been installed properly from SQLSTP.LOG.

If you are using a firewall then ensure the specified port in SQL configuration manager has been kept open for authentication. KBA http://support.microsoft.com/default.aspx?scid=kb;en-us;287932 for a reference on authentication.

|||

Hi Satya,

Thanks a lot for your reply.

However we have decided to reinstall the server, if we encounter the same problem i will try your suggestion

Many thanks

Felix Adhitya

MSSQLSERVER service error when starting (timely fashion problem) :((

Hi All,

I would need your help please :((.

When i tried to start the SQL Server service theres an error sayin like this

"The MSSQLSERVER service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion. "

Do you have any web link for solution or you have any solutions, please kindly help :((.

Thanks a lot

Best Regards

Felix Adhitya

If you are using a local or domain account for SQL Server services startup then ensure the username and password has been supplied correctly to authenticate.

Is this a new installation of SQL Server?

If not check the SQL has been installed properly from SQLSTP.LOG.

If you are using a firewall then ensure the specified port in SQL configuration manager has been kept open for authentication. KBA http://support.microsoft.com/default.aspx?scid=kb;en-us;287932 for a reference on authentication.

|||

Hi Satya,

Thanks a lot for your reply.

However we have decided to reinstall the server, if we encounter the same problem i will try your suggestion

Many thanks

Felix Adhitya

MSSQL_ENG020598 - The row was not found at the Subscriber when applying the replicated command.

Hello,

We are seeing error MSSQL_ENG020598 - "The row was not found at the Subscriber when applying the replicated command", when running peer to peer transactional replication. Unfortunately the error message provides the database in which the error occurs but not the table or SQL statement that causes the conflict.

Is there a way to determine exactly what query caused the conflict - or at least what table the error occurred in?

Thanks in advance.

If you run distribution agent in a job, you can set the OutputVerboseLevel of distribution agent profile to 2.

If you run distribution agent from command line, simply set parameter -OutputVerbloseLevel to 2.

It shows the exact SQL statement that distribution agent use.

Peng

|||Thanks, this looks like it helped.