Jiwa runs fine but reports don't open and error with [Databa

[renes]

If Jiwa is running fine but reports don't open and the error [Database Vendor Code: 17] is reported, then Crystal can't connect to the database. Crystal can't use shared memory and therefore won't be able to use the shared TCP/IP protocol. The TCP/IP protocol needs to be enabled in SQL Server Network Configuration.

Error - Vendor Code: 17

17635_Crystal_ConnectionError.jpg (42.31 KiB) Viewed 1981 times

Enabling the TCP/IP network protocol in MS SQL Server 2012

- Windows 7: Go to Start>Run
- Windows 8/8.1: Press the Windows key, type Run and hit Enter
- Type sqlservermanager11.msc and click OK
- Select SQL Server Network Configuration from the left hand pane
- Right click TCP/IP from the right hand pane and select Enable
- Restart MS SQL Service

Enabling the TCP/IP network protocol in MS SQL Server 2008

- Windows 7: Go to Start>All Programs>Microsoft SQL Server 2008 R2>Configuration Tools>SQL Server Configuration Manager
- Windows 8/8.1: Press the Windows key, type Run and hit Enter and type sqlservermanager11.msc and click OK
- Select SQL Server Network Configuration from the left hand pane
- Right click TCP/IP from the right hand pane and select Enable
- Restart MS SQL Service

Enable TCP/IP Protocol

17635_Crystal_Enable TCPIP.jpg (89.71 KiB) Viewed 1981 times