Installing SQL Server 2005 Problem in

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

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.

VB

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

Balu Balaji

Add a Solution

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?

2 solutions

Add a Solution

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

uspatel · Answer 1 · 2012-10-11T19:08:00

Solution 1

This error occured due to many reasons
try steps in this link
http://www.sswug.org/articlesection/default.aspx?TargetID=44331[^]

Posted 11-Oct-12 19:08pm

uspatel

Comments

Balu Balaji 12-Oct-12 1:33am

i cant get anything here
http://www.sswug.org/articlesection/default.aspx?TargetID=44331[^]

uspatel 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

Balu Balaji 12-Oct-12 2:04am

Ya I tried To Start manually but that are not getting started.

Balu Balaji 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

Balu Balaji · Answer 2 · 2012-10-11T20:53:00

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

Posted 11-Oct-12 20:53pm

Balu Balaji

Comments

Balu Balaji 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

Balu Balaji 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

Balu Balaji 12-Oct-12 4:02am

If any Sollution
Other wise i will Remove my OS and Install New Operating System

Installing SQL Server 2005 Problem in

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Installing SQL Server 2005 Problem in

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us