We currently have a report which is crashing with the following error message:
A server error occurred while solving the document’s query prompts: Database error: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation… Contact your administrator or database supplier for more information. (Error: WIS 10901) (Error: INF -2147220777)
We are running the report through in Webintellegence. The strange thing is. When I login and run the report it works correctly. All other users who login to run the report get the above message.
check the kind of credentials you are using at connection level.
For example, it might be you are using BOUSER as login user. In this case SQL Server would throw your user back.
In order to stay away from those kind of issues, make sure you are entering SQL Srv with the usual “sa” user and run your tests. Moreover, set up the bo_trace.ini together with the flag on cs.cfg file set to yes, so to track any SQL activity related details.
(BOB member since 2009-06-11)
(BOB member since 2002-08-29)