Reporting Services Configuration NO Initialization
Mar 29, 2007
I am installing sql server 2005 reporting services on server running sql server 2005. I get to the reporting services configuration page and configure...
report server virtual directory
report manager virtual directory
windows service identity
web service identity
database setup
encryption keys
when I get to Initialization the button is grey and inactive so I can't initialize reporting
services, Do I need to restart server?
Hi I am trying to configure reporting services. When I try to connect the portal through browser, it gives following error
"The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError)"..
Any idea, why this error? Also, in reporting services configuration manager, the initialization tab is greyed. I need this to get solved as soon as possible. Please let me know how can I get this thing done.
We have installed SQL Server 2005 with reporting services.When tried to open getting errors as below: how to avoid such errors See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has occurred and no additional error information is available. ---> System.Runtime.InteropServices.COMException (0x8000000A) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
I'd like to put all the properties from the DBPROPSET_SSCE_DBINIT propset into a configuration file (XML probably) such that I can read in and dynamically adjust my SSCE connections. This way stuff like max database size and buffer size can be changed without a recompile.
My idea was to have an XML in the form:
<PropertySet Id = DBPROPSET_SSCE_DBINIT> <Property Id = DBPROP_SSCE_AUTO_SHRINK_THRESHOLD> <Options>DBPROPOPTIONS_REQUIRED</Options> <Type>VT_I4</Type> <Value>100</Value> </Property> <Property Id = DBPROP_SSCE_MAX_DATABASE_SIZE> <Options>DBPROPOPTIONS_REQUIRED</Options> <Type>VT_I4</Type> <Value>1024</Value> </Property> . . . </PropertySet>
Now my question is...can y'all think of any better way to convert these strings that I'll retrieve (e.g. "DBPROP_SSCE_MAX_DATABASE_SIZE") to their enum'd equivalents than to do the following:
It's seems entirely too unelegant and wasteful...but maybe I'm being too picky. It also has the disadvantage of needing to be updated if more properties are added with subsequent versions.
obviously until I get this sorted I cannot deploy my reports
in my Reporting Services Configuration
All ticked except initialisation (3)
in Database services ticked but on the right hand side there are warnings/errors
Verifying Database Edition - ticked
Verifying Database Version - warning
The current connection string is not valid and can't be used to connect to SQL Server
Where do I check this? (1)
Creating A Grant Rights script for LocalSystem = ticked
Assigning Reporting Services Rights to User = error (2)
System.Data.SqlClient.SqlException: The role 'RSExecRole' does not exist in the current database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script) at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
Can someone tell me what I should be checking please?
I am trying to configure reporting services using the Configuration Tool. I get all checks green except for Encryption Keys (Blue), Initialization (Grey), and Email Settings and Execution Account (both Yellow). I am not too worried about the yellow and blue ones because I have read that other people have the same, but I was wondering how to make Initialization available to configure. I am running SQL Server 2005 - Standard Edition.
I've encountered this error when opening up http://localhost/ReportServer/
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerRSReportServer.config' is denied.
Here is the log info:
<Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product> <Locale>en-US</Locale> <TimeZone>Pacific Daylight Time</TimeZone> <Path>C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFilesReportServerService__06_20_2007_10_08_12.log</Path> <SystemName>CSD060266</SystemName> <OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName> <OSVersion>5.1.2600.131072</OSVersion> </Header> ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file. ReportingServicesService!resourceutilities!9!6/20/2007-10:08:13:: i INFO: Reporting Services starting SKU: Developer ReportingServicesService!resourceutilities!9!6/20/2007-10:08:13:: i INFO: Evaluation copy: 0 days left ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 57106 seconds. Cycle: 86400 seconds ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: SQM timer timer enabled: Next Event: 60706 seconds. Cycle: 86400 seconds ReportingServicesService!library!e!6/20/2007-10:08:13:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ReportingServicesService!library!e!6/20/2007-10:08:44:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson ReportingServicesService!library!e!6/20/2007-10:08:44:: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus) at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition() at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage() at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread() ReportingServicesService!library!e!6/20/2007-10:08:44:: Attempting to start service again...
I've been doing all I could think of: reinstall the whole SQL server and its services; stop and restart SQL server service and Reporting service.
It could be my SQL version has a problem...not sure....
I could not think of anything else.
If you have any thoughts about it, please do reply.
Any suggestion is highly appreciated. Thank you...
Hi All - I am trying to configure reporting services on virtual machine but unable to succeed. I never touched this topic before SQL Server 2005. The left hand side options in Reporting Services Configuration Manager such as Server Status, Virtual Directories, Web Identity works fine but it fails in Database Setup section Here are the details: AppServer: SQL Server 2005 Reporting Services & Client components build# 2153 (with SP1 & SP1 hotfix) going to apply SP2 and Add-on component after the configuration DBServer: SQL Server 2005 Database Services & Client components build# 2153 (with SP1 & SP1 hotfix) OS: Windows 2003 Server with SP1 IIS version on AppServer: 6
I have SQL 2005 Reporting services and 2005 Database Engine on 2 different machines.
Here is the error message I am receiving when I try to apply the script in "Database Setup" section of Reporting Services Configuration Manager It did not log any errors in SQL Server however it shows a warning message in Event Log Event Log message - "The RSReportServer.config file has been modified."
Configuration Manager error message - It shows me "Create a Grants Rights Script" task failed "System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Management.ManagementScope.InitializeGuts(Object o) at System.Management.ManagementScope.Initialize() at System.Management.ManagementObjectSearcher.Initialize() at System.Management.ManagementObjectSearcher.Get() at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String machine) at ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String dbServer) at ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String connectionString, String server, String database, ConfigurationCredentialsType credsType, String account, String password, Boolean upgrade, String dbVersion)"
I have captured the screenshot, let me know if I can send this.
One of my friends suggested the following and I have tried the first option but could not work - Option I) Our account that is used for database connection should have 1) public and RSExecRole roles for the ReportServerDatabase. 2) RSExecRole roles for the master, msdb , and ReportServerTempDB databases.
Else - Option II) we can run the Reporting Service Windows Service under the local System Account and then the credentials type for the database set up would be Service credentials. This way we would have more permission.
Did anyone face this problem? how should I resolve this?
Anyone have steps to follow as I feel of missing something in the configuration steps? Any information/ suggestions/ pointer on this are higly appreciated.
I've installed SQL 2005 on a Windows 2003 R2 Server, I also installed another Web Server (Another Windows 2003 R2 Server) on a different machine. I've installed the Reporting Services on the Web Server. When I am trying to configure the report server, I successfully created the Virtual Directories, but when trying to do the "Database Setup" step, I am getting an error on the "Create a Grants Rights Script", with this message:
System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Management.ManagementScope.InitializeGuts(Object o) at System.Management.ManagementScope.Initialize() at System.Management.ManagementObjectSearcher.Initialize() at System.Management.ManagementObjectSearcher.Get() at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String machine) at ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String dbServer) at ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String connectionString, String server, String database, ConfigurationCredentialsType credsType, String account, String password, Boolean upgrade, String dbVersion)
As a result, I cannot run the reports nor get to the folder.aspx page on the manager side of the application. I am getting this HTML msg: The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) Get Online Help
When installing the Reporing Server on the SQL Server machine, it works with no problems, and I am doing everything the same.
Would appreciate your help, I've been working on this for few days with no luck.
I've got an error when I want to initialize the Report Server by means of RS Configuration Manager.
All points are check in green except "Encryption Keys" that is in "Optionnal configuration" and "Initialization" that is in "Not Configured".
When I click on "Initialization" an error occured :
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)
When I want to browse the report this error occured:
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) (rsRPCError). Cannot generate SSPI context.
I am attempting to set up SQL 2005 reporting on my local system. When I get to the "Initialization" step I get the following error:
ReportServicesConfigUI.WMIProvider.WMIProviderException: Keyset does not exist (Exception from HRESULT: 0x80090016) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)
Can anyone provide assistance or suggestions on resolving this error? Many Thanks!!
I have SQL 2008 R2 instance and would like to install SSRS 2012. I have below query related to database configuration...Is there any performance impact while using SQL 2008R2 instance?Once configured SSRS database on 2008 R2, Will there any issue if we move our SQL instance from 2008R2 to SQL 2012 in future?
I developed a report in development environment, which will later be deployed to QA, Staging and then Production. This report has more than 10 datasets and if the report is moved through each of the databases, datasource has to be changed for all the datasets. is there anyway that I can do it globally, what i mean is can i set up any configuration files which I can use in QA, Staging and Production.
I am using BIDS 2012.I am getting this error: Unable to load assembly U2.
Data.Client, Version=2.1.0.0, Culture=neutral , PublicKeyToken=9ab9148678f4f448, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.IO.FileNotFoundException: Could not load file or assembly 'U2.Data.Client, Version=2.1.0.0, Culture=neutral, PublicKeyToken=9ab9148678f4f448' or one of its dependencies. The system cannot find the file specified.
[code]....
I am expecting C:WindowsMicrosoft.NETFramework64v4.0.30319configmachine.config
how can I force SSRS to use "C:WindowsMicrosoft.NETFramework64v4.0.30319configmachine.config".
I have installed SSRS 2012 Standard Edition in our DR site. We replicate over the reporting server databases over from our Production server via storage replication. It is on a different server than the reporting service. When I configure the SSRS in DR it is still seeing the SSRS from our Production server and tries to make it a scale out deployment which it is obviously not allowed to be because of the edition.Is there something in the database itself I need to change so it doesn't think the production server is still connecting?
Hi all, i am tring to install and configure reporting services in Windows 2003 SP2- 64 bit machine as part of installing SCE 2007, and i followed the procedure for confiurng all the options in reportingservices config tool,
all the options show green flag and still could not proceed further as the following error is coming
"The Selected Sql server reportin service instance is not configured , please configure to continue" which halts the further process,
I have installed SQL Server 2005 edition and installed Sql server 2005 SP2 also,
Hi All, I want to deploy my reports in a Sharepoint site. So I need to change the Deployment mode from Native to Sharepoint Integrated mode. When go to Reporting Services Configuration and in Database Setup - the Server Mode option is not visible. Anyone help me what is the reason for this or How to get Server Mode option in Database Setup in Reporting Services Configuration menu. However the system installed with Sharepoint and SSRS SP2.
I installed 2K5 developer on my box. I was impressed with the Summary tab report functions and the reports available there. Then I ran the "Reporting services configuration" tool to get RS running, but now several of the summary reports are broken. There are several different error messages given in the summary window, depending on the report selected.
For example, the "server dashboard" now displays
Summary Unavailable
The information needed to display a summary page for the selected object is not available.
Error:
"sql_handle" is not a recognized table hints option. If it is intended as a parameter to a table-valued function, ensure that your database compatibility mode is set to 90.
The next two reports work, but the "Scheduler Health" report displays
Summary Unavailable
The information needed to display a summary page for the selected object is not available.
Error:
Incorrect syntax near '.'.
"Memory Consumption" works GREAT, but "Activity - All blocking transaction" shows:
Summary Unavailable
The information needed to display a summary page for the selected object is not available.
Error:
Incorrect syntax near '.'. Incorrect syntax near '.'. Incorrect syntax near the keyword 'as'. Incorrect syntax near the keyword 'as'.
What could be the cause of such errors? Is there an "easy fix"? I wouldn't know how to "unconfigure" reporting services and have a feeling that wouldn't help anyway...
We have SCCM 2012 primary site and Remote SQL 2012 server. Due to hardening and password reset we are facing reporting issue.
while we Open the SRS report in SQL server and try to edit the Report (Report Builder) we are getting following error due to which we are unable to configure Reporting Service point in the SCCM 2012 server. We created the New Reporting server database still we are getting the below error.
I have problem during first configuration of Reporting Services from MS SQL 2005 Server Express with Advanced Services SP2. The error occurs when configuring virtual directory (Reporting Services Configuration Manager -> Report Server Virtual Directory). When I try to create new virtual directory I can see following messages:
Number of errors: 0 Create Virtual Directory
The virtual directory was created and assigned. Changing Secure Connection Level
After last message Windows reports that SQL Server 2005 Reporting Configuration Tool has encountered a problem and needs to close (and I can send report to Microsoft).
IIS shows that virtual directory under default web site was created.
My environment: MS SQL Reporting Services Version 9.00.3042.00 Windows XP Proffessional SP2 IIS 5.1 all components are fresh new installations. The only additional configuration I've made was adding IWAM_<hostname> as WebServiceAccount, all other configuration is default.
I contact you because we installed Report Services 2012 and after configuring werb service URL, database, Report Manager URLs... the URLs linked to the Report server + Report Manager does not work.After searching in IIS, it seems that even if virtual directories are created, they are linked to directories which does not exist :- c:Program FilesMicrosoft SQL ServerMSRS11.ReportReporting Services does contain only LogFiles and RSTempFiles directories.
In case of having only one host, is the <HostName> tag mandatory? I was not able to find more information regarding the xsd on which the configuration file is based. To be more specific, is it possible to define the PermittedHost like this or will this result in an error?
I've SQL Server Reporting Services 2005 configured on my system, but now I'm NOT Able to start the report server. I get this error on http://<serverurl>/Reports/Home.aspx:
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B)
I don't want to loose any data. Please help me resolving this error.
FYI, I've modified the SQL Reporting Services account LogOnAs info, in Properties of "SQL Server Reporting Services (MSSQLSERVER)" Service, in Windows Service Managment.
Earlier I had .useraccount as username, I modified it to domainnameuseraccount. And then suddenlt everything broke for reporting server.
Yesterday, literally I was banging my head to the wall, kept getting this error:
A Connection could not be established with the information provided. Hit OK to change your connection settings. Invalid object name 'sysdatabases'.
I uninstall and re-install back the reporting services couple times and I kept getting the same error. I have 2 instances of SQL Server on the same Server:
SQL Server 2000
SQL Server 2005 The 2 instances work side by side, I was wondering if this causing the error.
I've a slight problem with configuring my Report Server. I have set up everything apart from the initialisation and and the Windows Service Identity, however when I select the panel for the latter I am presented with a message box displaying the following:
" Reporting Services Configuration Manager:
There was an error while switching panels. The most likely cause is an error retreiving WMI properties. The exception details are:
InvalidArgument=Value of '1' is not valid for 'SelectedIndex'.
Parameter name: SelectedIndex "
I have tried re-installing the entire SQL server setup and this made no difference, I followed this by removing then reinstalling just the Report Service. Still nothing.
Any ideas as to what it is doing and how I should go about fixing it?
While migrating Report services in SQL Server 2005 to 2014, I am trying to restore the Encryption Key in RS Configuration Manager in2014. But I cannot click the 'Restore' button in RS Configuration Manager. So if I should be grant more right to do so or any other action?
I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified. Restored my Reportserver and ReportserverTempDB databases Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script) at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'? Is it possible to migrate from 32bit to 64bit?
I'm attempting to obtain a cost effective solution for my existing customers to develop reports on their SQL 2000 Server installations using their Reporting Services 2000. With products like Visual Basic.NET 2003 becoming almost impossible to obtain, I have at least one customer who is running into a dead end.
One option possibly is the SQL Express with Advanced Services download, which has Reporting Services. My questions are as follows:
Can the report designer component of SQL Express Reporting Services be configured to connect to an external database (which would happen to be a SQL 2000 database) to establish its datasets? Does the resultant designed report end up in an RDL file? If the customer published this report via the Reporting Services 2000 Report Manager, would the report be able to run?
Sorry for asking a question like this that I could probably answer on my own, but my customer needed this answer yesterday. I have scoured the web and microsoft sites - and posted a question on the official SQL Reporting Services cateogy ... in an attempt to answer the basic question of how to design reports for Reporting Services 2000 in the absence of Visual Basic.NET 2003 (or other .NET 2003 tools) with no success.
I installed 2005 advance... install said all OK. I go to Reporting Configuration tool, try to set Report Server Virtual Directory, set new to default... says number of errors 0 but the crashes with the "... and has to close" No details as to what the error is and when I retry I cannot click on Report Manager Virtual Directory. Any Ideas?
