Cannot connect to SQL Server express from SSMS

问题:

I have installed SQL Server Management Studio 2005. I can't find my server name when I click browse for more but i know that my server name will be the same as the user name as in the picture below.

回答1:

Use . or (local) or localhost for server name if you installed the server as default instance.

Use .\sqlexpress or localhost\sqlexpress if you have SQL Express.

The server name syntax is

Servername\InstanceName

If the instance is default you use just Servername.
For SQL Express, instance name is sqlexpress by default.

回答2:

Please see: SQL Server 2005 Connectivity Issue Troubleshoot