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?

Answer 1

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

Answer 2

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

Answer 3

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.

Answer 4

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

Answer 5

Thank you again, Alberto. That explains it.

Answer 6

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