Hi I have created a dashboard using sharepoint 3.0. My CRM and SQL is on Server1 and my sharepoint server is running off Server2 and all users access CRM and Sharepoint off a terminal server session on Server3.
The problem I am having is when Server3 views the sharepoint site (using the same username and password as my administrator login on the CRM server) I cannot access the data from SQL, I tried re-creating a SQL connection in another web part, I enter the SQL server name use windows authentication like my SQL is setup to do, I then get the option to select my CRM instance and then I cannot see the data.
Has anybody expierenced this or have any idea on how I can resolve it.
Thanks