"Not associated with a trusted SQL Server connection"

Hello,
Having some trouble here with a CRM installation, and I think there is
something wrong with our SQL Server, since we got the exact same issue with
another application.
Anyhow, we got a SQL Server 2000 SP4. Right now we are running databases for
Microsoft Navision 4.0 and a .NET webshop, and it works fine. Installed a ne
w
server the otherday (Windows Server 2003 SP1) for Microosoft CRM, and want
the CRM-databases on our current SQL Server.
During installation we get the following error:
=====================
Microsoft CRM 3.0 Server Setup
--
Activating SQL Server Reporting Services failed.
Setup failed to validate specified Reporting Services Report Server
http://CRM1/ReportServer. Error: The report server cannot open a connection
to the report server database. A connection to the database is required for
all requests and processing.
=====================
I press "Ignore" just to finish the installation, and it continues. After
that, when trying to connect to http://crm1 to access the system (from the
CRM1 server), it just gives the following .NET-error:
=========================
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
=========================
Been Googleing and testing alot of stuff, but can't find the solution. I am
not that great on SQL Server, so we got a few other people to look at it, bu
t
it just doesn't work.
Anyone know what to do, I'm clueless...Problem solved.
On the SQL Server, in "local security policy" --> "access this computer from
the network" was only "domain/domain users" specified. I added CRM1 (the
server), and it started to work.
"joup" wrote:

> Hello,
> Having some trouble here with a CRM installation, and I think there is
> something wrong with our SQL Server, since we got the exact same issue wit
h
> another application.
> Anyhow, we got a SQL Server 2000 SP4. Right now we are running databases f
or
> Microsoft Navision 4.0 and a .NET webshop, and it works fine. Installed a
new
> server the otherday (Windows Server 2003 SP1) for Microosoft CRM, and want
> the CRM-databases on our current SQL Server.
> During installation we get the following error:
> =====================
> Microsoft CRM 3.0 Server Setup
> --
> Activating SQL Server Reporting Services failed.
> Setup failed to validate specified Reporting Services Report Server
> http://CRM1/ReportServer. Error: The report server cannot open a connectio
n
> to the report server database. A connection to the database is required fo
r
> all requests and processing.
> =====================
> I press "Ignore" just to finish the installation, and it continues. After
> that, when trying to connect to http://crm1 to access the system (from the
> CRM1 server), it just gives the following .NET-error:
> =========================
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> =========================
> Been Googleing and testing alot of stuff, but can't find the solution. I a
m
> not that great on SQL Server, so we got a few other people to look at it,
but
> it just doesn't work.
> Anyone know what to do, I'm clueless...