Post reply

Server Name is blank on fresh installation of SQL Server 2014

  • February 9, 2017 at 10:08 am

    #334899

    I have installed SQL Server on my personal laptop not connected to a network to learn SQL Server. Unfortunately within the Database Engine the Server Name is blank and I don't know what to do next. When I enter the machine name as the server name I get an error. When I choose Browse for more... it takes me to another screen where I can choose Local Server Name or Network Server name, neither are populated.

    This is supposed to be a standalone configuration on a desktop for learning SSIS. I'm not trying to log into a network. 

    Any Ideas on why the installation or configuration fails to populate a server name?

    Thanks,
    Corey

  • February 9, 2017 at 10:15 am

    #1927585

    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

  • February 9, 2017 at 10:25 am

    #1927592

    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!

  • February 9, 2017 at 11:13 am

    #1927606

    <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 4 posts - 1 through 4 (of 4 total)

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