Click here to Skip to main content
12,504,519 members (55,613 online)
Rate this:
 
Please Sign up or sign in to vote.
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

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:
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
Updated 12-Oct-12 0:34am
v2
Comments
Wes Aday 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?
leaderbalaji 12-Oct-12 6:42am
   
so what can i do
Rate this: bad
 
good
Please Sign up or sign in to vote.

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.
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

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[^]
  Permalink  
v3
Comments
Member 12071319 19-Oct-15 18:09pm
   
patel, you saved the day.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 5

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!
  Permalink  
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)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160919.1 | Last Updated 1 Apr 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100