Problem in Installing 64-bit Reporting Services

Hi,

Trying to install 64-bit SQL Server 2005 RTM on Windows 2003 x64 Server with SP 1. The Reporting services option is not enabled in the installation steps. The installation process gets completed, but the Reporting Services is not installed.

The server does have IIS installed, the .NET framework 2.0 is installed by SQL Server 2005 RTM itself. Am I doing anything wrong.

Can anyone help/suggest ?

Thanks in advance.

Setup should show error message in case of error.

Also, you can check setup log files in %ProgramFiles%\Microsoft SQL Server\90\Setup BootStrap\LOG\Files

|||

Unfortunately, the setup doesnt show any error. The Reporting Services option is not "enabled" during the installation steps.

Can anyone suggest any other forum, where installation issues are discussed.

Thanks in advance.

|||

Rajeeb,

We have tested RS successfully on many x64 machines, so it is definitely possible! If RS is not selectable during setup, it is because some prereq is not met. Please look carefully at the System Configuration Check screen for anything that is not "green". It is possible for IIS to be installed, but not in a configuration that allows RS to be installed.

|||Please verify that IIS is installed before installing SQL Reporting Services. IIS is a required for Reporting Services.

Problem Creating Full-Text Catalog on Pubs

I have just installed SQL Server 2005 Developer Edition and attached the Pubs database that is enabled for full-text searching and I have run full-text searches on it using Sql Server 2005 Express. When i tried to search, I was informed that the catalog was not in a stable condition. I ran this script

Drop FullText Catalog PubsCatalog

I got this message:

Warning: The fulltext catalog 'PubsCatalog' is being dropped and is currently set as default.

When I try to create a new PubsCatalog, I get:

Msg 7689, Level 16, State 1, Line 1
Execution of a full-text operation failed. 'The dependency service does not exist or has been marked for deletion.'

I have tried other catalog names but the same result.

This was easy to do with the same db in Sql Server 2005 Express. What is wrong and how do I fix it?

The problem seems to be related to Vista. Sql Server 2005 SP2 fixed it.

problem creating a sqldatasource connection

I am able to connect but when I try to use the advanced sql generation options the two check boxes are non enabled (generate insert, update, and delete statements

use optimistic concurrency

what is happening the user id has permissions to update/delete/select from the selected table

Are you using a SQL statement that has a JOIN in it? The sql generator does not work with joined tables.