I am trying to install SQL Reports on my development and I am getting the following error and it will not Install.
I have SQL service pack 4 installed on my machine
I have SQL Server Development Edition installed on my machine and I am running Windows XP,
with VS 2003 Professional Edition
I am trying to install Developer Edition SQL Reporting Services
Event ViewerEvent Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 10005
Date: 13/10/2005
Time: 16:41:23
User: OBELIX\Administrator
Computer: OBELIX
Description:
Product: Microsoft SQL Server 2000 Reporting Services Developer Edition -- Error 29581. SQL Setup failed to execute a command for server configuration. The error was: Database 'ReportServer' does not exist. Check sysdatabases.
Refer to the Server error logs and setup logs for detailed error information.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 32 38 37 39 43 41 35 {2879CA5
0008: 30 2d 31 35 39 39 2d 34 0-1599-4
0010: 46 34 42 2d 42 39 45 43 F4B-B9EC
0018: 2d 31 31 31 30 43 31 30 -1110C10
0020: 39 34 43 31 36 7d 94C16}
This is from the Error Log
2005-10-13 15:41:54.70 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2005-10-13 15:41:54.76 server Copyright (C) 1988-2002 Microsoft Corporation.
2005-10-13 15:41:54.76 server All rights reserved.
2005-10-13 15:41:54.76 server Server Process ID is 864.
2005-10-13 15:41:54.76 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2005-10-13 15:41:55.48 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2005-10-13 15:41:58.43 server SQL Server configured for thread mode processing.
2005-10-13 15:41:58.70 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2005-10-13 15:41:59.59 server Attempting to initialize Distributed Transaction Coordinator.
2005-10-13 15:42:00.56 server Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE
2005-10-13 15:42:01.14 spid3 Starting up database 'master'.
2005-10-13 15:42:07.12 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2005-10-13 15:42:07.12 spid5 Starting up database 'model'.
2005-10-13 15:42:07.39 spid3 Server name is 'OBELIX'.
2005-10-13 15:42:07.39 spid8 Starting up database 'msdb'.
2005-10-13 15:42:07.39 spid9 Starting up database 'pubs'.
2005-10-13 15:42:07.64 spid10 Starting up database 'Northwind'.
2005-10-13 15:42:07.64 spid11 Starting up database 'wktog36_test'.
2005-10-13 15:42:07.92 spid12 Starting up database 'wktog40_Test'.
2005-10-13 15:42:08.03 spid13 Starting up database 'MSPData'.
2005-10-13 15:42:08.32 spid14 Starting up database 'wktog40_pmtest'.
2005-10-13 15:42:09.14 spid15 Starting up database 'GaryTest'.
2005-10-13 15:42:12.10 spid5 Clearing tempdb database.
2005-10-13 15:42:12.96 spid10 Starting up database 'MikeTest'.
2005-10-13 15:42:20.39 server SQL server listening on 10.2.131.61: 1433.
2005-10-13 15:42:20.39 server SQL server listening on 127.0.0.1: 1433.
2005-10-13 15:42:22.12 server SQL server listening on TCP, Shared Memory, Named Pipes.
2005-10-13 15:42:22.12 server SQL Server is ready for client connections
2005-10-13 15:42:23.04 spid5 Starting up database 'tempdb'.
2005-10-13 15:42:24.10 spid3 Recovery complete.
2005-10-13 15:42:24.10 spid3 SQL global counter collection task is created.
2005-10-13 15:47:12.32 spid51 Using 'xplog70.dll' version '2000.80.2039' to execute extended stored procedure 'xp_msver'.
2005-10-13 15:47:13.34 spid51 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'xp_fileexist'.
2005-10-13 15:50:47.09 spid51 Starting up database 'ReportServer'.
2005-10-13 15:50:59.74 spid51 Starting up database 'ReportServer'.
2005-10-13 16:41:18.68 spid51 Starting up database 'ReportServer'.
2005-10-13 16:41:27.03 spid51 Starting up database 'ReportServer'.
cykophysh
Participant
783 Points
172 Posts
Installing SQL Reports
Oct 13, 2005 04:10 PM|LINK
I have SQL service pack 4 installed on my machine
I have SQL Server Development Edition installed on my machine and I am running Windows XP,
with VS 2003 Professional Edition
I am trying to install Developer Edition SQL Reporting Services
Event ViewerEvent Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 10005
Date: 13/10/2005
Time: 16:41:23
User: OBELIX\Administrator
Computer: OBELIX
Description:
Product: Microsoft SQL Server 2000 Reporting Services Developer Edition -- Error 29581. SQL Setup failed to execute a command for server configuration. The error was: Database 'ReportServer' does not exist. Check sysdatabases.
Refer to the Server error logs and setup logs for detailed error information.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 32 38 37 39 43 41 35 {2879CA5
0008: 30 2d 31 35 39 39 2d 34 0-1599-4
0010: 46 34 42 2d 42 39 45 43 F4B-B9EC
0018: 2d 31 31 31 30 43 31 30 -1110C10
0020: 39 34 43 31 36 7d 94C16}
This is from the Error Log
2005-10-13 15:41:54.70 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2005-10-13 15:41:54.76 server Copyright (C) 1988-2002 Microsoft Corporation.
2005-10-13 15:41:54.76 server All rights reserved.
2005-10-13 15:41:54.76 server Server Process ID is 864.
2005-10-13 15:41:54.76 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2005-10-13 15:41:55.48 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2005-10-13 15:41:58.43 server SQL Server configured for thread mode processing.
2005-10-13 15:41:58.70 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2005-10-13 15:41:59.59 server Attempting to initialize Distributed Transaction Coordinator.
2005-10-13 15:42:00.56 server Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE
2005-10-13 15:42:01.14 spid3 Starting up database 'master'.
2005-10-13 15:42:07.12 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2005-10-13 15:42:07.12 spid5 Starting up database 'model'.
2005-10-13 15:42:07.39 spid3 Server name is 'OBELIX'.
2005-10-13 15:42:07.39 spid8 Starting up database 'msdb'.
2005-10-13 15:42:07.39 spid9 Starting up database 'pubs'.
2005-10-13 15:42:07.64 spid10 Starting up database 'Northwind'.
2005-10-13 15:42:07.64 spid11 Starting up database 'wktog36_test'.
2005-10-13 15:42:07.92 spid12 Starting up database 'wktog40_Test'.
2005-10-13 15:42:08.03 spid13 Starting up database 'MSPData'.
2005-10-13 15:42:08.32 spid14 Starting up database 'wktog40_pmtest'.
2005-10-13 15:42:09.14 spid15 Starting up database 'GaryTest'.
2005-10-13 15:42:12.10 spid5 Clearing tempdb database.
2005-10-13 15:42:12.96 spid10 Starting up database 'MikeTest'.
2005-10-13 15:42:20.39 server SQL server listening on 10.2.131.61: 1433.
2005-10-13 15:42:20.39 server SQL server listening on 127.0.0.1: 1433.
2005-10-13 15:42:22.12 server SQL server listening on TCP, Shared Memory, Named Pipes.
2005-10-13 15:42:22.12 server SQL Server is ready for client connections
2005-10-13 15:42:23.04 spid5 Starting up database 'tempdb'.
2005-10-13 15:42:24.10 spid3 Recovery complete.
2005-10-13 15:42:24.10 spid3 SQL global counter collection task is created.
2005-10-13 15:47:12.32 spid51 Using 'xplog70.dll' version '2000.80.2039' to execute extended stored procedure 'xp_msver'.
2005-10-13 15:47:13.34 spid51 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'xp_fileexist'.
2005-10-13 15:50:47.09 spid51 Starting up database 'ReportServer'.
2005-10-13 15:50:59.74 spid51 Starting up database 'ReportServer'.
2005-10-13 16:41:18.68 spid51 Starting up database 'ReportServer'.
2005-10-13 16:41:27.03 spid51 Starting up database 'ReportServer'.
Gary Woodfine
My Website || Blog