Click here to Skip to main content
15,851,335 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
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
Updated 12-Oct-12 1:34am
v2
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

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.
 
Share this answer
 
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[^]
 
Share this answer
 
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.
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!
 
Share this answer
 
v2
Comments
Manas Bhardwaj 8-Nov-14 13:09pm    
Why open an old question?

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900