Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

I need help with SQL Server 2012 advanced tools

Posted on 2013-12-12
2
Medium Priority
?
766 Views
Last Modified: 2013-12-16
Hi Experts,
A program was installed on our SQL Server 2012 machine, and now I cannot access SSMS.  I get the following error message:  "Cannot find one or more components.  Please reinstall the application."


If I download and install Sql Server 2012 with advanced tools on my machine, will I be able to connect and access SSMS on the SQL Server 2012 machine?  

Thanks in advance,
mrotor
0
Comment
Question by:mainrotor
2 Comments
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 2000 total points
ID: 39714616
Assuming you have some logon details for the sa account or a domain account that has rights to the sql server instance you will be able to connect from your machine if the SQL Server has been set to allow remote connections.

Have you tried reinstalling on the server itself?
0
 
LVL 9

Expert Comment

by:QuinnDex
ID: 39714713
there used to be a bug in sql server where some configuration or instance changes and some updates made ssms unavailable and the easiest way of correcting this was re installing sql server tools.

i dont know if this is still a problem in 2012

comments from other experts would be helpful here as i havnt upgraded to 2012 yet.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question