Failing to Generate Reports

[ullmanio]

Hi all,

Anybody seen this error message before when trying to run a report:

COM error in repGenerate(): Crystal Reports ActiveX Designer-Failed to open a rowset. Details: ADO Error Code: 0x80004005 Source: Microsoft OLE DB Provider for SQL Server Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. SQL State: 08001 Native Error: 17

[Yanto.Chiang]

Hi Ullmanio,

What is your existing configuration used for ADNM?

Is it connected to your existing MS SQL Database?

cheers,

[ullmanio]

Yup it is currently connected to our MS SQL 2005 server which is working fine.  All the connections work and the testDB in the AMS maintenance connects successfully it just seems that the reporting element of the system connect connect....

[Yanto.Chiang]

Hi Ullmanio,

According to your information :

COM error in repGenerate(): Crystal Reports ActiveX Designer-Failed to open a rowset. Details: ADO Error Code: 0x80004005 Source: Microsoft OLE DB Provider for SQL Server Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. SQL State: 08001 Native Error: 17

It was looked that your access denied when ADNM tried to access your SQL Server. By the way i am not expert in Database but as for your reference information this link would be help you :

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25809

http://blogs.msdn.com/b/sql_protocols/archive/2005/12/19/505372.aspx

cheers,

[ullmanio]

Thanks for the links but I can't see them relating to my problem.

[ullmanio]

hi,

it turned out that the console didnt like connecting to the FQDM of the SQL server.  Just put the DNS name in and it worked fine.

[slate38]

I have the exact same problem, Test from AMS all work fine its just the reporting side. did try DNS name instead of the IP, but still no luck.

error logs state the same

COM error in repGenerate(): Crystal Reports ActiveX Designer-Failed to open a rowset. Details: ADO Error Code: 0x80004005 Source: Microsoft OLE DB Provider for SQL Server Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. SQL State: 08001 Native Error: 17