• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 382
  • Last Modified:

i cant see sql server mgt studio icon 2005

hi im running windows xp professional
im having vs 2005 installed in my pc
after install sql server 2005 developer edition in my pc
i cant able to see  i cant see sql server mgt studio icon
i can see only configuration tools

what should i have to do to see
 sql server mgt studio icon 2005 and connect to database.

im running sql server 2000 in the same pc.
0
bsarahim
Asked:
bsarahim
1 Solution
 
Rahul Goel ITILSenior Consultant - DeloitteCommented:
You might faced some problem while installation of SQL Server 2005.

Try to re-intall with Tools - Workstation components.
and do not use the default instance, use the named one
0
 
JenniferIT DirectorCommented:
To use the management tool in SQL Server 2005 like you would use SQL 2000 you have to install an additional component.

If you go to this website:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
Or search for SQL 2005 Management Tool
you should be able to find it.

Download and install this item and see if you have the items.
0
 
David ToddSenior DBACommented:
Hi,

In principle I diskagree with jlrbjw, but its worth a shot.

That is, as you suggest in the question, installing developer should have installed SSMS; you shouldn't need to install SSMS Express.

Firstly I'd try a reinstall of the workstation components to see if that fixes it. Else I'd get the Widnows Installer Clean-up utility from MS and use it to remove the installed settings for SQL, and try the installation again.

Cheers
  David
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now