I am using Crystal Reports XI R2 and querying a MS-SQL database (64-bit Windows 2003, SQL Server 2005). Recently the SQL db servername was changed. I updated the ODBC Datasource to use the new name and was then able to connect again.
Existing reports did not work - even though the datasource name was the same. So, to fix those reports, I opened them, logged off the server (from within Crystal), then set the datasource location and connected to a new ODBC connection. This worked fine.
However, recently, now and again, NEW reports that have been made with the updated datasource after the server name change have come up with an error after saving them and then reopening them.
"Database Connector Error: '42000:[Microsoft][ODBC SQL Server Driver][SQL Server]The SELECT permission was denied on the object 'tablename', database 'db name', schema 'dbo'. [Database Vendor Code: 229 ]"
This is the same error that came up on reports that I had created prior to the server name being changed.
Whilst I can fix it as described above, it is very annoying, and suggests to me that something is not right.
Any ideas why this would be happening?
Existing reports did not work - even though the datasource name was the same. So, to fix those reports, I opened them, logged off the server (from within Crystal), then set the datasource location and connected to a new ODBC connection. This worked fine.
However, recently, now and again, NEW reports that have been made with the updated datasource after the server name change have come up with an error after saving them and then reopening them.
"Database Connector Error: '42000:[Microsoft][ODBC SQL Server Driver][SQL Server]The SELECT permission was denied on the object 'tablename', database 'db name', schema 'dbo'. [Database Vendor Code: 229 ]"
This is the same error that came up on reports that I had created prior to the server name being changed.
Whilst I can fix it as described above, it is very annoying, and suggests to me that something is not right.
Any ideas why this would be happening?