Silent Installation - SQL 2000 Reporting Services
Feb 14, 2008
Hi,
I'm trying to install SQL 2000 Server Reporting Services silently.
I've read that I need to customize template.ini file. This is my file:
[Options]
USERNAME=user
COMPANYNAME="Company Name"
PIDKEY=*******************************
INSTALLDIR="C:Program FilesMicrosoft SQL Server"
;Components to install
ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS_BooksOnline_EN
RSACCOUNT=
RSPASSWORD=
RSAUTOSTART=1
RSVIRTUALDIRECTORYSERVER=ReportServer
RSVIRTUALDIRECTORYMANAGER=
RSREDIRECTTOMANAGER=0
RSUSESSL=1
RSDATABASESERVER=
RSDATABASENAME="ReportServer"
RSDATABASEFILELOCATION=
RSDATABASELOGFILELOCATION=
RSSQLACCOUNT=
RSSQLPASSWORD=
RSSETUPACCOUNT=
RSSETUPPASSWORD=
PERSEAT=1
I don't know if I missing something essencial or if I did it in a wrong way, but when I ran the installation from the command line, I get, after a while, a minimized window with "ERROR REPORTING" as title that I can't restore.
I could install it manually without problems (as a test). I've made ISS files for the SQL 2000 Server Developer Edition, but I couldn't for reporting services. Is this possible? Is there an error in my template.ini?
Thank you in advance!!
View 4 Replies
ADVERTISEMENT
Sep 13, 2007
Could someone tell me what a silent inatallation is please?
Many thanks
View 2 Replies
View Related
Dec 7, 2006
Hi:
Is it possible to install a 64 bit SQL Server 2005 silently?. I am wondering what are the command options that are needed to do a quiet Install of Enterprise Edition of SQL Server 2005 (x64) on a x64 OS.
Any info is appreciated.
Thanks
Ankith
View 1 Replies
View Related
Mar 14, 2006
I am writing an application that requires SQL Express to be installed alongside.
So I try to do the following - Before installing my application, I pop-up a link which leads to "SQLEXPR.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLServer <other parameters> /qb " .
But this displays only a basic GUI, which means that the pre-requisite checks for SQL express are not displayed to the user. So if MDAC version 2.8 is not present on the system the installation of SQLexpress fails without any error messages (except in the log files).
( This is not a problem with all pre-requisites :: If .NET is not present on the system, the failure is much more elegant. There is a nice GUI pop-up which requests the user to install .NET 2.0 before installing SQL express.)
On the other hand, If I remove the "/qb" switch, I can get the pre-requisites GUI to display and the end-user can figure out the cause of failure easily enough. But this means that the optional parameters I use, for example the instancename or the authentication mode will not be used during the install
Is there a good commandline switch I can use so that
1) The pre-requisites check screen is displayed
2) All the commandline options are used for installation.
Thanks
View 5 Replies
View Related
Apr 16, 2007
Hi There,
My ASP.Net application needs AJAX and SQL Server to be installed on the server.
How can I make AJAX and SQL Server installation as a part of my application installation?
Is it possible to automate the install of SQL Server? So user dont need to write in anything, all the answers will be prewritten.
I heard, using Microsoft Setup manager we can generate Setup.iss files to automate the silent install of SQL Server. But I cant find information about how to implement and where can I find this tool.
My main motive is to save my client from installation questions of SQL Server.
One version of my application uses SQL Server 2005 Express and another one uses Standard version.
Please help and guide me.
View 3 Replies
View Related
Aug 21, 2007
Hi..
i am new to vbscripting.i need to create the vbscript for
( .netframework2.0,MDAC2.7,XML4.0,VC++2005,windowsinstaller3.0,OWC10)
with silent installation via VBscript.before that i need to check the
machine have my pre-requisites or not,which machine does not have my
pre-requisites through script i have to install.
Kindly provide any solution for this.you can reach me at
senthil...@tcs.com.
thanks,
N.senthil
View 1 Replies
View Related
Feb 19, 2007
Hi,
I'm trying to create a silent installation which will create a new instance of the express version
on my clients machine, the problem is that i can't set the service account to local service
i.e AGTACCOUNT="NT AUTHORITYLOCAL SERVICE"
if im running the normal setup (GUI) i can set this property easly,
but from the command line all i get is
"NT AUTHORITYLOCAL SYSTEM" which is the default i think
how can i do it from the command line???
Thanks
View 8 Replies
View Related
Dec 23, 2014
I tried SQL server 2014 express edition for Silent installation using the below procedure. The process got exited without completion in few minutes.
Command used for silent installation is
SQLEXPRADV_x86_ENU /q ConfigurationFile="ConfigurationFile.ini"
Created Configuration File Manually: Below is the File Data
;SQLSERVER2008 Configuration File
[SQLSERVER2008]
IACCEPTSQLSERVERLICENSETERMS="True"
; Specify the Instance ID for the SQL Server features you have specified. SQL Server directory structure, registry structure, and service names will reflect the instance ID of the SQL Server instance.
INSTANCEID="SHAREPOINT"
; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter.
ACTION="Install"
; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, RS, IS, and Tools. The SQL feature will install the database engine, replication, and full-text. The Tools feature will install Management Tools, Books online, Business Intelligence Development Studio, and other shared components.
FEATURES=SQLENGINE,REPLICATION
; Displays the command line parameters usage
HELP="False"
; Specifies that the detailed Setup log should be piped to the console.
INDICATEPROGRESS="False"
; Setup will not display any user interface.
QUIET="True"
; Setup will display progress only without any user interaction.
QUIETSIMPLE="False"
; Specifies that Setup should install into WOW64. This command line argument is not supported on an IA64 or a 32-bit system.
X86="False"
; The directory for the extracted service pack files used to update the setup media.
PCUSOURCE="d:d8ad8f24d77c0777a5PCUSOURCE"
; Specify if errors can be reported to Microsoft to improve future SQL Server releases. Specify 1 or True to enable and 0 or False to disable this feature.
ERRORREPORTING="False"
; Specify the root installation directory for native shared components.
INSTALLSHAREDDIR="C:Program FilesMicrosoft SQL Server"
; Specify the root installation directory for the WOW64 shared components.
INSTALLSHAREDWOWDIR="C:Program Files (x86)Microsoft SQL Server"
[code].....
View 1 Replies
View Related
Mar 22, 2008
Hello,
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?
Any help is appreciated
View 1 Replies
View Related
Apr 10, 2007
I 'm trying to install Sql Server 2005 Express Edition using c# 2.0 by starting a process and launching setup. I also want to informed about installation progress. For instance i want to inform end user if any installation error return or if setup has successfully completed etc. I think i need a callback... I have no problem about silent - unattended install but how can i informed about running installation progress ? and send these info to end user 's form ?
Regards.
Yusuf Incekara
View 5 Replies
View Related
Feb 21, 2008
Hi,
I want to build a silent setup/installation of MS-SQL-Server-Express 2005 for installation on customers computers.
I want to integrate it in my own setup/installation routine of my application.
How can I do that?
Where can I get Infos or tutorials? Perhaps here ?
Sorry for my bad english
Regards Tron
View 7 Replies
View Related
Dec 18, 2006
I tried to install SQL Reporting services in windowns server 2003
this one is web server with IIS - 6.00
i installed MDAC 2.8
i registered asp.net with IIS through command prompt.
but still it's installing only sample databases and sql reporting help
installation wizard is not showing the wizard to create report server db.
AND other report server components.
sql reporting services downloaded from MSDB subscription.
SQL Server is SQL 2K enterprise edition.
please help me to install properly, your help highly appriciated.
View 1 Replies
View Related
Apr 10, 2008
Hi All
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" ...
http://msdn2.microsoft.com/en-us/library/ms143703.aspx
... where step-2 sais to "check the Report Server Service is running".
I've checked both front-end and back-end servers and cannot find this service.
any advise please
Richard101
View 2 Replies
View Related
Mar 17, 2006
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?
View 6 Replies
View Related
Apr 30, 2008
Hello,
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 ?
Regards,
alpha
View 11 Replies
View Related
Oct 9, 2006
Hey all,
Cool place! Has anyone deployed SQL Express silently using one click and an attached a smart client DB from within the app ... would love to see some of the best practices or horror stories! Just kidding... :) I'm about to deploy a smart client using SQL Express and could use some tips from someone who has been there.
Thanks in advance,
Bill
View 7 Replies
View Related
Apr 16, 2004
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 ?
Thanks
Mikhail
View 1 Replies
View Related
Aug 12, 2004
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
View 2 Replies
View Related
Feb 2, 2004
Hi,
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.
Can anyone help?
View 1 Replies
View Related
Apr 29, 2007
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.
View 18 Replies
View Related
Sep 14, 2006
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?
View 4 Replies
View Related
Jan 26, 2007
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.
Thanks!
View 1 Replies
View Related
Jan 14, 2008
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.
View 2 Replies
View Related
Jan 20, 2007
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.
Where did I go wrong?
View 3 Replies
View Related
Dec 6, 2006
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.
Thanks to anyone who can help.
-- Mark
View 1 Replies
View Related
Mar 5, 2004
Hi,
I have asked this before...I didnt reach anywhere yet.I am putting this problem again infront of you guys.
I have installed SQL Services Reporting Services on my Windows XP machine which has vs.net 2003 and SQL 2000 with sp3a in working condition.Unfortunately none of the Server components of the Reporting Services got installed(like Report Server,Report Manager).All the Client components(Report Designer,Report Wizard etc) got installed.I am able to design and preview the reports but I cannot publish since I dont have a Report Server.I installed the Reporting Services from the MSDN subscriber download and I have a valid SQL Server license.
Any thoughts woule be deeply appreciated...
Thanks
View 1 Replies
View Related
Jun 20, 2007
Hi,
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...
View 3 Replies
View Related
Apr 21, 2006
The upgrade was alright for my first/default instance of reporting services but failed for the other 3 non-default instances.
I was running SP1 using remote desktop connection.
I got the following error at the report manager and the reporting services configuration's initialization. Is there any way to get around this?
The version of the report server
database is either in a format that is not valid, or it cannot be read. The
found version is 'C.0.8.40'. The expected version is 'C.0.8.43'. To continue,
update the version of the report server database and verify access rights.
(rsInvalidReportServerDatabase)
Extract from RS9_Hotfix_KB913090.log:
....
04/21/2006 13:20:34.652 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller04/21/2006 13:20:34.668 Failed to read registry key: Debug04/21/2006 13:20:34.761 Unable to install MSP file: \D11-OEMP4-16c$481974575b35c5d8b2HotFixRSFilessqlrun_rs.msp04/21/2006 13:20:34.808 The following exception occurred: Unable to install Windows Installer MSP file Date: 04/21/2006 13:20:34.808 File: depotsqlvaultsetupmainsetupsqlsesqlsedllcopyengine.cpp Line: 856
04/21/2006 13:20:34.871
04/21/2006 13:20:34.933 Product Status Summary:
04/21/2006 13:20:34.980 Product: SQL Server Native Client
04/21/2006 13:20:35.027 SQL Server Native Client (RTM ) - Reboot Required
04/21/2006 13:20:35.090
04/21/2006 13:20:35.168 Product: Setup Support Files
04/21/2006 13:20:35.230 Setup Support Files (RTM ) - Success
04/21/2006 13:20:35.277
04/21/2006 13:20:35.340 Product: Database Services
04/21/2006 13:20:35.402 Database Services (RTM 1399 ENU) - Reboot Required
04/21/2006 13:20:35.465 Analysis Services (RTM 1399 ENU) - Success
04/21/2006 13:20:35.511 Reporting Services (RTM 1399 ENU) - Success
04/21/2006 13:20:35.574
04/21/2006 13:20:35.636 Product: Notification Services
04/21/2006 13:20:35.699 Notification Services (RTM 1399 ENU) - Success
04/21/2006 13:20:35.746
04/21/2006 13:20:35.808 Product: Reporting Services
04/21/2006 13:20:35.871 Reporting Services (RTM 1399 ENU) - Failure04/21/2006 13:20:35.933 Details: Unable to install Windows Installer MSP file04/21/2006 13:20:35.980 04/21/2006 13:20:36.043 Product: Reporting Services04/21/2006 13:20:36.105 Reporting Services (RTM 1399 ENU) - Failure04/21/2006 13:20:36.152 Details: Unable to install Windows Installer MSP file04/21/2006 13:20:36.215 04/21/2006 13:20:36.277 Product: Reporting Services04/21/2006 13:20:36.340 Reporting Services (RTM 1399 ENU) - Failure04/21/2006 13:20:36.402 Details: Unable to install Windows Installer MSP file
04/21/2006 13:20:36.480
04/21/2006 13:20:36.543 Product: Integration Services
04/21/2006 13:20:36.605 Integration Services (RTM 1399 ENU) - Not Applied
04/21/2006 13:20:36.683
04/21/2006 13:20:36.746 Product: Client Components
04/21/2006 13:20:36.808 Client Components (RTM 1399 ENU) - Not Applied
04/21/2006 13:20:36.871
04/21/2006 13:20:36.918 Product: MSXML 6.0 Parser
04/21/2006 13:20:36.996 MSXML 6.0 Parser (RTM ) - Not Applied
04/21/2006 13:20:37.043
04/21/2006 13:20:37.074 Product: SQLXML4
04/21/2006 13:20:37.105 SQLXML4 (RTM ) - Not Applied
04/21/2006 13:20:37.183
04/21/2006 13:20:37.246 Product: Backward Compatibility
04/21/2006 13:20:37.308 Backward Compatibility (RTM ) - Not Applied
04/21/2006 13:20:37.371
04/21/2006 13:20:37.433 Product: Microsoft SQL Server VSS Writer
04/21/2006 13:20:37.496 Microsoft SQL Server VSS Writer (RTM ) - Not Applied
04/21/2006 13:20:37.543
04/21/2006 13:37:53.718 Hotfix package closed
View 17 Replies
View Related
Nov 27, 2006
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."
any ideas?
View 6 Replies
View Related
Jul 19, 2015
When I try to install sql server 2014 on my machine,all the features were installed but except Reporting services-Native and error occurred as shown below.
Error details:
§ Error installing SQL Server Reporting Services
Updating permission setting for folder 'C:WindowsTemp' failed. The folder permission setting were supposed to be set to 'DA;OICI;0x1200af;;;S-1-5-80-4063824523-3130906261-2263067808-2545249320-213050741)'.
Error code: 0x84CF0003
View 8 Replies
View Related
Aug 24, 2015
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.
View 7 Replies
View Related
Apr 11, 2008
I have been through virtually every last posting on installing SQL Server Express with Advanced Services in this site and still have no success accessing the Reporting Services site: http://localhost.reports$sqlexpress. I get a the correct background to the site as in the tutorials, but only get "ERROR - unable to connect to the remote server", which may be indicative because this is all installed on my local machine (Dell AMD Athlon 64 X2 Dual Core 4000+ 2.11 Ghz, 1GB, Windows Ultimate). I have gone through How to install ... on a Windows Vista-based computer, KB934164, and most recently, How to configure .. to allow remote connections, kb 914277, in hopes of addressing the "remote server" issue. I still can't get past this obstacle. PLEASE HELP!! :-)
View 11 Replies
View Related
Sep 16, 2007
Hi All,
I'm trying to create reports in RS2005 using AS2000 as my data source. I understand that if I use RS2005 on AS2000, I wont be able to enjoy the OLAP based parameters as in using AS2005. Does anyone know an easy way to easily use Parameters in RS2005 while still using AS2000?
Regards,
Joseph
View 1 Replies
View Related
