"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 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 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 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, but
> it just doesn't work.
>