Solved

I need help with SQL Server 2012 advanced tools

Posted on 2013-12-12
2
757 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 500 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

688 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