i Get rsReportServerNotActivated error message although it is activated.

Hi
I get this error when I want to view a report in a browser:
Reporting Services Error
----
--
The report server installation is not initialized. Check the documentation
for more information. (rsReportServerNotActivated) Get Online Help
----
--
Microsoft Reporting Services
But when I run rsactivate I get the following message:
Failure initializing remote NT Service:
The service is already activated
Any suggestions?
My OS is WinXP Pro if it is of any use.Problem solved - uninstall an re-install did the trick.
"Howzit" <hrbotha@.absa.co.za> wrote in message
news:OW2Sn8PZEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> I get this error when I want to view a report in a browser:
> Reporting Services Error
> ----
--
> --
> The report server installation is not initialized. Check the documentation
> for more information. (rsReportServerNotActivated) Get Online Help
> ----
--
> --
> Microsoft Reporting Services
> But when I run rsactivate I get the following message:
> Failure initializing remote NT Service:
> The service is already activated
> Any suggestions?
> My OS is WinXP Pro if it is of any use.
>

I don't see Database Maintenance Planner in my SQL Server Enterorise Manager

Strange..... Anyways, is it possible to add the tool for Database Maintenance Planner to the existing DB installation?

If so, how do I do that? Would someone please help me on this?

Thanks a lot in advance.

Chris.

Hi Chris. If you don't see it, that could mean you aren't logged in as a sysadmin, they are the only logins that are allowed to view/modify maintanence plans.

It should be visible under the Management node in Enterprise manager, then a node called 'Database Maintanence Plans'. You should never see it under a specific database if that's where you are looking, not sure from your post if that may be where you were headed...

As for adding it to an existing installation, that's not really something that ever would need to be done...it's part of all installations, so it should already exist if the installation was successfull to any degree.

HTH,

|||

Having read your kind explanation above, it really make sense!

With confidence backed by your explanation, I will look into the SQL installation (which I did not install myself) and login users on Monday.

Once again, thank you so so so much, Chad. I wish I could buy you a drink!

Chris,

|||No problem Chris, glad to help. Repost if you still continue to have issues finding it...I'd take that drink if I could too!sql

I dont find any sql server database

Hi,

I installed already vs 2005. The installation installed automaticaly SQL Server 2005 express. Now , I want to see which databases I have there and tables,views,store procedure etc. I tried the server explorer in the vs but I don't see any database on my pc. I tried also to open somthing like enterprise manager like I have in sql server 2000 but I don't found such a tool. I tried to find it in START=>Programs=>SQL Server 2005 but their I see only the Configuration tool. I want to know if the installation of the vs 2005 does not install Databases for the sql server Express ? Should I have to download this database samples? What about a tool to view those database like the enterprise manager in sql server 2000 ?

Thanks,

David

Go to SQL server Express web page and download SQL Management studio express

http://msdn2.microsoft.com/en-us/sql/aa336346.aspx

or

http://msdn.microsoft.com/vstudio/express/sql/download/

It should help. To test you can just create new project in VS and try to create SQL server datasource in it.

Thanks

JPazgier

|||

Hi,

You can install the express edition for Management Studio and you can also configure the SQL Server instance from your Server Explorer. But first, you have to check whether the SQL Server instance has been started.

Here are the steps:

1. Start->Run
2. Enter "services.msc" to start the services window.
3. Find the service named SQL Server. The default name for a SQL Express instance is SQLEXPRESS.
4. If it is not started, start it.

HTH.

|||

Hi JPazgier,

Thanks. It works. I installed the managment sudio but it was with no deafault database so I downloaded also the AdventureWorksDB.msi and installad it. After it, I write this code in the managment studio :

execsp_attach_db @.dbname=N'AdventureWorks', @.filename1=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf', @.filename2=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf'

Now it works.

David

|||

You can aslo do it directly in management studio by right click on Databases and select comand from menu attach database (or something like this).

By the way you always have at least 4 system databases on the server and system use one of them as default if no default database is specified for user.

Good work

JPazgier

I can't connect to http://localhost/Reports - rsinternal error

After a new installation I can't connect to http://localhost/Reports - rsinternal error

The logfiles give me the following: (haven't been able to find an answer to this issue)

<Header>

<Product>Microsoft SQL Server Reporting Services Version 8.00.1038.00</Product>

<Locale>en-US</Locale>

<TimeZone>W. Europe Daylight Time</TimeZone>

<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServer__07_28_2006_11_27_56.log</Path>

<SystemName>BUIS8907-6</SystemName>

<OSName>Microsoft Windows NT 5.1.2600.0</OSName>

<OSVersion>5.1.2600.0</OSVersion>

</Header>

aspnet_wp!webserver!b0c!7/28/2006-11:27:57:: i INFO: Reporting Web Server started

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.

aspnet_wp!resourceutilities!b0c!7/28/2006-11:27:57:: i INFO: Running on 1 physical processors, 1 logical processors

aspnet_wp!resourceutilities!b0c!7/28/2006-11:27:57:: i INFO: Reporting Services starting SKU: Evaluation

aspnet_wp!resourceutilities!b0c!7/28/2006-11:27:57:: i INFO: Eval SKU: 120 days left

aspnet_wp!runningjobs!b0c!7/28/2006-11:27:57:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds

aspnet_wp!runningjobs!b0c!7/28/2006-11:27:57:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds

aspnet_wp!runningjobs!b0c!7/28/2006-11:27:57:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds

aspnet_wp!runningjobs!b0c!7/28/2006-11:27:57:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds

aspnet_wp!library!b0c!07/28/2006-11:28:09:: i INFO: Call to GetPermissions:/

aspnet_wp!crypto!b0c!07/28/2006-11:28:15:: i INFO: Initializing crypto as user: BUIS8907-6\ASPNET

aspnet_wp!crypto!b0c!07/28/2006-11:28:15:: i INFO: Exporting public key

aspnet_wp!library!b0c!07/28/2006-11:28:15:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;

Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.IO.FileNotFoundException: The system cannot find the file specified.

at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)

at RSManagedCrypto.RSCrypto.ExportPublicKey()

at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()

at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()

at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()

at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()

at Microsoft.ReportingServices.Library.Storage.get_Connection()

at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)

at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)

at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)

at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String name)

at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)

at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()

at Microsoft.ReportingServices.Library.RSService.PathToInternal(String source)

at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path, Boolean validate, Boolean convert, Boolean translate)

at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path)

at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)

at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)

End of inner exception stack trace

I have already tried the rsconfig -c, this was succesfully but did not resolved the issue.

hey,

I am not a expert but i had similar kind of problem initially.

http://localhost/Reportserver is a default name. Instead of localhost try putting ur database name .

like http://Database/reportserver.

ashish

|||

Thanks Ashish for your reply, but unfortunately that didn't work.

Even when I browser the virtual directory in the IIS is gives me the rsinternal error.

I found somewhere else someone who re-installed and it resolved it for them. That was the first thing I did still have the issue.

I think there must be a setting or parameter incorrect somewhere. After the installation was finished I received a message telling me that the service could not be started and I would have to manually start it. I check the service and it was running. I even restarted it. the eventviewer tells me it started successfully so.....?

Thanks again, hoping for more suggestions

sql

I am sorry

A lot of time the norton antivirus block an atemp to hack on my computer from an ip called himself nemo

the problem is that after the installation of MSSEE with advanced service I found that the mssee want to connect to a server called nemo and that the admin name is nemo

so whatthat suppose to mean?

ahere is a part of the log file:

Opening 'MachineConfigScope' for [NEMO]
Trying to find Product Code from command line or passed transform
If possible, determine install id and type
Trying to find Instance Name from command line.
No Instance Name provided on the command line
If possible, determine action
Machine = NEMO, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = NEMO, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = NEMO, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)

Moving to SQL Security forum.|||

I am so sorry I discovered that the system name of my computer is nemo

so the mssee is secure

I am aufully sorry

youssef