SQL Server 2008 R2 installation Issue

SubbuUSA
SubbuUSA used Ask the Experts™
on
Earlier, I had been running SQL Server 2005. All I was needed only Mgmt Studio to run my queries and Procs. After my DB Server upgrade to 2008 R2. My connection was refused from 2005. I tried installing 2008 R2 Enterprise client on my machine. Installation went successfully ..I selected necessary tools but mgmt studio is not on my machine. Kind of wierd..can somebody help me.

I installed VS.Net 3.5 SP1 and all necesarry service packs to get it running but no luck.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
You can install Management Studio from Here:
http://www.microsoft.com/download/en/details.aspx?id=22985

Then you can go here to check all necessary steps for remoting your server...
http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/

When you installed 2008 R2 Ent, on the Feature Selection page, did you definitely select Management Tools - Basic and Management Tools - Complete from the Shared Features section. The entries for Client Tools and connectivity aren't SQL Management Studio.

Also, check the following location as that is where it should be located (C:\Program Files (x86)\ on x64)

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe

Author

Commented:
@edlunad: This is the Error I am getting

"To continue, select a feature to install. If all features are already selected, these features are installed. You cannot add additional features."

It says I already have but I do not see it..

Commented:
Did you check on all your programs folders that start with "Microsoft SQL Server..."

you can try to start it from Start > Run > SSMS and click ok

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial