December 18, 2008 at 7:59 am
Hi,
We have a number of SQL servers with databases that are accessed by mainly Cognos applications(Cognos BI, Data manager , EP)
On an intermittent basis we get error messages being generated i.e
UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server][DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. (SQLSTATE=08S01, SQLERRORCODE=11)
UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Connection failure (SQLSTATE=08S01, SQLERRORCODE=0)
or
UDA-SQL-0031 Unable to access the xyz Database
UDA-SQL-0532 Datasource not accesible. "xyz" database
uda-sql-0564 [microsoft ole db provider for sql server]timeout expired sqlstate=HYT00, sqlerrorcode=0
Now we have checked the utilisation on cpu / mem / disk / network and all seems to be ok...on all servers accessing any databases on this machine and the database server itself..
Ran a SQL profiler and around the times of the failure no significant activity was happening...
So any ideas where to start?
Regards
Ray
December 19, 2008 at 9:50 am
Hopefully this is the Fix
December 20, 2008 at 5:30 pm
In my case this worked:http://support.microsoft.com/kb/942861
Risk is involved here as registry needs to be touched upon.
MJ
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply