I've just installed SQL Server 2005 on the same dev machine where I have VS
2005 already installed. Everything went fine. But now, I can't find any of
the SQL Server Management tools that I remember from the previous version of
SQLServer. I found the "SQL Server Configuration Manager," but where are the
tools to allow me to visually create databases, navigate them, set
permissions, etc., etc? Shortcusts for these were not installed in the
SQLSever Start Menu folder and I don't know where to look.

Thanks.

Alex

Hi,

From your description, I understand that:
SSMS was not installed after the installation of SQL Server 2005.
If I have misunderstood, please to let me know.

First, please check whether or not sqlwb.exe exists on your computer. It
locates, by default, in the directory "C:\Program Files\Microsoft SQL
Server\90\Tools\Binn\VSShell\Common7\IDE\"; if it exists, try running it
directly; otherwise, you can run the SQL Server 2005 setup CD and reinstall
the client tools. SSMS is under the tree node of the client tools and need
to be selected.

If you have any other questions or concerns, please feel free to let me
know. It's my pleasure to be of assistance.

Charles Wang
Microsoft Online Community Support

Seems that you installed the Express version of SQL Server, if you want
to have any visual tools for this you have to download the SSMS Express
from here:

http://msdn.microsoft.com/vstudio/express/sql/download/

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Alex,

Both the other answers you have received could be the correct ones for
your post.

Another possibility that occurs to me is that you're looking for
Enterprise Manager and Query Analyzer that you are familiar with from
SQL Server 2000 (is that what you mean by "previous version"?).

Neither is installed with SQL Server 2005. SQL Server Management
Studio and SQL Server Configuration Manager are the tools you need to
install and familiarise yourself with.

Andrew Watt MVP

On Thu, 10 Aug 2006 16:27:02 -0700, Alex Maghen
<AlexMaghen (AT) newsgroup (DOT) nospam> wrote:

Andrew -

Thanks for the help. I'm still a little bit confused. Are you saying that in
this Version of SQL Server, the "Sql Server Management Studio" isn't included
at ALL in the installation for SQL Server? It's not even on the Disk? Isn't
that a little weird?

If it's not, do I have to *buy* it? (please say no!). How do I get it?

Alex

"Andrew Watt [MVP]" wrote:

Hi Alex,
I think Andrew's meaning is that SQL Server Enterprise Manager and SQL
Query Analyzer are not included in the SQL 2005 setup CD. As they are SQL
Server 2000 components.

SSMS (SQL Server Management Studio) is included in the SQL 2005 setup CD
and you can find it under the client tools during the installation wizard.
However SQL Server 2005 Express doesn't include this component.

You can refer to:
SQL Server 2005 Features Comparison
http://www.microsoft.com/sql/prodinf...-features.mspx

Sincerely yours,
Charles Wang
Microsoft Online Community Support

I have a very similar problem: first installed Express, could not find a
management console, then installed full SQL 2005, but _still_ cannot find the
management studio. I do have Visual Studio 2005 installed.
The directory C:\Program Files\Microsoft SQL
Server\90\Tools\Binn\VSShell\Common7\IDE contains one folder, but no
excutables.

I uninstalled the SQLExpress server engine.

I have tried to separately install client tools and they appear to be
installed (such as are listed).

"Alex Maghen" wrote:

What you have installed is the Express client tools which are a couple
config programs. Because you already have them installed, setup will not
reinstall them. If you uninstall them and then install the client tools
from the full install, you should get what you want.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"JimLudden" <JimLudden (AT) discussions (DOT) microsoft.com> wrote