Click here to Skip to main content
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 11-Oct-12 23:59pm
Edited 12-Oct-12 0: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 2

First we need to Remove visualStudio
and then install Sql Server 2005 then it will get install successfully.
  Permalink  

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

  Print Answers RSS
0 CHill60 360
1 Sarvesh Kumar Gupta 248
2 OriginalGriff 218
3 Sergey Alexandrovich Kryukov 158
4 RyanDev 120


Advertise | Privacy | Mobile
Web03 | 2.8.140709.1 | Last Updated 2 May 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid