Can't find SQL Profiler after Install

I have installed SQL Server Express, the configuration tools as well as the SQL Server Management Express However, I need the SQL Profiler. Where or how does this get installed with SQL Server Express?

hi,

Profiler does not come with SQLExpress... it' only available with full blown SQL Server 2005 editions, as reported in http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

regards

Cant find SMSS

After installing the evaluation edition of MSSQL Enterprise 2005 I can not find SSMS. I know I installed the client tools upon installation. It's not showing up on in the menu, where is the location for the executable file.

Is SSMS even distriubted with the evaluation edition?

If not, is it possible to download it from somwhere...

Did you get any warnings while setup cheked your computer configuration?

Did you specify client tools installation during setup?

P.S. This question suits http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1 forum better.

|||

SSMS is part of the evaluation edition. To see a report of what's installed go to Add/Remove Programs, select the entry for "Microsoft SQL Server 2005", select "Change", then select "Report". Under "Common Components" you'll want to see something like this:

Workstation Components
[Version: 9.00.1399.06 Edition: Evaluation Edition Patch level: 9.00.1399.06 Language: English (United States)]

If you see this and still don't think you have SSMS installed, close the report. On the "Change" dialog you should see an entry for Workstation Components, select it and press "Next". This will launch the component in maintenance mode. Just follow the dialogs. When you get to the feature tree be sure to select Management Tools under the Client Components node.

SSMS is installed to %ProgramFiles%\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlwb.exe

|||Thanks for your reply::

I got the evauation to work when I downloaded the DVD image and burnt it to disk, and did a fresh install...

I'm now in the process of converting my MySQL talbles over to MSSQL... weeee fun... SSIS takes some of the headake away!|||Excellent!

Can't find Report Designer

I think I've installed all of the required pieces (SRS, already had VS.NET
2005 installed, BI tools). But the BI tools (e.g. Report Designer) don't
appear on a menu anywhere, and the desired project type for reports doesn't
appear in VS.NET.
What might I have done wrong?
Thanks.
--
Dan Cooperstock
DONATION web site: http://www.FreeDonationSoftware.org
DONATION Support forums: http://forums.FreeDonationSoftware.org
E-mail: mailto:info@.FreeDonationSoftware.org
Home Phone: 416-423-9064If report designer was installed before VS 2005 then it will not be
integrated (that happened to me). Reinstall Report Designer from the SQL
Server 2005 media.
Note that RS 2005 comes with a version of VS so you did not have to have VS
2005 (this is different than the case with RS 2000).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Cooperstock" <dancoo@.newsgroups.nospam> wrote in message
news:Xns9876ADBF155ACdcoopssympaticoca@.207.46.248.16...
>I think I've installed all of the required pieces (SRS, already had VS.NET
> 2005 installed, BI tools). But the BI tools (e.g. Report Designer) don't
> appear on a menu anywhere, and the desired project type for reports
> doesn't
> appear in VS.NET.
> What might I have done wrong?
> Thanks.
>
> --
> Dan Cooperstock
> DONATION web site: http://www.FreeDonationSoftware.org
> DONATION Support forums: http://forums.FreeDonationSoftware.org
> E-mail: mailto:info@.FreeDonationSoftware.org
> Home Phone: 416-423-9064|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
news:eNhaYvEBHHA.3836@.TK2MSFTNGP02.phx.gbl:
> If report designer was installed before VS 2005 then it will not be
> integrated (that happened to me). Reinstall Report Designer from the
> SQL Server 2005 media.
> Note that RS 2005 comes with a version of VS so you did not have to
> have VS 2005 (this is different than the case with RS 2000).
>
Nope, VS.NET 2005 was installed first. I have tried installing SQL Server
(including Report Designer - via BI tools) a few times now, and nothing
appears in VS.NET.
Dan Cooperstock
DONATION web site: http://www.FreeDonationSoftware.org
DONATION Support forums: http://forums.FreeDonationSoftware.org
E-mail: mailto:info@.FreeDonationSoftware.org
Home Phone: 416-423-9064|||Not sure what to say except to make sure you are doing client tools instead
of the server but it sounds like you are doing that.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Cooperstock" <dancoo@.newsgroups.nospam> wrote in message
news:Xns9876B678377E8dcoopssympaticoca@.207.46.248.16...
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> news:eNhaYvEBHHA.3836@.TK2MSFTNGP02.phx.gbl:
>> If report designer was installed before VS 2005 then it will not be
>> integrated (that happened to me). Reinstall Report Designer from the
>> SQL Server 2005 media.
>> Note that RS 2005 comes with a version of VS so you did not have to
>> have VS 2005 (this is different than the case with RS 2000).
>>
> Nope, VS.NET 2005 was installed first. I have tried installing SQL Server
> (including Report Designer - via BI tools) a few times now, and nothing
> appears in VS.NET.
>
> --
> Dan Cooperstock
> DONATION web site: http://www.FreeDonationSoftware.org
> DONATION Support forums: http://forums.FreeDonationSoftware.org
> E-mail: mailto:info@.FreeDonationSoftware.org
> Home Phone: 416-423-9064|||Hello Dan,
Would you please try to check whether you have the Business Intelligence
Projects under the folder
%Program Files%\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies ?
Also, please let me know your Visual Studio version.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||weilu@.online.microsoft.com (Wei Lu [MSFT]) wrote in news:ghfrDiJBHHA.4432
@.TK2MSFTNGXA01.phx.gbl:
> Please check you have the Business Intelligence projects under
> Program Files/Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
The only thing I see there that looks relevant is
Microsoft.ReportDesigner.dll.
I can also clarify that while I don't see the project types when I go to
add a new Project to the solution (which the installer suggested I should I
have) I did discover that under adding a new Item to a project, I do have
Report, and it is indeed an SRS Report that it creates.
Dan Cooperstock
DONATION web site: http://www.FreeDonationSoftware.org
DONATION Support forums: http://forums.FreeDonationSoftware.org
E-mail: mailto:info@.FreeDonationSoftware.org
Home Phone: 416-423-9064|||When you do New Project you should have Business Intelligence Projects as a
choice.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Cooperstock" <dancoo@.newsgroups.nospam> wrote in message
news:Xns987755AA3C448dcoopssympaticoca@.207.46.248.16...
> weilu@.online.microsoft.com (Wei Lu [MSFT]) wrote in news:ghfrDiJBHHA.4432
> @.TK2MSFTNGXA01.phx.gbl:
>> Please check you have the Business Intelligence projects under
>> Program Files/Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
> The only thing I see there that looks relevant is
> Microsoft.ReportDesigner.dll.
> I can also clarify that while I don't see the project types when I go to
> add a new Project to the solution (which the installer suggested I should
> I
> have) I did discover that under adding a new Item to a project, I do have
> Report, and it is indeed an SRS Report that it creates.
>
> --
> Dan Cooperstock
> DONATION web site: http://www.FreeDonationSoftware.org
> DONATION Support forums: http://forums.FreeDonationSoftware.org
> E-mail: mailto:info@.FreeDonationSoftware.org
> Home Phone: 416-423-9064|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
news:unK9bGNBHHA.3560@.TK2MSFTNGP03.phx.gbl:
> When you do New Project you should have Business Intelligence Projects
> as a choice.
>
Yes, I agree that I should. But I don't. The fact that I don't is what led
me to post about this in the first place!
Dan Cooperstock
DONATION web site: http://www.FreeDonationSoftware.org
DONATION Support forums: http://forums.FreeDonationSoftware.org
E-mail: mailto:info@.FreeDonationSoftware.org
Home Phone: 416-423-9064|||I have had people doing things with VS 2005 thinking they were using the
report designer when really they were dealing with the new controls (which
also allow designing reports). You wouldn't believe how many times people
have not installed from the SQL Server media the client BI tools. That is
why I am making sure.
I had exactly what you are talking about happen but it appeared when I
re-installed. Have you tried removing (not just re-installing) but first
removing the BI tools and then re-installing.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Cooperstock" <dancoo@.newsgroups.nospam> wrote in message
news:Xns9877DF702FAE7dcoopssympaticoca@.207.46.248.16...
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> news:unK9bGNBHHA.3560@.TK2MSFTNGP03.phx.gbl:
>> When you do New Project you should have Business Intelligence Projects
>> as a choice.
>>
> Yes, I agree that I should. But I don't. The fact that I don't is what led
> me to post about this in the first place!
>
> --
> Dan Cooperstock
> DONATION web site: http://www.FreeDonationSoftware.org
> DONATION Support forums: http://forums.FreeDonationSoftware.org
> E-mail: mailto:info@.FreeDonationSoftware.org
> Home Phone: 416-423-9064|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
news:uZSipgaBHHA.4592@.TK2MSFTNGP03.phx.gbl:
> I have had people doing things with VS 2005 thinking they were using
> the report designer when really they were dealing with the new
> controls (which also allow designing reports). You wouldn't believe
> how many times people have not installed from the SQL Server media the
> client BI tools. That is why I am making sure.
> I had exactly what you are talking about happen but it appeared when I
> re-installed. Have you tried removing (not just re-installing) but
> first removing the BI tools and then re-installing.
>
Yes, uninstalling my whole SQL Server installation and then re-installing
it fixed it - I now have the Business Intelligence projects.
Thanks!
--
Dan Cooperstock
DONATION web site: http://www.FreeDonationSoftware.org
DONATION Support forums: http://forums.FreeDonationSoftware.org
E-mail: mailto:info@.FreeDonationSoftware.org
Home Phone: 416-423-9064|||Good. Glad it is fixed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Cooperstock" <dancoo@.newsgroups.nospam> wrote in message
news:Xns987892BF57C28dcoopssympaticoca@.207.46.248.16...
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> news:uZSipgaBHHA.4592@.TK2MSFTNGP03.phx.gbl:
>> I have had people doing things with VS 2005 thinking they were using
>> the report designer when really they were dealing with the new
>> controls (which also allow designing reports). You wouldn't believe
>> how many times people have not installed from the SQL Server media the
>> client BI tools. That is why I am making sure.
>> I had exactly what you are talking about happen but it appeared when I
>> re-installed. Have you tried removing (not just re-installing) but
>> first removing the BI tools and then re-installing.
> Yes, uninstalling my whole SQL Server installation and then re-installing
> it fixed it - I now have the Business Intelligence projects.
> Thanks!
> --
> Dan Cooperstock
> DONATION web site: http://www.FreeDonationSoftware.org
> DONATION Support forums: http://forums.FreeDonationSoftware.org
> E-mail: mailto:info@.FreeDonationSoftware.org
> Home Phone: 416-423-9064

Can't find client

I can't see any SQL Management tools after installed SQL 2005. How can I see
the database by tools just like what we had in SQL 2000?
Hello,
Run the Setup program when you continue you have an option for Components to
install and choose "Workstation COmponents"
and continue.
Thanks
Hari
"Kit Wong" <Kit Wong@.discussions.microsoft.com> wrote in message
news:6CA37313-603E-4275-A714-E6491EA13408@.microsoft.com...
>I can't see any SQL Management tools after installed SQL 2005. How can I
>see
> the database by tools just like what we had in SQL 2000?
|||Hari,
Thanks. I can see and select workstation components and client components.
But it hhas been ceased with error immediately.
TITLE: Microsoft SQL Server 2005 Setup
There was an unexpected failure during the setup wizard. You may review the
setup logs and/or click the help button for more information.
For help, click:
[url]http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server& ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=50000& EvtType=packageengine%5cinstallpackageaction.cpp%4 0InstallToolsAction.10%40sqls%3a%3aInstallPackageA ction%3a%3aperform%400x643[/url]
BUTTONS:
OK
COACH [pizza01@.netvigator.com]
"Hari Prasad" wrote:

> Hello,
> Run the Setup program when you continue you have an option for Components to
> install and choose "Workstation COmponents"
> and continue.
> Thanks
> Hari
>
> "Kit Wong" <Kit Wong@.discussions.microsoft.com> wrote in message
> news:6CA37313-603E-4275-A714-E6491EA13408@.microsoft.com...
>
>
|||Hello,
See the Setup bootstap log folder (Program Files\Microsoft SQL
Server\90\Setup Bootstrap\LOG) for the setup log file and see if there is
any
error occured during installation.
Thanks
Hari
"Kit Wong" <KitWong@.discussions.microsoft.com> wrote in message
news:0BBA2865-ABD7-481B-9809-3FCC48D49193@.microsoft.com...[vbcol=seagreen]
> Hari,
> Thanks. I can see and select workstation components and client components.
> But it hhas been ceased with error immediately.
> TITLE: Microsoft SQL Server 2005 Setup
> --
> There was an unexpected failure during the setup wizard. You may review
> the
> setup logs and/or click the help button for more information.
>
> For help, click:
> [url]http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server& ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=50000& EvtType=packageengine%5cinstallpackageaction.cpp%4 0InstallToolsAction.10%40sqls%3a%3aInstallPackageA ction%3a%3aperform%400x643[/url]
> --
> BUTTONS:
> OK
> --
>
> COACH [pizza01@.netvigator.com]
> "Hari Prasad" wrote:

Can't create SSIS project in BIDS on workstation with Client tools only installed

I have the June CTP SQL 2005 client tools only installed on my workstation. All has gone well until I tried to create a SSIS project in BIDS.

I receive this message

TITLE: Microsoft Visual Studio

Error creating package

ADDITIONAL INFORMATION:

Failed to save package file "D:\Documents and Settings\SuzMSDN\Local Settings\Temp\tmp13E.tmp" with error 0x80040154 "Class not registered".

Failed to save package file "D:\Documents and Settings\SuzMSDN\Local Settings\Temp\tmp13E.tmp" with error 0x80040154 "Class not registered".

Tried registering DTSPipeline.dll per a post with no success.

I can log into the server where SQL is installed and use BIDS on the server without issue for an SSIS project.

Thoughts?

Susan

Does the dialog have "show technical details" button?
If yes, please post this information.

Thanks,
Michael.|||

Below are the technical Details ...thanks

Susan
===================================

Error creating package (Microsoft Visual Studio)

===================================

Failed to save package file "D:\Documents and Settings\SuzMSDN\Local Settings\Temp\tmp10.tmp" with error 0x80040154 "Class not registered".

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToXml(String fileName, Package package, IDTSEvents events)
at Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.AddPackageToProject(Package package, String itemName)
at Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.CreateAndAddPackageToProject()
at Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.Execute(WizardInputs wizardInputs)

===================================

Failed to save package file "D:\Documents and Settings\SuzMSDN\Local Settings\Temp\tmp10.tmp" with error 0x80040154 "Class not registered".

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToXML(String FileName, IDTSPersist90 pPersistObj, IDTSEvents90 pEvents)
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToXml(String fileName, Package package, IDTSEvents events)

|||Let's try this:

regsvr32 msxml3.dll
regsvr32 msxml4.dll
regsvr32 msxml6.dll|||Michael,

Thanks you. That did the trick. I had to unregister msxml6 in order to take the MS SQL 2005 elearning classes.

So to take class you unregister...to work you register. ; )

Hopefully corrected for elearning in the next release.

Thanks for your assistance.

Susan

can't connect to SQLEXPRESS locally

I have SQLEXPRESS installed on a Windows 2003 Server. The SQL Tools show that TCP and Named Pipes are Enabled. I can't connect using either the command line or the Mgmt Studio with either of these protocols.

Following is excerpt from program I'm trying to install:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

And this from the command line

C:\Documents and Settings\edulog>sqlcmd -E -S localhost
HResult 0x274D, Level 16, State 1
TCP Provider: No connection could be made because the target machine actively re
fused it.

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

Thanks,

That's expected. Enable shared memory and you'll be good to go.

Paul

|||The MS documentation ( in the SQL Server Express Readme) says shared memory is enabled by default. I am trying to connect locally, and have named pipes, and tcp enabled as well as shared memory. All 3 methods fail.

Wendell