Troubleshooting problems with SQL Server 2008 R2 roles If you have problems with roles in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 role bugs were fixed in SQL Server service packs, you should install the latest SQL Server service...