Click here to Skip to main content
12,253,335 members (51,799 online)
Rate this:
 
Please Sign up or sign in to vote.
Before i have SQL Server 2005 It's get correpted thats why i uninstalled and try to installing a New one while installing following Error will come but installed in Windows Authentication mode.


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.


But when i tried to Login the following Error will come.



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)



Thanks in Advance
Posted 11-Oct-12 19:02pm
Comments
jvamsikrishna 12-Oct-12 1:08am
   
I think this is installation problem,
please un-install completely with previous instances and install freshly,
check your network permissions in your system
Remote access is available?
ip is configured properly?
network instances are named correctly?

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

This error occured due to many reasons
try steps in this link
http://www.sswug.org/articlesection/default.aspx?TargetID=44331[^]
  Permalink  
Comments
leaderbalaji 12-Oct-12 1:33am
   
i cant get anything here
http://www.sswug.org/articlesection/default.aspx?TargetID=44331[^]
Uma Shankar Patel 12-Oct-12 1:58am
   
check your sql server services running on your system
or
you pass correct instance name when connecing to database engine
leaderbalaji 12-Oct-12 2:04am
   
Ya I tried To Start manually but that are not getting started.
leaderbalaji 12-Oct-12 3:08am
   
One Friend Suggest me like this

For your login issue check the following steps

Run SQL Server Configuration Manager.
Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.
Make sure TCP/IP is enabled.

for this following error

SQL Configaration Manager

Error is :

MMC Could not create the snap-in
MMC could not create the snap-in might not have been installed correctly.
Name:SQL Server Configuration Manager
CLSID: {CA9F8727-31DF-(&%C-887D84903967}



what can i do
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

One Friend Suggest me like this

For your login issue check the following steps

Run SQL Server Configuration Manager.
Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.
Make sure TCP/IP is enabled.

for this following error

SQL Configaration Manager

Error is :

MMC Could not create the snap-in
MMC could not create the snap-in might not have been installed correctly.
Name:SQL Server Configuration Manager
CLSID: {CA9F8727-31DF-(&%C-887D84903967}



what can i do
  Permalink  
Comments
leaderbalaji 12-Oct-12 3:10am
   
i think for successfull installation

SQL Server Network Configaration Manager(Local)
three Options should come that are
1.Sql Server Services
2.Sql Server Network Configaration
3.SQL Native Client 10.0 Configaration

for me these three are not comming that is the issue actually
leaderbalaji 12-Oct-12 3:33am
   
http://egranthalaya.nic.in/How_to_Install_and_setup_SQL_Server_2005_Manually.pdf

in the above link Please see the step 21

SQl Server Database Services

only this option is not installing
leaderbalaji 12-Oct-12 4:02am
   
If any Sollution
Other wise i will Remove my OS and Install New Operating System

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
Web02 | 2.8.160426.1 | Last Updated 12 Oct 2012
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