2012 Management Studio Server Name

Question

2012 Management Studio Server Name

DaveBriCam

SSCarpal Tunnel

Points: 4294
More actions
November 20, 2013 at 9:15 am

#285372

I'm using SQL Server Management Studio 2012 and simply want to create a new database... when I launch SQL Server it prompts me for a Server Name... I just want to create this database locally for now... what do I put in the server window upon launch or should I just hit cancel? I'm kinda lost as usually I'm working on databases that already exist... thanks for any help fo this newbie!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323504 More actions · Answer 1

your local server has a number of aliases, and you might need to specifically look in Administrative tools>>Services to see if you have named instances.

assuming a default isntance, you could put:

. --that's right, just a period

(local)

127.0.0.1

machinename --(ie, if your computer is named DEV223)

192.168.?.? --your actual IP address on the network

--leaving it completely blank

if you have instances (here i'm assuming you went to services, and probably see a SQLEXPRESS instance; note in my screenshot have have 4 services:

he default instance)

and then named instances named:(on my machine named DEV223

DEV223\SQL2005

DEV223\SQL2008R2

DEV223\SQL2012

so you can connect to:

.\SQLEXPRESS

127.0.0.1\SQLEXPRESS

DEV223\SQLEXPRESS

192.168.?.?\SQLEXPRESS

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

DaveBriCam SSCarpal Tunnel Points: 4294 More actions · Answer 2

I went to Services and found nothing relating to SQL Server.

Lowell SSC Guru Points: 323504 More actions · Answer 3

briancampbellmcad (11/20/2013)
I went to Services and found nothing relating to SQL Server.

in that case, it sounds like you only have the SQL server Manangement Studio tools, and not a local instance.

you'd need to download and install 2012 express(with advanced services probably) to have a local database to play with.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!