Post reply

Starting SQL Server 2012 Express with Tools

  • February 14, 2012 at 9:18 am

    #250741

    I downloaded and installed on my laptop running Windows 7 Pro. It said I was successful. Nothing shows up in the "start programs" list. There are many .exe files in the Microsoft SQL Server folder, but I don't want to go double-clicking on all of them. I did try double-clicking

    MSSQL11.SQLEXPRESS\MSSQL\Binn\sqlservr.exe but I got the message

    "Your SQL Server installation is either corrupt or has been tampered with (Error getting instance ID from name). Please uninstall then re-run setup to correct this problem."

    Since I'm not sure I should be double-clicking on this file, I don't want to go through the whole re-install without some advice. Any ideas?

  • February 14, 2012 at 9:32 am

    #1446922

    sql runs as a service, it's main executable is not double clickable/runable...you go to Control Panel Administrative tools>>Services and see if it is running there or not (you can use Taskmanager as well and lookf or the process)

    .

    it can be wierd, but the express version usually comes without tools, so you either need to download the SSMS express for 2012 separately, or connect with a program or something like Linqpad to your instance.

    for 2008, there was a specific express version "with advanced tools" which included the SSMS express GUI;

    make sure the service is running,a nd then get the express verison of SSMS to connect,a nd i think you'll be good to go.

    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 14, 2012 at 9:44 am

    #1446931

    Wow, thanks Lowell! I already had downloaded SSMS, and now that I've executed THAT from "start programs" it seems to be working. Gratefully, Mountaine 😀

  • October 21, 2013 at 2:44 am

    #1660053

    There is a SQL Server Express Advanced version and it installs SSMS as well as Reporting Services.

    I could show you an image in my computer but I can only upload from an URL in this forum. The download link for Express Advanced is this:

    http://www.microsoft.com/en-us/download/details.aspx?id=29062

    File name:

    File size:

    ENU\x64\SQLEXPR_x64_ENU.exe

    132.3 MB

    ENU\x64\SQLEXPRADV_x64_ENU.exe

    1.3 GB

    ENU\x64\SQLEXPRWT_x64_ENU.exe

    669.9 MB

    ENU\x64\SqlLocalDB.MSI

    33.0 MB

    ENU\x64\SQLManagementStudio_x64_ENU.exe

    600.2 MB

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

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