Trying To Install The An SQL Database
Aug 17, 2006
I have this CD that has a database called Contacts on it and everytime I try to insatll it I get the same errors. I'm trying to install it from the D: drive
This is what is to be ran in Query Analyzer
/****** Object:
Database Contacts
Script Date:
3/7/2002 1:52:44 PM ******/
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE
name = N'Contacts')
DROP
DATABASE [Contacts]
GO
CREATE DATABASE [Contacts]
ON (NAME = N'Contacts_Data', FILENAME = N'MCSDWebAppschapter05Contacts.MDF'
, SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'Contacts_Log', FILENAME =
N'MCSDWebAppschapter05Contacts.LDF' , SIZE = 1, FILEGROWTH = 10%)
COLLATE
SQL_Latin1_General_CP1_CI_AS
GO
exec sp_dboption N'Contacts', N'autoclose', N'false'
GO
exec sp_dboption N'Contacts', N'bulkcopy', N'false'
GO
exec sp_dboption N'Contacts', N'trunc. log', N'false'
GO
exec sp_dboption N'Contacts', N'torn page detection',
N'true'
GO
exec sp_dboption N'Contacts', N'read only', N'false'
GO
exec sp_dboption N'Contacts', N'dbo use', N'false'
GO
exec sp_dboption N'Contacts', N'single', N'false'
GO
exec sp_dboption N'Contacts', N'autoshrink', N'false'
GO
exec sp_dboption N'Contacts', N'ANSI null default', N'false'
GO
exec sp_dboption N'Contacts', N'recursive triggers',
N'false'
GO
exec sp_dboption N'Contacts', N'ANSI nulls', N'false'
GO
exec sp_dboption N'Contacts', N'concat null yields null',
N'false'
GO
exec sp_dboption N'Contacts', N'cursor close on commit',
N'false'
GO
exec sp_dboption N'Contacts', N'default to local cursor',
N'false'
GO
exec sp_dboption N'Contacts', N'quoted identifier', N'false'
GO
exec sp_dboption N'Contacts', N'ANSI warnings', N'false'
GO
exec sp_dboption N'Contacts', N'auto create statistics',
N'true'
GO
exec sp_dboption N'Contacts', N'auto update statistics',
N'true'
GO
use [Contacts]
GO
/****** Object:
Table
[dbo].[Calls]
Script Date: 3/7/2002
1:52:49 PM ******/
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Calls]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Calls]
GO
/****** Object:
Table
[dbo].[Contact Types]
Script Date:
3/7/2002 1:52:49 PM ******/
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Contact Types]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Contact Types]
GO
/****** Object:
Table
[dbo].[Contacts]
Script Date: 3/7/2002
1:52:49 PM ******/
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Contacts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Contacts]
GO
/****** Object:
User
ASPNET
Script Date: 3/7/2002 1:52:45
PM ******/
if not exists (select * from dbo.sysusers where name =
N'ASPNET' and uid < 16382)
EXEC
sp_grantdbaccess N'ASPNET', N'ASPNET'
GO
/****** Object:
User
dbo
Script Date: 3/7/2002 1:52:45 PM
******/
/****** Object:
User
ASPNET
Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_accessadmin', N'ASPNET'
GO
/****** Object:
User
ASPNET
Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_backupoperator', N'ASPNET'
GO
/****** Object:
User
ASPNET
Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_datareader', N'ASPNET'
GO
/****** Object:
User
ASPNET
Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_datawriter', N'ASPNET'
GO
/****** Object:
User
ASPNET
Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_ddladmin', N'ASPNET'
GO
/****** Object:
User
ASPNET
Script Date: 3/7/2002 1:52:45 PM
******/
exec sp_addrolemember N'db_denydatareader', N'ASPNET'
GO
/****** Object:
User
ASPNET
Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_denydatawriter', N'ASPNET'
GO
/****** Object:
User
ASPNET
Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_owner', N'ASPNET'
GO
/****** Object:
User
ASPNET
Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_securityadmin', N'ASPNET'
GO
/****** Object:
Table
[dbo].[Calls]
Script Date: 3/7/2002
1:52:51 PM ******/
CREATE TABLE [dbo].[Calls] (
[CallID]
[int] NOT NULL ,
[ContactID]
[int] NOT NULL ,
[CallDate]
[datetime] NULL ,
[CallTime]
[datetime] NULL ,
[Subject]
[nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Notes]
[ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:
Table
[dbo].[Contact Types]
Script Date:
3/7/2002 1:52:55 PM ******/
CREATE TABLE [dbo].[Contact Types] (
[ContactTypeID]
[int] NOT NULL ,
[ContactType]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
/****** Object:
Table
[dbo].[Contacts]
Script Date: 3/7/2002
1:52:55 PM ******/
CREATE TABLE [dbo].[Contacts] (
[ContactID]
[int] NOT NULL ,
[FirstName]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LastName]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Dear]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Address]
[nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[City]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[StateOrProvince]
[nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PostalCode]
[nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Region]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Country]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CompanyName]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Title]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[WorkPhone]
[nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[WorkExtension]
[nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[HomePhone]
[nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[MobilePhone]
[nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[FaxNumber]
[nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[EmailName]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Birthdate]
[smalldatetime] NULL ,
[LastMeetingDate]
[smalldatetime] NULL ,
[ContactTypeID]
[int] NULL ,
[ReferredBy]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Notes]
[ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContactsInterests]
[nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Calls] WITH NOCHECK ADD
CONSTRAINT
[PK__Calls__59063A47] PRIMARY KEY
CLUSTERED
(
[CallID]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[Contact Types] WITH NOCHECK ADD
CONSTRAINT
[PK__Contact Types__5AEE82B9] PRIMARY KEY
CLUSTERED
(
[ContactTypeID]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[Contacts] WITH NOCHECK ADD
CONSTRAINT
[PK__Contacts__5CD6CB2B] PRIMARY KEY
CLUSTERED
(
[ContactID]
)
ON [PRIMARY]
GO
GRANT
REFERENCES
,
SELECT ,
UPDATE ,
INSERT ,
DELETE
ON [dbo].[Calls]
TO [ASPNET]
GO
GRANT
REFERENCES
,
SELECT ,
UPDATE ,
INSERT ,
DELETE
ON [dbo].[Contact Types]
TO [ASPNET]
GO
GRANT
SELECT
ON [dbo].[Contacts]
TO [public]
GO
GRANT
REFERENCES
,
SELECT ,
UPDATE ,
INSERT ,
DELETE
ON [dbo].[Contacts]
TO [ASPNET]
GO
INSERT Contacts VALUES (1, 'Kim', 'Abercrombie', 'Ms.',
'1234 Lone Dr.', 'Mobile', 'AL', '999999', NULL, 'USA', 'Wide World Importers',
NULL, '(111) 555-1111', '999', '(111) 555-2222',NULL, NULL,'someone@microsoft.com'
, '8/3/1961', NULL, 1, NULL, NULL, 'Parasailing')
INSERT Contacts VALUES (2, 'Jay', 'Adams', 'Mr.', '631 Eagle
Rd.', 'Watertown', 'PA', '999999', NULL, 'USA', 'Fabrikam', NULL, '(111)
555-1112', '888', '(111) 555-2222',NULL, NULL,'someone@microsoft.com' ,
'4/1/1942', NULL, 3, NULL, NULL, NULL)
INSERT Contacts VALUES (3, 'Adam', 'Bar', 'Mr.', '55
Passaway Ave.', 'Boston', 'MA', '999999', NULL, 'USA', 'Wide World Importers',
NULL, '(111) 555-1113', NULL, '(111) 555-2222',NULL, NULL,'someone@microsoft.com'
, '2/3/1965', NULL, 4, NULL, NULL, 'Fly fishing')
INSERT Contacts VALUES (4, 'Ido', 'Ben-Sachar', 'Mr.', '602A
Leeward Dr.', 'Sarasota', 'FL', '999999', NULL, 'USA', 'Wide World Importers',
NULL, '(111) 555-1114', '777', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '1/22/1960', NULL, 1, NULL, NULL, NULL)
INSERT Contacts VALUES (5, 'Bradley', 'Beck', 'Mr.', '44
Adams St.', 'Parkaway', 'NJ', '999999', NULL, 'USA', 'Adventure Works', NULL,
'(111) 555-1115', '333', '(111) 555-2222',NULL, NULL,'someone@microsoft.com' ,
'9/30/1959', NULL, 2, NULL, NULL, NULL)
INSERT Contacts VALUES (6, 'Karen', 'Berge', 'Mrs.', '205
Lone Dr.', 'Mobile', 'AL', '999999', NULL, 'USA', 'Wide World Importers', NULL,
'(111) 555-1116', NULL, '(111) 555-2222',NULL, NULL,'someone@microsoft.com' ,
'6/7/1960', NULL, 3, NULL, NULL, 'Windsurfing')
INSERT Contacts VALUES (7, 'Scott', 'Bishop', 'Dr.', '8898
Lipshaw Blvd.', 'Paradise', 'OR', '999999', NULL, 'USA', 'Wide World
Importers', NULL, '(111) 555-1117', '555', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '11/23/1961', NULL, 1, NULL, NULL, NULL)
INSERT Contacts VALUES (8, 'Pat', 'Coleman', 'Ms.', 'Rte 3
Highway 99', 'Circle City', 'AZ', '999999', NULL, 'USA', 'Fabrikam', NULL,
'(111) 555-1118', '87', '(111) 555-2222',NULL, NULL,'someone@microsoft.com' ,
'10/13/1970', NULL, 2, NULL, NULL, 'Skiing')
INSERT Contacts VALUES (9, 'Jane', 'Clayton', 'Ms.', '2
Wyldflower Ln.', 'Boulder', 'CO', '999999', NULL, 'USA', 'Wide World
Importers', NULL, '(111) 555-1119', '22', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '5/4/1961', NULL, 3, NULL, NULL, 'Hunting')
INSERT Contacts VALUES (10, 'Kari', 'Hensien', 'Ms.', '43
Stormwater Cr.', 'Indialantic', 'FL', '999999', NULL, 'USA', 'Adventure Works',
NULL, '(111) 555-1110', '0988', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '7/7/1959', NULL, 1, NULL, NULL, NULL)
INSERT Contacts VALUES (11, 'Don', 'Funk', 'Mr.', '55
Moccasin Wallow Dr.', 'Ernst', 'FL', '999999', NULL, 'USA', 'Fourth Coffee',
NULL, '(111) 555-1120', '111', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '3/15/1966', NULL, 1, NULL, NULL, NULL)
INSERT "Contact Types" VALUES(1, 'Business')
INSERT "Contact Types" VALUES(2, 'Social')
INSERT "Contact Types" VALUES(3, 'Friend')
INSERT "Contact Types" VALUES(4, 'Fishing buddy')
INSERT Calls VALUES(1,1,'3/3/2002', '12:00PM', 'Hosting
services', 'Return call with estimates')
INSERT Calls VALUES(2,3,'3/3/2002', '1:00PM', 'Trip to
Azores', 'Got lost on way. Needs directions.')
INSERT Calls VALUES(3,2,'2/1/2002', '10:00AM', 'Long call',
'A very, very long call.')
THIS IS THE ERRORS I KEEP GETTING
Server: Msg 5105, Level 16, State 2, Line 2
Device activation error. The physical file name
'MCSDWebAppschapter05Contacts.MDF' may be incorrect.
Server: Msg 1802, Level 16, State 1, Line 2
CREATE DATABASE failed. Some file names listed could not be
created. Check previous errors.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 911, Level 16, State 1, Line 2
Could not locate entry in sysdatabases for database
'Contacts'. No entry found with that name. Make sure that the name is entered
correctly.
Server: Msg 15007, Level 16, State 1, Procedure
sp_grantdbaccess, Line 97
The login 'ASPNET' does not exist.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 4604, Level 16, State 1, Line 2
There is no such user or group 'ASPNET'.
Server: Msg 4604, Level 16, State 1, Line 2
There is no such user or group 'ASPNET'.
Server: Msg 4604, Level 16, State 1, Line 2
There is no such user or group 'ASPNET'.
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
I JUST WANT TO KNOW WHAT I NEED TO DO STEP FOR STEP
THIS IS MY FIRST TIME ON THIS FORUM
CAN ANYONE HELP ME OUT
View 2 Replies
Feb 6, 2007
I am currently running Windows XP Professional Service Pack2. It already has MSDE & SQL Server 2000 installed (although I just uninstalled MSDE in the vain hope that it might present the installer with a more straightforward upgrade).
I have tried installing with the default instance & a new instance (I don't really care - I just need to install the darn thing). I just want the basic database & Books On-line, nothing fancy.
Here is the Summary log, for what it's worth:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Tue Feb 06 16:45:14 2007
Machine : ANTHONYY1
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_OWC11_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BackwardsCompat_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : MSXML 6.0 Parser (KB927977)
Product Version : 6.00.3890.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_OWC11_2.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server 2005 Books Online (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BOL_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BackwardsCompat_2.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : MSXML 6.0 Parser (KB927977)
Product Version : 6.00.3890.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_MSXML6_2.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : SQLXML4
Error : Setup is preparing to continue with the installation.
--------------------------------------------------------------------------------
Here is the SQLSetup0011_ANTHONYY1_Core(Local).log
Microsoft SQL Server 2005 Setup beginning at Tue Feb 06 16:45:14 2007
Process ID : 2560
C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/1/6 16:45:14
Complete: LoadResourcesAction at: 2007/1/6 16:45:14, returned true
Running: ParseBootstrapOptionsAction at: 2007/1/6 16:45:14
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/1/6 16:45:14, returned true
Running: ValidateWinNTAction at: 2007/1/6 16:45:14
Complete: ValidateWinNTAction at: 2007/1/6 16:45:14, returned true
Running: ValidateMinOSAction at: 2007/1/6 16:45:14
Complete: ValidateMinOSAction at: 2007/1/6 16:45:14, returned true
Running: PerformSCCAction at: 2007/1/6 16:45:14
Complete: PerformSCCAction at: 2007/1/6 16:45:14, returned true
Running: ActivateLoggingAction at: 2007/1/6 16:45:14
Complete: ActivateLoggingAction at: 2007/1/6 16:45:14, returned true
Running: DetectPatchedBootstrapAction at: 2007/1/6 16:45:14
Complete: DetectPatchedBootstrapAction at: 2007/1/6 16:45:14, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2560" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions:
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2007/1/6 16:45:14
Complete: PerformDotNetCheck2 at: 2007/1/6 16:45:14, returned true
Running: InvokeSqlSetupDllAction at: 2007/1/6 16:45:14
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.1399.0
<Func Name='DwLaunchMsiExec'>
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [ANTHONYY1]
Trying to find Product Code from command line or passed transform
If possible, determine install id and type
Trying to find Instance Name from command line.
No Instance Name provided on the command line
If possible, determine action
Machine = ANTHONYY1, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = XMLDomDocument, Result = 0 (0x0)
Machine = ANTHONYY1, Article = Processor, Result = 0 (0x0)
Machine = ANTHONYY1, Article = PhysicalMemory, Result = 0 (0x0)
Machine = ANTHONYY1, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = ANTHONYY1, Article = OSVersion, Result = 0 (0x0)
Machine = ANTHONYY1, Article = OSServicePack, Result = 0 (0x0)
Machine = ANTHONYY1, Article = OSType, Result = 0 (0x0)
Machine = ANTHONYY1, Article = iisDep, Result = 0 (0x0)
Machine = ANTHONYY1, Article = AdminShare, Result = 0 (0x0)
Machine = ANTHONYY1, Article = PendingReboot, Result = 70011 (0x1117b)
Machine = ANTHONYY1, Article = PerfMon, Result = 0 (0x0)
Machine = ANTHONYY1, Article = IEVersion, Result = 0 (0x0)
Machine = ANTHONYY1, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = ANTHONYY1, Article = COMPlus, Result = 0 (0x0)
Machine = ANTHONYY1, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = ANTHONYY1, Article = MDAC25Version, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: ANTHONYY1
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
<Func Name='DisplaySCCWizard'>
CSetupBootstrapWizard returned 1
<EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'>
Failed to find help file for LCID :2057
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0
<EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2007/1/6 16:49:35, returned true
Running: SetPackageInstallStateAction at: 2007/1/6 16:49:35
Complete: SetPackageInstallStateAction at: 2007/1/6 16:49:36, returned true
Running: DeterminePackageTransformsAction at: 2007/1/6 16:49:36
Complete: DeterminePackageTransformsAction at: 2007/1/6 16:49:47, returned true
Running: ValidateSetupPropertiesAction at: 2007/1/6 16:49:47
Complete: ValidateSetupPropertiesAction at: 2007/1/6 16:49:47, returned true
Running: OpenPipeAction at: 2007/1/6 16:49:47
Complete: OpenPipeAction at: 2007/1/6 16:49:47, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2007/1/6 16:49:47
Complete: CreatePipeAction at: 2007/1/6 16:49:47, returned false
Error: Action "CreatePipeAction" failed during execution.
Action "RunRemoteSetupAction" will be skipped due to the following restrictions:
Condition "Action: CreatePipeAction has finished and passed." returned false.
Running: PopulateMutatorDbAction at: 2007/1/6 16:49:47
Complete: PopulateMutatorDbAction at: 2007/1/6 16:49:47, returned true
Running: GenerateRequestsAction at: 2007/1/6 16:49:47
SQL_Engine = 3
SQL_Data_Files = 3
SQL_Replication = 3
SQL_FullText = 3
SQL_SharedTools = 3
SQL_BC_DEP = 3
Analysis_Server = -1
AnalysisDataFiles = -1
AnalysisSharedTools = -1
RS_Server = -1
RS_Web_Interface = -1
RS_SharedTools = -1
Notification_Services = -1
NS_Engine = -1
NS_Client = -1
SQL_DTS = -1
Client_Components = 3
Connectivity = 3
SQL_Tools90 = 3
SQL_WarehouseDevWorkbench = 3
SDK = 3
SQLXML = 3
Tools_Legacy = 3
TOOLS_BC_DEP = 3
SQL_Documentation = 3
SQL_BooksOnline = 3
SQL_DatabaseSamples = -1
SQL_AdventureWorksSamples = -1
SQL_AdventureWorksDWSamples = -1
SQL_AdventureWorksASSamples = -1
SQL_Samples = -1
Complete: GenerateRequestsAction at: 2007/1/6 16:49:48, returned true
Running: CreateProgressWindowAction at: 2007/1/6 16:49:48
Complete: CreateProgressWindowAction at: 2007/1/6 16:49:48, returned true
Running: ScheduleActionAction at: 2007/1/6 16:49:48
Complete: ScheduleActionAction at: 2007/1/6 16:49:48, returned true
Skipped: InstallASAction.11
Skipped: Action "InstallASAction.11" was not run. Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.18
Skipped: Action "InstallASAction.18" was not run. Information reported during analysis:
No install request found for package: "owc11", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.22
Skipped: Action "InstallASAction.22" was not run. Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.9
Skipped: Action "InstallASAction.9" was not run. Information reported during analysis:
No install request found for package: "msxml6", referred by package: "as", install will be skipped as a result.
Skipped: InstallDTSAction
Skipped: Action "InstallDTSAction" was not run. Information reported during analysis:
No install request found for package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.11
Skipped: Action "InstallDTSAction.11" was not run. Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.12
Skipped: Action "InstallDTSAction.12" was not run. Information reported during analysis:
No install request found for package: "sqlncli", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.18
Skipped: Action "InstallDTSAction.18" was not run. Information reported during analysis:
No install request found for package: "owc11", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.22
Skipped: Action "InstallDTSAction.22" was not run. Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.9
Skipped: Action "InstallDTSAction.9" was not run. Information reported during analysis:
No install request found for package: "msxml6", referred by package: "dts", install will be skipped as a result.
Skipped: InstallNSAction
Skipped: Action "InstallNSAction" was not run. Information reported during analysis:
No install request found for package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.11
Skipped: Action "InstallNSAction.11" was not run. Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.12
Skipped: Action "InstallNSAction.12" was not run. Information reported during analysis:
No install request found for package: "sqlncli", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.18
Skipped: Action "InstallNSAction.18" was not run. Information reported during analysis:
No install request found for package: "owc11", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.22
Skipped: Action "InstallNSAction.22" was not run. Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.9
Skipped: Action "InstallNSAction.9" was not run. Information reported during analysis:
No install request found for package: "msxml6", referred by package: "ns", install will be skipped as a result.
Skipped: InstallRSAction.11
Skipped: Action "InstallRSAction.11" was not run. Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.18
Skipped: Action "InstallRSAction.18" was not run. Information reported during analysis:
No install request found for package: "owc11", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.22
Skipped: Action "InstallRSAction.22" was not run. Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "rs", install will be skipped as a result.
Running: InstallSqlAction.11 at: 2007/1/6 16:49:48
Installing: sqlsupport on target: ANTHONYY1
Complete: InstallSqlAction.11 at: 2007/1/6 16:49:51, returned true
Running: InstallSqlAction.12 at: 2007/1/6 16:49:51
Installing: sqlncli on target: ANTHONYY1
Complete: InstallSqlAction.12 at: 2007/1/6 16:49:55, returned true
Running: InstallSqlAction.18 at: 2007/1/6 16:49:55
Installing: owc11 on target: ANTHONYY1
Complete: InstallSqlAction.18 at: 2007/1/6 16:49:56, returned true
Running: InstallSqlAction.21 at: 2007/1/6 16:49:56
Installing: sqlwriter on target: ANTHONYY1
Complete: InstallSqlAction.21 at: 2007/1/6 16:49:58, returned true
Running: InstallSqlAction.22 at: 2007/1/6 16:49:58
Installing: bcRedist on target: ANTHONYY1
Complete: InstallSqlAction.22 at: 2007/1/6 16:50:0, returned true
Running: InstallSqlAction.9 at: 2007/1/6 16:50:0
Installing: msxml6 on target: ANTHONYY1
Complete: InstallSqlAction.9 at: 2007/1/6 16:50:2, returned true
Running: InstallToolsAction.11 at: 2007/1/6 16:50:2
Installing: sqlsupport on target: ANTHONYY1
Complete: InstallToolsAction.11 at: 2007/1/6 16:50:5, returned true
Running: InstallToolsAction.12 at: 2007/1/6 16:50:5
Installing: sqlncli on target: ANTHONYY1
Complete: InstallToolsAction.12 at: 2007/1/6 16:50:8, returned true
Skipped: InstallToolsAction.13
Skipped: Action "InstallToolsAction.13" was not run. Information reported during analysis:
No install request found for package: "PPESku", referred by package: "tools", install will be skipped as a result.
Running: InstallToolsAction.18 at: 2007/1/6 16:50:8
Installing: owc11 on target: ANTHONYY1
Complete: InstallToolsAction.18 at: 2007/1/6 16:50:10, returned true
Running: InstallToolsAction.20 at: 2007/1/6 16:50:10
Installing: BOL on target: ANTHONYY1
Complete: InstallToolsAction.20 at: 2007/1/6 16:52:2, returned true
Running: InstallToolsAction.22 at: 2007/1/6 16:52:2
Installing: bcRedist on target: ANTHONYY1
Complete: InstallToolsAction.22 at: 2007/1/6 16:52:4, returned true
Running: InstallToolsAction.9 at: 2007/1/6 16:52:4
Installing: msxml6 on target: ANTHONYY1
Complete: InstallToolsAction.9 at: 2007/1/6 16:52:6, returned true
Skipped: InstallNSAction.10
Skipped: Action "InstallNSAction.10" was not run. Information reported during analysis:
No install request found for package: "sqlxml4", referred by package: "ns", install will be skipped as a result.
Running: InstallSqlAction at: 2007/1/6 16:52:7
Installing: sql on target: ANTHONYY1
Error: MsiOpenDatabase failed with 110
Failed to install package
This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package.
Error: MsiOpenDatabase failed with 110 for MSI D:ServersSetupSqlRun_SQL.msi
Setting package return code to: 1620
Complete: InstallSqlAction at: 2007/1/6 16:52:27, returned false
Error: Action "InstallSqlAction" failed during execution. Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Running: InstallToolsAction.10 at: 2007/1/6 16:52:27
Installing: sqlxml4 on target: ANTHONYY1
Error Code: 0x8007006e (110)
Windows Error Text: The system cannot open the device or file specified.
Source File Name: sqlchainingminorbuildactionbehavior.cpp
Compiler Timestamp: Mon Jun 13 14:30:04 2005
Function Name: sqls::MinorBuildActionBehavior::modifyRequest
Source Line Number: 65
---- Context -----------------------------------------------
sqls::InstallPackageAction::perform
Complete: InstallToolsAction.10 at: 2007/1/6 16:55:59, returned false
Error: Action "InstallToolsAction.10" failed during execution. Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Action "InstallToolsAction" will return false due to the following preconditions:
Condition "Action: InstallToolsAction.10 has finished and failed." returned true.
Installation of package: "tools" failed due to a precondition.
Step "InstallToolsAction" was not able to run.
Skipped: InstallASAction
Skipped: Action "InstallASAction" was not run. Information reported during analysis:
No install request found for package: "as", install will be skipped as a result.
Skipped: InstallRSAction
Skipped: Action "InstallRSAction" was not run. Information reported during analysis:
No install request found for package: "rs", install will be skipped as a result.
Skipped: RepairForBackwardsCompatRedistAction
Skipped: Action "RepairForBackwardsCompatRedistAction" was not run. Information reported during analysis:
Action: "RepairForBackwardsCompatRedistAction" will be skipped due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Error: Action "UninstallForMSDE2000Action" failed during execution. Error information reported during run:
Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchMSDE2000" failed due to a precondition.
Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run:
Action: "UninstallForSQLAction" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchLibertySql" failed due to a precondition.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following condition:
Condition "Action: InstallRSAction was skipped." returned true.
Running: ReportChainingResults at: 2007/1/6 16:55:59
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 1620
Error Code: 0x80070654 (1620)
Windows Error Text: This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package.
Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Thu Sep 1 22:23:05 2005
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3097
---- Context -----------------------------------------------
sqls::HostSetupPackageInstallerSynch::postCommit
sqls::HighlyAvailablePackage::preInstall
led due to cancel code received from cancel source: 29539
...and here is the SQLSetup0011_ANTHONYY1_SQL.log:
=== Verbose logging started: 06/02/2007 16:52:14 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (00:54) [16:52:14:284]: Resetting cached policy values
MSI (c) (00:54) [16:52:14:284]: Machine policy value 'Debug' is 0
MSI (c) (00:54) [16:52:14:284]: ******* RunEngine:
******* Product: D:ServersSetupSqlRun_SQL.msi
******* Action:
******* CommandLine: **********
MSI (c) (00:54) [16:52:14:284]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (00:54) [16:52:14:284]: Grabbed execution mutex.
MSI (c) (00:54) [16:52:14:299]: Cloaking enabled.
MSI (c) (00:54) [16:52:14:299]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (00:54) [16:52:14:299]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (A4:98) [16:52:14:299]: Grabbed execution mutex.
MSI (s) (A4:00) [16:52:14:299]: Resetting cached policy values
MSI (s) (A4:00) [16:52:14:299]: Machine policy value 'Debug' is 0
MSI (s) (A4:00) [16:52:14:299]: ******* RunEngine:
******* Product: D:ServersSetupSqlRun_SQL.msi
******* Action:
******* CommandLine: **********
MSI (s) (A4:00) [16:52:21:080]: Note: 1: 2203 2: D:ServersSetupSqlRun_SQL.msi 3: -2147024873
MSI (s) (A4:00) [16:52:21:080]: MainEngineThread is returning 1620
MSI (c) (00:54) [16:52:21:080]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (00:54) [16:52:21:080]: MainEngineThread is returning 1620
=== Verbose logging stopped: 06/02/2007 16:52:21 ===
I suppose an error dialog (or log message) that actually told you what is wrong and then what to do is too much to ask for. (Or an installer than just copied all the files into place). :(
View 4 Replies
View Related