Running windows 2003 SP1 with SQL Server 2000 SP4. Upgraded Crystal Reports 11 to both servers, once completed, started to get OLE DB SQL SERVER errors on 1 of the Nodes. I have checked registry settings for permissions which may have been changed during CR upgrade. Re-install SP4 for SQL Server 2000. Still have the same problem....Possible next step is the re-install of SQL Server 2000 Any thoughts ??????
Is Cristal Reports installed on cluster sql servers? Can you provide complete error info... When are you getting OLEDB errors? Check your MS DTC security configuration and make network access is enabled... MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
http://aspalliance.com/532?ref=devzone_netzone_thirdparty_aspalliance http://support.microsoft.com/kb/306518 fyi too. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
MohammedU, Thanks for the reply. Yes Crystal reports is installed on both nodes of the cluster. I find the following error in the event viewer. Error Source = Microsoft OLE DB Provider for SQL Server Error Description = [DBNETLIB] Microsoft OLE DB Provider for SQL Server (80004005): [DBNETLIB]
Seen the above links, specifically KBA> Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
