Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Cannot connect to SQL Server express from SSMS

Tags:

enter image description here

enter image description here

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.

like image 434
Abid Ali Avatar asked May 15 '11 06:05

Abid Ali


People also ask

How do I connect to SQL Express from SSMS?

Connect to the SQL Server using SSMS Next, from the Connect menu under the Object Explorer, choose the Database Engine… Then, enter the information for the Server name (localhost), Authentication (SQL Server Authentication), and password for the sa user and click the Connect button to connect to the SQL Server.

Does SSMS work with SQL Server Express?

SQL Express does not install the SQL Management Studio so you have to get this installed yourself. You may need to manage users like the built in 'sa' user and its password. For example when installing the AlarmDB Logger Manager.


2 Answers

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.

like image 195
Alex Aza Avatar answered Oct 03 '22 23:10

Alex Aza


Please see:

  • Solving Connectivity errors to SQL Server
  • Troubleshoot connecting to the SQL Server Database Engine
like image 31
Mitch Wheat Avatar answered Oct 03 '22 23:10

Mitch Wheat