'Unable to connect to the database' SQL server does not exist or access is denied' error message when you try to open MessageStats reports from remote client machines.
Verify that the following criteria is met:
* The UDL file is used to provide SQL database connections parameters.
* Integrated Windows authentication is set on MessageStats web directory.
* The Web Reports can successfully be opened only from local machine.
* If the authentication is changed to 'Basic authentication' then it works both from local and remote machines.
The issue is due to SQL server security. There might be access restrictions to the named pipe on SQL server side.
To fix this issue configure the connection string to use TCP/IP rather than the named pipe. Open the UDL file | Select All tab | Select Network Library | Edit | and add the following parameter DBMSSOCN
Save this UDL file and launch open Web Reports.
N/A
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center