December 23, 2010 at 5:06 pm
The user i am using is me and I have permission to the database in question, but I cannot access this through cognos catalogue I am getting the following error.
Error number -258:
DMS-E-GENERAL, A general exception has occurred during operation 'attach direct'.
DMS-E-RDS_OLEDB, The OLE DB provider has returned the following error:
HRESULT: E_FAIL
Microsoft OLE DB Provider for SQL Server
Cannot open database "SQLAudit_Front" requested by the login. The login failed.
SQLSTATE = 42000, ERROR = 4060
any ideas because cognos people are blaming sql, anything I should be checking.
I can connect via sql 2008 studio manager using my logon sql but cannot via cognos.
I would be grateful for a some pointers here.
January 4, 2011 at 12:57 pm
Does the Cognos catalog is using your Login Id?. The error message clearly says that the Login doesn't have access to the Database.
July 17, 2012 at 11:23 am
Hello, I am having the same issue. Was this resolved...if so, how?
Any help is appreciated - thank you!
July 19, 2012 at 3:07 am
I suggest you run a trace and verify the user name being used, and also verify that you are logging into the database you expect.
Then you can be 100% certain that you are logging into the correct database with the correct user, and that pretty much narrows it down to a password issue.
Do you know what user the catalog is using to connect?
July 19, 2012 at 8:47 am
Thanks Nick!
I created a workaround by removing some of the parallel JobStreams to be executed serially and it worked. There is obviously something going on between the DecisionStream server and the SQL Server 2008 server/Database.
At this point, I believe that in order to find the root cause we would need to get server and network people involved as it over my head.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply