>>>>>>Hi,
>>>>>>
>>>>>>I downloaded and installed SQL Server 2008 R2 Express on the computer which didn't have any other version of SQL Server. The installation went through without errors. Now when I start SSMS the Window Connect to Server shows the server name as (local). And Authentication is Windows. When I click on Connect I get error.
>>>>>>
>>>>>>A network-related or instance specific error occurred while establishing a connection. The serve was not found or was not accessible...
>>>>>>
>>>>>>When I click on the pull-down list of the Server name and then on click on "Browse for more" no server names appear.
>>>>>>What step do I need to make the server accessible?
>>>>>>TIA.
>>>>>
>>>>>Run SQL Browser.
>>>>>Are you sure you added current user as administrator when you installed SQL Server?
>>>>>Are Service run?
>>>>
>>>>I opened the SQL Server Configuration Manager. The SQLEXPRESS is running. But the SQL Server Browser is stopped. And I don't have the option to start it (when right-mouse click).
>>>
>>>Use the Services app from Administrative Tools to set the properties for the SQL Browser service.
>>
>>Success! Now when I started the SQL Server Browser and enter the name not as local but as COMPUTERNAME\SQLEXPRESS I get into the SQL Server.
>>Thank you all very much.
>
>:-)
>SQL Server Browser is just for that - to find named instances of the SQL Server.
I didn't know that. Thank you for clarifying.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham