Server: Windows 2008 R2
Pervasive Server 10.30
Client: Windows 2008 R2 Terminal Server
Visual Studio 2005
Crystal Report 10
Network user is a domain admin
I have a Crystal report that uses ODBC to connect to Pervasive. When the report is opend from a VB.Net 2005 program, it prompt for a "Database Login". The prompt has four text boxes, (1) "Server Name" box is populated with Pervasive Client DSN and grayed out; (2) "Database" box is blank and greyed out; (3) Login ID box; (4) Password box, and "Use Integrated Security" check box. No matter what I enter for Login ID and password, login always fails and Crystal report viewer will quit.
If I open the report in Crystal Report designer, it will prompt for login. If I just click OK without providing any Login ID and passowrd, it can connect to Pervasive and get data OK.
This problem did not exist when our Pervasive server is on Windows 2003.
Has anyone seen this problem before? Thanks