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