Error: Cannot display activity

TITLE: Microsoft SQL Server Management Studio Express (CTP Nov)

OS: Both XP SP2 and Win2003 SP1

Cannot display activity for database 'SomeDBName'.

ADDITIONAL INFORMATION:

Could not load file or assembly 'ActivityMonitor, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (mscorlib)

To reproduce:

Try to detach a database which has at least one active connection. On the Detach Database dialog click on: 1 Active connection.

Hi, this issue has already been found and resolved. You should not see this on the RTM version.|||

Hi

This is the only place in the entire world I have found reference to this problem. I have the same problem and I'm running MS SQL Server 2005 Express SP1 running on XP SP2.

Help > About on SSMSE shows:

Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

I found a KB article a while back about changing the registry key HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\TlbAutoRepair\mscorlib.tlb TlbPath value of %CLRVERSION% to v2.0.50727 but that didn't fix it. I've since tried repairing .Net Framework 2.0 and SSMSE but still have the problem.

Any ideas where to go next?

Mick

Error: Cannot display activity

TITLE: Microsoft SQL Server Management Studio Express (CTP Nov)

OS: Both XP SP2 and Win2003 SP1

Cannot display activity for database 'SomeDBName'.

ADDITIONAL INFORMATION:

Could not load file or assembly 'ActivityMonitor, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (mscorlib)

To reproduce:

Try to detach a database which has at least one active connection. On the Detach Database dialog click on: 1 Active connection.

Hi, this issue has already been found and resolved. You should not see this on the RTM version.|||

Hi

This is the only place in the entire world I have found reference to this problem. I have the same problem and I'm running MS SQL Server 2005 Express SP1 running on XP SP2.

Help > About on SSMSE shows:

Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

I found a KB article a while back about changing the registry key HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\TlbAutoRepair\mscorlib.tlb TlbPath value of %CLRVERSION% to v2.0.50727 but that didn't fix it. I've since tried repairing .Net Framework 2.0 and SSMSE but still have the problem.

Any ideas where to go next?

Mick

Error: An error occurred due to no connection

This error is for Nov RTM running under "NETWORK SERVICE" account.

I created a data source "MyDataSource". It looks like:
<DataSource xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0" xsi:type="RelationalDataSource" dwd:design-time-name="2d2b4fc8-af5c-4314-9155-384afd11fb70" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<ID>MyDataSource</ID>
<Name>MyDataSource</Name>
<CreatedTimestamp>0001-01-01T05:00:00Z</CreatedTimestamp>
<LastSchemaUpdate>0001-01-01T05:00:00Z</LastSchemaUpdate>
<ConnectionString>Provider=SQLOLEDB.1;Data Source=dbserver\my_instance;Integrated Security=SSPI;Initial Catalog=MyDataSource</ConnectionString>
<ConnectionStringSecurity>Unchanged</ConnectionStringSecurity>
<ImpersonationInfo>
<ImpersonationMode>ImpersonateServiceAccount</ImpersonationMode>
<ImpersonationInfoSecurity>Unchanged</ImpersonationInfoSecurity>
</ImpersonationInfo>
<Timeout>PT0S</Timeout>
</DataSource>

In my package, I obtain a new connection from the data source (test connection succeeds). I use a data flow task. Inside the data flow task I have a flat file source and an Ole Db Destination. For configuring OleDbDestination, I can see in the drop-down a list of tables in my database. When I select the desired table and click "preview", I get:
TITLE: Microsoft Visual Studio

Error at Data Flow Task - my task [OLE DB Destination [831]]: An error occurred due to no connection. A connection is required when requesting metadata.

--
ADDITIONAL INFORMATION:

Exception from HRESULT: 0xC0202022 (Microsoft.SqlServer.DTSPipelineWrap)

BUTTONS:

OK
TIA,
Nitesh

Can you please check that you are not working with "Work Offline" settings.