Answered by:
SQL server management studio 12 install just wants to reinstall sql server

-
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?
Question
Answers
-
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- Edited by Alberto MorilloMVP, Moderator Monday, January 20, 2014 10:17 PM
- Marked as answer by Normanlane Wednesday, January 22, 2014 7:10 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
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- Edited by Alberto MorilloMVP, Moderator Monday, January 20, 2014 10:17 PM
- Marked as answer by Normanlane Wednesday, January 22, 2014 7:10 PM
-
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
- Edited by M. Mahfoud EL HOUDAIGUI 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.
-
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
-
-
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.aspxIf 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