none
SQL server management studio 12 install just wants to reinstall sql server

    Question

  • I am trying to set up SQL server on a desktop machine WIN7 to use as a test server for a database application. The application provider said to download and install SQL server express 12 and management studio. I downloaded both and installed SQL server, then ran the install program for management studio and it started over with the server install. I clicked on upgrade rather than standalone, but there being no more features to install it would not run and nothing to do but cancel. The files I ran were:

    SQLEXPR_x64_ENU

    SQLManagementStudio_x64_ENU

    What am I doing wrong?

    Monday, January 20, 2014 9:33 PM

Answers

All replies

  • Hello,

    You can use the upgrade option of SQL Server setup program only if you have installed a previous version of SQL Server on the computer.

    Use the following resources SQL Server 2012:

    http://www.linglom.com/it-support/how-to-install-sql-server-2012-express/

    http://www.linglom.com/it-support/how-to-install-sql-server-2012-management-studio/

    You need apply Windows 7 SP1 before installing SQL Server 2012.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com


    Monday, January 20, 2014 10:06 PM
    Moderator
  • I think SQLEXPR_x64_ENU incule SSMS SQL Server management Studio.

    Or unistall all and download this file SQLEXPRADV_x64_ENU.exe (1,3 Go) that include the server and SSMS :

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


    Tuesday, January 21, 2014 12:07 AM
  • Thank you, Alberto.

    Now it is working, but I cannot get the SQL Server Agent to start. I have tried starting it from the management studio and from task manager, but nothing happens. The error message is just something about the request timed out. I looked in the current SQL Server log, but there is no entry during the time period that I tried starting the agent, and nothing about the agent during the time when I started the system.

    Wednesday, January 22, 2014 7:15 PM
  • Hello,

    SQL Server Agent is a feature not available on SQL Server Express Edition. You can see it listed as a service on SQL Server Configuration Manager but you cannot get the service started.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Marked as answer by Normanlane Thursday, January 23, 2014 3:18 PM
    Wednesday, January 22, 2014 11:40 PM
    Moderator
  • Thank you again, Alberto. That explains it.
    Thursday, January 23, 2014 3:19 PM
  • Hello,

    I would like to share with you the following article about features supported by editions of SQL Server.

    http://msdn.microsoft.com/en-us/library/cc645993.aspx

    If you find that Express Edition has many limitations consider Developer Edition for US$50.00 more or less. It has all the features of the Enterprise Edition, but is intended for development environments.

    Thank you for visiting MSDN forums! Have a great day!

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Thursday, January 23, 2014 7:17 PM
    Moderator