Default server name for Microsoft SQL Server Management Studio 2012

Question

I wanted to use Microsoft SQL Server and thereby installed a fresh copy of Microsoft SQL Server Management Studio 2012. It was an automatic installation and did not ask me for a server name. Right now, I'm stuck at the login screen and not sure what to put as the server name.

I happened to refer few previously posted questions and tried using ".\SQLExpress" as the Server Name, but the following error was displayed

What could be the possible Server Name ? PS: The system name is "CBEUG".

Answer 1

SQL Management Studio is just that - the management studio tools. It is not the SQL Server itself. For that, you will need to install the SQL Server package.

If you can't see a SQL Server services in Services, it is not installed.

Answer 2

In the Server Name field (where you type the server name) you also have a scroll box with "Browse database..." (or something like that according to the version). That's where all of your databases are so you don't have to remember their names. Good luck!