中間曾因客戶不想花錢升級sql2005，因為OLAP和DTS要打掉重做，客戶覺得為什麼要花錢重做，為什麼不能直接升級上去就好...BLA BLA BLA.....反正就一直撐著。
最近有個以他的OLAP2000當資料來源的系統先升級了，OS換成WINDOWS 2008R2+SQL2005 64bit，原本是WINDOWS2003R2+SQL 2005 32bit，升級後，在SQL 2005 64BIT上建立OLAP 的LINKED SERVER時，出現了以下的錯誤，
MSOLAP 目標電腦拒絕連線。
查到這篇KB，真是殘念啊，OLAP2000只能在SQL SERVER2005 32BIT上才能建立LINKED SERVER。
After you install a 64-bit instance of SQL Server 2005 Analysis
Services, only the 64-bit version of the Microsoft OLE DB Provider for
Analysis Services 9.0 provider is available. The 64-bit version of the
SQL Server service can use this provider to connect to 64-bit instances
of SQL Server 2005 Analysis Services and to 32-bit instances of SQL
Server 2005 Analysis Services. However, the 64-bit version of the SQL
Server service cannot use this provider to connect to SQL Server 2000
Analysis Services.
After you install a 32-bit instance of SQL Server 2005 Analysis Services, the 32-bit version of the Microsoft OLE DB Provider for Analysis Services 9.0 provider is available. If you are running the 32-bit version of the SQL Server service, the SQL Server service can use this provider to connect to SQL Server 2000 Analysis Services.
After you install a 32-bit instance of SQL Server 2005 Analysis Services, the 32-bit version of the Microsoft OLE DB Provider for Analysis Services 9.0 provider is available. If you are running the 32-bit version of the SQL Server service, the SQL Server service can use this provider to connect to SQL Server 2000 Analysis Services.
改裝了SQL2005 32BIT就可正常連線到OLAP2000了。
最近花了很多時間在搞這種舊系統，真是累!
沒有留言:
張貼留言