Installing SQL Server Reporting Services on SBS 2003 Premium for Dynamics CRM 3.0

We are currently in the process of performing a trial installation of Microsoft Dynamics CRM for a client. In amongst their existing IT infrastructure they have:
SBS 2003 SP1 PremiumServer 2003 StandardWhilst an organisation of their size would usually choose to deploy MS CRM Small Business, they've decided they don't want to install SBS on the same system as their SBS box and instead place it on their server 2003 and therefore we're attempting to install CRM Premium.

One of the requirements of Dynamics CRM 3.0 is SQL Server Reporting services (SRS).

SRS will not install on their server 2003 box, as unbeknownst to us initially, besides running Blackberry server, the machine also appears to be running a full blown instance of Terminal Services which SRS refuses to install alongside.. I even tried change user /install ... change user /execute and this failed.

Then I resolved instead to run SRS on the same machine as their SQLServer - the SBS box.

It didn't find visual studio - fair enough.. We don't want to customise any forms just yet.

It then complained about not being able to find ASP.net 1.1 and that sharepoint services were installed.. I read the notes on sharepoint/SRS co-installs and was satisfied there I knew what needed to be done..

I then attempted to install .net framework 1.1, but was advised it was already present. I then checked IIS manager and indeed ASP.net 1.1 was registered and enabled, whilst 2.0 ASP.net was also installed, but prohibited.

I reran the SRS install - and it still couldn't find ASP.net 1.1 and therefore has not installed the web components that MS Dynamics CRM 3.0 requires..

Could someone at least give me a pointer in the right direction here to getting it (SRS) installed happily?

AnthonyI may have found your answer. I believe it's here: http://icu-mscrm.blogspot.com/2007/08/fix-for-weird-error-when-installing-sql.html

Installing Sql Server 2005 Trial Software From Microsoft Website - Self Extracting Executable

Hello,

I'm trying to install sql server 2005 Trial software from the self-installing executable (X86 Executable) as I wait for my copy of the full version of SQL Server 2005.
Steps:
Click the X86 Executable link
When prompted, click Run SqlEval.exe.
After that is finished I (Excuse me if I don't have to exact terminology down) I clicked O.K. and the software evaluated the .exe and then prompted me to click the finish button. As soon as I clicked finish an error saying the file was corrupted halted everything.

Any suggestions?

Thanks,

Matt

The most likely answer is just what's reported: the file was corrupted, presumably during the download process. Download again, and I bet it will work.

Paul

Installing Sql Server 2005 Trial Software From Microsoft Website - Self Extracting Executable

Hello,

I'm trying to install sql server 2005 Trial software from the self-installing executable (X86 Executable) as I wait for my copy of the full version of SQL Server 2005.
Steps:
Click the X86 Executable link
When prompted, click Run SqlEval.exe.
After that is finished I (Excuse me if I don't have to exact terminology down) I clicked O.K. and the software evaluated the .exe and then prompted me to click the finish button. As soon as I clicked finish an error saying the file was corrupted halted everything.

Any suggestions?

Thanks,

Matt

The most likely answer is just what's reported: the file was corrupted, presumably during the download process. Download again, and I bet it will work.

Paul

Installing SQL Server 2005 Express

Hi, I have installed the Visual Web Developer 2005 trial IDE. The installation also came with SQL Server 2005 Express. I have used other versions of SQL Server in the past and have been able to navigate the databases, use Query Analyzer etc.

In the current (SQL Server 2005 Express edition) installation all I have is a program group named "MS SQL Server 2005">"Configuration Tools">"SQL Server Configuration Manager", "SQL Server Error and Usage Reporting" and "SQL Server Surface Area Configuration".

My question is 'Have I not completed the installation?". How do I create databases?

Thanks in advance for your help!

*shiku

SQL Server 2005 Express does not come with Query Analyzer and Enterprise Manager.It's like MSDE. You can create a database from within Visual Studio (see View menu, Server Explorer) or try this download from Microsoft http://www.microsoft.com/downloads/details.aspx?FamilyID=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en (though it's not the final version, it worked fine for me)