Can't find rsactivate.exe

I've spent a few hours bashing my head into the wall - no matter what I install and uninstall, I can't seem to get setup to put the rsactivate.exe file into my sql server 2005 installation. Without this tool, I can't get sql reporting working. Can anyone tell me step by step what I need to do to get this tool installed?

Thanks!

rsactivate.exe does no longer exist and is no longer needed in RS 2005.

There is a new graphical configuration tool (Reporting Services Configuration Tool) and you can use rsconfig.exe / rskeymgmt.exe to configure the report server.

-- Robert

|||

Thanks - now that I know that I managed to get my server set up, but the ReportServer virtual directory still returns this error:

Reporting Services Error

---

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)|||

Most likely the account that is configured to run the RS Web service (typcially Network Service) does not have any file system permissions to access the installation directory and consequently cannot access the configuration file.

In general, setup would set the ACLs correctly on those folders. However, you mentioned that you ran through multiple install/uninstall cycles, so something with the ACLs may be messed up.

One approach you should try is to start the RS configuration tool, go the web service account and (re-)apply the account settings.

-- Robert

|||

Looks like it was a conflict with sharepoint services. I found a KB article on this, and now everything seems to be resolved. I also found that I needed to run rskeymgmt -d to clear our the previously created keys before I could proceed.

Thanks for the help!

|||

I have problems also with Reporting Server SQL 2005 reinstallation. I am using the configurer and have restarted the installation many times, deleting each time the bases and web sites.

When I start the navigator to reach http://localhost/report server, I receive the message that the access to the file intepub/wwwroot/web.config is refused

there no reason that this file be accedded for Report Server and I dont'know what to do to find a solution

Thanks to reply if you have any idea

Gerard

Can't find rsactivate.exe

I've spent a few hours bashing my head into the wall - no matter what I install and uninstall, I can't seem to get setup to put the rsactivate.exe file into my sql server 2005 installation. Without this tool, I can't get sql reporting working. Can anyone tell me step by step what I need to do to get this tool installed?

Thanks!

rsactivate.exe does no longer exist and is no longer needed in RS 2005.

There is a new graphical configuration tool (Reporting Services Configuration Tool) and you can use rsconfig.exe / rskeymgmt.exe to configure the report server.

-- Robert

|||

Thanks - now that I know that I managed to get my server set up, but the ReportServer virtual directory still returns this error:

Reporting Services Error

---

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)|||

Most likely the account that is configured to run the RS Web service (typcially Network Service) does not have any file system permissions to access the installation directory and consequently cannot access the configuration file.

In general, setup would set the ACLs correctly on those folders. However, you mentioned that you ran through multiple install/uninstall cycles, so something with the ACLs may be messed up.

One approach you should try is to start the RS configuration tool, go the web service account and (re-)apply the account settings.

-- Robert

|||

Looks like it was a conflict with sharepoint services. I found a KB article on this, and now everything seems to be resolved. I also found that I needed to run rskeymgmt -d to clear our the previously created keys before I could proceed.

Thanks for the help!

|||

I have problems also with Reporting Server SQL 2005 reinstallation. I am using the configurer and have restarted the installation many times, deleting each time the bases and web sites.

When I start the navigator to reach http://localhost/report server, I receive the message that the access to the file intepub/wwwroot/web.config is refused

there no reason that this file be accedded for Report Server and I dont'know what to do to find a solution

Thanks to reply if you have any idea

Gerard

Cant drop constraint...?

Hello, I have hit the wall here...can't make sense of this one.

I have a script that creates a PRIMARY KEY constraint called PK_tblDRG
CODE:

ALTER TABLE [dbo].[tblDRG]
ALTER COLUMN [record_id] Uniqueidentifier NOT NULL
Go
ALTER TABLE [dbo].[tblDRG]
WITH NOCHECK ADD PK_tblDRG PRIMARY KEY CLUSTERED
(
[record_id]
) WITH FILLFACTOR = 90 ON [PRIMARY]

All is fine with that. I run this to verify:

EXEC sp_pkeys @.table_name = 'tblDRG'
,@.table_owner = 'dbo' ,@.table_qualifier = 'Relational_05Q3'

which returns this:

TABLE_QUALIFIER TABLE_OWNER TABLE_NAME COLUMN_NAME KEY_SEQ PK_NAME
Relational_05Q3 dbo tblDRG record_id 1 PK_tblDRG

Now I want to drop the constriant if it exists:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PK__tblDRG]') and OBJECTPROPERTY(id, N'IsPrimaryKey') = 1)
ALTER TABLE [dbo].[tblDRG] DROP CONSTRAINT PK__tblDRG

AND I get this in return:

The command(s) completed successfully.

So, lets double check:

EXEC sp_pkeys @.table_name = 'tblDRG'
,@.table_owner = 'dbo' ,@.table_qualifier = 'Relational_05Q3'

AND I STILL GET THIS:

TABLE_QUALIFIER TABLE_OWNER TABLE_NAME COLUMN_NAME KEY_SEQ PK_NAME
Relational_05Q3 dbo tblDRG record_id 1 PK_tblDRG

Hmmmmm. Looks like the IF statement didn't do it's job. Ok fine. I'll just kill it myself:

ALTER TABLE [dbo].[tblDRG] DROP CONSTRAINT PK__tblDRG

AND I GET THIS?!?!?!?!

Server: Msg 3728, Level 16, State 1, Line 1
'PK__tblDRG' is not a constraint.

What am I not getting here? Is it me...I can take If I am a bone head here.

Any help would be appreciated. Thanks!Nevermind...I am a moron.
PK__tblDRG doesn't exists because it's PK_tblDRG!!!

Sorry!

Can't create new SSIS package in VS 05

Is there anyone out there that can help me - please! I'm about to put my head through a wall.

I used to be able to create SSIS packages in VS 05. It's been a while since I've done it, but when I went in the other day, it would let me - all I can do is get errors. It tells me an "error prevented the view from loading" when it opens in control flow (blank packages and ones I created before all this started) and I get this error :

"Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) (System.Windows.Forms)"

If I go over to the Data Flow tab and there are no errors until I click "Click here to add a new Data Flow task", then I get this :

"Object reference not set to an instance of an object. (Microsoft.DataTransformationServices.Design)"

So... here's what I've tried.

Uninstalled and reinstalled VS 05 and SP1 (this was before I realized the problem was with SQL).

Uninstalled and reinstalled Office 2003 Web Tools.

Made sure all the MSXMLs were registered.

Uninstalled and reinstalled all SQL Servers and Tools/Components.

Made sure all SQL Services were running under Local Account

Made sure Integrated Services service was running.

Applied all SQL patches.

I cannot get this to work and I need to be able to create packages. The only other step I can think of is wiping my computer and I don't want to have to do that.

Please please can anyone help me? I've been scouring the internet and working on this for 1 day and 1/2.

Miraculously - it's started working again. All I've done since then is go to the MS Update website and tried to add SQL 2005 SP2 again. It failed again, but this time when I opened my SSIS project, it opened ok.

I also just realized that I disabled the antivirus on my computer in an attempt to upgrade to SP2 again (although I haven't tried to upgrade the second time), but the antivirus is still off - When I reboot, I'll try to open it again - of it fails it must be the antivirus.

|||

Well, it wasn't the antivirus, because I've rebooted and it's still working - with the antivirus running. So if anyone else is running into this issue and is reading this thread for help - sorry - don't know what to tell you or how it fixed itself.

All I know is - you live by Microsoft, you die by Microsoft.