DataSource communication Failure

[FunkyBunch]

I have created a few reports within CR9 using SQL Server 2005 and after restoring the database to a more current version. I get this error for each table: The database table "Vehicles_fw" cannot be found. Proceed to remove this table from report?"

After clicking no through all of the warning i recieve another error: "Failed to Open A rowset. Details: 08S01:[Microsoft][ODBC SQL SERVER DRIVER] Communication Link Failure.

I have done a few selects inside of SQL and the tables are all there.

Thanks,

 

[synapsevampire]

Perhaps when you restored you did not issue the required GRANT privileges for the users?

-k

 

[FunkyBunch]

Thanks for the quick response Synapse, but it was just an error within Crystal Reports. I just logged off the server and logged back on and everything seems to work fine right now.