"The feature(s) specified are not valid for this edition of SQL Server" error when ins

I've successfully installed SQL Server 2005 Standard Edition on an Enterprise edition of Windows Server 2003 x64. I'm now (and also tried & failed during the install of the database engine) attempting to install the "Management Tools" component on the same server. However, in all my attempts to do so, I receive the following error:

The feature(s) specified are not valid for this edition of SQL Server

The message box does not list the features that are not valid but since the only item I've selected to install is the "Management Tools" option under "Client Components" it obviously points to something with that.

Am I missing something or are the Management Tools not supported in my config - most notably SQL Server 2005 Standard edition running on Windows Server 2003 x64?

Thanks.

- Lance

Colorado State University

I was finally able to install the "Management Tools" with a pretty simple solution: Install using the installer files directly off of the physical DVD. My prior attempts had all been using a copy of the files on the DVD stored locally on the server. Incidently, I had used the same copied files to successfully install the DB engine and SSIS. Go figure.

"Report is being generated" but never does...

I have created a report and deployed it successfully to a seperate machine with SSRS on. Both my dev machine and the SSRS machine are in the same workgroup. I can then Browse to the Report Manager though IE and click & run the report (The connection is using integrated security). The report requires a single parameter to be entered which once done works successfully. The report has a single table, an inbedded image and a few static fields in the report header.

If I however add a report viewer control to an aspx test form all is not well. As soon as the page opens I am prompted to enter the parameter which is good news as it shows there has been some communication with the SSRS metabase. I then click the view report button. Using Profiler I have proved that the report Stored Proc. is running with the correct parameter value. The report viewer however seems to hang and only displays "Report is being generated" without displaying the results. It does this even with a timeout set of 1000ms.

I don't think this is a security issue as both the Report Manager works and the test form prompts me for the parameter and effectively runs the report SP. I can only assume it is a problem with returning the report to the browser.

Does anyone have any insight?

Regards

Anthony Kay

Hmmh, 1000ms ist just a second, thats not much. Try to have a look in the log information, it should present jyou more details about opening the report, querying the data, rendering the report. There you might see where the execution stops.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Seem to have the same problem.

Anthony, did you find a solution for this already?

thanks in advance

Wouter van Dis

|||I found later that it was specific to my development machine as my colleagues still worked. I have found no explaination for this as yet.

"Report is being generated" but never does...

I have created a report and deployed it successfully to a seperate machine with SSRS on. Both my dev machine and the SSRS machine are in the same workgroup. I can then Browse to the Report Manager though IE and click & run the report (The connection is using integrated security). The report requires a single parameter to be entered which once done works successfully. The report has a single table, an inbedded image and a few static fields in the report header.

If I however add a report viewer control to an aspx test form all is not well. As soon as the page opens I am prompted to enter the parameter which is good news as it shows there has been some communication with the SSRS metabase. I then click the view report button. Using Profiler I have proved that the report Stored Proc. is running with the correct parameter value. The report viewer however seems to hang and only displays "Report is being generated" without displaying the results. It does this even with a timeout set of 1000ms.

I don't think this is a security issue as both the Report Manager works and the test form prompts me for the parameter and effectively runs the report SP. I can only assume it is a problem with returning the report to the browser.

Does anyone have any insight?

Regards

Anthony Kay

Hmmh, 1000ms ist just a second, thats not much. Try to have a look in the log information, it should present jyou more details about opening the report, querying the data, rendering the report. There you might see where the execution stops.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Seem to have the same problem.

Anthony, did you find a solution for this already?

thanks in advance

Wouter van Dis

|||I found later that it was specific to my development machine as my colleagues still worked. I have found no explaination for this as yet.

"No Mapping between Account Names and Security Ids was done".

I am trying to process a dimension. After four attributes are processed successfully, it gives an error saying "No Mapping between Account Names and Security Ids was done".

What could be the possible reason?I found it myself. The Data source shall be registered with Windows Authentication.