CODEWITHSUNDEEP
sqlsql-serversql-server-2012
SathyaWP
SathyaWP

Reputation: 117

Default server name for Microsoft SQL Server Management Studio 2012

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. SQL Server Management Studio 2012 - Login Screen

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

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

Upvotes: 4

Views: 30449

Answers (4)

Kishan Bheemajiyani
Kishan Bheemajiyani

Reputation: 3439

Well I was facing same issue and when i have done something like this 

Server name : "your computer user name"\SQLExpress

and use your user name and password that you have given while installing the SQL studio.

it will work.

Upvotes: 2

Hernan Demczuk
Hernan Demczuk

Reputation: 405

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!

Upvotes: 2

vhadalgi
vhadalgi

Reputation: 7189

By default it takes the name of the computer say if the computer name is B,then enter B as server's name with windows authentication

Upvotes: 0

podiluska
podiluska

Reputation: 51494

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.

Upvotes: 8

Related Questions