SQL Server service failed to start

Question

1.00/5 (2 votes)

See more:

SQL-Server-2005

while installing sql server 2005 following error came but installed

The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually.

so i tried to start these following services but it's not getting started because it shown bellow Error

HTML

msftesql$SQLEXPRESS1234
MSSQL$SQL2005
MSSQLServerADHelper
msftesql$SMARTSQL2005
msftesql$SQLEXPRESS
msftesql$SQLEXPRESS123
msftesql$SQLEXPRESS1234
MSSQL$SQLEXPRESS1234
MSSQL$SQLEXPRESS123
MSSQL$SQLEXPRESS
SQLBrowser

Error is

Windows could not start the sql server the above services on Local Computer.

Error2:The system cannot find the file specified.

so i am trying to login but it's got failure and showing message like

ERROR:

HTML

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.

Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

Posted 11-Oct-12 23:59pm

Balu Balaji

Updated 12-Oct-12 0:34am

Kenneth Haugland

v2

Add a Solution

Comments

[no name] 12-Oct-12 6:39am

So why is it that you are trying to connect to SQL Server when you know that it's not even starting?

Balu Balaji 12-Oct-12 6:42am

so what can i do

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2012-10-12T08:04:00

Solution 1

The old IT rule says: restart computer ;)

Download and install MS SQL Managment Studio[^]. Run MS SQL Server Manager[^] and try to run MS SQL Server. If it won't help, reinstall SQL server.

Posted 12-Oct-12 8:04am

Maciej Los

grapestech · Answer 2 · 2014-07-21T22:05:00

Solution 4

For SQL Server 2005 : just replace with (sqlservr.exe, sqlos.dll) and restart SQL Services

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn

download link from : https://drive.google.com/file/d/0BwO_5_XsCcVfRTBQMzR4eVdTQ00/edit?usp=sharing[^]

Posted 21-Jul-14 22:05pm

grapestech

Updated 22-Mar-16 0:28am

v3

Comments

Member 12071319 19-Oct-15 18:09pm

patel, you saved the day.

GIRISH RANA 8-Aug-19 4:13am

Hello, the download link is no longer available. I was wondering if there was another site/link that I could access? Thanks.

Kiran Shrihari Shenvi · Answer 3 · 2014-11-08T06:37:00

To solve this problem, you may need to repair your SQL Server 2005
Simple steps can be
1. Update/Install .Net 2.0 framework. Windows Installer 3.1 available online recommended
2. Download the setup file from Microsoft website :
http://www.microsoft.com/en-in/download/details.aspx?id=184[^]
2. Follow the steps mentioned below from the Symantec website:
http://www.symantec.com/connect/articles/install-and-configure-sql-server-2005-express[^]
Hope this helps!