Connecting Crystal Reports to VPS
I am trying to connect Crystal Reports XI release 2 to my VPS. I am trying to connect with the following step :
In Database expert menu i am selecting OLE DB (ADO) and then selecting Microsoft OLE DB Provider for SQL Server. Then it asks me Server, UserID, Password, Database. I am filling the fileds but when i try to select database it shows nothing. When i leave the database field empty and click on next then it give me the following message:
“Failed to open the connection.
Details: ADO Error Code:0x
Source: Microsoft OLE DB Provider for SQL Server
Description : [DBNETLIB][ConnectionOpen (Connect().]SQL Server does not exist or access denied.
Native Error: [Database Vendor Code:17]”
Could you please advise.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×