Click here to Skip to main content
11,429,777 members (74,944 online)
Rate this: bad
good
Please Sign up or sign in to vote.
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

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 12-Oct-12 0:59am
Edited 12-Oct-12 1:34am
v2
Comments
Wes Aday at 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 at 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 Wink | ;)

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

Solution 2

First we need to Remove visualStudio
and then install Sql Server 2005 then it will get install successfully.
  Permalink  
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 at 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)



Advertise | Privacy | Mobile
Web03 | 2.8.150428.2 | Last Updated 8 Nov 2014
Copyright © CodeProject, 1999-2015
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