How do you know the SQL Server name?

Posted on 2014-03-11
Medium Priority
Last Modified: 2014-03-11
I just installed SQL 2012 Management express on a new 2012 R2 server and when it ask for the server name.  I tried the name server, I tried local, I tried browsing.

How do I find the name
Question by:J.R. Sitman
  • 2

Assisted Solution

c1nmo earned 800 total points
ID: 39922350
Look under services in administrative tools, the service name will be SQL Server (My Express Instance Name).  To connect it would be windows server name\my express instance name.

Author Comment

by:J.R. Sitman
ID: 39922365
They is not a single SQL service.  Maybe I should have installed SQL 2012 and then Management express?
LVL 29

Accepted Solution

Paul Jackson earned 800 total points
ID: 39922431
Yeah sounds like you have installed SQL Server Management Studio but not actually installed an instance of the SQL Server Database engine.

Author Closing Comment

by:J.R. Sitman
ID: 39922472
Thanks.  It's working

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question