Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
New install of SQL 2008 R2 Express
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01546338
Message ID:
01546352
Vues:
37
>>>>>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform