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...
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.
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.
Setup: Windows server 2003 SP1, SQL 2005 SP2, Sharepoint Office server 2007, Report Services addin (CTP v9.00.3027).
Using the Report server configuration tool, setting Report Server Virtual directory, end up with RS Configuration tool crashing.
It appears to be happening on the task "Changing Secure connection level", & returns "System.NullReferenceException was unhandled Message: Object reference not set to an instance of an object."
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.
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)
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 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?
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 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 feel I've completed the installation of 2005 Reporting Services with a remove database following these notes ... http://msdn2.microsoft.com/en-us/library/ms143703.aspx
... now I want to confirm its working. There is a link in the notes to "Verify a Report Services Installation" ...
When I install reporting services in sqlserver 2005,its stops half way saying ' sqlserver setup failed to obtain system account information for the ASPNET account.To proceed re install the .NET framework and continue'
How do I set up an ASP account so as to continue with the installation?
I have SQL server 2005 which has some kind of different options as normal SQL installation and there is no any option for reporting services. I do full installation and have everything I need : BIDS, reporting config tool etc, but there is no reporting service available. So I get error when try to run reporting services configuration tool. Error claims that it can't find any reporting services on my machine. I have looked at services list in my PC and there is no reporting services. So my question is how to install reporting services as stand alone ?
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've just tried to install SQL Reporting services on my development workstation.
I was going well but suddenly I got an error that my SQL server instance is not supported. I am running SQL Server 2000 desktop edition, service pack 3.0.
Is that true that is is not supported or it is just a bug in installation ?
I have this situation in my current project. I’m trying to install SQL Reporting services on two machines: the web part on a web server, the databases on a SQL Server. The ASP.NET process is running under a custom account that I created, let's say, 'MyAccountASPNET' . I'm using this account to connect to the SQL server. I already have a web application that is using this configuration to connect to SQL. Now, during the SQL reporting services installation, at the end of the installation, while running the scripts to create the databases, I'm getting this message: 'The account 'MyAccountASPNET' is not a valid domain name <domain/username>. Please use the correct name.' How am I suppose to use <domain/username> , while the two servers are not in a domain, on each of them I have a user 'MyAccountASPNET' with the same password, but of course the users are 'WebserverMyAccountASPNET' and 'SQLServerMyAccountASPNET'. Any idea how to solve this problem? Thanks
Here's the situation: * I had an older beta (beta 1) of RS installed on a machine at an earlier time. * Someone manually deleted the RS files on the machine as opposed to a add/remove programs operation. * I installed the RTM Reporing Services on the machine. * I try to author a report and get the following message:
'The located assembly's manifest definition with name 'Microsoft.VisualStudio.Shell.Interop' does not match the assembly reference.'
I have removed VS 2003 and Reporting Services, and re-installed them numerous times, but still keep getting the same error message when I try to author a report.
I have tried several times to get the Reporting Services Add-In to install. It seems as if everything is going along well except when the installation gets to "Removing Backup" files it hangs and then completely uninstalls the product. Moreover, the event log simply notes "installation failed". Has anybody else encountered this? Thanks in advance for any help.
I recently installed SQL Express advanced and came across something thats confusing me. When i look at my running services i see the advanced features like SQL Server Full Text Search and the like ,but cant seem to find the reporting service. Is there a chance i skipped over it in the insall? I had assumed i would have a service running that would say something along the lines of SQL Reporting Services. I havent come across directions on how to turn it on, so i assume that i missed it during installation?
I am converting an old Crystal Reports environment to 2005 Reporting Services. I've seen the basic memory requirements for the SSRS programs themselves, but I was wondering if there are any other guides available that will help me size the H/W based on anticipated users and reports.
Hi. I am having trouble installing the Reporting Services Add-in for Sharepoint 2007. Installing the SharePointRS.msi file from the command line seems to work fine. It's when I run rsCustomAction.exe that the installation craps out on me. The account i'm running the install from is a local admin,farm, and site collection admin so I dont' think it's a permission issue. I have pasted the error I'm receiving and bit about my farm configuration below. If anyone could give me some help or point me in the right direction I would greatly appreciate it. Many thanks in advance!
Server 1: Application Server & WFE w/ Sharepoint SP1 Server 2: SQL Reporting Services SP2, Sharepoint (basic install) + SP1 Server 3: SQL Database Engine w/ SP2
Reporting Services Log file contained the following:
User: xxxxxxxxxxxx Installing Report Server feature. Calling copyappbincontents command.
copyappbincontents command completed successfully. Adding Report Server feature to farm. Install error: A web configuration modification operation is already running. Uninstalling Report Server feature. Uninstalling Report Server feature. Report Server feature was uninstalled. Stopping W3SVC service. Removing Report Server web application files Removed file C:InetpubwwwrootwssVirtualDirectories80App_GlobalResourcesReportServer.cs-CZ.resx.
....goes on to uninstall the rest of the language resource files...
Removing DocIcon.xml file updates Beginning uninstall of cab files. Calling HCInstal for lcid '1033'
Outcome code is: 32
Calling HCInstal for lcid '3082'
..the above is printed for the rest of the languages...
Outcome code is: 32
Cab files uninstalled successfully. Starting W3SVC service. SSRSCustomActionError: A web configuration modification operation is already running.
I have installed Developer edition Sql Server and Reporting Services 2005 on my Windows XP machine (peer-to-peer network not domain). If I try to access the Report Manager home page (http://localhost:8080/reports), a login dialog appears but my own login is denied access, even though I am a member of the computer administrators group. If I change the access of the reports virtual directory to permit anonymous access then I can get to the Report manager home page, but of course there is then no site settings tab.
In the Rpting Svcs Configuration, the following are maked completed: Server status, Report Server Virtual Directory, Report Manager Virtual Directory, Windows Service Identity (set to LocalSytem), Web service identity (set to ASPNET account), Database Setup & Initiatialization.
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.
