小熊子的技術世界

KB-解決 IIS6 上傳檔案大小200kb的限制

2012-01-06T10:32:00.001+08:00

這邊有一種解決方式

http://www.hkcode.com/programming/539

IIS 預設上傳限制為 200kb，要修改這個限制，方法如下：

1. 開啟 Internet Information Services Manager (IIS)。 (中文版好像叫 IIS 管理員)

2. 在 server 上面 right click 及選擇 Properties

3. 選取 "Enable Direct Metabase Edit" 並按 OK

4. 開啟 Notepad，開啟以下檔案

%Windows dir%\System 32\Inetsrv\MetaBase.xml

5. 找出字串 AspMaxRequestEntityAllowed，預設是 204800，即 200kb，例如想改為 5mb 的話，應改為：

預設為 AspMaxRequestEntityAllowed = "52428800"

6. 完成後儲存 MetaBase.xml 便完成，不須要重新啟動 IIS。

7. 回到 Internet Information Services Manager (IIS)，移除 "Enable Direct Metabase Edit" 的選項。

我比較喜歡這樣子的解決方式

cscript c:\Inetpub\AdminScripts\adsutil.vbs SET W3SVC/<WebSiteID>/AspMaxRequestEntityAllowed 52428800

MSDTC 問題集錦

2011-12-30T15:21:00.001+08:00

最近處理了 MSDTC 的問題，一定要寫一篇記錄下來，黑大真的太強了啊!!!

第一步：MSDTC 是否安裝及設定成功?

a.設定(含防火牆)

MSDTC on Windows 2003 SP1的注意事項

http://blog.darkthread.net/blogs/darkthreadtw/archive/2006/03/07/msdtc-on-windows-2003-sp1.aspx

心得：上面這一篇，超級超級超級重要，一定要有耐心看完!!

====我是小抄=====

Enable network DTC access(Win2003 程式集)

MSDTC Security Configuration :Allow Inbound , Allow Outbound , No Authentication Required , Enable XA Transactions

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

b.安全性設定

心得：不小心遇到了需要做 sc sdshow msdtc 及 sc sdset msdtc <權限> 記得要非常非常小心，最好在做 sdshow 時，直接下這樣子的指令存到一個文字檔中來修改。

sc sdshow msdtc > msdtc-sec.txt 這樣子比較保險一點。

【茶包射手專欄】奧妙的MSDTC咒語

http://blog.darkthread.net/blogs/darkthreadtw/archive/2008/04/17/transactionscope-web-access-denied.aspx

第二步：確認發生關係的主機，互相都認得?

在主機上使用 Ping 主機名稱就知道囉!!

KB-MSDTC cross different domains

http://blog.darkthread.net/blogs/darkthreadtw/archive/2007/02/12/kb-msdtc-cross-different-domains.aspx

還有遇到多網卡的問題，要確定【發動主機->配合主機】的網路路線，要跟【配合主機->發動主機】的網路路線相同，否則可能出現時好時不好的狀況。

第三步：拿MSDTC 除錯工具來驗證

測試DTC設定-使用Mini C# Lab

http://blog.darkthread.net/blogs/darkthreadtw/archive/2009/02/22/test-dtc-with-csharplab.aspx

SQL 2008 / Windows 2008 之 MSDTC 注意事項

http://blog.darkthread.net/post-2010-11-12-msdtc-2008.aspx

Oracle

【茶包射手專欄】錯怪Oracle~~

http://blog.darkthread.net/blogs/darkthreadtw/archive/2007/08/31/1011.aspx

Distributed Transaction With MS OLEDB Provider For Oracle

http://blog.darkthread.net/blogs/darkthreadtw/archive/2007/11/07/distributed-transaction-with-ms-oledb-provider-for-oracle.aspx

MSDTC 除錯工具

測試DTC設定-使用Mini C# Lab

http://blog.darkthread.net/blogs/darkthreadtw/archive/2009/02/22/test-dtc-with-csharplab.aspx

.NET分散式交易程式開發FAQ

http://blog.darkthread.net/blogs/darkthreadtw/archive/2008/05/09/distributed-transactoin-with-dotnet-faq.aspx

SQL Reporting Service 虛擬化時複製機器的小技巧

2011-12-14T13:46:00.001+08:00

虛擬化的好處就是機器可以快速的複製，Windows 系統上，用 sysprep 就可以進行更換 newid ，但是 Reporting Service 就會出現錯誤：

The report server cannot decrypt the symmetric key. Most likely, the service account or password has changed. To continue, run rsconfig.exe to update the report server account information.

由於直接複製，所以 SSRS 的 InstallationID 都會一樣，建立 Reporting Service Cluster 時就會相衝，有以下小技巧可以進行，不用重新安裝：

STEP 1:

修改 C:\Program Files\Microsoft SQL Server\<SSRS Instance ID>\Reporting Services\ReportServer\rsreportserver.config 中的 InstallationID，換新的 Guid

   1:  <Configuration>

   2:      <Dsn>......</Dsn>

   3:      <ConnectionType>Default</ConnectionType>

   4:      <LogonUser></LogonUser>

   5:      <LogonDomain></LogonDomain>

   6:      <LogonCred></LogonCred>

   7:      <InstanceId>MSRS10_50.MSSQL2008</InstanceId>

   8:      <InstallationID>{12345-f89c-4c11-ae78-52117dafbcc2}</InstallationID>

   9:      <Add Key="SecureConnectionLevel" Value="0"/>

  10:      <Add Key="CleanupCycleMinutes" Value="10"/>

  11:      <Add Key="MaxActiveReqForOneUser" Value="20"/>

  12:      <Add Key="DatabaseQueryTimeout" Value="120"/>

  13:      <Add Key="RunningRequestsScavengerCycle" Value="60"/>

  14:      <Add Key="RunningRequestsDbCycle" Value="60"/>

  15:      <Add Key="RunningRequestsAge" Value="30"/>

  16:      <Add Key="MaxScheduleWait" Value="5"/>

  17:      <Add Key="DisplayErrorLink" Value="true"/>

  18:      <Add Key="WebServiceUseFileShareStorage" Value="false"/>

  19:  </Configuration>

STEP 2:

Restore Key (SSRS Key 一定要備份出來，否則連線帳密、設定等資訊都沒有辦法再恢復，等於要重新安裝資料庫，非常重要!!)

Configuring a VMWare clone for SSRS disaster recovery

http://www.pertell.com/sqlservings/archive/2011/07/configuring-a-vmware-clone-for-ssrs-disaster-recovery/

SQL Server 的版本編號

Release	Report server	Report server database
SQL Server 2008 R2	10.50.nnnn.nn	n/a
SQL Server 2008 Service Pack 1 (SP1)	10.0.2531.00	C.0.9.45
SQL Server 2008	10.0.1600.00	C.0.9.45
SQL Server 2005 Reporting Services Service Pack 3 (SP3)	9.0.4035.00	C.0.8.54
SQL Server 2005 Reporting Services Service Pack 2 (SP2)	9.0.3042.00	C.0.8.54
SQL Server 2005 Express with Advanced Services	9.0.3042.00	C.0.8.45
SQL Server 2005 Reporting Services Service Pack 1 (SP1)	9.0.2049.00	C.0.8.43
SQL Server 2005 Reporting Services	9.0.1399.01	C.0.8.40
SQL Server 2000 Reporting Services Service Pack 2 (SP2)	8.00.1038	C.0.6.54
SQL Server 2000 Reporting Services Service Pack 1 (SP1)	8.00.0878	C.0.6.51
SQL Server 2000 Reporting Services	8.00.0743	C.0.6.43

Tips-Oracle TNSName.ora Compare Tool

2011-09-29T11:12:00.001+08:00

最近因為 TNSName.ora 檔案的整理，需統一一個 TnsName.ora ，問題來了，近100個 TNS 主機，要怎麼對呢?

後來使用了 TOAD 的 TNS Editor來完成任務

如何比對呢? TOAD TNSEditor 可以依據 Host(IP) 或者是 Service 來排序，若有新增，實體的文字檔會直接新增在檔案尾端。

Excel 2007 的 Pivot Table 樞鈕分析表就差這個功能

2011-05-20T13:37:00.000+08:00

在列標籤，若是以列表的方式表現時，Excel 2007 無法重覆項目名稱，在將資料匯出至別的用途時，就會很麻煩。

Excel 2010 新增了這個貼心的功能

另外Excel 2010 也可以使用 Powerpivot 這個增益集，看來還是要升級至 Excel 2010 呀

Win7,Win2008 使用檔案總管開啟 Sharepoint 文件庫時異常緩慢

2011-05-18T14:13:00.001+08:00

Sharepoint 可以支援使用網芳(或說檔案分享，UNC ，FileSharing)的方式，在 IE or 檔案總管上進行操作。

新灌的Win2008 Server 連線 Sharepoint 的文件庫就很慢，一直百思不得其解，後來發現，原來是 IE 的自動偵測 Proxy 搞的鬼，關掉就 OK 囉!!

參考連結

http://oddballupdate.com/2009/12/18/fix-slow-webdav-performance-in-windows-7/

如何用ICS讓遠端可以連線主機內部(NAT)的虛擬機器

2011-05-18T13:47:00.001+08:00

微軟WinXP之後有新增了一個網際網路共用服務( ICS，全名叫 Internet Connection Sharing)

詳細說明可以看這裡(http://windows.microsoft.com/zh-TW/windows-vista/Using-ICS-Internet-Connection-Sharing)

可以讓我們連到主機背後VM的遠端桌面

看看怎麼做吧

OnBoard 網卡是對外的網路

VMNAT是HyperV虛擬的網卡

啟用 ICS

新增一個 VM RDP Service

設定 VM 的 IP，並且定義外部的 Port 與內部遠端桌面的 Port

特別注意，Port Forwarding 的測試，需要在外部機器上測試，在主機上是測不通的哦!!

Tips-如何使用 Windows 驗證連接 SQL Server

2011-05-06T13:56:00.001+08:00

SQL Server 2005/2008 之後，因為安全性增強的關係，所以已經不允許使用控制台中[儲存的帳號/密碼]直接透通。

那該如何做呢?

我們可以使用 RunAs.exe 這個指令啟動 SQL Server Management Studio

RunAs.exe 指令語法是這樣子的，詳細可以至微軟網站查詢(http://technet.microsoft.com/en-us/library/bb490994.aspx)

Syntax

runas [{/profile|/noprofile}] [/env] [/netonly] [/smartcard] [/showtrustlevels] [/trustlevel] /user:UserAccountName program

Parameters

/profile : Loads the user's profile. /profile is the default.

/no profile : Specifies that the user's profile is not to be loaded. This allows the application to load more quickly, but it can also cause a malfunction in some applications.

/env : Specifies that the current network environment be used instead of the user's local environment.

/netonly : Indicates that the user information specified is for remote access only.

/smartcard : Indicates whether the credentials are to be supplied from a smartcard.

/showtrustlevels : Lists the /trustlevel options.

/trustlevel : Specifies the level of authorization at which the application is to run. Use /showtrustlevels to see the trust levels available.

/user: UserAccountName : Specifies the name of the user account under which to run the program. The user account format should be user@domain or Domain\User.

program : Specifies the program or command to run using the account specified in /user.

/? : Displays help at the command prompt.

我們可以建立一個文字檔，取名為： SSMS(michadel_mike).cmd，再填入以下內容。

這個指令的意思是，用我的身份啟動 ssms.exe ，但當遇到網路連結時，請改用 michadel\mike。

==(x64)注意雙引號====

runas /netonly /user:michadel\mike "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

==(x32) 注意雙引號====

runas /netonly /user:michadel\mike "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

===========

存好後，執行時，會出現底下的視窗，要求輸入密碼。

最後，提醒一點，由於此方法是使用到網路的部份，改用 michadel\mike 帳號，

所以，若有要在程式裡面存取網路磁碟機(例如：載入*.sql文件)，會用 michadel\mike 存取，會造成存取被拒的狀況發生!!

參考連結：

stackoverflow:Connect to SQL Server with Management Studio using a Windows Credential while not on the domain

http://stackoverflow.com/questions/1678216/connect-to-sql-server-with-management-studio-using-a-windows-credential-while-not

容許主機/服務一年停機多久呢?

2011-04-21T09:37:00.001+08:00

最近購買的線上相簿出了兩次的錯誤，造成了約莫5個小時的停機時間，對於老外來看，似乎影響不大，因為都在他們的睡覺時間，對於我而言，就會有朋友來關切網站掛點的問題，所以從底下的可用性換算公式的背後，還有一個加權的分數，當停機時間是落在睡覺時間時的感受就會不同

可用性百分比與一年停機時間

可用性百分比	一天 24 小時為基準	一天 8 小時為基準
90%	876 小時 (36.5 日)	291.2 小時 (12.13 日)
95%	438 小時 (18.25 日)	145.6 小時 (6.07 日)
99%	87.6 小時 (3.65 日)	29.12 小時 (1.21 日)
99.9%	8.76 小時	2.91 小時
99.99%	52.56 分鐘	17.47 分鐘
99.999% (「5 個 9」)	5.256 分鐘	1.747 分鐘
99.9999%	31.536 秒	10.483 秒

MSMQ 歷險記

2010-07-05T09:01:00.001+08:00

MSMQ Overview

保哥的心得分享，深入淺出的介紹 MSMQ，並且許多有用的連結，推薦先看這一篇

Message Queuing (MSMQ) 學習心得分享

http://blog.miniasp.com/post/2010/04/MSMQ-Message-Queuing-Learning-Notes.aspx

錯誤訊息：Access to Message Queuing system is denied

MSMQ 3.0 too secure for you?

http://blogs.msdn.com/b/johnbreakwell/archive/2007/01/15/msmq-3-0-too-secure-for-you.aspx

小熊子測試的結果，上面的選項沒有用，跨 Domain 時，直接設定 Queue 安全性屬性 ANONYMOUS_LOGON=> Full Control

Message Queuing security overview

http://technet.microsoft.com/en-us/library/cc759412%28WS.10%29.aspx

這邊有一個 step by step

http://jwbs-blog.blogspot.com/2009/06/msmq-continued.html

錯誤訊息：The Message Queuing service is not available

*檢查防火牆是否有擋下 mqsvc.exe ?

*是否有開啟 MSMQ Service ?

*檢查 MSMQ 路徑格式是否有錯?

PUBLIC=QueueGUID
DIRECT=Protocol:ComputerAddress\QueueName
DIRECT=OS:ComputerName\private$\QueueName
PRIVATE=ComputerGUID\QueueNumber

OR

DIRECT=AddressSpecification\QueueName  (For public queues)
DIRECT=AddressSpecification\PRIVATE$\QueueName  (For private queues)
DIRECT=AddressSpecification\QueueName;JOURNAL  (For public queue journals)
DIRECT=AddressSpecification\PRIVATE$\QueueName;JOURNAL  (For private queue journals)
DIRECT=AddressSpecification\SYSTEM$;computersystemqueue  (Introduced in MSMQ 2.0 for the computer journal and dead-letter queues.)
DIRECT=URLAddressSpecification/QueueName  (Introduced in MSMQ 3.0)
(小熊子常常 OS:<ComputerName> 會寫成 OS:<IP> 當然會出錯!!)

如何遠端傳送 private Queue ?

這兩篇文章很不錯

MSMQ - Sending messages to remote private queues

http://www.infosysblogs.com/microsoft/2007/02/msmq_sending_message_to_remote.html

MSMQ - Receiving messages from remote private queues

http://www.infosysblogs.com/microsoft/2007/05/msmq_receiving_messages_from_r.html

如何取得 Outgoing Queues

為什麼會需要檢查Outgoing Queue? MSMQ 在 Send Remote Queue 時，會先丟到本機的 Outgoing Queues，而且程式上不會出錯，但訊息有可能會卡在這個部份，所以需要程式化來做監控。

引用 COM (Microsoft Message Queue 3.0 object library ; c:\windows\system32\mqoa.dll)
使用 MSMQApplication.ActiveQueues 取得目前活動的 Queue
利用 MSMQManagement.Init 取得 MSMQOutgoingQueueManagement 物件，透由 MSMQOutgoingQueueManagement.State 來判斷是否存活
參考
Accessing Outgoing Message Queues (MSMQ)
http://www.codeproject.com/KB/IP/MSMQ.aspx
Monitoring MSMQ connection health in C#
http://social.msdn.microsoft.com/Forums/en/windowstransactionsprogramming/thread/72da7b77-13ff-4d11-86a7-586fd4b747da
Message Queuing COM Components(MSDN)
http://msdn.microsoft.com/en-us/library/ms704064%28v=VS.85%29.aspx
MSMQApplication(MSDN)
http://msdn.microsoft.com/en-us/library/ms703173%28v=VS.85%29.aspx
MSMQManagement(MSDN)
http://msdn.microsoft.com/en-us/library/ms711378%28v=VS.85%29.aspx
MSMQOutgoingQueueManagement(MSDN)
http://msdn.microsoft.com/en-us/library/ms701455%28v=VS.85%29.aspx

如何取得 Queue 裡的訊息數

這個方法好，而且是純 .net
Counting Messages in an MSMQ MessageQueue from C#
http://jopinblog.wordpress.com/2008/03/12/counting-messages-in-an-msmq-messagequeue-from-c/
這篇提到兩種作法
1.用 Performance Counter - MSMQ Queue 取得
2.用 COM (Microsoft Message Queue 3.0 object library ; c:\windows\system32\mqoa.dll) 取得
也可以參考
Counting messages in Queue - the .NET version
http://msmq.spaces.live.com/blog/cns!393534E869CE55B7!121.entry
這篇也是用 COM
Accessing Outgoing Message Queues (MSMQ)
http://www.codeproject.com/KB/IP/MSMQ.aspx
這篇用 P/Invoke 取得 MQMgmtGetInfo
Counting the number of messages in a Message Queue in .NET

http://blog.codebeside.org/archive/2008/08/27/counting-the-number-of-messages-in-a-message-queue-in.aspx

其他

MessageQueueErrorCode.cs 錯誤代碼對照

http://www.koders.com/csharp/fidE632059BF610D9D912C019A96DCF7A2DD76C847F.aspx

MessageQueueErrorCode Enumeration(MSDN)

http://msdn.microsoft.com/en-us/library/system.messaging.messagequeueerrorcode%28VS.80%29.aspx

IIS Basic Authentication & Windows Authentication Slow Issue

2010-05-12T13:46:00.001+08:00

最近遇到的問題是這樣子的：

Basic 認證慢，Windows 認證快 (本機帳號認證快)

起先，看到 Basic Authentication 有一個 logonMethod 屬性可以設定

擷取http://www.iis.net/ConfigReference/system.webServer/security/authentication/basicAuthentication片段如下：

The logonMethod attribute can be one of the following possible values. The default is ClearText.

Value	Description
`Batch`	This logon type is intended for batch servers, where processes may be executing on behalf of a user without that user's direct intervention. The numeric value is `1`.
`ClearText`	This logon type preserves the name and password in the authentication package, which allows the server to make connections to other network servers while impersonating the client. The numeric value is `3`.
`Interactive`	This logon type is intended for users who will be using the computer interactively. The numeric value is `0`.
`Network`	This logon type is intended for high performance servers to authenticate plaintext passwords. Credentials are not cached for this logon type. The numeric value is `2`.

IIS Program Manager Thomas Deml (http://blogs.iis.net/thomad) 在這篇有寫到

When you logon with Basic Authentication IIS caches the logon information (token) of a user in the IIS token cache. This is necessary because entering a single Url in the browser might generate hundreds of requests. Just look at some of your pages and count all the images and other HREFs you have in there. Each one is its own request. If IIS wouldn't cache the token it would have to call LogonUser for each one of these requests. This could result in going to the Domain Controller (which is probably on another machine) for each one of these request and this gets incredibly expensive and your web-site would get awfully slow.

These tokens are cached for 15 minutes by default. The timeout is completely configurable though. Have a look at the following article: http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/6b2e7fcd-5fad-4ac8-ac0a-dcfbe771e9e1.mspx?mfr=true

The simplest way to purge the token cache is to recycle the Application Pool however or to call the FlushTokenCache API (search for FlushTokenCache).

Hope this helps.

下圖是 IIS7 Configuration Editor 設定 logonMethod 的方式，比起 IIS6 要另外安裝 Administrator Kit 好多了。

但是在 MSDN 上頭文件有說明：

Basic

IIS implements Basic authentication, which is part of the HTTP 1.0 specification, using Windows user accounts. When using Basic authentication, the browser prompts the user for a user name and password. This information is then transmitted across HTTP where it is encoded using Base64 encoding. Although most Web servers, proxy servers, and Web browsers support Basic authentication, it is inherently insecure. Because it is easy to decode Base64 encoded data, Basic authentication is essentially sending the password as plain text. For more information, see About Authentication in the IIS Documentation (http://www.microsoft.com/windows2000/en/server/iis/htm/core/iiabasc.htm).

The IIS metabase contains a LogonMethod property to specify the logon method for clear-text logons such as Basic authentication. By default, Basic authentication requires the Windows user account to have local logon rights at the Web server. If you use the default setting, IIS caches credentials during logon, which slows the logon process. By specifying either network logon or network with cleartext logon, IIS does not cache credentials at logon, which expedites the logon process. A local logon makes it possible for the user to access network resources, whereas a network logon does not. However, a network with cleartext logon makes it possible for the user to access network resources. For more information, see LogonMethod in the IIS Documentation (http://www.microsoft.com/windows2000/en/server/iis/htm/asp/apro1zms.htm).

To improve the security of this authentication scheme, you can use it in combination with Secure Sockets Layer/Transport Layer Security (SSL/TLS) support to encrypt the HTTP session. However, SSL/TLS impacts performance because it encrypts and decrypts all data on each exchange. TLS is the Internet Engineering Task Force (IETF) version of Netscape's SSL, sometimes referred to as SSL 3.1. For more information, see the specification (RFC 2246) on the Internet Engineering Task Force (IETF) Web site (http://www.ietf.org/rfc/rfc2246.txt).

When used in conjunction with Kerberos v5 authentication, IIS can delegate security credentials among computers running Windows 2000 and later that are trusted for delegation. Delegation enables remote access of resources on behalf of the delegated user.

老實說，我對於這些說法都被搞混了，後來我用了一個簡單的方式測試是否卡在 AD 認證：

將網域的人員加入本機群組，就可以發現有兩段會慢，第一段是下圖查詢 AD 的 Global Catalog，另一段是 Check Name 檢查名稱的部份

Basic

http://www.iis.net/ConfigReference/system.webServer/security/authentication/basicAuthentication

Widnows

http://www.iis.net/ConfigReference/system.webServer/security/authentication/windowsAuthentication

iPhone 開發 Web 應用程式小技巧

2010-04-26T16:29:00.001+08:00

1.特殊連結

Google Map http://maps.google.com/maps?q=<地址>

電話 call:

簡訊 sms:

郵件 mailto:

2.iPhone 桌面上建立圖示

圖示大小：57 x 57px

增加 <link rel="apple-touch-icon" href="<圖片網址>" />

例如 Hami.emome.net http://hami.emome.net/img/hami_WebClip.png

3.版面調整

Safari on iPhone 預設版型會以一般(桌上型)呈顯，但如果下了以下這行，會直接以 iPhone 寬度限制住(如 320px or 480px)

預設縮放比例為 1

詳細 viewport 參考文件

4.強制不偵測電話號碼

<meta name="format-detection" content="telephone=no">

5.隱藏網址列Hide address bar

如何讓 IE/Firefox/Chrome 可以模擬 iPhone 網頁?

安裝 Fiddler 後，透由 Customize Rules 變更 User-Agents 來進行模擬!!

在

public static RulesOption("IE &7 (Vista)", "&User-Agents", true)
var m_IE7: boolean = false;

之下增加：

public static RulesOption("IPHONE", "&User-Agents", true)
var m_IPHONE: boolean =false;

還有另一段

if (m_IE7){
oSession.oRequest["User-Agent"] = "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1)";
}
else

之下增加

if (m_IPHONE){
oSession.oRequest["User-Agent"] = "iPhone;Mozilla/4.0 (compatible; iphone;)";
}

else

存檔後關閉就會在下圖中出現 IPHONE

WCF 歷險記

2010-04-23T10:22:00.001+08:00

WCF Test Client Tool

SOA Cleaner
- 好用，但是不是免費
- 支援 DataTable / DataSet
- 不支援 maxBufferPoolSize , maxReceivedMessageSize
WCFTestClient.exe (Build in Visual Studio)
- C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\WcfTestClient.exe
- 不支援 DataTable / DataSet

Q:呼叫多次出現 cannot be used for communication because it is in the Faulted state.

A:http://msdn.microsoft.com/en-us/library/aa355056.aspx

Client 避免使用 Using 改用 Try...Catch...

WCF Client Avoiding Problems with the Using Statement

Note:

The using statement and ServiceHost: Many self-hosting applications do little more than host a service, and ServiceHost.Close rarely throws an exception, so such applications can safely use the using statement with ServiceHost. However, be aware that ServiceHost.Close can throw a CommunicationException, so if your application continues after closing the ServiceHost, you should avoid the using statement and follow the pattern previously given.

=====

Q: WCF Proxy Class can not generated 無法自動產生 Service Reference?

A: 有可能含有 WCF 不支援的型別，例如 DateTime?
可以使用 DataContractAttribute 排除

http://msdn.microsoft.com/zh-tw/library/system.runtime.serialization.datacontractattribute%28VS.90%29.aspx

=====

Q:為什麼回傳 DataTable 會出現錯誤?

A:序列化時 DataTable.TableName 為必填欄位，要記得指定。

=====

Q:為什麼無法回傳 Enum 型別?

A:需設定 [EnumMember] 在 Client 才會出現正確

範例：

[DataContract]
public enum FuncRight { [EnumMember]Read, [EnumMember] Edit };

Sharing Enum with WCF Service

KB-Report Viewer Control Localization

2010-04-16T11:56:00.001+08:00

最近 Web 使用了 Report View Control 來做為報表的呈顯，但是 Server 安裝版本是 English，無法呈顯多語系

Microsoft Report Viewer 2008 SP1 Redistributable

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=bb196d5d-76c2-4a0e-9458-267d22b6aac6

結果報表呈現上就是英文

試了很久，後來發現 Report View 有 Language Pack

Microsoft Report Viewer Redistributable 2008 SP1 语言包-簡體中文

http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=c1df3b07-09d7-48cb-bb63-df6d3c2f8141

Microsoft 可轉散發報表檢視器 2008 SP1 語言套件-繁體中文

http://www.microsoft.com/downloads/details.aspx?familyid=C1DF3B07-09D7-48CB-BB63-DF6D3C2F8141&displaylang=zh-tw

安裝後就可以依據 Browser 的語言來做切換，另外在 Server 上也可以定義：

1.Page

<%@ Page Language="C#" ...... Culture="zh-tw" %>

2.Web.config

<System.Web>

<globalization uiCulture="zh-tw" culture="zh-tw" />

</System.Web>

比較方便的方法是直接安裝繁體中文版的 Report View ，就會內含繁中+英文。

Microsoft Report Viewer 2008 SP1 Redistributable - 繁體中文

http://www.microsoft.com/downloads/details.aspx?familyid=BB196D5D-76C2-4A0E-9458-267D22B6AAC6&displaylang=zh-tw

ORA-02069: global_names parameter must be set to TRUE for this operation

2010-01-13T10:07:00.001+08:00

最近在做正式台與測試台 Oracle 的資料轉檔，結果遇到這個錯誤

ORA-02069: global_names parameter must be set to TRUE for this operation

會遇到這個錯誤，小熊子初步分析是用 View 的結果轉入 DBLink 的遠端 Table 問題。

後來找到這麼一篇文章，我的解法是用暫存 table 轉入 DBLink 的遠端 Table 以下是範例：

--依 select 結果建立暫存資料表

CREATE TABLE myTemp as

Select * from v_myView;

--用暫存資料表轉入遠端 Table

INSERT INTO myRemoteTable@remoteDB

select * from myTemp;

--卸除暫存資料表

DROP TABLE myTemp;

Heres a note from Oracle that explains whats going on, and offers a bit of a clumsy workaround.

Problem Description:
====================
You receive an ORA-02069 error during an insert to a remote database through a
database link when the insert contained a local sequence.
    ORA-02069: global_names parameter must be set to TRUE for this operation
        Cause: A remote mapping of the statement is required but cannot be
               achieved because global_names should be set to TRUE for it to
               be achieved.
       Action: Issue alter session set global_names = true if possible
Problem Explanation:
====================
This is expected behaviour.
The insert statement is transformed so that it can be executed at the remote
end of the dblink. The reference to the local sequence has to be qualified so
that the remote end knows to call back to the local instance. The qualification
is made by appending @local_dbname.domain to the sequence reference if
global_names=true. When global_names=false, the code cannot make the assumption
that the qualifier will be valid and reports the error ORA-02069 'global_names
parameter must be set to TRUE for this operation'.
Search Words:
=============
DBLINK SEQUENCE GLOBAL_NAMES ORA-2069
Solution Description:
=====================
Use the following workaround:
1. Create a 'temporary' table on the local database for holding the inserts.
2. Insert the entire row into this table.
3. Insert the 'temporary' row from the temporary table to the remote table.
4. Delete the 'temporary' row from the temporary table.
This is slower but it will get around the problem.
--OR--
Set GLOBAL_NAMES=TRUE in the init<SID>.ora
Solution Explanation:
=====================
The first workaround bypasses the remote node having to make a
call back to the local instance to reference the local sequence.

Tips-Excel 別再用 F2 將數字換文字,也別用巨集(Macro),請改用資料剖析!!

2009-12-25T10:49:00.001+08:00

之前常常會遇到一個問題，Excel 欄位預設格式為"通用"，若沒有先自行改為"文字"格式時，給 User 填完資料後，回來要匯入資料庫就一整個痛苦，

因為會需要一個一個用 F2 再按下 Enter 改為文字，後來還有用 Macro 寫，不過，最近發現一個好用的功能，就是資料剖析(Text to Columns)

資料剖析(Text to Columns)原本的用途是可以再讓你將一個欄位再切割，如果裡面有 , 還可以再拆前/後兩個欄位，

但也可以一整個欄位中所有的列，都改為文字，試試看，用過都會說讚的啦~~

Excel 2003 資料剖析功能位置(Text toColumns)

Excel 2007 資料剖析功能位置(Text to Columns)

Tips-如何大量設定共用資料夾權限 Part II

2009-12-21T14:28:00.001+08:00

最近在設定主機的備援，重新溫習了 RMTShare 與 NET SHARE，發現 Windows 2000 與 2003/2008 行為不同。

主要差別如下：

	Windows 2000	Windows 2003/2008
RMTShare	支援權限設定及共用設定	支援權限設定及共用設定
NET SHARE	只支援共用設定	支援權限設定及共用設定

以下是 Windows NT 2000 的語法

NET SHARE sharename
          sharename=drive:path [/USERS:number | /UNLIMITED]
                               [/REMARK:"text"]
                               [/CACHE:Manual | Automatic | No ]
          sharename [/USERS:number | /UNLIMITED]
                    [/REMARK:"text"]
                    [/CACHE:Manual | Automatic | No ]
          {sharename | devicename | drive:path} /DELETE

NET SHARE 將伺服器的資源開放給網路使用者。
如果沒有加上選項，會列出電腦上所有共用資源的相關資訊。
Windows NT 會報告每項資源的裝置名稱或路徑名稱，及相關描述。

sharename          要共用資源的網路名稱。如果在 NET SHARE 之後
                   只輸入一個共用名稱，會顯示這個共用的資訊。
drive:path         指定共用目錄的絕對路徑。
/USERS:number      設定可以同時存取該共用資源的
                   使用者最大個數。
/UNLIMITED         對同時存取該共用資源使用者數目不加以限制。
/REMARK:"text"     為資源加上描述備註。
                   請用雙引號括住備註文字。
devicename         sharename 上的可共用的印表機 (從 LPT1: 到 LPT9:)
/DELETE            停止資源共用。
/CACHE:Automatic   啟用自動重新整合的離線用戶端快取。
/CACHE:Manual      啟用手動重新整合的離線用戶端快取。
/CACHE:No          告訴用戶端不適合啟用離線快取。

NET HELP command | MORE 會以一次一個螢幕的方式顯示說明。

以下是 Windows Server 2003/2008 , XP/Vista 的語法

NET SHARE
sharename
          sharename=drive:path [/GRANT:user,[READ | CHANGE | FULL]]
                               [/USERS:number | /UNLIMITED]
                               [/REMARK:"text"]
                               [/CACHE:Manual | Documents| Programs | None ]
          sharename [/USERS:number | /UNLIMITED]
                    [/REMARK:"text"]
                    [/CACHE:Manual | Documents | Programs | None]
          {sharename | devicename | drive:path} /DELETE
          sharename \\computername /DELETE

NET SHARE 讓伺服器的資源可供網路使用者使用。
若未使用選項，它會列示電腦上所有共用資源的相關資訊。
Windows 會針對每一資源，報告裝置名稱或路徑名稱，
以及相關的描述性備註。

sharename          為共用資源的網路名稱。在鍵入
                   NET SHARE 時加上 sharename，只會顯示
                   有關該項共用的資訊。
drive:path         指定要共用目錄的絕對路徑。
/GRANT:user,perm   建立共用時加上安全性描述元，可將要求的權限
                   授與指定的使用者。此選項可多次使用，以便將
                   共用權限授與多位使用者。
/USERS:number      設定可同時存取共用資源的使用者數目上限。
/UNLIMITED         指定可同時存取共用資源的使用者數目不限。
/REMARK:"text"     新增關於資源的描述性備註。
                   將文字置於引號中。
devicename         為 sharename 所共用的一或多部印表機
                   (LPT1: 至 LPT9:)。
/DELETE            停止共用資源。
/CACHE:Manual      啟用此共用的程式及文件的手動用戶端快取功能。
/CACHE:Documents   啟用此共用的文件自動快取功能。
/CACHE:Programs    啟用此共用的文件及程式自動快取功能。
/CACHE:None        停用此共用的快取功能。

NET HELP 命令 | MORE 每次顯示一頁的說明。

之前的文章

TIPS-如何大量設定共用資料夾權限

[KB]ASP.NET Development Server Can not Load jQuery.js

2009-11-19T12:56:00.001+08:00

這個問題之前遇過一次，結果沒有寫 KB 就又忘記了，最近又新開另一個專案時又碰到，心一橫，還是要乖乖寫文件才行。

在測試環境中的 Web.Config 如下

<authentication mode="Forms">
<forms name=".aspxCoookie" loginUrl="logon.aspx"/>
</authentication>
<authorization>
<deny users="?" />
</authorization>

狀況是這樣子的，logon.aspx 裡面會載入 ~/inc/jQuery.js ，當在 IIS 的環境上正常，但是換到 ASP.NET Development Server 時，就出現 HTTP 401 錯誤訊息。

ASP.NET Development Server 是 Visual Studio 中，可以自行執行 asp.net 的小型 web server ，沒記錯的話，前身應該是 Cassini，於 VS2005 時納進 VS 產品中。

後來恍然大悟， *.js 在 IIS 上，是由 IIS 管理，而非使用 aspnet_isapi.dll 管理，當然不會進入 .Net 的世界，但 ASP.NET Development Server(很長的字，有縮寫嗎?)都是活在 .Net 的世界，所以…觀念清楚了之後，就知道怎麼解決啦~

在 ~/inc/ 目錄中，要新增一個 web.config ，如下所示：

或者是限定只有 jQuery.js

這個案例，不只是 jQuery.js 適合，還有…還沒認證前，看不到圖(.gif/.jpg/.png)，格式不對(.css)

KB-VSS Network Not Found Issue

2009-10-08T11:43:00.001+08:00

最近 VSS(Visual SourceSafe) 遇到一個問題，Check out / Check in 會出現很討厭的訊息

Network Not Found

後來查了一下，網路上有一個解法，設定 Journal File，重點是 Journal file ，Client 也要連得到，不然還是會出現 Network not found issue

已經使用了一天，這個問題沒有再出現困擾。

[KB][SPS2007]Microsoft.Office.Server.Internal.UI.SharedServicesAdminDefaultPage is not allow for this page

2008-06-20T11:37:00.001+08:00

出現這個錯誤已經好幾次，都忘記寫下來。

錯誤訊息為：

The base type 'Microsoft.Office.Server.Internal.UI.SharedServicesAdminDefaultPage' is not allow for this page.

This type is not registered as safe.

通常會遇到這個問題都是客製作 default.master 造成的。

先做了客製作之後，再連接至 admin or ssp 網站就會造成。

解決的方式就是

1.先還原 default.master

2.至admin or ssp 網站的 /_catalogs/master ，將 default.aspx 重設網站定義即可。

[FIX][IIS6] The path specified cannot be used at this time

2008-06-20T11:23:00.001+08:00

當開啟 Internet Information Service 時，就會出現這個錯誤

The path specified cannot be used at this time.

很奇怪的是，在 EventLog 上也出現以下的訊息

Event Type:    Error
Event Source:    Office SharePoint Server
Event Category:    Office Server 共用服務
Event ID:    6482
Date:        2008/6/20
Time:        上午 10:37:20
User:        N/A
Computer:
Description:
服務執行個體 Microsoft.Office.Server.Search.Administration.SearchAdminSharedWebServiceInstance (82d1a3e4-bbc4-4589-b114-1e3e49a50237) 的應用程式伺服器管理工作失敗。

原因: The path specified cannot be used at this time. (Exception from HRESULT: 0x80070094)

技術支援詳細資料:
System.Runtime.InteropServices.COMException (0x80070094): The path specified cannot be used at this time. (Exception from HRESULT: 0x80070094)
   at System.DirectoryServices.DirectoryEntry.CommitChanges()
   at Microsoft.SharePoint.Metabase.MetabaseObject.Update()
   at Microsoft.SharePoint.Administration.SPProvisioningAssistant.ApplyIisVirtualDirectorySettings(VirtualDirectory virtualDirectory, String path, AccessFlags accessFlags, String applicationName, String applicationPoolId, String[] scriptMaps)
   at Microsoft.SharePoint.Administration.SPProvisioningAssistant.ProvisionIisRootVirtualDirectory(WebSite webSite, String path, AccessFlags accessFlags, String applicationName, String applicationPoolId, String[] scriptMaps)
   at Microsoft.SharePoint.Administration.SPProvisioningAssistant.ProvisionIisWebSite(String serverComment, String[] serverBindings, String[] secureBindings, AuthenticationMethods authenticationMethods, String[] authenticationProviders, String path, AccessFlags accessFlags, String applicationName, String applicationPoolId, String[] scriptMaps, String sslCertificateSubjectName)
   at Microsoft.SharePoint.Administration.SPMetabaseManager.ProvisionIisWebSite(String serverComment, String[] serverBindings, String[] secureBindings, Int32 authenticationMethods, String[] authenticationProviders, String path, Int32 accessFlags, String applicationName, String applicationPoolId, String[] scriptMaps, String sslCertificateSubjectName)
   at Microsoft.Office.Server.Administration.SharedWebServiceInstance.Synchronize()
   at Microsoft.Office.Server.Administration.ApplicationServerJob.ProvisionLocalSharedServiceInstances(Boolean isAdministrationServiceJob)

Event Type:    Error
Event Source:    Windows SharePoint Services 3
Event Category:    計時器
Event ID:    6398
Date:        2008/6/20
Time:        上午 10:30:50
User:        N/A
Computer:
Description:
工作定義 Microsoft.Office.Server.Administration.ApplicationServerAdministrationServiceJob (識別碼 ce316348-a374-4dc2-ad07-e3328c4868ca) 的 Execute 方法發生例外狀況。其他資訊如下。

Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

我發現微軟有一個 KB 在說明這個問題，並且在右上角提供索取 hotfix 的方法(小熊子大眼睛沒看到，謝謝黑暗大哥)

http://support.microsoft.com/kb/946517

以下是 KB946517 的內容，提供參考

安裝完後， IIS 管理界面就開得起來囉~

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

SYMPTOMS

Consider the following scenario. You have a process that has more than one thread. Additionally, the process uses the Internet Information Services (IIS) Active Directory Service Interfaces (ADSI) provider to access IIS 6.0. Two threads access IIS 6.0 at the same time. In this scenario, you may be unable to manage IIS 6.0 by using Server Manager.
When this problem occurs, you must restart IIS 6.0, or you must restart the process that uses the IIS ADSI provider.
This problem is likely to occur for the SharePoint Timer service (OWSTimer.exe) in Microsoft Office SharePoint Server 2007. When this problem occurs for the SharePoint Timer service, you may experience the following symptoms:

•
In SharePoint Server 2007, tasks that are scheduled do not run.

•
On the SharePoint Web front-end server, you see repeated errors in the Application log in Event Viewer. These errors usually include one of the following three events:

•
Event ID 6398

•
Event ID 6482

•
Event ID 7076

For example, you may see an error message that resembles the following:

Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: (964)
Event ID: 6398
Date: 11/7/2007
Time: 5:45:38
PM User: N/A
Computer: 44MOSSAGRUK
Description:
The Execute method of job definition Microsoft.Office.Server.Administration.ApplicationServerAdministrationServiceJob
(ID 02b5e3f2-21e3-4552-bf1d-6e152749458a) threw an exception. More information is included below.
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

•
When you try to manage IIS 6.0 by using Server Manager, you receive a blank page, or you receive the following error message:

the path specified cannot be used at this time

[KB] 組態檔的 processModel 區段中提供了無效的使用者名稱和 (或) 密碼，所以無法啟動 aspnet_wp.exe 程式

2008-06-05T16:39:00.001+08:00

事件類型: 錯誤
事件來源: ASP.NET 1.1.4322.0
事件識別碼: 1084
描述:
無法啟動 aspnet_wp.exe。這項失敗的錯誤碼為 80004005。當背景工作處理序帳戶沒有足夠權限讀取 .NET Framework 檔案時就可能會發生這項錯誤。請確定 .NET Framework 安裝正確，而且安裝目錄上的 ACL 允許存取設定的帳戶。

事件類型:    錯誤
事件來源:    ASP.NET 1.1.4322.0
事件識別碼:    1007
描述:
由於在組態檔的 processModel 區段中提供了無效的使用者名稱和 (或) 密碼，所以無法啟動 aspnet_wp.exe 程式。

我的解決方式為：

開啟 %windir%\Microsoft.NET\Framework\v1.1.4322\CONFIG\machine.config
找到 <processModel> 確定 userName 是 machine，password 是 AutoGenerate (<==大小寫有分哦)
重新安裝 aspnet

移除ASPNET的帳號
執行 %windir%\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis -i
執行 %windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis -i (optional)
執行 iisreset

可能可以先用 ProcMon 找 aspnet_wp.exe 的 Access Denied 事件

[FIX]VSS 2005 與 PDF 不相容問題(2008-05-08 Updated)

2008-05-08T08:21:00.000+08:00

最近將企劃美編人員與開發人員共用維護的網站，利用 VSS 2005 來做一個版本控管，以前用 VSS 6.0(a/b/c/d)都沒什麼事，想當然爾就是 OK 的，

就直接 check-in 後就可以用了，過了幾天，發現事情不妙了， PDF 的檔案格式 check-out 後有問題，而且是一定要再 Get Latest Version 才會出包。

看來一下 byte 數，check-in 前與 Get Latest Version後竟然差了1~2 bytes，-_-

後來發現檔案不太一樣，用二位進比對後發現會有折行發生，很像以前 ftp 時，沒有指定 Binary or ASCII 的狀況。

上網找了一下問題，結果發現是微軟的 BUG.... @%$#$^%$#!@#$@!%$^&%&%~

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

底下是微軟 KB 的片段 http://support.microsoft.com/kb/923434/en-us/

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

FIX: The PDF file becomes corrupted after you check in the PDF file in Visual SourceSafe 2005

SYMPTOMS

After you check in a Portable Document Format (PDF) file in Microsoft Visual SourceSafe 2005, the PDF file becomes corrupted. Additionally, you do not receive any error messages. You may experience this problem if the following conditions are true:

•
You select the Auto-detect encoding of local file check box on the General tab.
Note To access the General tab, click Properties on the File menu.

•
In the Options dialog box, you select Binary file on the File types tab.
Note To open the Options dialog box, click Options on the Tools menu.

CAUSE

This problem occurs when the autodetect feature switches the file from the binary format to the ANSI format.

RESOLUTION

Download information

The following file is available for download from the Microsoft Download Center:
Download the 284443_ENU_i386_zip.exe package now. (https://connect.microsoft.com/VisualStudio/Downloads/DownloadDetails.aspx?DownloadID=7257)
Release Date: 6/20/2007

2008-05-08 更新：

發現微軟有一個 FIX package : List of bugs that are fixed in the Visual SourceSafe 2005 Update (2007/12/13 v2.1)

http://support.microsoft.com/kb/943847/

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

Bugs that are fixed in the Visual SourceSafe 2005 Update

For more information about the bugs that are fixed in this update, click the following article numbers to view the articles in the Microsoft Knowledge Base:

916688 (http://support.microsoft.com/kb/916688/) FIX: Error message when you try to use the Visual SourceSafe 2005 LAN booster service together with Visual Studio 2005 on a server that is running Windows 2000:"Unable to use SourceSafe LAN service"

917491 (http://support.microsoft.com/kb/917491/) FIX: The Analyze.exe utility may incorrectly remove files and projects in Visual SourceSafe 2005 when you run the utility by using the - d switch

923434 (http://support.microsoft.com/kb/923434/) FIX: The PDF file becomes corrupted after you check in the PDF file in Visual SourceSafe 2005

924702 (http://support.microsoft.com/kb/924702/) FIX: You cannot compare the latest version of a file to any earlier versions of that file after you change the file type to the UTF8 file type in Visual SourceSafe 2005

923842 (http://support.microsoft.com/kb/923842/) FIX: Error message in the Analyze.log file when you run the Analyze.exe utility in Visual SourceSafe 2005: "The file 0\DATA\\ is not a valid SourceSafe physical database file"

927004 (http://support.microsoft.com/kb/927004/) FIX: After you perform a merge operation on a file in Visual SourceSafe 2005, only three accounts can access the merged file

925234 (http://support.microsoft.com/kb/925234/) FIX: When you check out and then try to open a PDF file, the file may not open if the file was checked in by using Visual SourceSafe 2005

925275 (http://support.microsoft.com/kb/925275/) FIX: When you generate a report to show the history of a source file, Visual SourceSafe 2005 may stop unexpectedly

927887 (http://support.microsoft.com/kb/927887/) FIX: Error message when you use the Get Latest Version option in Visual SourceSafe 2005 to try to obtain the latest version of an XML file: "SourceSafe was unable to finish writing a file"

928392 (http://support.microsoft.com/kb/928392/) FIX: Error message when you try to check in a file that has a comment template and the comment template has more than three lines in Visual SourceSafe 6.0: "Error reading from file"

930573 (http://support.microsoft.com/kb/930573/) FIX: Visual SourceSafe 2005 may stop responding when you generate a report in the "Show History" dialog box

932058 (http://support.microsoft.com/kb/932058/) FIX: Error message when you try to set the value of the IVSSItem.AutoDetectEncoding property to "false" if the item is checked out in Visual SourceSafe 2005: "System.Runtime.InteropServices.COMException (0x8004D67F)"

934723 (http://support.microsoft.com/kb/934723/) FIX: You may receive an error message when you use Ole Automation to programmatically retrieve a specific version of a file from the history in Visual SourceSafe 2005

932874 (http://support.microsoft.com/kb/932874/) FIX: Visual SourceSafe 2005 may stop responding (hang) when you check in a large binary file

938607 (http://support.microsoft.com/kb/938607/) FIX: Error message when you try to add files to a Visual SourceSafe 2005 database or when you try to retrieve files from a Visual SourceSafe 2005 database by using Web access through HTTP: "Operation timed out"

How to obtain the Visual SourceSafe 2005 Update

The following file is available for download from the Microsoft Download Center:
Download the VS80-KB943847-X86-INTL.exe package now.

(http://download.microsoft.com/download/7/1/f/71fdb660-4e69-471a-ad58-d984b45cc140/vs80-kb943847-x86-intl.exe)
Release Date: December 11, 2007

[SSIS]Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

2008-05-07T15:35:00.001+08:00

Error loading BlahBlah.dtsx:

Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.".

You may not be authorized to access this information. This error occurs when there is a cryptographic error.

Verify that the correct key is available.

Possible options are (see MSDN):

DontSaveSensitive: Sensitive data is not saved at all (replaced with blanks). It has to be re-entered each time the package is opened. Every logged-on user can open/execute the package.
EncryptAllWithPassword: The whole package is encrypted using the password given in the "PackagePassword" property of the package. The package cannot be opened/executed without this password, but every logged-on user who knows it can open/execute the package.
EncryptAllWithUserKey: The whole package is encrypted using a key calculated from the creator's user profile. The package can only be opened and executed from the creator windows user.
EncryptSensitveWithPassword: Not whole package, but only sensitive data is encrypted using the password given in "PackagePassword" property. When opening/executing the package, you have to specify the password to decrypt the sensitive data (if not the package can be opened anyway, but sensitive data is not available).
EncryptSensitiveWithUserKey (default): Same as above, but instead of PackagePassword user profile is used as key. Other logged-on windows users can open the package in VS but sensitive data must be re-entered. The package can only be executed by the creator windows user.
ServerStorage: Protects the whole package using SQL Server database roles. This option is supported only when a package is saved to the SQL Server msdb database. It is not supported when a package is saved to the file system from Business Intelligence Development Studio.

Sensitive data are:

The password part of a connection string.
The task-generated XML nodes that are tagged as sensitive. The tagging of XML nodes is controlled by Integration Services and cannot be changed by users.
Any variable that is marked as sensitive. The marking of variables is controlled by Integration Services.

參考資料：

http://www.cubido.at/Blog/tabid/176/EntryID/155/Default.aspx ( thanks m.unterauer)

[VSS] 忘記 Admin 密碼怎麼辦?

2008-04-18T13:18:00.001+08:00

最近遇到 VSS 的管理者忘記密碼，VSS 要加新的人員及權限設定都要靠他，怎麼辦??

Hack VSS!!

網路上找到一個方式，真的可以在 VSS 2005 運作。

不過也很擔心的是…以檔案為基礎的 VSS ，如果沒有仔細設定好，

任何人只要能存取 VSS Database 就可以自己提昇權限或更改 Admin 密碼做壞事後再還原。

1.找到 <VSS DB>\data\um.dat ，並先備份(極重要)

2.使用 HEX Editor ( e.g. UltraEditor )開啟 um.dat

3.找到 41 64 6d 69 6e 字串，此為 "Admin" 的 16 進位碼，然後看著下方總共 80 bytes ，將自己的 um.dat 調整成一樣

55 55 bc 7f 41 64 6d 69 6e 00 00 00 00 00 00 00

00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

00 00 00 00 90 6e 00 00 a8 01 00 00 00 00 00 00

[好像回到以前打 Game 的時代，將三國志的諸葛亮武力調整 256 (ff) ]

4.存檔後，再用 Visual Source Safe Admin ，密碼是空白登入，大功告成!!

5.記得趕快更改 Admin 密碼哦。

關於 VSS 安全性有兩個地方要注意：

1.Tools->Options->General->Use Network Name for Automatic User Login In 選項要特別注意：

詳情請看黑暗大師的文章 http://blog.darkthread.net/blogs/darkthreadtw/archive/2007/12/04/wtf-vss-option.aspx

2. um.dat 由於 Users 需有修改權限，也不能讓一般 User 無修改權限，意即是…VSS 裡面沒有秘密可言。

參考文章：

Forgot SourceSafe Admin Password

Lost the Admin Password of Visual SourceSafe v6.0x

http://www.interdimension.org/en/it/vss_lost_admin_password.htm

VSS(Visual Source Safe)有安全性可言吗？

http://www.witsun.net/blog/article.asp?id=164

SourceSafe Password Recovery Made Easy

http://www.c6software.com/articles/sourcesafepassword.aspx

Google Map	http://maps.google.com/maps?q=<地址>
電話	call:
簡訊	sms:
郵件	mailto:

小熊子的技術世界

KB-解決 IIS6 上傳檔案大小200kb的限制

MSDTC 問題集錦

第一步：MSDTC 是否安裝及設定成功?

a.設定(含防火牆)

b.安全性設定

第二步：確認發生關係的主機，互相都認得?

第三步：拿MSDTC 除錯工具來驗證

SQL 2008 / Windows 2008 之 MSDTC 注意事項

Oracle

【茶包射手專欄】錯怪Oracle~~

Distributed Transaction With MS OLEDB Provider For Oracle

MSDTC 除錯工具

.NET分散式交易程式開發FAQ

SQL Reporting Service 虛擬化時複製機器的小技巧

STEP 1:

STEP 2:

延伸閱讀

Configuring a VMWare clone for SSRS disaster recovery

Tips-Oracle TNSName.ora Compare Tool

Excel 2007 的 Pivot Table 樞鈕分析表就差這個功能

Win7,Win2008 使用檔案總管開啟 Sharepoint 文件庫時異常緩慢

如何用ICS讓遠端可以連線主機內部(NAT)的虛擬機器

Tips-如何使用 Windows 驗證連接 SQL Server

容許主機/服務一年停機多久呢?

可用性百分比與一年停機時間

MSMQ 歷險記

MSMQ Overview

錯誤訊息：Access to Message Queuing system is denied

MSMQ 3.0 too secure for you?

錯誤訊息：The Message Queuing service is not available

如何遠端傳送 private Queue ?

MSMQ - Sending messages to remote private queues

MSMQ - Receiving messages from remote private queues

如何取得 Outgoing Queues

如何取得 Queue 裡的訊息數

其他

IIS Basic Authentication & Windows Authentication Slow Issue

Basic 認證慢，Windows 認證快 (本機帳號認證快)

Basic

iPhone 開發 Web 應用程式小技巧

1.特殊連結

2.iPhone 桌面上建立圖示

3.版面調整

4.強制不偵測電話號碼

5.隱藏網址列Hide address bar

相關連結

如何讓 IE/Firefox/Chrome 可以模擬 iPhone 網頁?

WCF 歷險記

KB-Report Viewer Control Localization

Microsoft Report Viewer 2008 SP1 Redistributable

Microsoft Report Viewer Redistributable 2008 SP1 语言包-簡體中文

Microsoft 可轉散發報表檢視器 2008 SP1 語言套件-繁體中文

Microsoft Report Viewer 2008 SP1 Redistributable - 繁體中文

ORA-02069: global_names parameter must be set to TRUE for this operation

Tips-Excel 別再用 F2 將數字換文字,也別用巨集(Macro),請改用資料剖析!!

Tips-如何大量設定共用資料夾權限 Part II

以下是 Windows NT 2000 的語法

以下是 Windows Server 2003/2008 , XP/Vista 的語法

[KB]ASP.NET Development Server Can not Load jQuery.js

KB-VSS Network Not Found Issue

Network Not Found

[KB][SPS2007]Microsoft.Office.Server.Internal.UI.SharedServicesAdminDefaultPage is not allow for this page

[FIX][IIS6] The path specified cannot be used at this time

SYMPTOMS

[KB] 組態檔的 processModel 區段中提供了無效的使用者名稱和 (或) 密碼，所以無法啟動 aspnet_wp.exe 程式

[FIX]VSS 2005 與 PDF 不相容問題(2008-05-08 Updated)

FIX: The PDF file becomes corrupted after you check in the PDF file in Visual SourceSafe 2005

SYMPTOMS

CAUSE

RESOLUTION

Download information

Bugs that are fixed in the Visual SourceSafe 2005 Update

How to obtain the Visual SourceSafe 2005 Update

[SSIS]Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

[VSS] 忘記 Admin 密碼怎麼辦?