Solved

i dont found any instance name to run sql server 2005 enterprise edition sp3 after i installed on windows 7 64bit ?

Posted on 2011-02-16
5
783 Views
Last Modified: 2012-05-11
I installed sql 2005 enterprise edition sp 3 on my windows 7- 64 bit. But after installation when i start the management studio its asked me for instance name ..i tried all the way to do it but its not working...

when i was installing sql server 2005 sp3 its doesnt asked me for any instance . After installing when i am trying to open the management studio so its asked me to give instance name but it doesnot accept any instance name.(server name). Even i am trying to connect with network also but it doesnot work.

Now when when i run "Management Studio" There is no name in "Server name" section . I typed my Computer name Or "." and i got this Error :

A network -related instance-specific error occurred while establishinga 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: Named Pipes Provider , error :40 - Could not open a connection to SQL Server ) ( Microsoft SQL Server , Error :2) .

I googled some for this Error and some people said follow this instruction:

Start>sql server 2005>Configuration tools>Sql Server Surface Configuration Area>Surface Area Configuration for services and Connections

But i got this Error :

No SQl SErver 2005 Components were found on the specified computer . Either no components are installed , or you are not a administrator on this computer (SQLSAC)..

wat should i have to do? i m stuck because anyhow i have to solved this problem immediately
0
Comment
Question by:krishnabalar
5 Comments
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34906113
Take a look in Services. There should be a service called "SQL Server ([Instance Name])".

If not then SQL is not installed.
0
 
LVL 1

Accepted Solution

by:
banditkd earned 500 total points
ID: 34906280
If you didn't specifiy an instance name then it would ahve installed a default instance so (local) would allow you to connect.

p.s. the brackets are needed

if that doesn't work it sounds like you just installed mangement studio and not the sql engine. you can confirm this by going to control panel -> Programs and Features

Select Microsoft SQL Server 2005 (64bit) if you used the x64 version or Microsoft SQL Server 2005 if it is the 32 bit version (not sure about the exact as i don't use 32 bit versions anymore)

click Change\Remove and then click Remove

SQL will then try and identify the instances installed  - if you can't get this far then it pretty much confirms that sql is not installed or the installation corrupt which is a whole different ballgame
0
 

Author Comment

by:krishnabalar
ID: 35023296
okie
0
 
LVL 59

Expert Comment

by:LeeTutor
ID: 35252721
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
By default the complete memory dump option is disabled in windows . If we want to enable the complete memory dump for a diagnostic purpose, we have a solution for it. here we are using the registry method to enable this.
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question