Server Name is blank on fresh installation of SQL Server 2014

  • This sounds like you're opening SSMS (SQL Server management studio), which depending on the version you've installed could well be a standalone application.

    Do you have an application called SQL Server 2014 Configuration Manager installed? (I assume 2014, as that's the forum you have posted in).

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • if you've installed SQL locally, there are aliases you can use, but you can also see what is installed and running.
    if you go to start>>Run>>services.msc
    it will open your services, if you scroll alphabetically, you should see SQL Server; you may see one that ends in MSSQLSERVER , or a specific name:

    if it is MSSQLSERVER , you can connect by putting in any of the following:
    . (yes a single period)
    (local)
    YourLaptopName
    127.0.0.1

    if it named, you need to append the name on there:

    .\SQLExpress
    \(local)\SQLExpress
    YourLaptopName\SQLExpress
    127.0.0.1\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!

  • <RESOLVED>
    Thanks guys,
    Lowell, I just realized that MSSQLSERVER was not running when I launched services. The server name now appears in the Database engine.
    Appreciate the help!!

    Corey

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

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