0

To download and install Microsoft SQL Server 2008 R2, I followed these steps from http://www.microsoft.com/en-in/download/details.aspx?id=22985:

  1. Download and install Microsoft .Net Framework 3.5 SP1.
  2. Download and install Windows Installer 4.5.
  3. Download and install Windows PowerShell 1.0.

  4. Download SQL Server 2008 R2 Management Tools by clicking the appropriate link below. 

    SQLManagementStudio_X86 Executable

but still on searching in start menu, I am just able to see Microsoft SQL Server 2008 R2 -> Configuration Tools -> SQL Server Installation Server.

What should I do to get and open that ide where I can create a database for my applications?

mehdi lotfi
  • 11,194
  • 18
  • 82
  • 128
ananya
  • 1
  • 1
  • 1
  • 1

5 Answers5

1

Try looking for the EXE; by default it should be in the following location: C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe

You can then create a start menu or quick launch item by dragging the exe there.

If you can't find it, search your hard drive for files called ssms.exe.
To do the search I'd suggest Agent Ransack; Windows search is slower and these days aimed more at finding documents than system files: http://www.mythicsoft.com/agentransack

JohnLBevan
  • 22,735
  • 13
  • 96
  • 178
1

If you face this problem, just try to look in the folder ManagementStudio ("C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio" for me)

If you sort the folder by the type, you will find in application type : Ssms. Just dubble click on this and Microsoft SQL Server Management Studio wil open.

Alicia
  • 1,152
  • 1
  • 23
  • 41
Carbon 4horse
  • 308
  • 2
  • 5
0

Did you actually install Management Studio? If yes, you should see the icon in Start->All Programs->Microsoft SQL Server 2008 R2-> SQL Server Management Studio.

Delphi.Boy
  • 1,199
  • 4
  • 17
  • 38
  • yes i have had installed it and the icon in Start menu is like this start->All Programs->Microsoft SQL Server 2008 R2-> configurations tool -> sql server installation server . – ananya Jan 11 '14 at 15:02
  • This means Management Studio is not installed correctly. Run the setup again and follow instructions. – Delphi.Boy Jan 11 '14 at 15:40
0

Download Management Studio 2008 R2. Then only you would be able to see that in your start menu

Download link for Management Studio 2008 R2

Click here

Prakash Vishwakarma
  • 814
  • 2
  • 9
  • 25
0

Did you actually install sql server, or just sql management studio? The management studio only gives you the client and a few other configuration items. You need to install the sql server first, which you can do here: https://www.microsoft.com/en-us/download/details.aspx?id=52679

Also, be sure to install the management studio that corresponds to you sql server version (else you'll be limited in what operations you can perform on the databases).

If you have trouble finding SSMS client, an easy trick for windows 8 and above is to just type SSMS at the start menu/screen and when you get the icon (a database symbol connected to a hammer/spanner), right-click and pin to start.

Randhir Rawatlal
  • 365
  • 1
  • 3
  • 13