.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Post New Web Links

installed RTM SQL 2008 EE but profiler & DETA are MIA

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :Sql Server

Hi, I installed SQL Server 2008 Enterprise Edition (RTM) and checked Management Tools (Basic and Advanced) but profiler and DETA are missing in action.  They were not installed and I cannot find a link to add them.  Help!


Dr. William Sewell

View Complete Post

More Related Resource Links

installed ms sql server 2008 and there is no db instance

I had the 2005 version on installed on my pc...I installed visual studio 2010 professional but the sql 2005 did not work. I tried to install sql 2008 but I was unable to. Searched on the web and found out that I had to uninstall sql 2005 for some reason. I did. I successfully installed sql 2008 now but there is no database instance. I tried sqlcmd -L and there where no servers available.   Can I install I new instance now? How can I do that?

VS 2008, in addition to VSeWSS, has to be installed to the WSS3.0/MOSS2007 web server?

We just started to develop SharePoint Intranet by using WSS 3.0.  To get a first hand experience in developing SharePoint Web Parts in VS 2008, I plan to install VSeWSS to the web server where we installed WSS3.0, and MOSS2007 in the future. Do I still need to install VS 2008 to this web server, or I can develop SharePoint web parts from my workstation where VS 2008 was already installed?

Rebooting one Instance on a SQL 2008 Server with multiple instances installed

Hello, Hoping someone can answer the following questions ... If I have SQL Server 2008 with multiple Named Instances configured on it, can I reboot one Named Instance without rebooting any of the other Named Instances, or without having to reboot the entire server ? For example, if I have an application that needs to be re-booted and it requires the Database to be re-booted. Regards, JD

Getting Sql Server Management Studio 2008 installed on local computer

Hello, I have been trying to figure out this problem for a while now so hopefully someone can help me out - I would really appreciate it! Right now I have SQl Server Management Studio2005 installed on my computer for a SQL sever that we have. We recently got a 2008 sql server and if I remotely access the server, I can see that SQL Management Studio 2008 has been isntalled on the new server. I need to build new databases but need SQL Management Studio 2008 on my computer and I have no idea how to get it. I have a "Microsoft SQl Server 2008 R2" folder on my computer, and I have already tried clicking on "Configuration Tools" and then "SQL Server Installation center" and it isntalls a bunch of things, but none of them are "SQL Server Management Studio 2008."  I also found a link on a Microsoft website that says it's SQL Server Management studio 2008 R2 but it was just the same bunch of programs I already downloaded. How do I install Sql Server Managment Studio 2008 on my computer?! Thanks in advance for any help you can provide.

SQL Server 2008 Profiler--Templates Missing

For some reason (even after an uninstall, reinstall and updating the the Community Update) there are no templates visible in the Profiler for SQL Server 2008. On another system it works fine but the Trace Provider Type shows "Microsoft SQL Server 2008". On the problem system it shows "Microsoft SQL Server 10.0".   What's up?

"Load Report failed " after migration of VS 2008 to VS2010 with SAP crystal reports installed

i have migrated VS 2008 application in VS2010  including crystal report. i have installed SAP crystal reports to support  crystal reports in VS 2010. how can i migrate the old reports into SAP crystal reports please suggest me.

Silent install of SQL Server 2005 fails when SQL Server 2008 is installed


We currently install SQL Server 2005 Express silently during our installation, using the following switches


We also attach a 2005-created database immediately after using the following command line (^ is a path concat operator in Installshield):

sqlcmd.exe -S .\\SQLEXPRESS -E -i \"" + svConfigPath ^ "SetupUapDB.sql\" -vmdfpath=\"" + svConfigPath ^ "UapCfg.mdf\" -vldfpath=\"" + svConfigPath ^ "UapCfg_log.ldf\" -o \"" + svConfigPath ^ "SqlCreateDB.txt\" -e

Note that we do not specify an instance name.  We ran into a situation where someone had installed SQL Server 2008 on a box using a default instance name and our install then failed.  I am considering 2 possible fixes, and have questions for both.

Fix #1: Specify an instance name.  Ideally this would install SQL Server 2005 Express side by side with SQL Server 2008, create a unique instance name and we'd be good to go right?  If yes, what is the accepted convention for specifying instance names?

Fix #2: Not sure if this is possible.  Can we detect if SQL Server 2008 is on the box, and if yes, apply our 2005 database to it instead?  In this case (tell me

SQL server 2008 profiler


I am trying to run a trace in the SQL management studio to find out queries taking long time to run. But the when I do the new trace it only lets me select an instance but not a particular DB. How can find out about the quires in  a particular DB.


Detect SQL Express 2008 installed on machine


Hello all,

How cal I detect if SQL Express is installed on may machine through C#.





Can't install SQL 2008 if we previously installed SQL 2008 and removed it???

We installed SQL 2008 and uninstalled it.  Now we can't install SQL 2008.  This seems to be consisten with other servers.  Generally, you get one shot at SQL 2008.  I have a Microsoft case open, but they can't figure it out.  Anyone have any ideas?

Sharepoint 2010 DBs Installed on SQL 2008 r2 With Compatibility Level of 90


We installed Sharepoint 2010 using SQL 2008 r2 and had most databases install with a compatibility level of 100.  However two of the databases relating to User Profile Service SynchBD installed with a compatiblity level of 90.  Why would the Sharepoint install do that?  thx!

SQL2005 x64 on Windows Server 2008 x64 - One or more of the components being installed are already r


Failed to install and configure assemblies E:\Program Files_64bit\Microsoft SQL Server\90\DTS\Tasks\Microsoft.sqlServer.MSMSTask.dll in the COM+ catalog.
Error -2146233087. Error message: Unknown error 0x80131501
Error Description: One or more of the components being installed are already registered as 32 bit components in the target application.
(a) You must install the 64 bit versions of the components being installed in a different COM+ application,
(b) delete the existing 32 bit versions of the components being installed from the target COM+ application prior to attemping install of the 64 bit versions.
COM+ applications cannot contain bit neutral components.
Copied From installation Summary
<Func Name='LaunchFunction'>
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlAssemblyRegSvcs
PerfTime Start: Do_sqlAssemblyRegSvcs : Mon Sep 14 14:35:26 2009
<Func Name='Do_sqlAssemblyRegSvcs'>
Failed to install and configure assemblies E:\Program Files_64bit\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog.
Error: 2148734209
Error message: Unknown error 0x80131501
Error descrition: One or more of the components being installed are already registe

Cannot connect to SQL Server 2008 R2 installed on Win Server 2008 R2 in domain controlled by Win SBS


I have 2 SQL Server 2008 R2 instances installed on a new server running Win Server 2008 R2 in a Windows SBS 2008 domain.

The instances are configured to allow remote connection. The users are authorized in the SQL root security. The users are authorized for the computer and both SQL instances. Shared folders on the computer are visible remotely.

When I attempt to connect to either instance either programmatically, or using SQL Server Management Studio, the attempt fails with a Server not found ... error. I cannot see either instance.

I opened port 1434 in the firewall but that only made things worse.

I have not experienced this error before in SQL Servers 2000 or 2005.

Can anyone tell me what I am doing wrong?



M Whipps

How to identify if the SQL Server 2008 R2 version installed is 32 bit or 64 bit


How do I identify if the SQL Server 2008 R2 version that is installed is 32 bit or 64 bit. I see that the are some files in Program Files directory and some others in Program Files(x86) directory on an Windows Server 2008 R2 OS.  

I have read that having both BIDS 2005 and 2008 installed on my PC could be a problem.


I am trying to deploy an SSIS package through dtutil.

I am getting an error 'Could not find stored procedure sp_ssis_putpackage'.

I have read that having both BIDS 2005 and 2008 installed on my PC could be a problem.

Does any body know how to get around this error?

Mr Shaw

Where is SQL Profiler for 2008


I see a lot of people asking this question, but haven't found an answer yet.
I installed the full version of SQL Server 2008, but cannot find the SQL Profiler.

Any clue to where it is or how I can get it?

Microsoft SQL Server Management Studio      10.50.1600.1
Microsoft Data Access Components (MDAC)      3.85.1132
Microsoft MSXML      2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer      8.0.6001.18702
Microsoft .NET Framework      2.0.50727.3615
Operating System      5.1.2600


D. Watson
Microsoft - making my life difficult

SQL 2008 problem launching profiler


When I run the SQL profiler I get a message that says:

Profiler.exe - Application Error
The application failed to initialize properly (0xc0000005).

I've tried uninstalling and reinstalling, etc, but no luck.

Sigh... please help.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend