Connecting to a SQL Server 2014 Alwayson Database using Crystal XI.
Hello,
I've been playing around with the Always_on technology in SQL Server 2014 Enterprise. I've got a production database and I've created a secondary database using this technology to use as a "Real Time" reporting database. I've got the databases setup using Always_on and I am using Crystal Reports XI to try to connect to the "Synchronized" database but I am unable to connect. In fact when I try to create an ADO connection to the database I put in the "sa" user and password and the database doesn't even show up in the database dropdown. I've got the secondary database set to "Readable"
Any help would be greatly appreciated.
I've been playing around with the Always_on technology in SQL Server 2014 Enterprise. I've got a production database and I've created a secondary database using this technology to use as a "Real Time" reporting database. I've got the databases setup using Always_on and I am using Crystal Reports XI to try to connect to the "Synchronized" database but I am unable to connect. In fact when I try to create an ADO connection to the database I put in the "sa" user and password and the database doesn't even show up in the database dropdown. I've got the secondary database set to "Readable"
Any help would be greatly appreciated.
ASKER
mlmcc. Thanks for the reply. Are you sure you gave correct link?
I have been doing some more research and you may be able to use a connection but you have to set the connection intent to be read-only.
Most of the articles are for SSRS and not Crystal so it may not work.
mlmcc
Most of the articles are for SSRS and not Crystal so it may not work.
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your help. Still haven't gotten it to work with Crystal XI. If anyone figures it out let me know.
UncleT, do you still need help with this question?
ASKER
Vitor,
If you have any suggestions I would appreciate it. My main goal here is to get a "Real Time" reporting server that my crystal reports can connect to. I've researched Log Shipping, Mirroring and all that is good but when the mirror or log shipping takes place all the users are kicked off. The database is too big and in use too much to replicate. I thought "Always On" was my solution but from my understanding Crystal Reports when connecting to a database needs read write access and "Always On" is Read only. If you know of a way around this I would greatly appreciate it.
If you have any suggestions I would appreciate it. My main goal here is to get a "Real Time" reporting server that my crystal reports can connect to. I've researched Log Shipping, Mirroring and all that is good but when the mirror or log shipping takes place all the users are kicked off. The database is too big and in use too much to replicate. I thought "Always On" was my solution but from my understanding Crystal Reports when connecting to a database needs read write access and "Always On" is Read only. If you know of a way around this I would greatly appreciate it.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Was able to get this to work by upgrading my SQL Native Client to version 11 which allowed me to use the "ApplicationIntent" = "ReadOnly" option in an ODBC.
Interesting. So, Crystal Report didn't use the SNAC from SQL Server 2014 but an old version.
Lucky that you've found a solution but I still recommend you to upgrade the CR version when possible. CR XI is from 2004/05. That's too old for IT :)
Lucky that you've found a solution but I still recommend you to upgrade the CR version when possible. CR XI is from 2004/05. That's too old for IT :)
Don Williams believes you need write permission for Crystal to connect to a data source.
https://archive.sap.com/discussions/thread/386128
mlmcc