Home > sql server > SQL Server Management Studio missing when I installed SQL Server 2005

SQL Server Management Studio missing when I installed SQL Server 2005

July 15Hits:1
Advertisement

For some reason SQL Server Management Studio is missing when I installed SQL Server 2005 Developers Edition. Any reason why or how can i get SQL Server Management Studio on my PC?

My operating system is Windows XP Pro..........

Thanks in advanced!

Answers

This is a common problem, the SQL 2005 install does not often install manamgent studio, even though you tell it to install all the tools. The easiest way to get it installed is to look on the CD, or setup file location and run:

{drive}\ENGLISH\SQL2005\DEVELOPER\SQL Server\Tools\Setup\SqlRun_Tools.exe

if your using the X64 version use:

{drive}\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Tools\Setup\SqlRun_Tools.exe

Source

edit: My mistake, my lack of coffee had me read SQL Server 2005 Express, not Developer. There are some workarounds for Dev edition here:

http://aspadvice.com/blogs/ssmith/archive/2008/03/21/SQL-2005-Tools-Install-Experience-is-the-suck.aspx

http://aspadvice.com/blogs/name/archive/2007/09/24/Installing-SQL-Server-Management-Studio-with-SQL-Server.aspx

Related Articles

  • SQL Server Management Studio missing when I installed SQL Server 2005July 15

    For some reason SQL Server Management Studio is missing when I installed SQL Server 2005 Developers Edition. Any reason why or how can i get SQL Server Management Studio on my PC? My operating system is Windows XP Pro.......... Thanks in advanced! --

  • How to make SQL Server Management Studio use latest version of SQL Server?

    How to make SQL Server Management Studio use latest version of SQL Server?July 26

    I'm upgrading my dev machine from Windows 7 to 8. While installing earlier versions of Visual Studio it installed SQL Server 2005. I then went to this site and downloaded and installed SQL Server Management Studio (SQLManagementStudio_x64_ENU.exe fil

  • Can SQL Server Management Studio Express be installed standalone?February 5

    I was wondering if the SQL Server Management Studio Express (mainly for Microsoft SQL Server) be installed on a standalone machine (without any of the SQL Services and stuff) to connect to a remote database? I run a SQL Server 2012; I have been told

  • SQL Server Management Studio 2008 Express installationFebruary 7

    Is it possible to install SQL Server Management Studio 2008 Express without installing the SQL Server 2008? I have now the SQL Server 2005 and SQL Server Management Studio 2005 Express on my computer. --------------Solutions------------- You should b

  • How do I open SQL Server Management Studio?March 1

    How do I open SQL Server Management Studio? I installed it but I don't see where I can open it. --------------Solutions------------- Click on the Windows Start button, click on the "Run" option and try to run the following command: ssms.exe Work

  • sql server management studio backup error

    sql server management studio backup error July 30

    hello, i want a back up for my database in sql server management studio. i am using ms sql. but when i try to back up , i take the following error: =================================== Backup failed for Server 'ERDI-PC\SQLEXPRESS'. (Microsoft.SqlServe

  • "Could not find stored procedure' even though the stored procedure have been created in MS SQL Server Management Studio

    "Could not find stored procedure' even though the stored procedure have been created in MS SQL Server Management StudioSeptember 10

    I have created a table testtable inside the database testbase that have the following structure: product_no (int, not null) product_name (varchar(30), not null) price (money, null) expire_date (date, null) expire_time (time(7), null) which I used the

  • Missing menu items for Azure SQL tables within SQL Server Management Studio?

    Missing menu items for Azure SQL tables within SQL Server Management Studio?October 10

    I have a table (say Table1) that is replicated via SQL Data Sync Agent across a local SQL Server 2012 as well as an Azure SQL Server (part of Microsoft Azure). Everything about Table1 (schema, table values etc ) is identical to the best of my underst

  • How to copy database from server to local machine in SQL Server Management studio? September 10

    I am pretty much new to SQL Server Management Studio. I connect to SQL Server using Windows authentication. But not sure if my work affect the server database. How can I make sure not to mess with the updates and commits to the data? --------------So

  • SQL Server Management Studio 2008 InstallOctober 12

    I installed SQL EXPRESS 2008 Advanced then I downloaded 64 bits Management Studio. It says install service pack 1 for SQL. I downloaded service pack 1, it says nothing to update :( So how do I install management studio? --------------Solutions-------

  • Trouble installing SQL Server Management Studio ExpressJune 9

    Using VirtualBox I am running 64 bit versions of ... Windows Server 2008 R2 SQL Server 2008 R2 Express SharePoint Foundation I want to install SQL Server Management Studio Express, but I get this warning: "This program has known compatibility issues.

  • Install sql server management studio API only

    Install sql server management studio API onlyAugust 4

    I have already installed sql server 2008 R2 , but now i need to install sql server management studio also ( i mean just that API ony ) is it possible to install only this instead of uninstall sql server 2008 R2 and Re-install sql server managemant st

  • Can I install SQL Server Management Studio locally?

    Can I install SQL Server Management Studio locally?August 12

    Can I install SQL Server Management Studio on my desktop to access a database on a SQL Server 2012 instance? If so, where can I find the installer? Google searches only return 'express' versions whereas, I am looking for the full SQL Server Managemen

  • How to check if SQL Server Management Studio is installed on a system programmatically?January 16

    I need to find whether SQL Server Management Studio is installed on a system or not. I need this specially when an instance of SQL Server Express is installed on a system by installing Visual Studio but with no Management Studio installed on the syst

  • Is it destructive to use SQL Server Management Studio to modify properties on an MSSQL 2000 database?May 11

    We have a few databases that are stuck in legacy mode at SQL Server 2000. I commonly use SQL Server Management Studio from SQL Server 2005 to query the data in these dbs from my desktop, but have been logging in to the server to use the SQL Server 20

  • SQL Server Managment Studio 2005 to an Express databaseMay 25

    I just installed SQL Server Standard Edition with the Management Studio. I'm able to connect to my SQL server instance but I can't connect to a SQL Server Express instance on a remote computer. Is the Management Studio Standard able to connect to an

  • SQL Server Management Studio unable to connect to local instanceAugust 6

    I'm not a DBA, I'm a developer - and I'm having trouble with SQL Server Management studio. I installed SQL Server 2008 Standard on Windows 2008 Server R2, and according to Sql Server Configuration Manager, I've got two instances: OFFICESERVERS (for s

  • SQL Server Management StudioOctober 16

    I need to install just the Management studio so that the analysts can do their adhoc queries on various databases. I do not want them to be able to install the entire SQL Server app on their local machines nor do I want to have to do the installs of

  • Can I run SQL Server Management Studio in Windows 7?January 30

    I've recently upgraded my OS to Windows 7, but this new OS wouldn't let me install SQL Server Management Studio. Is there a way to get around it? --------------Solutions------------- I'm running Windows 7 with SQL Server 2005. You have to install a c

  • Can't remotely connect through SQL Server Management StudioApril 2

    I have setup a SQL Server 2008 Express instance on a dedicated Windows 2008 Server hosted by 1and1.com. I cannot connect remotely to the server through management studio. I have taken the following steps below and am beyond any further ideas. I have

Copyright (C) 2017 ceus-now.com, All Rights Reserved. webmaster#ceus-now.com 14 q. 0.912 s.