I'm facing issues with linking an ADP to SQL Server 2008. I was able to link ADP to SQL server 2005. Everything worked fine, but since my company is moving to SQL server 2008 i have to create a new ADp pointing to SQL server 2008, i can't connect the ADP to SQL server 2008. It gives me this error. Can you please help me with this. Also is ADP compatible with SQL Server 2008? Is there any work around available for this?
Any info on this will be appreciated.