Archive for April, 2011

iSCSI useful links

Advertisements

Leave a comment

0x8024200D and 0x800f081f error when you are installing Windows 7 or Windows Server 2008 R2 SP1

1 Comment

SQL Server and dynamic memory with Hyper-V in Windows Server 2008 R2 SP1

  1. http://blogs.technet.com/b/andrew/archive/2011/02/28/sql-server-and-dynamic-memory-with-hyper-v-in-windows-server-2008-r2-sp1.aspx
  2. Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment  http://support.microsoft.com/kb/956893
  3. SQL Server and Hyper-V Dynamic Memory http://blogs.msdn.com/b/sqlosteam/

Leave a comment

HTML Formatting is not being transported over Remote App Clipboard (RDP 7.0)

I have Windows 2008 R2 SP1 session host with RemoteApp configured. I have the text formatting issues when doing copy / paste operations between RemoteApp and local office applications in very specific directions:

  1. Copy from RemoteApp MS Excel 2010 and paste (-> ) to client MS Excel 2010: OK
  2. Copy from client MS Excel 2010 and paste (-> ) to RemoteApp MS Excel 2010: OK
  3. Copy from RemoteApp MS Excel 2010 and paste (-> ) to client MS Word 2010: OK
  4. Copy from client MS Word 2010 and paste (->) to RemoteApp MS Excel 2010: text formatting is lost!!!
  5. Copy from RemoteApp MS Word 2010 and paste (->) to client MS Excel 2010: text formatting is lost!!!
  6. Copy from client MS Excel 2010 and paste (-> ) to RemoteApp MS Word 2010: OK
  7. Copy from RemoteApp MS Word 2010 and paste (-> ) to client MS Word 2010: OK
  8. Copy from client MS Word 2010 and paste (->) to RemoteApp MS Word 2010: OK

The issue also happens when I use 1C accounting application (v. 8.1.15) in RemoteApp mode and a local Word / Wordpad.

Additional information

  1. Windows 2008 R2 Remote Desktop Session Host: Windows 2008 Standard R2 SP1 with Microsoft Office 2010 x86
  2. Client side (Windows XP and Windows 7 both have the issue):
    1. Windows XP SP3 x86 with Microsoft Office 2010 x86, Remote Desktop Client 6.1 (mstsc.exe = 6.0.6.001.1800)
    2. Windows 7 SP1 x64 with Microsoft Office 2010 x86, Remote Desktop Client 7.1 (mstsc.exe = 6.1.7601.17514)
  3. Microsoft Word and Excel versions are the same on clients and RD Session host:
    1. Winword.exe: 14.0.5123.5000
    2. Excel.exe: 14.0.4756.1000
  4. It happens with all files.
    1. I simply open locally installed Word 2010, create and format a table, write down some text and try to copy / paste this table to Excel 2010 in RemoteApp mode. I get a plain text only.
    2. Or I open Word 2010 in RemoteApp mode, create and format a table, write down some text and try to copy / paste this table to locally installed Excel 2010. I get a plain text only.
  5. It is tested that:
    1. All is working fine with

i.      Windows 2008 x86 SP2 Terminal Services

ii.      Windows XP x86 SP3 with RDC 6.1.After upgrading RDC 6.1 to RDC 7.0 on Windows XP x86 SP3 – the issue appears.

6. The problem is definitely with RemoteApp shell – RDPShell.exe, when RDP 7.0 or higher is used.

Cause

Microsoft product support services confirmed – it is the Bug (HTML Formatting is not being transported over Remote App Clipboard on W8k2 R2 SP1 RDSH and W7 SP1). Microsoft plans to fix it only with next Windows / RDP version.

Resolution / Workaround

Use a full RDP Session to connect to your RDSH instead of Remote App.

4 Comments

ACS reports return no more than 42 days old data

Updated on January 17, 2012: Microsoft has released KB article 2663919 “System Center Operations Manager 2007 ACS reports return no more than 42 days of data”  http://support.microsoft.com/kb/2663919

The information below is retrieved from Microsoft support forum:

The ACS collector service uses the “DbDeletePartition.sql” (Path C:\Windows\System32\Security\AdtServer) to delete partition table based on retention period and also create the views AdtServer.dvall, AdtServer.dvall5 and AdtServer.dvheader. In the DbDeletePartition.sql the dvall , dvall5 and dvheader views use union of only the top 42 partition tables. See below.
Create or update dvAll, the view across all partition views
declare @iIsFirst int
declare @vchStmt nvarchar(max)
declare @vchPartitionId nchar(36)
declare cPartition cursor for
select top 42 PartitionId from dtPartition order by PartitionCloseTime desc
set @iIsFirst = 1
set @vchStmt = N’create view [AdtServer].dvAll as’
open cPartition
fetch next from cPartition into @vchPartitionId
while @@fetch_status = 0
begin
if @iIsFirst = 0
set @vchStmt =  @vchStmt + N’ union all’
set @vchStmt =  @vchStmt + N’ select * from dvAll_’ + @vchPartitionId
set @iIsFirst = 0
fetch next from cPartition into @vchPartitionId
end
close cPartition
deallocate cPartition
if exists (
select * from dbo.sysobjects where
id = object_id(N'[AdtServer].dvAll’) and
objectproperty(id, N’IsView’) = 1)
drop view [AdtServer].dvAll
exec (@vchStmt)
go
Create or update dvAll5, the view across all partition views limited to the first 5 strings
declare @iIsFirst int
declare @vchStmt nvarchar(max)
declare @vchPartitionId nchar(36)
declare cPartition cursor for
select top 42 PartitionId from dtPartition order by PartitionCloseTime desc
set @iIsFirst = 1
set @vchStmt = N’create view [AdtServer].dvAll5 as’
open cPartition
fetch next from cPartition into @vchPartitionId
while @@fetch_status = 0
begin
if @iIsFirst = 0
set @vchStmt =  @vchStmt + N’ union all’
set @vchStmt =  @vchStmt + N’ select * from dvAll5_’ + @vchPartitionId
set @iIsFirst = 0
fetch next from cPartition into @vchPartitionId
end
close cPartition
deallocate cPartition
if exists (
select * from dbo.sysobjects where
id = object_id(N'[AdtServer].dvAll5′) and
objectproperty(id, N’IsView’) = 1)
drop view [AdtServer].dvAll5
exec (@vchStmt)
go
Create or update dvHeader, the view across all partition views with no dtstring joins
declare @iIsFirst int
declare @vchStmt nvarchar(max)
declare @vchPartitionId nchar(36)
declare cPartition cursor for
select top 42 PartitionId from dtPartition order by PartitionCloseTime desc
set @iIsFirst = 1
set @vchStmt = N’create view [AdtServer].dvHeader as’
open cPartition
fetch next from cPartition into @vchPartitionId
while @@fetch_status = 0
begin
if @iIsFirst = 0
set @vchStmt =  @vchStmt + N’ union all’
set @vchStmt =  @vchStmt + N’ select * from dvHeader_’ + @vchPartitionId
set @iIsFirst = 0
fetch next from cPartition into @vchPartitionId
end
close cPartition
deallocate cPartition
if exists (
select * from dbo.sysobjects where
id = object_id(N'[AdtServer].dvHeader’) and
objectproperty(id, N’IsView’) = 1)
drop view [AdtServer].dvHeader
exec (@vchStmt)
go

As a workaround, you may try to increase this value. For example, change “select top 42 PartitionId from dtPartition order by PartitionCloseTime desc” to “select top 60 PartitionId from dtPartition order by PartitionCloseTime desc” in dvall, dvall5 and dvheader, and you should get 60 days old data in ACS report.

DbCreatepartition.sql (path C:\Windows\System32\Security\AdtServer) is called to create new partition tables, while DbDeletePartition.sql (path C:\Windows\System32\Security\AdtServer) is called to delete old tables that are ready to be groomed out. Please edit both .sql files

Note: SQL 2005 has a limitation and allows only 255 partition tables in a view. Do not set the value more than 255. Also higher the value, it can take longer to fetch the data in the reports and performance may degrade.

Leave a comment

“The specified secure socket layer (SSL) port is not allowed. ISA server is not configured to allow SSL requests from this port. Most WEB-browsers use port 443 for SSL requests”

Leave a comment