Installing Express toolkit

Hello

I have SQL Express with Advance report tools installed. I have download the express toolkit to use the Business Intelligence, however after I have installed the add on, when ever I select the Musiness Intelligence Management Studio I have a browser looking for the file Devenv.exe file and a reinstall is not working.

Can anyone help with this?

hi,

if you are running on Vista, the problem could be related to privileges required running devenv.exe.. you can try what's reported here, even if not strictly related to BIDS ..

regards

|||

Hi

I am running XP Pro SP2.

|||

I discuss some solutions for the devenv.exe problem in my blog, check out this post.

Mike

Installing Client Tools

I recently installed an evaluation copy of SQL Server (Enterprise x64 edition). What's the proper way to load the management and analytical tools onto client machines? There are 2 separate problems:

1. The 64 bit program only comes with 64 bit tools. (Should I just download the 32 bit evaluation copy? Will the tools expire in 180 days on all the client machines?)

2. What are the licensing rules? Surely I am allowed to load client tools (but not the server itself) onto client devices. Is that right?

Thanks!Evaulation edition expiration only applicable to server components whereby you cannot use the server services, but for client tools I haven't seen such problem you can use them to connect to other SQL server instances.|||That's very helpful - thank you.

It would also be nice to know what the licensing rules actually are & what the best practice is supposed to be.|||Refer to this http://support.microsoft.com/kb/257716 page that clears about licensing policy on client tools, though it is for SQL 2000 all the information is still applicable to SQL 2005 in this case. I would also ask you to refer to the local Microsoft support for more information on licensing, as x64 is bit new in recent times.

Installed SQL Server 2005 CTP.. wheres enterprise manager?

Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
installed the configuration tools menu in start > programs. But i cannot
find enterprise manager. am i missing something?
Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
about the actual server software, not the client tools).
Thanks!
cheers, murray
There is no Enterprise Manager in SQL Server 2005. EM functionality is
included in Sql Server Management Studio.
SQL 2000 Developer and Evaluation editions can be installed on XP but not
Standard or Enterprise. SQL 2005 Developer, Express and Workgroup editions
can be installed on XP but not Standard or Enterprise. For the complete
lists of system requirements, see:
http://www.microsoft.com/sql/evaluat...0/default.mspx
http://www.microsoft.com/sql/evaluat...5/default.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>
|||Hi
SQL Server 7.0 is not supported on Windows XP
SQL Server 2000 and 2005, developer and personal editions are installable on
Windows XP. Standard and Enterprise Editions are not.
SQL Server Management Studio is the replacement for Enterprise Manager. If
it is not there, it means you did not select it during the install.
SQL Server 2005 Express does not ship with a UI until 2006.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>

Installed SQL Server 2005 CTP.. wheres enterprise manager?

Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
installed the configuration tools menu in start > programs. But i cannot
find enterprise manager. am i missing something?
Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
on Windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
about the actual server software, not the client tools).
Thanks!
cheers, murrayThere is no Enterprise Manager in SQL Server 2005. EM functionality is
included in Sql Server Management Studio.
SQL 2000 Developer and Evaluation editions can be installed on XP but not
Standard or Enterprise. SQL 2005 Developer, Express and Workgroup editions
can be installed on XP but not Standard or Enterprise. For the complete
lists of system requirements, see:
http://www.microsoft.com/sql/evalua...00/default.mspx
http://www.microsoft.com/sql/evalua...05/default.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on Windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>|||Hi
SQL Server 7.0 is not supported on Windows XP
SQL Server 2000 and 2005, developer and personal editions are installable on
Windows XP. Standard and Enterprise Editions are not.
SQL Server Management Studio is the replacement for Enterprise Manager. If
it is not there, it means you did not select it during the install.
SQL Server 2005 Express does not ship with a UI until 2006.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on Windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>

Installed SQL Server 2005 CTP.. wheres enterprise manager?

Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
installed the configuration tools menu in start > programs. But i cannot
find enterprise manager. am i missing something?
Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
about the actual server software, not the client tools).
Thanks!
cheers, murrayThere is no Enterprise Manager in SQL Server 2005. EM functionality is
included in Sql Server Management Studio.
SQL 2000 Developer and Evaluation editions can be installed on XP but not
Standard or Enterprise. SQL 2005 Developer, Express and Workgroup editions
can be installed on XP but not Standard or Enterprise. For the complete
lists of system requirements, see:
http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.mspx
http://www.microsoft.com/sql/evaluation/sysreqs/2005/default.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>|||Hi
SQL Server 7.0 is not supported on Windows XP
SQL Server 2000 and 2005, developer and personal editions are installable on
Windows XP. Standard and Enterprise Editions are not.
SQL Server Management Studio is the replacement for Enterprise Manager. If
it is not there, it means you did not select it during the install.
SQL Server 2005 Express does not ship with a UI until 2006.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>

Installed SQL 2005, but where is the management tools?

I installed the SQL2005, but cannot find the management tools like
Enterprise Manager in 2000
During Installation, i selected advanced
and select to install
all in Database Service,
all in Client Components and
the SQL BOL in Documentation, Sample, and Sample Database.
But after the installation complete, I cannot locate the SQL Management
Studio
In my program list, it only has
SQL Server 2005\Configuration Tools
SQL Server 2005\Documentation and Tutorials
I checked the Add/Remove Program in Control Panel, it show followings are
installed
MS SQL Server 2005
MS SQL Server 2005 Backward compatibility
MS SQL Server 2005 BOL (English)
MS SQL Server Natvie Client
MS SQL Server Setup Support Files
MS SQL Server VSS Writer
but no any manager tools.
I tried to insert to dvd again and select to install the Client Component
but the wizard said the component i choose is already installed.
So what is the problem?
P.S. OS WinXP SP2
already have SQL 2000 Dev Ed installed with Enterprise Manager.
Any Help?
Thanks in Advanced
Jason
What edition did you install?
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
|||You need to install the workstation tools if you installed the standard or
enterprise edition.
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
|||This [1] is the only current option for SQL Express.
<%= Clinton Gallagher
[1]
http://www.microsoft.com/downloads/d...displaylang=en
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
|||Do you have Internet Explorer 6 SP1 or higher on the machine?
"Jason Chan" wrote:

> I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
>

Installed SQL 2005, but where is the management tools?

I installed the SQL2005, but cannot find the management tools like
Enterprise Manager in 2000
During Installation, i selected advanced
and select to install
all in Database Service,
all in Client Components and
the SQL BOL in Documentation, Sample, and Sample Database.
But after the installation complete, I cannot locate the SQL Management
Studio
In my program list, it only has
SQL Server 2005\Configuration Tools
SQL Server 2005\Documentation and Tutorials
I checked the Add/Remove Program in Control Panel, it show followings are
installed
MS SQL Server 2005
MS SQL Server 2005 Backward compatibility
MS SQL Server 2005 BOL (English)
MS SQL Server Natvie Client
MS SQL Server Setup Support Files
MS SQL Server VSS Writer
but no any manager tools.
I tried to insert to dvd again and select to install the Client Component
but the wizard said the component i choose is already installed.
So what is the problem?
P.S. OS WinXP SP2
already have SQL 2000 Dev Ed installed with Enterprise Manager.
Any Help?
Thanks in Advanced
JasonWhat edition did you install?
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||You need to install the workstation tools if you installed the standard or
enterprise edition.
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||This [1] is the only current option for SQL Express.
<%= Clinton Gallagher
[1]
http://www.microsoft.com/downloads/...&displaylang=en
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||Do you have Internet Explorer 6 SP1 or higher on the machine?
"Jason Chan" wrote:

> I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
>

Installed SQL 2005, but where is the management tools?

I installed the SQL2005, but cannot find the management tools like
Enterprise Manager in 2000
During Installation, i selected advanced
and select to install
all in Database Service,
all in Client Components and
the SQL BOL in Documentation, Sample, and Sample Database.
But after the installation complete, I cannot locate the SQL Management
Studio
In my program list, it only has
SQL Server 2005\Configuration Tools
SQL Server 2005\Documentation and Tutorials
I checked the Add/Remove Program in Control Panel, it show followings are
installed
MS SQL Server 2005
MS SQL Server 2005 Backward compatibility
MS SQL Server 2005 BOL (English)
MS SQL Server Natvie Client
MS SQL Server Setup Support Files
MS SQL Server VSS Writer
but no any manager tools.
I tried to insert to dvd again and select to install the Client Component
but the wizard said the component i choose is already installed.
So what is the problem?
P.S. OS WinXP SP2
already have SQL 2000 Dev Ed installed with Enterprise Manager.
Any Help?
Thanks in Advanced
JasonWhat edition did you install?
--
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||You need to install the workstation tools if you installed the standard or
enterprise edition.
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||This [1] is the only current option for SQL Express.
<%= Clinton Gallagher
[1]
http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||Do you have Internet Explorer 6 SP1 or higher on the machine?
"Jason Chan" wrote:
> I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
>sql

installed eval and only have config tools

I installed the Sql Server 2005 Enterprise Edition 180 day eval.
However, under SQL Server 2005 program group, all I have is Configuration
Tools.
What happened to Query Analyzer, Enterprise Manager, etc?
Hi Ruthsieg
I have encountered this problem before but not on the eval, it is related to
the windows installer. If you perform a manual install from the tools folder
on the installation cd you will have the management tools available.
Regards
Charl
http://www.sqlserver.co.za
"ruthsieg" wrote:

> I installed the Sql Server 2005 Enterprise Edition 180 day eval.
> However, under SQL Server 2005 program group, all I have is Configuration
> Tools.
> What happened to Query Analyzer, Enterprise Manager, etc?
>

installed eval and only have config tools

I installed the Sql Server 2005 Enterprise Edition 180 day eval.
However, under SQL Server 2005 program group, all I have is Configuration
Tools.
What happened to Query Analyzer, Enterprise Manager, etc?Hi Ruthsieg
I have encountered this problem before but not on the eval, it is related to
the windows installer. If you perform a manual install from the tools folder
on the installation cd you will have the management tools available.
Regards
Charl
http://www.sqlserver.co.za
"ruthsieg" wrote:

> I installed the Sql Server 2005 Enterprise Edition 180 day eval.
> However, under SQL Server 2005 program group, all I have is Configuration
> Tools.
> What happened to Query Analyzer, Enterprise Manager, etc?
>sql

installed eval and only have config tools

I installed the Sql Server 2005 Enterprise Edition 180 day eval.
However, under SQL Server 2005 program group, all I have is Configuration
Tools.
What happened to Query Analyzer, Enterprise Manager, etc?Hi Ruthsieg
I have encountered this problem before but not on the eval, it is related to
the windows installer. If you perform a manual install from the tools folder
on the installation cd you will have the management tools available.
Regards
Charl
--
http://www.sqlserver.co.za
"ruthsieg" wrote:
> I installed the Sql Server 2005 Enterprise Edition 180 day eval.
> However, under SQL Server 2005 program group, all I have is Configuration
> Tools.
> What happened to Query Analyzer, Enterprise Manager, etc?
>

Installed client tools but they don't show up in VS.Net

According to
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/7fcbd1e9109b9b4b/67a26738d8cd2126?q=install+client+vs.net,
when I install the client components of SQL Reporting Services, the add-ins
should automatically be added to VS.Net. I've tried it several times, but the
add-ins don't show up.
How can I add these? I see the components on my hard drive (C:\Program
Files\Microsoft SQL Server\80\Tools\Report Designer) but there is nothing in
the RS help about adding them - it assumes that the install takes care of
that.
TIA!In VS.NET, select File > New > Blank Solution
Then, do you see Business Intelligence Projects among your choices?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Cyberwombat" <Cyberwombat@.discussions.microsoft.com> wrote in message
news:9797BF5A-B9EA-40FA-8BFA-BC90C77FFBAC@.microsoft.com...
> According to
> http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/7fcbd1e9109b9b4b/67a26738d8cd2126?q=install+client+vs.net,
> when I install the client components of SQL Reporting Services, the
> add-ins
> should automatically be added to VS.Net. I've tried it several times, but
> the
> add-ins don't show up.
> How can I add these? I see the components on my hard drive (C:\Program
> Files\Microsoft SQL Server\80\Tools\Report Designer) but there is nothing
> in
> the RS help about adding them - it assumes that the install takes care of
> that.
> TIA!

Installation problem

I have installed SSRS 2005 in one system.There is only configuration tools.

But there is no SQL server Business intelligent development studio,SQL Server Mangement Studio and Performence tools.

While I am installing I am not getting this problem in all machines.

Please help me

Do you have SQL Server Express installed ? If yes, you will have to download the tools that don′t come with the default package or download the Advanced Services ediotion:

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

HTH, Jens K. Suessmeyer

http://www.sqlserver2005.de

|||Thanks Jens

installation of SQL Server 2005 CTP (June) error 2147944003

During installation of SQL Server 2005 CTP (June) I get the error 2147944003.
This error refers to the installation of tools (client components).
The server components seem to be ok., services are running.
My os is Microsoft Windows XP Professional Service Pack 2 (Build 2600).
Could anybody help me, please?

--

This is a part of summary.txt:

Machine : WBG5
Product : Microsoft SQL Server 2005 Tools CTP
Product Version : 9.00.1187.07
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup

Bootstrap\LOG\Files\SQLSetup0006_WBG5_Tools.log
Error Number : 2147944003

--

This is a part at the end of SQLSetup0006_WBG5_Tools.log:

Property(S): ProgramMenuFolder.Samples1033 = C:\Documents and Settings\All Users\Start Menu\Programs\
Property(S): SqlMenuFolder.Samples1033 = C:\Documents and Settings\All Users\Start

Menu\Programs\Microsoft SQL Server 2005 CTP\
MSI (s) (A0:D4) [11:23:21:000]: Note: 1: 1708
MSI (s) (A0:D4) [11:23:21:000]: Product: Microsoft SQL Server 2005 Tools CTP -- Installation failed.

MSI (s) (A0:D4) [11:23:21:100]: Cleaning up uninstalled install packages, if any exist
MSI (s) (A0:D4) [11:23:21:110]: MainEngineThread is returning 1603
MSI (s) (A0:B4) [11:23:21:230]: Destroying RemoteAPI object.
MSI (s) (A0:BC) [11:23:21:230]: Custom Action Manager thread ending.
=== Logging stopped: 11/21/2005 11:23:20 ===

--

The checker says:
WBG5 : The current system does not meet minimum hardware requirements for this SQL Server release.

For detailed hardware requirements, see the readme file or SQL Server Books Online.
WBG5 : Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is

required by some SQL Server features...

I did prove the requirements. Okay, IIS is not installed, but that can't be the reason.

Any chance you have SQL 2005 Express Edition installed? If so, this should help:

http://blogs.msdn.com/jpapiez/archive/2005/11/14/492534.aspx

jeff.|||Thank you for your help, but that doesn't work.
I have no express edition installed.
The only MS SQL Client-Software I have installed is the native client of my CTP.

Do you still have another idea?|||Search SQLSetup0006_WBG5_Tools.log for "Value 3". This will put you at the location of the log file that has the actual failure information. I doubt this has anything to do with IIS. Post that failure section back here.

Dan|||Thank you for this - it helped.
I could see that it is a space problem on C-partition.
Stupid that you cannot decide another partition.
So I removed some other programs from C - and the installation was successful!