SQL server 2012 installation repair

MJ 21 Reputation points
2020-10-14T05:48:27.08+00:00

I installed an SQL sever 2012 but it doesnt work so I want to repair before I delete it and re-install. However, when i try to repair through the SQL server Installation Center, they ask me the Installation media but i cannot find installation media for 2012. So where can i get it or what can i do instead?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,314 questions
{count} votes

3 answers

Sort by: Most helpful
  1. m 4,266 Reputation points
    2020-10-14T06:53:12.83+00:00

    Hi @MJ ,

    ...So where can i get it or what can i do instead?

    Download here: Microsoft® SQL Server® 2012 Express
    Follow steps as this to install sql2012: how-to-install-sql-server-2012-express-on-windows-server-2012
    And then I recommend you follow this tutorial to connect the sqlserver after the installation: lesson-1-connecting-to-the-database-engine

    BTW, you can free download SQL2019 to have a test. And you can also try to google SQL Server installation tutorial in YouToBe if you are instrested in.

    More information: sql-server-2012-installation-step-by-step, install-sql-server-developer-edition-on-windows-server

    BR,
    Mia


    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.

  2. Erland Sommarskog 99,461 Reputation points MVP
    2020-10-14T16:18:17.887+00:00

    If you installed SQL 2012 you did that from the installation media being asked for.

    Mia suggested a download, but she jumped to the conclusion that you had installed Express Edition. We would need to know which edition you installed to help you, if you really are going to repair.

    Then again, just like Shashank I advice against uninstalling or repairing. At least as long we don't know what is not working. You suggest that there is a problem with SSMS, and in such I advice you to download and install the latest version of SSMS which you find here: https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms. This version of SSMS can be installed in parallel with SQL 2012. And you can use it with SQL 2012, no problem.

    If SSMS is the only problem, there is absolutely no problem with meddling with the SQL 2012 installation. SQL 2012 came with SSMS buindled, but since then SSMS has been detached from SQL Server and is a independent installation.

    0 comments No comments

  3. m 4,266 Reputation points
    2020-10-15T07:13:05.453+00:00

    Hi @MJ ,

    Do you solve the issue?
    Is the reply helpful?

    BR,
    Mia


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments