MS CRM 3.0: Unable to add products to opportunities.
Posted on 2007-07-30
We are about to roll out MS CRM 3.0 to around 25 users but I've hit a snag. No users are able to add opportunity products to an existing opportunity. When trying to save a selected product we recieve the following error message:
Record Is Unavailable
The record that you are requesting is currently unavailable. Either the record was not found or you do not have sufficient security permissions to view it.
It doesn't matter who owns the opportunity or who the user is (even Admin) and the security permissions look good. We have a test system set up on a Virtual Machine with an identical user/permissions setup and it works fine there. I'm guessing this may be a database issue.
We have a Microsoft CRM 3.0 Server running on MS Server 2003 R2 with Update Rollup 2 installed. The SQL Database is sitting on a seperate MS SQL 2000 server.
Can anyone help?