I have a problem with environment of two Windows Server 2008
Enterprise x64 systems:
SQL Server 2008
Microsoft Dynamics CRM 4.0
1. CRM works fine.
2. I can connect to SQL server from CRM using SQL Server Management
Studio as "sa" and as domain user. I can see databases > tables, but
when I try to open table I get unhandled exception.
3. On CRM I have some web sites which collects data directly from MS
CRM database using integrated security (from filtered views). Web site
is in the same Application pool as MS CRM. When I am logged in to the
CRM as domain administrator and open this site (web site is in "local
intranet" with automatic logon with current username and password
enabled) the sites connects to DB and collects data with no problems.
4. But when I am logged in to CRM as user other than DOMAIN
\administrator but also with domain administrator rights (also CRM
user with System Administrator role) the site tries to connect to SQL
as NT AUTHORITY\ANONYMOUS LOGON.
5. When I log in as DOMAIN\administrator to AD and open the same site
(web site is in "local intranet" with automatic logon with current
username and password enabled) the site tries to connect to SQL as NT
I remind that the site use Integrated security in connection string
and works OK the this user logged in to CRM.
AD was domain controller (domain: domain1) and CRM was connected to
AD was reinstalled and set as domain controlled (domain: domain2) and
CRM was connected to new domain.
Right now we have totally no idea what can be a problem :/