We are running a SQL within an Active Active Windows
Cluster setup. Will I run into any issues when attempting
to patch SQL with SQL SP3? Are there any issues I should
be aware of when patching the SQL cluster or any
prerequisite patches that need to be applied before
patching SQL in a cluster?
This is a rather open ended question. Are you talking about a specific
patch or just patches in general
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I am speaking of a general Serivce Pack 3a update. When dealing with virtual servers, are there any issues when applying the SP3a update?
rp
-- Rand Boyd [MSFT] wrote: --
This is a rather open ended question. Are you talking about a specific
patch or just patches in general
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Not really anything special. Make sure all nodes are online and are capable
of hosting the service. You will need to run the service pack from the node
hosting the particular instance you wish to update. If you have more than
one instance, you will need to apply the Service Pack to each instance
independantly. It is possible to run different instances at different
service pack and hotfix levels without a problem. Of course all instances
on a particular host will run against the same level MDAC installation. If
you run into any issues, you know where to find help.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Bob" <anonymous@.discussions.microsoft.com> wrote in message
news:02068577-4EB9-472E-A36E-D21EF109FC91@.microsoft.com...
> I am speaking of a general Serivce Pack 3a update. When dealing with
virtual servers, are there any issues when applying the SP3a update?
> rp
> -- Rand Boyd [MSFT] wrote: --
> This is a rather open ended question. Are you talking about a
specific
> patch or just patches in general
> Rand
> This posting is provided "as is" with no warranties and confers no
rights.
>
|||Before applying any service pack, always review the readme. For sp3a on a
cluster, see:
811168 INF: SQL Server 2000 Service Pack 3 or Service Pack 3a
Pre-Installation
http://support.microsoft.com/?id=811168
And you should strongly consider applying the MS03-031 security rollup as
well.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Cindy. I didn't know you had joined Microsoft.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
Showing posts with label patch. Show all posts
Showing posts with label patch. Show all posts
Tuesday, March 20, 2012
Patch SP4 hanging
SP4 installation hangs. I used windows login to do the patch, a message
saying that it is not a valid user. I selected "retry" then used "sa". It
started hanging when "...MDAC" message disappeared.
I checked c:\winnt\sqlsp.log file. It is different from the files on the
other normal patched servers.
The last 2 lines in the file are:
End: Installpkgs(ID_INSTALLMDAC)
**** Starting open OP in write mode ****
What is the cause? How to fix it?
Hi Julia
You may want to try using the MDAC component checker to see if you have a
consistent installation of MDAC and possibly loading MDAC MDAC 2.8 SP1 if on
Windows 2000 or MDAC 2.8 SP2 if on XP/Windows 2003 before installing the
service pack.
http://www.microsoft.com/downloads/r...splayLang= en
John
"Julia" <Julia@.discussions.microsoft.com> wrote in message
news:686DFD79-5223-4A80-BF1B-99469046BF5D@.microsoft.com...
> SP4 installation hangs. I used windows login to do the patch, a message
> saying that it is not a valid user. I selected "retry" then used "sa".
> It
> started hanging when "...MDAC" message disappeared.
> I checked c:\winnt\sqlsp.log file. It is different from the files on the
> other normal patched servers.
> The last 2 lines in the file are:
> End: Installpkgs(ID_INSTALLMDAC)
> **** Starting open OP in write mode ****
> What is the cause? How to fix it?
saying that it is not a valid user. I selected "retry" then used "sa". It
started hanging when "...MDAC" message disappeared.
I checked c:\winnt\sqlsp.log file. It is different from the files on the
other normal patched servers.
The last 2 lines in the file are:
End: Installpkgs(ID_INSTALLMDAC)
**** Starting open OP in write mode ****
What is the cause? How to fix it?
Hi Julia
You may want to try using the MDAC component checker to see if you have a
consistent installation of MDAC and possibly loading MDAC MDAC 2.8 SP1 if on
Windows 2000 or MDAC 2.8 SP2 if on XP/Windows 2003 before installing the
service pack.
http://www.microsoft.com/downloads/r...splayLang= en
John
"Julia" <Julia@.discussions.microsoft.com> wrote in message
news:686DFD79-5223-4A80-BF1B-99469046BF5D@.microsoft.com...
> SP4 installation hangs. I used windows login to do the patch, a message
> saying that it is not a valid user. I selected "retry" then used "sa".
> It
> started hanging when "...MDAC" message disappeared.
> I checked c:\winnt\sqlsp.log file. It is different from the files on the
> other normal patched servers.
> The last 2 lines in the file are:
> End: Installpkgs(ID_INSTALLMDAC)
> **** Starting open OP in write mode ****
> What is the cause? How to fix it?
Patch SP4 hanging
SP4 installation hangs. I used windows login to do the patch, a message
saying that it is not a valid user. I selected "retry" then used "sa". It
started hanging when "...MDAC" message disappeared.
I checked c:\winnt\sqlsp.log file. It is different from the files on the
other normal patched servers.
The last 2 lines in the file are:
End: Installpkgs(ID_INSTALLMDAC)
**** Starting open OP in write mode ****
What is the cause? How to fix it?Hi Julia
You may want to try using the MDAC component checker to see if you have a
consistent installation of MDAC and possibly loading MDAC MDAC 2.8 SP1 if on
Windows 2000 or MDAC 2.8 SP2 if on XP/Windows 2003 before installing the
service pack.
http://www.microsoft.com/downloads/results.aspx?productID=&freetext=mdac&DisplayLang=en
John
"Julia" <Julia@.discussions.microsoft.com> wrote in message
news:686DFD79-5223-4A80-BF1B-99469046BF5D@.microsoft.com...
> SP4 installation hangs. I used windows login to do the patch, a message
> saying that it is not a valid user. I selected "retry" then used "sa".
> It
> started hanging when "...MDAC" message disappeared.
> I checked c:\winnt\sqlsp.log file. It is different from the files on the
> other normal patched servers.
> The last 2 lines in the file are:
> End: Installpkgs(ID_INSTALLMDAC)
> **** Starting open OP in write mode ****
> What is the cause? How to fix it?
saying that it is not a valid user. I selected "retry" then used "sa". It
started hanging when "...MDAC" message disappeared.
I checked c:\winnt\sqlsp.log file. It is different from the files on the
other normal patched servers.
The last 2 lines in the file are:
End: Installpkgs(ID_INSTALLMDAC)
**** Starting open OP in write mode ****
What is the cause? How to fix it?Hi Julia
You may want to try using the MDAC component checker to see if you have a
consistent installation of MDAC and possibly loading MDAC MDAC 2.8 SP1 if on
Windows 2000 or MDAC 2.8 SP2 if on XP/Windows 2003 before installing the
service pack.
http://www.microsoft.com/downloads/results.aspx?productID=&freetext=mdac&DisplayLang=en
John
"Julia" <Julia@.discussions.microsoft.com> wrote in message
news:686DFD79-5223-4A80-BF1B-99469046BF5D@.microsoft.com...
> SP4 installation hangs. I used windows login to do the patch, a message
> saying that it is not a valid user. I selected "retry" then used "sa".
> It
> started hanging when "...MDAC" message disappeared.
> I checked c:\winnt\sqlsp.log file. It is different from the files on the
> other normal patched servers.
> The last 2 lines in the file are:
> End: Installpkgs(ID_INSTALLMDAC)
> **** Starting open OP in write mode ****
> What is the cause? How to fix it?
Monday, March 12, 2012
Patch SP4 hanging
SP4 installation hangs. I used windows login to do the patch, a message
saying that it is not a valid user. I selected "retry" then used "sa". It
started hanging when "...MDAC" message disappeared.
I checked c:\winnt\sqlsp.log file. It is different from the files on the
other normal patched servers.
The last 2 lines in the file are:
End: Installpkgs(ID_INSTALLMDAC)
**** Starting open OP in write mode ****
What is the cause? How to fix it?Hi Julia
You may want to try using the MDAC component checker to see if you have a
consistent installation of MDAC and possibly loading MDAC MDAC 2.8 SP1 if on
Windows 2000 or MDAC 2.8 SP2 if on XP/Windows 2003 before installing the
service pack.
http://www.microsoft.com/downloads/...La
ng=en
John
"Julia" <Julia@.discussions.microsoft.com> wrote in message
news:686DFD79-5223-4A80-BF1B-99469046BF5D@.microsoft.com...
> SP4 installation hangs. I used windows login to do the patch, a message
> saying that it is not a valid user. I selected "retry" then used "sa".
> It
> started hanging when "...MDAC" message disappeared.
> I checked c:\winnt\sqlsp.log file. It is different from the files on the
> other normal patched servers.
> The last 2 lines in the file are:
> End: Installpkgs(ID_INSTALLMDAC)
> **** Starting open OP in write mode ****
> What is the cause? How to fix it?
saying that it is not a valid user. I selected "retry" then used "sa". It
started hanging when "...MDAC" message disappeared.
I checked c:\winnt\sqlsp.log file. It is different from the files on the
other normal patched servers.
The last 2 lines in the file are:
End: Installpkgs(ID_INSTALLMDAC)
**** Starting open OP in write mode ****
What is the cause? How to fix it?Hi Julia
You may want to try using the MDAC component checker to see if you have a
consistent installation of MDAC and possibly loading MDAC MDAC 2.8 SP1 if on
Windows 2000 or MDAC 2.8 SP2 if on XP/Windows 2003 before installing the
service pack.
http://www.microsoft.com/downloads/...La
ng=en
John
"Julia" <Julia@.discussions.microsoft.com> wrote in message
news:686DFD79-5223-4A80-BF1B-99469046BF5D@.microsoft.com...
> SP4 installation hangs. I used windows login to do the patch, a message
> saying that it is not a valid user. I selected "retry" then used "sa".
> It
> started hanging when "...MDAC" message disappeared.
> I checked c:\winnt\sqlsp.log file. It is different from the files on the
> other normal patched servers.
> The last 2 lines in the file are:
> End: Installpkgs(ID_INSTALLMDAC)
> **** Starting open OP in write mode ****
> What is the cause? How to fix it?
Patch question re: SQL 7.0 SP4
I'm getting ready to apply SQL 7.0 SP4 and the SQL Server instance is running on Win NT
4.0 SP6. According to http://support.microsoft.com/?id=327068, there is an
O/S patch that needs to be applied, per KB 258437. Fine and well, but then
I see in http:/
/support.microsoft.com/?id=821279 that this patch superseeds (sp?) the previ
ous SQL patch.
So, all that being said, do I still need to apply the O/S patch in KB 258437
? At what point to I apply the patch; before SP4, between SP4 and KB 821279
, or after KB 821279?
Better yet, how do I convince management / users / vendors to upgrade to Win
2K / SQL 2K? ;-)
TIA,
Mike
mstuart_nospam@.gates.comAll,
FYI, I spoke to some folks at Microsoft, and I was told to install SP4 then KB821279 (p
atch available at http://www.microsoft.com/downloads/...&displaylang=en) and that should take care of i
t.
Mike
4.0 SP6. According to http://support.microsoft.com/?id=327068, there is an
O/S patch that needs to be applied, per KB 258437. Fine and well, but then
I see in http:/
/support.microsoft.com/?id=821279 that this patch superseeds (sp?) the previ
ous SQL patch.
So, all that being said, do I still need to apply the O/S patch in KB 258437
? At what point to I apply the patch; before SP4, between SP4 and KB 821279
, or after KB 821279?
Better yet, how do I convince management / users / vendors to upgrade to Win
2K / SQL 2K? ;-)
TIA,
Mike
mstuart_nospam@.gates.comAll,
FYI, I spoke to some folks at Microsoft, and I was told to install SP4 then KB821279 (p
atch available at http://www.microsoft.com/downloads/...&displaylang=en) and that should take care of i
t.
Mike
patch null value?
following is my sql:
select a.dcode, b.district from table1 a, table2 b
where
a.id = b.id
and return following result:
dcode district
123 south
321 north
456 east
789 west
123
789
so for those records that district are null, how can i fill them up as i know they have the same dcode as the other records?
use Isnull or coalesce
Code Snippet
select a.dcode, isnull(b.district,-1) from table1 a, table2 b
where
a.id = b.id
--or
select a.dcode, COALESCE(b.district,-1) from table1 a, table2 b
where
a.id = b.id
|||This could possibly point towards a de-normalized database design.
It might be better if you created a separate lookup table to store a distinct list of 'dcode' values against the appropriate 'district' value (and possibly even split distinct 'district' values out to a second lookup table) - you could then store 'dcode' in both table1 and table2 and remove the 'district' column from table2. Depending on your database design there may even be scope to store 'dcode' in either table1 or table2 (and not both).
Granted, you might have to re-work substantial amounts of code but it would help you in situations such as the one you're currently facing and would, more importantly, help to maintain the integrity of your data.
Chris
|||Joe,
Below is one way that you could accomplish this.
declare @.temptable table
(dcode int,
district varchar(20))
insert into @.temptable values (123,'south')
insert into @.temptable values (321,'north')
insert into @.temptable values (456,'east')
insert into @.temptable values (789,'west')
insert into @.temptable values (123,NULL)
insert into @.temptable values (789,NULL)
select a.dcode,COALESCE(a.district,b.district,'')
from @.temptable a
left join (select dcode,district
from @.temptable
where district is not null) b
on a.dcode = b.dcode
Let me know if you have any other questions.
crusso.
|||I completely agree with Chris that you have an improperly desiged database.
First thing: You need to create a District table that has a district code/Id and description, and use this code in both of your tables. This fixes the inconsistency of codes.
Second: Why are you recording district in both tables? (your names give no clue) Does this district mean the same thing? Or could the be different for some logical reason? If they have the same meaning, then delete one and join to get the other one if you need it in a query. This will make sure that you don't get out of sync values.
|||
i've figured myself how to solve this problem:
select a.dcode, b.district into #temp from table1 a, table2 b
where
a.id = b.id
I
I
I
V
update #tempset district = b.district
from #temp a, (select * from #temp) b
where
a.dcode = b.dcode
and
a.district is null
patch null value?
following is my sql:
select a.dcode, b.district from table1 a, table2 b
where
a.id = b.id
and return following result:
dcode district
123 south
321 north
456 east
789 west
123
789
so for those records that district are null, how can i fill them up as i know they have the same dcode as the other records?
use Isnull or coalesce
Code Snippet
select a.dcode, isnull(b.district,-1) from table1 a, table2 b
where
a.id = b.id
--or
select a.dcode, COALESCE(b.district,-1) from table1 a, table2 b
where
a.id = b.id
|||This could possibly point towards a de-normalized database design.
It might be better if you created a separate lookup table to store a distinct list of 'dcode' values against the appropriate 'district' value (and possibly even split distinct 'district' values out to a second lookup table) - you could then store 'dcode' in both table1 and table2 and remove the 'district' column from table2. Depending on your database design there may even be scope to store 'dcode' in either table1 or table2 (and not both).
Granted, you might have to re-work substantial amounts of code but it would help you in situations such as the one you're currently facing and would, more importantly, help to maintain the integrity of your data.
Chris
|||Joe,
Below is one way that you could accomplish this.
declare @.temptable table
(dcode int,
district varchar(20))
insert into @.temptable values (123,'south')
insert into @.temptable values (321,'north')
insert into @.temptable values (456,'east')
insert into @.temptable values (789,'west')
insert into @.temptable values (123,NULL)
insert into @.temptable values (789,NULL)
select a.dcode,COALESCE(a.district,b.district,'')
from @.temptable a
left join (select dcode,district
from @.temptable
where district is not null) b
on a.dcode = b.dcode
Let me know if you have any other questions.
crusso.
|||I completely agree with Chris that you have an improperly desiged database.
First thing: You need to create a District table that has a district code/Id and description, and use this code in both of your tables. This fixes the inconsistency of codes.
Second: Why are you recording district in both tables? (your names give no clue) Does this district mean the same thing? Or could the be different for some logical reason? If they have the same meaning, then delete one and join to get the other one if you need it in a query. This will make sure that you don't get out of sync values.
|||i've figured myself how to solve this problem:
select a.dcode, b.district into #temp from table1 a, table2 b
where
a.id = b.id
I
I
I
V
update #tempset district = b.district
from #temp a, (select * from #temp) b
where
a.dcode = b.dcode
and
a.district is null
patch null value?
following is my sql:
select a.dcode, b.district from table1 a, table2 b
where
a.id = b.id
and return following result:
dcode district
123 south
321 north
456 east
789 west
123
789
so for those records that district are null, how can i fill them up as i know they have the same dcode as the other records?
use Isnull or coalesce
Code Snippet
select a.dcode, isnull(b.district,-1) from table1 a, table2 b
where
a.id = b.id
--or
select a.dcode, COALESCE(b.district,-1) from table1 a, table2 b
where
a.id = b.id
|||This could possibly point towards a de-normalized database design.
It might be better if you created a separate lookup table to store a distinct list of 'dcode' values against the appropriate 'district' value (and possibly even split distinct 'district' values out to a second lookup table) - you could then store 'dcode' in both table1 and table2 and remove the 'district' column from table2. Depending on your database design there may even be scope to store 'dcode' in either table1 or table2 (and not both).
Granted, you might have to re-work substantial amounts of code but it would help you in situations such as the one you're currently facing and would, more importantly, help to maintain the integrity of your data.
Chris
|||Joe,
Below is one way that you could accomplish this.
declare @.temptable table
(dcode int,
district varchar(20))
insert into @.temptable values (123,'south')
insert into @.temptable values (321,'north')
insert into @.temptable values (456,'east')
insert into @.temptable values (789,'west')
insert into @.temptable values (123,NULL)
insert into @.temptable values (789,NULL)
select a.dcode,COALESCE(a.district,b.district,'')
from @.temptable a
left join (select dcode,district
from @.temptable
where district is not null) b
on a.dcode = b.dcode
Let me know if you have any other questions.
crusso.
|||I completely agree with Chris that you have an improperly desiged database.
First thing: You need to create a District table that has a district code/Id and description, and use this code in both of your tables. This fixes the inconsistency of codes.
Second: Why are you recording district in both tables? (your names give no clue) Does this district mean the same thing? Or could the be different for some logical reason? If they have the same meaning, then delete one and join to get the other one if you need it in a query. This will make sure that you don't get out of sync values.
|||
i've figured myself how to solve this problem:
select a.dcode, b.district into #temp from table1 a, table2 b
where
a.id = b.id
I
I
I
V
update #tempset district = b.district
from #temp a, (select * from #temp) b
where
a.dcode = b.dcode
and
a.district is null
Patch needed for Q178642
Hi there,
Could anyone tell me if there's a patch for the above
mention article?
Thank you
Regards,Keith
Have you tried to search on www.microsoft.com?
"Keith" <leong@.nti.com.my> wrote in message
news:38a601c34059$5d3b72f0$a601280a@.phx.gbl...
> Hi there,
> Could anyone tell me if there's a patch for the above
> mention article?
> Thank you
> Regards,
>
Could anyone tell me if there's a patch for the above
mention article?
Thank you
Regards,Keith
Have you tried to search on www.microsoft.com?
"Keith" <leong@.nti.com.my> wrote in message
news:38a601c34059$5d3b72f0$a601280a@.phx.gbl...
> Hi there,
> Could anyone tell me if there's a patch for the above
> mention article?
> Thank you
> Regards,
>
patch management
Hi experts!
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:
> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it wa
s
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+
)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:
>
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:
> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it wa
s
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+
)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:
>
patch management
Hi experts!
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
--
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:
> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:
> > Hi experts!
> >
> > Our domain has about 50+ sql servers most of them dedicated and some are
> > multi-instance
> > I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> > still scanning but output file was with 0 size and I
> > canselled the scan. What is the reason for this behavior?
> > Tried with ip ranges and it works fine
> > How to scan all domain and avoid using ip ranges bc they are so many (100+)
> > and it will be hard work.
> > Please share your experiense updating sql servers with sp and security
> > patches. Is there a useful tools for scanning and patching domain with big
> > number sql machines.
> > Thanks in advance.
> >
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
--
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:
> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:
> > Hi experts!
> >
> > Our domain has about 50+ sql servers most of them dedicated and some are
> > multi-instance
> > I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> > still scanning but output file was with 0 size and I
> > canselled the scan. What is the reason for this behavior?
> > Tried with ip ranges and it works fine
> > How to scan all domain and avoid using ip ranges bc they are so many (100+)
> > and it will be hard work.
> > Please share your experiense updating sql servers with sp and security
> > patches. Is there a useful tools for scanning and patching domain with big
> > number sql machines.
> > Thanks in advance.
> >
patch management
Hi experts!
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.
use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:
> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>
|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.
use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:
> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>
|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:
Patch Level
What patch level is:
Microsoft SQL Server 7.00 - 7.00.1141
It SP4 but what Q article is also installed. Looked
everywhere and all I can find is 7.00.1094 which is
SP4+Q815495
Thanks in advanceHi,
I tried looking and could not find anything either.
But there is back door approach: you could look at the
patches installed on the server by going to through the
control panel and going through Add or Remove Programs.
You will be able to see any hot fixes that are installed
on your machine. You could then narrow your search.
hth
DeeJay
>--Original Message--
>What patch level is:
>Microsoft SQL Server 7.00 - 7.00.1141
>It SP4 but what Q article is also installed. Looked
>everywhere and all I can find is 7.00.1094 which is
>SP4+Q815495
>Thanks in advance
>.
>|||It should be 828090
Rand
This posting is provided "as is" with no warranties and confers no rights.
Microsoft SQL Server 7.00 - 7.00.1141
It SP4 but what Q article is also installed. Looked
everywhere and all I can find is 7.00.1094 which is
SP4+Q815495
Thanks in advanceHi,
I tried looking and could not find anything either.
But there is back door approach: you could look at the
patches installed on the server by going to through the
control panel and going through Add or Remove Programs.
You will be able to see any hot fixes that are installed
on your machine. You could then narrow your search.
hth
DeeJay
>--Original Message--
>What patch level is:
>Microsoft SQL Server 7.00 - 7.00.1141
>It SP4 but what Q article is also installed. Looked
>everywhere and all I can find is 7.00.1094 which is
>SP4+Q815495
>Thanks in advance
>.
>|||It should be 828090
Rand
This posting is provided "as is" with no warranties and confers no rights.
Patch KB815495-8.00.0818-ENU ?
I am so very weary of these patches and Service packs for SQL 2000. So = very weary of them. But I'm even more weary of not applying them as the = last SQL worm made evident. The only way I was able to successfully = install Service Pack 3 was by completely renmoving SQL from my Windows = 2000 and then reinstalling from the CD-ROM and then applying SP3.
I really do not want to go through that again. Are there any issues = that I should consider before trying to apply this July 23, 2003 patch? = Here's my plan:
Run the download.
How does that sound?
-- George Hester
__________________________________I hear what you're saying..
I applied the security patch to 4 servers on Thursday, 2
were live production systems, 1 development and 1 QA. I
must say I was a little too anxious to apply them.
The patch stopped and started the server, which lasted
out 10 seconds. I haven't run into any problems..course
that's not to say that you won't have different results..
scary eh?
Good luck!
steph
>--Original Message--
>I am so very weary of these patches and Service packs
for SQL 2000. So very weary of them. But I'm even more
weary of not applying them as the last SQL worm made
evident. The only way I was able to successfully install
Service Pack 3 was by completely renmoving SQL from my
Windows 2000 and then reinstalling from the CD-ROM and
then applying SP3.
>I really do not want to go through that again. Are
there any issues that I should consider before trying to
apply this July 23, 2003 patch? Here's my plan:
>Run the download.
>How does that sound?
>--
>George Hester
>__________________________________
>.
>
I really do not want to go through that again. Are there any issues = that I should consider before trying to apply this July 23, 2003 patch? = Here's my plan:
Run the download.
How does that sound?
-- George Hester
__________________________________I hear what you're saying..
I applied the security patch to 4 servers on Thursday, 2
were live production systems, 1 development and 1 QA. I
must say I was a little too anxious to apply them.
The patch stopped and started the server, which lasted
out 10 seconds. I haven't run into any problems..course
that's not to say that you won't have different results..
scary eh?
Good luck!
steph
>--Original Message--
>I am so very weary of these patches and Service packs
for SQL 2000. So very weary of them. But I'm even more
weary of not applying them as the last SQL worm made
evident. The only way I was able to successfully install
Service Pack 3 was by completely renmoving SQL from my
Windows 2000 and then reinstalling from the CD-ROM and
then applying SP3.
>I really do not want to go through that again. Are
there any issues that I should consider before trying to
apply this July 23, 2003 patch? Here's my plan:
>Run the download.
>How does that sound?
>--
>George Hester
>__________________________________
>.
>
PATCH for Article 817326
I am desperately looking for the patch across the internet
cause i really need this fix basically for WINDOWS
platform listed as follows:
Msbase.jar v 2.2.0030
Mssqlserver.jar v 2.2.0030
Msutil.jar v 2.2.0030
Please advise where can i extract all these patches.
DondonYou need to contact Microsoft product support. As the article states, the
fix is only available directly through them. You won't readily find them on
the Internet because of this.
"Dondon" <dondon@.newspage.com.sg> wrote in message
news:016701c38707$3bd80700$a001280a@.phx.gbl...
> I am desperately looking for the patch across the internet
> cause i really need this fix basically for WINDOWS
> platform listed as follows:
> Msbase.jar v 2.2.0030
> Mssqlserver.jar v 2.2.0030
> Msutil.jar v 2.2.0030
> Please advise where can i extract all these patches.
> Dondon
cause i really need this fix basically for WINDOWS
platform listed as follows:
Msbase.jar v 2.2.0030
Mssqlserver.jar v 2.2.0030
Msutil.jar v 2.2.0030
Please advise where can i extract all these patches.
DondonYou need to contact Microsoft product support. As the article states, the
fix is only available directly through them. You won't readily find them on
the Internet because of this.
"Dondon" <dondon@.newspage.com.sg> wrote in message
news:016701c38707$3bd80700$a001280a@.phx.gbl...
> I am desperately looking for the patch across the internet
> cause i really need this fix basically for WINDOWS
> platform listed as follows:
> Msbase.jar v 2.2.0030
> Mssqlserver.jar v 2.2.0030
> Msutil.jar v 2.2.0030
> Please advise where can i extract all these patches.
> Dondon
patch apply question
I got 4 sql2k5 servers with service patch version as following:
Microsoft SQL Server 2005 - 9.00.2221.00 (Intel X86) Feb 9 2007 17:30:38
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86) May 8 2006 22:41:28
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)
Can anyone please advise me what is the easiest way to upgrade them to the
most updated patch version? i.e. update path.
Meanwhile, what is the best practice to apply patches? Do you go to
microsoft website and check it out daily and apply it or other tricks?
Please advise. Thanks.
Hi
You may want to check out
https://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx
Post SP2 there are also some additional fixes the last publically available
hotfix is http://support.microsoft.com/?Kbid=934459
You should test your applications to make sure they are still working on the
upgraded version before moving.
John
"-Obama" wrote:
> I got 4 sql2k5 servers with service patch version as following:
> Microsoft SQL Server 2005 - 9.00.2221.00 (Intel X86) Feb 9 2007 17:30:38
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
> NT 5.2 (Build 3790: Service Pack 2)
> Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86) May 8 2006 22:41:28
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
> 5.2 (Build 3790: Service Pack 2)
> Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
> 5.2 (Build 3790: Service Pack 2)
> Can anyone please advise me what is the easiest way to upgrade them to the
> most updated patch version? i.e. update path.
> Meanwhile, what is the best practice to apply patches? Do you go to
> microsoft website and check it out daily and apply it or other tricks?
> Please advise. Thanks.
>
>
Microsoft SQL Server 2005 - 9.00.2221.00 (Intel X86) Feb 9 2007 17:30:38
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86) May 8 2006 22:41:28
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)
Can anyone please advise me what is the easiest way to upgrade them to the
most updated patch version? i.e. update path.
Meanwhile, what is the best practice to apply patches? Do you go to
microsoft website and check it out daily and apply it or other tricks?
Please advise. Thanks.
Hi
You may want to check out
https://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx
Post SP2 there are also some additional fixes the last publically available
hotfix is http://support.microsoft.com/?Kbid=934459
You should test your applications to make sure they are still working on the
upgraded version before moving.
John
"-Obama" wrote:
> I got 4 sql2k5 servers with service patch version as following:
> Microsoft SQL Server 2005 - 9.00.2221.00 (Intel X86) Feb 9 2007 17:30:38
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
> NT 5.2 (Build 3790: Service Pack 2)
> Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86) May 8 2006 22:41:28
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
> 5.2 (Build 3790: Service Pack 2)
> Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
> 5.2 (Build 3790: Service Pack 2)
> Can anyone please advise me what is the easiest way to upgrade them to the
> most updated patch version? i.e. update path.
> Meanwhile, what is the best practice to apply patches? Do you go to
> microsoft website and check it out daily and apply it or other tricks?
> Please advise. Thanks.
>
>
patch apply question
I got 4 sql2k5 servers with service patch version as following:
Microsoft SQL Server 2005 - 9.00.2221.00 (Intel X86) Feb 9 2007 17:30:38
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86) May 8 2006 22:41:28
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)
Can anyone please advise me what is the easiest way to upgrade them to the
most updated patch version? i.e. update path.
Meanwhile, what is the best practice to apply patches? Do you go to
microsoft website and check it out daily and apply it or other tricks?
Please advise. Thanks.Hi
You may want to check out
https://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx
Post SP2 there are also some additional fixes the last publically available
hotfix is http://support.microsoft.com/?Kbid=934459
You should test your applications to make sure they are still working on the
upgraded version before moving.
John
"-Obama" wrote:
> I got 4 sql2k5 servers with service patch version as following:
> Microsoft SQL Server 2005 - 9.00.2221.00 (Intel X86) Feb 9 2007 17:30:38
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
> NT 5.2 (Build 3790: Service Pack 2)
> Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86) May 8 2006 22:41:28
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
> 5.2 (Build 3790: Service Pack 2)
> Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
> 5.2 (Build 3790: Service Pack 2)
> Can anyone please advise me what is the easiest way to upgrade them to the
> most updated patch version? i.e. update path.
> Meanwhile, what is the best practice to apply patches? Do you go to
> microsoft website and check it out daily and apply it or other tricks?
> Please advise. Thanks.
>
>
Microsoft SQL Server 2005 - 9.00.2221.00 (Intel X86) Feb 9 2007 17:30:38
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86) May 8 2006 22:41:28
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)
Can anyone please advise me what is the easiest way to upgrade them to the
most updated patch version? i.e. update path.
Meanwhile, what is the best practice to apply patches? Do you go to
microsoft website and check it out daily and apply it or other tricks?
Please advise. Thanks.Hi
You may want to check out
https://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx
Post SP2 there are also some additional fixes the last publically available
hotfix is http://support.microsoft.com/?Kbid=934459
You should test your applications to make sure they are still working on the
upgraded version before moving.
John
"-Obama" wrote:
> I got 4 sql2k5 servers with service patch version as following:
> Microsoft SQL Server 2005 - 9.00.2221.00 (Intel X86) Feb 9 2007 17:30:38
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
> NT 5.2 (Build 3790: Service Pack 2)
> Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86) May 8 2006 22:41:28
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
> 5.2 (Build 3790: Service Pack 2)
> Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
> 5.2 (Build 3790: Service Pack 2)
> Can anyone please advise me what is the easiest way to upgrade them to the
> most updated patch version? i.e. update path.
> Meanwhile, what is the best practice to apply patches? Do you go to
> microsoft website and check it out daily and apply it or other tricks?
> Please advise. Thanks.
>
>
patch application procedure
Hi,
I am having an mssql server with sp3. It is in sql cluster
(NT) as well as it participates in replication (merge). My
comany is very paranoid about doing things and all the
more there is no testing environment. Could any one please
explain how to apply SP4 for this server? We need to
consider the problematic conditions and disaster recovery
as well. My recovery mode is set to full.
james bond...-- james bond wrote: --
> Hi,
>> I am having an mssql server with sp3. It is in sql cluster
> (NT) as well as it participates in replication (merge). My
> company is very paranoid about doing things and all the
> more there is no testing environment. Could any one please
> explain how to apply SP4 for this server? We need to
> consider the problematic conditions and disaster recovery
> as well. My recovery mode is set to full.
--
Hi James Bond,
The best source of information for a service pack install is the README.htm of the service pack itself.
Hope this helps,
-Eric Cárdenas
SQL Server support
I am having an mssql server with sp3. It is in sql cluster
(NT) as well as it participates in replication (merge). My
comany is very paranoid about doing things and all the
more there is no testing environment. Could any one please
explain how to apply SP4 for this server? We need to
consider the problematic conditions and disaster recovery
as well. My recovery mode is set to full.
james bond...-- james bond wrote: --
> Hi,
>> I am having an mssql server with sp3. It is in sql cluster
> (NT) as well as it participates in replication (merge). My
> company is very paranoid about doing things and all the
> more there is no testing environment. Could any one please
> explain how to apply SP4 for this server? We need to
> consider the problematic conditions and disaster recovery
> as well. My recovery mode is set to full.
--
Hi James Bond,
The best source of information for a service pack install is the README.htm of the service pack itself.
Hope this helps,
-Eric Cárdenas
SQL Server support
Patch 3a
Ok filks here is a strange one. Tried installing service pack 3am on my
Windows XP
machine that is at service 2 on the OS Level. Now from what I can gather
when service pack 3a for SQL server is installed it wipes out all the driver
file locations and reinstalls a new MDAC from what I can see. But it never
gets them installed and the SQL Server becomes mute because you can never
connect to it. I've included a copy of the Log file that get's generated from
the install any one care to take a stab at this one. The following is the
SQLSTP.Log File and under that is the Error Log from the SQL Server
Directory. Any help would be great just reply to the group here.
-----
10:14:35 Begin Setup
10:14:35 8.00.194
10:14:35 Mode = Normal
10:14:35 ModeType = NORMAL
10:14:38 GetDefinitionEx returned: 0, Extended: 0x0
10:14:38 ValueFTS returned: 1
10:14:38 ValuePID returned: 1
10:14:38 ValueLic returned: 0
10:14:38 System: Windows NT WorkStation
10:14:38 SQL Server ProductType: Developer Edition [0x3]
10:14:38 Begin Action: SetupInitialize
10:14:38 End Action SetupInitialize
10:14:38 Begin Action: SetupInstall
10:14:38 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
10:14:38 CommonFilesDir=C:\Program Files\Common Files
10:14:38 Windows Directory=C:\WINDOWS\
10:14:38 Program Files=C:\Program Files\
10:14:38 TEMPDIR=C:\WINDOWS\TEMP\
10:14:38 Begin Action: SetupInstall
10:14:39 digpid size : 256
10:14:39 digpid size : 164
10:14:39 Begin Action: CheckFixedRequirements
10:14:39 Platform ID: 0xf000000
10:14:39 Version: 5.1.2600
10:14:39 File Version - C:\WINDOWS\System32\shdocvw.dll: 6.0.2800.1584
10:14:39 End Action: CheckFixedRequirements
10:14:40 Begin Action: ShowDialogs
10:14:40 Initial Dialog Mask: 0x83000f7, Disable Back=0x1
10:14:41 Begin Action ShowDialogsHlpr: 0x1
10:14:41 Begin Action: DialogShowSdWelcome
10:14:43 End Action DialogShowSdWelcome
10:14:43 Dialog 0x1 returned: 1
10:14:43 End Action ShowDialogsHlpr
10:14:43 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
10:14:43 Begin Action ShowDialogsHlpr: 0x2
10:14:43 Begin Action: DialogShowSdMachineName
10:14:45 ShowDlgMachine returned: 1
10:14:45 Name = DEV2, Type = 0x1
10:14:45 Begin Action: CheckRequirements
10:14:45 Processor Architecture: x86 (Pentium)
10:14:45 Service Pack: 256
10:14:45 ComputerName: DEV2
10:14:45 User Name: <Login Name>
10:14:45 IsAllAccessAllowed returned: 1
10:14:45 OS Language: 0x409
10:14:45 End Action CheckRequirements
10:14:45 This combination of Package and Operating System allows a full
product install.
10:14:46 CreateSetupTopology(DEV2), Handle : 0x1134a50, returned : 0
10:14:46 CreateSetupTopology returned : 0, Handle : 0x1134a50
10:14:46 Topology Type : 1, Return Value : 0
10:14:46 ST_GetPhysicalNode returned : 0, PNHandle : 0x1134a78
10:14:46 PN_EnumerateEx returned : 0
10:14:46 PN_GetSQLStates returned : 0, SqlStates : 0x0
10:14:46 PN_StartScan [0x1134a78] returned : 0
10:14:46 PN_GetNext [0x1134a78] returned : 18, Handle: [0x0]
10:14:46 No more items in enumeration.
10:14:46 ReleaseSetupTopology
10:14:46 Named instance limit: 100, quota: 0
10:14:46 End Action DialogShowSdMachineName
10:14:46 begin ShowDialogsUpdateMask
10:14:46 nFullMask = 0x83000f7, nCurrent = 0x2, nDirection = 0
10:14:46 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
10:14:46 Dialog 0x2 returned: 0
10:14:46 End Action ShowDialogsHlpr
10:14:46 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
10:14:46 Begin Action ShowDialogsHlpr: 0x4
10:14:46 Begin Action: DialogShowSdInstallMode
10:14:48 ShowDlgInstallMode returned: 1
10:14:48 InstallMode : 0x1
10:14:48 End Action DialogShowSdInstallMode
10:14:48 begin ShowDialogsUpdateMask
10:14:48 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
10:14:48 Updated Dialog Mask: 0xbf40037, Disable Back = 0x1
10:14:48 Dialog 0x4 returned: 1
10:14:48 End Action ShowDialogsHlpr
10:14:48 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
10:14:48 Begin Action ShowDialogsHlpr: 0x10
10:14:48 Begin Action: DialogShowSdRegisterUserEx
10:14:57 End Action DialogShowSdRegisterUserEx
10:14:57 Dialog 0x10 returned: 1
10:14:57 End Action ShowDialogsHlpr
10:14:57 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
10:14:57 Begin Action ShowDialogsHlpr: 0x20
10:14:57 Begin Action: DialogShowSdLicense
10:15:00 End Action DialogShowSdLicense
10:15:00 Dialog 0x20 returned: 1
10:15:00 End Action ShowDialogsHlpr
10:15:00 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
10:15:00 Begin Action ShowDialogsHlpr: 0x40000
10:15:00 Begin Action: DialogShowSdCliSvr
10:15:00 DisplaySystemPreReq
10:15:02 ShowDlgClientServerSelect returned: 1
10:15:02 Type : 0x2
10:15:02 End Action DialogShowSdCliSvr
10:15:02 begin ShowDialogsUpdateMask
10:15:02 nFullMask = 0xbf40037, nCurrent = 0x40000, nDirection = 1
10:15:02 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
10:15:02 Dialog 0x40000 returned: 1
10:15:02 End Action ShowDialogsHlpr
10:15:02 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
10:15:02 Begin Action ShowDialogsHlpr: 0x80000
10:15:02 Begin Action: DialogShowSdInstanceName
10:15:02 Begin Action: ShowDlgInstanceName
10:15:03 End Action: ShowDlgInstanceName
10:15:03 ShowDlgInstanceName returned : 1
10:15:03 InstanceName : MSSQLSERVER
10:15:03 CreateSetupTopology(DEV2), Handle : 0x1134a50, returned : 0
10:15:03 CreateSetupTopology returned : 0, Handle : 0x1134a50
10:15:03 Topology Type : 1, Return Value : 0
10:15:03 ST_GetPhysicalNode returned : 0, PNHandle : 0x1134a78
10:15:03 PN_EnumerateEx returned : 0
10:15:03 PN_GetSQLStates returned : 0, SqlStates : 0x0
10:15:03 PN_StartScan [0x1134a78] returned : 0
10:15:03 PN_GetNext [0x1134a78] returned : 18, Handle: [0x0]
10:15:03 No more items in enumeration.
10:15:03 ReleaseSetupTopology
10:15:03 End Action DialogShowSdInstanceName
10:15:03 begin ShowDialogsUpdateMask
10:15:03 nFullMask = 0xbfc0037, nCurrent = 0x80000, nDirection = 1
10:15:03 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
10:15:03 Dialog 0x80000 returned: 1
10:15:03 End Action ShowDialogsHlpr
10:15:04 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
10:15:04 Begin Action ShowDialogsHlpr: 0x100000
10:15:04 Begin Action: DialogShowSdSetupType
10:15:04 Begin Action: Setup Type
10:15:22 Setup type set Typical
10:15:34 SQL program folder: C:\Program Files\Microsoft SQL Server
10:15:34 SQL data folder: C:\Program Files\Microsoft SQL Server
10:15:34 Windows system folder: C:\WINDOWS\System32\
10:15:34 Prog req: 38073, Data req: 34432, Sys req: 114225
10:15:34 Prog avail: 9393472, Data avail: 9393472, Sys avail: 9393472
10:15:34 Prog req vs. avail, 186730, 9393472
10:15:34 Data req vs. avail, 34432, 9393472
10:15:34 Sys req vs. avail, 148657, 9393472
10:15:34 DisplaySystemPreReq
10:15:34 [SetupTypeSQL]
10:15:34 szDir = C:\Program Files\Microsoft SQL Server
10:15:34 szDir = %PROGRAMFILES%\Microsoft SQL Server
10:15:34 Result = 301
10:15:34 szDataDir = C:\Program Files\Microsoft SQL Server
10:15:34 szDataDir = %PROGRAMFILES%\Microsoft SQL Server
10:15:34 End Action: Setup Type
10:15:34 Setup Type: Typical (301)
10:15:34 End Action DialogShowSdSetupType
10:15:34 begin ShowDialogsUpdateMask
10:15:34 nFullMask = 0xbfc0037, nCurrent = 0x100000, nDirection = 301
10:15:34 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:15:34 Dialog 0x100000 returned: 301
10:15:34 End Action ShowDialogsHlpr
10:15:34 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
10:15:34 Begin Action ShowDialogsHlpr: 0x400000
10:15:34 Begin Action: DlgServices
10:16:15 ShowDlgServices returned: 1
10:16:15 [DlgServices]
10:16:15 Local-Domain= 61680
10:16:15 AutoStart= 15
10:16:15 SQLDomain= KALTEC
10:16:15 SQLDomainAcct= administrator
10:16:15 SQLDomainPwd
10:16:15 AgtDomain= KALTEC
10:16:15 AgtDomainAcct= administrator
10:16:15 AgtDomainPwd
10:16:15 Result= 1
10:16:15 End Action DlgServices
10:16:15 begin ShowDialogsUpdateMask
10:16:15 nFullMask = 0xbdc0037, nCurrent = 0x400000, nDirection = 1
10:16:15 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:15 Dialog 0x400000 returned: 1
10:16:15 End Action ShowDialogsHlpr
10:16:15 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
10:16:15 Begin Action ShowDialogsHlpr: 0x800000
10:16:15 Begin Action: DlgSQLSecurity
10:16:27 ShowDlgSQLSecurity returned: 1
10:16:27 LoginMode = 2,szPwd
10:16:28 End Action DlgSQLSecurity
10:16:28 begin ShowDialogsUpdateMask
10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x800000, nDirection = 1
10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:28 Dialog 0x800000 returned: 1
10:16:28 End Action ShowDialogsHlpr
10:16:28 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
10:16:28 Begin Action ShowDialogsHlpr: 0x1000000
10:16:28 Begin Action: DlgCollation
10:16:28 ShowDlgCollation returned: 1
10:16:28 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name =
Latin1_General,lcid = 0x409,SortId = 52,dwCompFlags = 0x30001
10:16:28 End Action DlgCollation
10:16:28 begin ShowDialogsUpdateMask
10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x1000000, nDirection = 1
10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:28 Dialog 0x1000000 returned: 1
10:16:28 End Action ShowDialogsHlpr
10:16:28 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
10:16:28 Begin Action ShowDialogsHlpr: 0x2000000
10:16:28 Begin Action: DlgNetwork
10:16:28 ShowDlgNetwork returned: 1
10:16:28 [DlgServerNetwork]
10:16:28 NetworkLibs = 255
10:16:28 TCPPort = 1433
10:16:28 TCPPrxy = Default
10:16:28 NMPPipeName = \\.\pipe\sql\query
10:16:28 Result = 1
10:16:28 End Action DlgNetwork
10:16:28 begin ShowDialogsUpdateMask
10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x2000000, nDirection = 1
10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:28 Dialog 0x2000000 returned: 1
10:16:28 End Action ShowDialogsHlpr
10:16:28 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
10:16:28 Begin Action ShowDialogsHlpr: 0x8000000
10:16:28 Begin Action: DialogShowSdStartCopy
10:16:30 End Action DialogShowSdStartCopy
10:16:30 begin ShowDialogsUpdateMask
10:16:30 nFullMask = 0xbdc0037, nCurrent = 0x8000000, nDirection = 1
10:16:30 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:30 Dialog 0x8000000 returned: 1
10:16:30 End Action ShowDialogsHlpr
10:16:30 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
10:16:30 End Action ShowDialogs
10:16:30 Begin Action ProcessBeforeDataMove:
10:16:31 DeinstallStart returned (C:\Program Files\Microsoft SQL
Server\MSSQL): 0
10:16:31 End Action ProcessBeforeDataMove:
10:16:31 Begin Action SetToolsComponentSelection:
10:16:31 End Action SetToolsComponentSelection:
10:16:31 Begin Action ProcessComponentSelection:
10:16:31 End Action ProcessComponentSelection
10:16:31 Begin Action LogSelectedComponents:
10:16:31 SQLProg
10:16:31 SQLProg\SQLServr
10:16:31 SQLProg\SQLServr\Help
10:16:31 SQLProg\SQLServr\SCMDev
10:16:31 SQLProg\SQLServr\SCMDev\SCMh
10:16:31 SQLProg\SQLServr\SCMDev\SCMX86Lb
10:16:31 SQLProg\SQLServr\SCMDev\SCMALb
10:16:31 SQLProg\SQLServr\Rs1033
10:16:31 SQLProg\SQLServr\RsIntl
10:16:31 SQLProg\SQLServr\ActiveX
10:16:31 SQLProg\SQLServr\System
10:16:31 SQLProg\UpgTools
10:16:31 SQLProg\UpgTools\UpgSys
10:16:31 SQLProg\UpgTools\ActiveX
10:16:31 SQLProg\UpgTools\Res1033
10:16:31 SQLProg\UpgTools\ResOther
10:16:31 SQLProg\UpgTools\Resld
10:16:31 SQLProg\ReplSupp
10:16:31 SQLProg\ReplSupp\ReplDat
10:16:31 SQLProg\ReplSupp\RepComm
10:16:31 SQLProg\ReplSupp\RepNoDk
10:16:31 SQLProg\ReplSupp\ActiveX
10:16:31 SQLProg\Install
10:16:31 SQLProg\System
10:16:31 SQLProg\SvrExt
10:16:31 SQLProg\SvrExt\Help
10:16:31 SQLProg\SvrExt\SvrExtRs
10:16:31 SQLProg\SvrExt\ResIntl
10:16:31 SQLProg\Dat
10:16:31 SQLProg\DatSmpl
10:16:31 SQLProg\BaseSys
10:16:31 SQLProg\BaseBinn
10:16:31 SQLProg\BaseInst
10:16:31 SQLProg\Symbols
10:16:31 SQLProg\Symbols\EXE
10:16:31 SQLProg\Symbols\DLL
10:16:31 SQLProg\Perfmon
10:16:31 SQLProg\Perfmon\System
10:16:31 SQLProg\Root
10:16:31 MgtTool
10:16:31 MgtTool\SEM
10:16:31 MgtTool\SEM\HTML
10:16:31 MgtTool\SEM\MSD98
10:16:31 MgtTool\SEM\MSD98SYS
10:16:31 MgtTool\SEM\MSD98Res
10:16:31 MgtTool\SEM\MSD98Hlp
10:16:31 MgtTool\SEM\Help
10:16:31 MgtTool\SEM\Res1033
10:16:31 MgtTool\SEM\ResIntl
10:16:31 MgtTool\SEM\MSD98RsI
10:16:31 MgtTool\SEM\ActiveX
10:16:31 MgtTool\SEM\ActiveX\Res1033
10:16:31 MgtTool\SEM\ActiveX\ResIntl
10:16:31 MgtTool\SEM\Scripts
10:16:31 MgtTool\SEM\OLEDB
10:16:31 MgtTool\SEM\OLEDB\Res1033
10:16:31 MgtTool\SEM\OLEDB\ResIntl
10:16:31 MgtTool\Profiler
10:16:31 MgtTool\Profiler\Help
10:16:31 MgtTool\Profiler\Res1033
10:16:31 MgtTool\Profiler\ResIntl
10:16:31 MgtTool\Qryanlz
10:16:31 MgtTool\Qryanlz\Help
10:16:31 MgtTool\Qryanlz\Res1033
10:16:31 MgtTool\Qryanlz\ResIntl
10:16:31 MgtTool\DTCCLi
10:16:31 MgtTool\Wzcnflct
10:16:31 MgtTool\Wzcnflct\WzcnHlp
10:16:31 MgtTool\Wzcnflct\Wzcn1033
10:16:31 MgtTool\Wzcnflct\WzcnOthr
10:16:31 MgtTool\Wzcnflct\WzcnCmn
10:16:31 MgtTool\UtilSys
10:16:31 MgtTool\UtilBinn
10:16:31 Connect
10:16:31 Connect\ConnSys
10:16:31 Books
10:16:31 Books\Bookso
10:16:31 Books\Bookso\Utils
10:16:31 DevTools
10:16:31 DevTools\Dbg Int
10:16:31 DevTools\Dbg Int\Dbg Int Common
10:16:31 DevTools\Dbg Int\EXE
10:16:31 CoreRepl
10:16:31 CoreRepl\Res1033
10:16:31 CoreRepl\ResIntl
10:16:31 Core
10:16:31 Core\Res1033
10:16:31 Core\ResOther
10:16:31 Repostry
10:16:31 Repostry\RepstSys
10:16:31 Repostry\Res1033
10:16:31 Repostry\ResIntl
10:16:31 CoreMisc
10:16:31 CoreMisc\ActiveX
10:16:31 CoreMisc\ActiveX\Res1033
10:16:31 CoreMisc\ActiveX\ResIntl
10:16:31 CoreMisc\Res1033
10:16:31 Monarch
10:16:31 Monarch\Monr1033
10:16:31 Monarch\MonrIntl
10:16:31 Jet
10:16:31 CoreInst
10:16:31 CoreCOM
10:16:31 CoreCOM\Res1033
10:16:31 CoreCOM\ResIntl
10:16:31 CoreTool
10:16:31 CoreTool\Res1033
10:16:31 CoreTool\ResOther
10:16:31 DBLibCli
10:16:31 SFExt
10:16:31 SFExt\ActiveX
10:16:31 SFExt\ActiveX\Res1033
10:16:31 SFExt\ActiveX\ResIntl
10:16:31 SFExt\Res1033
10:16:31 SFExt\ResIntl
10:16:31 Trace
10:16:31 Trace\Res1033
10:16:31 Trace\ResOther
10:16:31 MiscCore
10:16:31 MC
10:16:31 MC\MC1033
10:16:31 MC\MCIntl
10:16:31 MC\Help
10:16:31 SQLMgr
10:16:31 SQLMgr\Res1033
10:16:31 SQLMgr\ResIntl
10:16:31 SvrTool
10:16:31 SvrTool\Res1033
10:16:31 SvrTool\ResIntl
10:16:31 DTSUI
10:16:31 DTSUI\Res1033
10:16:31 DTSUI\ResIntl
10:16:31 MSOlap
10:16:32 MSOlap\Res1033
10:16:32 MSOlap\ResIntl
10:16:32 ATL
10:16:32 ATL\winnt
10:16:32 ATL\win9x
10:16:32 MFC42U
10:16:32 VC
10:16:32 VB
10:16:32 OCX1
10:16:32 SQLAdHlp
10:16:32 SQLAdHlp\Res1033
10:16:32 SQLAdHlp\ResOther
10:16:32 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
10:16:32 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
10:16:32 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
10:16:32 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
10:16:32 End Action LogSelectedComponents
10:16:32 Begin Action InstallPkgs:
10:16:32 Begin Action: Locked Connectivity Files Check
10:16:40 ConnectivityLocked returned: 0
10:16:40 The operation completed successfully.
10:16:40 End Action: Locked Connectivity Files Check
10:16:40 Setup is installing Microsoft Data Access Components (MDAC) ...
10:16:40 \\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Other\sqlredis. exe /q:a
/C:"setupre.exe WARN=1 -s -SMS"
10:17:43 ExitCode: 0
10:17:43 Setup is installing Microsoft Distributed Transaction Coordinator
(MSDTC) ...
10:17:43 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir
"C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg
"\\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Other\dtcsetup .exe" -LogFile
"C:\WINDOWS\sqlstp.log"
10:17:45 Process Exit Code: (0)
10:17:45 /Q:A /T:C:\WINDOWS\TEMP\ixp001.tmp
10:17:45 Setup is installing HTML Help ...
10:17:48 HTML Help installer exit code: 0
10:18:15 End Action InstallPkgs
10:18:15 Begin Action MoveFileData:
10:18:15 Enabled SELFREGISTERBATCH
10:18:15 Enabled CORECOMPONENTHANDLING
10:21:34 Begin Action: MoveFileDataSpecial
10:21:37 End Action: MoveFileDataSpecial
10:21:37 End Action MoveFileData
10:21:37 Begin Action ProcessAfterDataMove:
10:21:37 \\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Binn\hhcol.exe C:\Program
Files\Microsoft SQL Server\80\Tools\Books
10:21:42 End Action ProcessAfterDataMove
10:21:42 Begin Action BuildServer:
10:21:42 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 5 -ExePath
"C:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe" -Service
"MSSQLSERVER"
10:21:43 Process Exit Code: (0)
10:21:43 Begin Action: CreateRegistrySetSQL
10:21:43 End Action: CreateRegistrySetSQL
10:21:43 Begin Action: RegWriteSetupEntry
10:21:43 End Action: RegWriteSetupEntry
10:21:43 Begin Action: CreateSer
10:21:43 End Action: CreateSer
10:21:43 Begin Action: SkuIt
10:21:44 End Action: SkuIt
10:21:45 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL
Server\MSSQL returned: 0, 0
10:21:45 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
10:21:45 Begin Action: UpdateSystemPath
10:21:45 Path successfully updated.
10:21:45 C:\oracle\ora92\bin;C:\Program
Files\Oracle\jre\1.3.1\bin;C:\Program
Files\Oracle\jre\1.1.8\bin;C:\Perl\bin\;%SystemRoo t%\system32;%SystemRoot%;%SystemRoot%\System32\Wbe m;C:\OCM;C:\Program
Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Common
Files\Autodesk Shared\;C:\Program Files\proe2001\bin;C:\Program Files\Common
Files\Roxio Shared\DLLShared;C:\Program Files\UltraEdit;C:\Program
Files\Rouzer File Printer\;C:\Program Files\Executive Software\Diskeeper\
10:21:45 End Action: UpdateSystemPath
10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
10:21:47 Grant Right for KALTEC\administrator returned : 1, 0
10:21:47 Grant Right for KALTEC\administrator returned : 1, 0
10:21:48 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F
"C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q
"SQL_Latin1_General_CP1_CI_AS" -H 66300 -U sa -P
################################################## #############################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=DEV2;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
driver={sql server};server=DEV2;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
driver={sql server};server=DEV2;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
SQL Server configuration failed.
################################################## #############################
10:22:26 Process Exit Code: (-1)
10:22:35 Setup failed to configure the server. Refer to the server error
logs and C:\WINDOWS\sqlstp.log for more information.
10:22:37 Action CleanUpInstall:
10:22:37 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service
SQLSERVERAGENT
10:22:38 Process Exit Code: (1060) The specified service does not exist as
an installed service.
10:22:38 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service
MSSQLSERVER
10:22:38 Process Exit Code: (0)
10:22:38 StatsGenerate returned: 2
10:22:38 StatsGenerate (0x0,0x1,0xf000000,0x100,1033,303,0x0,0x1,0,0,0
10:22:38 StatsGenerate -1,<Login Name>)
10:22:38 Installation Failed.
-----
2004-10-28 10:21:51.33 server Microsoft SQL Server 2000 - 8.00.194
(Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 1)
2004-10-28 10:21:51.37 server Copyright (C) 1988-2000 Microsoft
Corporation.
2004-10-28 10:21:51.37 server All rights reserved.
2004-10-28 10:21:51.37 server Server Process ID is 3460.
2004-10-28 10:21:51.37 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2004-10-28 10:21:51.41 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2004-10-28 10:21:51.78 server SQL Server configured for thread mode
processing.
2004-10-28 10:21:51.82 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2004-10-28 10:21:51.87 server Attempting to initialize Distributed
Transaction Coordinator.
2004-10-28 10:21:56.01 spid3 Warning ******************
2004-10-28 10:21:56.01 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2004-10-28 10:21:56.04 spid3 Starting up database 'master'.
2004-10-28 10:21:57.41 spid3 Server name is 'DEV2'.
2004-10-28 10:21:57.42 server Using 'SSNETLIB.DLL' version '8.0.311'.
2004-10-28 10:21:57.42 spid5 Starting up database 'model'.
2004-10-28 10:21:57.42 spid7 Starting up database 'msdb'.
2004-10-28 10:21:57.42 spid8 Starting up database 'pubs'.
2004-10-28 10:21:57.42 spid9 Starting up database 'Northwind'.
2004-10-28 10:21:58.95 spid5 Clearing tempdb database.
2004-10-28 10:22:00.94 server SQL server listening on 10.10.1.33: 1433.
2004-10-28 10:22:00.94 server SQL server listening on 127.0.0.1: 1433.
2004-10-28 10:22:02.26 spid5 Starting up database 'tempdb'.
2004-10-28 10:22:02.41 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2004-10-28 10:22:02.41 server SQL Server is ready for client connections
2004-10-28 10:22:02.61 spid3 Recovery complete.
2004-10-28 10:22:02.64 spid3 Warning: override, autoexec procedures
skipped.
2004-10-28 10:22:12.92 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
Turn off the Windows Firewall or open up UDP 1434 and TCP 1433 on it.
"Jim B." <Jim B.@.discussions.microsoft.com> wrote in message
news:3AFED5B5-06E9-47A4-8A7E-A68E1EEC24C4@.microsoft.com...
> Ok filks here is a strange one. Tried installing service pack 3am on my
> Windows XP
> machine that is at service 2 on the OS Level. Now from what I can gather
> when service pack 3a for SQL server is installed it wipes out all the
driver
> file locations and reinstalls a new MDAC from what I can see. But it never
> gets them installed and the SQL Server becomes mute because you can never
> connect to it. I've included a copy of the Log file that get's generated
from
> the install any one care to take a stab at this one. The following is the
> SQLSTP.Log File and under that is the Error Log from the SQL Server
> Directory. Any help would be great just reply to the group here.
> ----
--
> 10:14:35 Begin Setup
> 10:14:35 8.00.194
> 10:14:35 Mode = Normal
> 10:14:35 ModeType = NORMAL
> 10:14:38 GetDefinitionEx returned: 0, Extended: 0x0
> 10:14:38 ValueFTS returned: 1
> 10:14:38 ValuePID returned: 1
> 10:14:38 ValueLic returned: 0
> 10:14:38 System: Windows NT WorkStation
> 10:14:38 SQL Server ProductType: Developer Edition [0x3]
> 10:14:38 Begin Action: SetupInitialize
> 10:14:38 End Action SetupInitialize
> 10:14:38 Begin Action: SetupInstall
> 10:14:38 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir
...
> 10:14:38 CommonFilesDir=C:\Program Files\Common Files
> 10:14:38 Windows Directory=C:\WINDOWS\
> 10:14:38 Program Files=C:\Program Files\
> 10:14:38 TEMPDIR=C:\WINDOWS\TEMP\
> 10:14:38 Begin Action: SetupInstall
> 10:14:39 digpid size : 256
> 10:14:39 digpid size : 164
> 10:14:39 Begin Action: CheckFixedRequirements
> 10:14:39 Platform ID: 0xf000000
> 10:14:39 Version: 5.1.2600
> 10:14:39 File Version - C:\WINDOWS\System32\shdocvw.dll: 6.0.2800.1584
> 10:14:39 End Action: CheckFixedRequirements
> 10:14:40 Begin Action: ShowDialogs
> 10:14:40 Initial Dialog Mask: 0x83000f7, Disable Back=0x1
> 10:14:41 Begin Action ShowDialogsHlpr: 0x1
> 10:14:41 Begin Action: DialogShowSdWelcome
> 10:14:43 End Action DialogShowSdWelcome
> 10:14:43 Dialog 0x1 returned: 1
> 10:14:43 End Action ShowDialogsHlpr
> 10:14:43 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
> 10:14:43 Begin Action ShowDialogsHlpr: 0x2
> 10:14:43 Begin Action: DialogShowSdMachineName
> 10:14:45 ShowDlgMachine returned: 1
> 10:14:45 Name = DEV2, Type = 0x1
> 10:14:45 Begin Action: CheckRequirements
> 10:14:45 Processor Architecture: x86 (Pentium)
> 10:14:45 Service Pack: 256
> 10:14:45 ComputerName: DEV2
> 10:14:45 User Name: <Login Name>
> 10:14:45 IsAllAccessAllowed returned: 1
> 10:14:45 OS Language: 0x409
> 10:14:45 End Action CheckRequirements
> 10:14:45 This combination of Package and Operating System allows a full
> product install.
> 10:14:46 CreateSetupTopology(DEV2), Handle : 0x1134a50, returned : 0
> 10:14:46 CreateSetupTopology returned : 0, Handle : 0x1134a50
> 10:14:46 Topology Type : 1, Return Value : 0
> 10:14:46 ST_GetPhysicalNode returned : 0, PNHandle : 0x1134a78
> 10:14:46 PN_EnumerateEx returned : 0
> 10:14:46 PN_GetSQLStates returned : 0, SqlStates : 0x0
> 10:14:46 PN_StartScan [0x1134a78] returned : 0
> 10:14:46 PN_GetNext [0x1134a78] returned : 18, Handle: [0x0]
> 10:14:46 No more items in enumeration.
> 10:14:46 ReleaseSetupTopology
> 10:14:46 Named instance limit: 100, quota: 0
> 10:14:46 End Action DialogShowSdMachineName
> 10:14:46 begin ShowDialogsUpdateMask
> 10:14:46 nFullMask = 0x83000f7, nCurrent = 0x2, nDirection = 0
> 10:14:46 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
> 10:14:46 Dialog 0x2 returned: 0
> 10:14:46 End Action ShowDialogsHlpr
> 10:14:46 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
> 10:14:46 Begin Action ShowDialogsHlpr: 0x4
> 10:14:46 Begin Action: DialogShowSdInstallMode
> 10:14:48 ShowDlgInstallMode returned: 1
> 10:14:48 InstallMode : 0x1
> 10:14:48 End Action DialogShowSdInstallMode
> 10:14:48 begin ShowDialogsUpdateMask
> 10:14:48 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
> 10:14:48 Updated Dialog Mask: 0xbf40037, Disable Back = 0x1
> 10:14:48 Dialog 0x4 returned: 1
> 10:14:48 End Action ShowDialogsHlpr
> 10:14:48 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
> 10:14:48 Begin Action ShowDialogsHlpr: 0x10
> 10:14:48 Begin Action: DialogShowSdRegisterUserEx
> 10:14:57 End Action DialogShowSdRegisterUserEx
> 10:14:57 Dialog 0x10 returned: 1
> 10:14:57 End Action ShowDialogsHlpr
> 10:14:57 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
> 10:14:57 Begin Action ShowDialogsHlpr: 0x20
> 10:14:57 Begin Action: DialogShowSdLicense
> 10:15:00 End Action DialogShowSdLicense
> 10:15:00 Dialog 0x20 returned: 1
> 10:15:00 End Action ShowDialogsHlpr
> 10:15:00 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
> 10:15:00 Begin Action ShowDialogsHlpr: 0x40000
> 10:15:00 Begin Action: DialogShowSdCliSvr
> 10:15:00 DisplaySystemPreReq
> 10:15:02 ShowDlgClientServerSelect returned: 1
> 10:15:02 Type : 0x2
> 10:15:02 End Action DialogShowSdCliSvr
> 10:15:02 begin ShowDialogsUpdateMask
> 10:15:02 nFullMask = 0xbf40037, nCurrent = 0x40000, nDirection = 1
> 10:15:02 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
> 10:15:02 Dialog 0x40000 returned: 1
> 10:15:02 End Action ShowDialogsHlpr
> 10:15:02 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
> 10:15:02 Begin Action ShowDialogsHlpr: 0x80000
> 10:15:02 Begin Action: DialogShowSdInstanceName
> 10:15:02 Begin Action: ShowDlgInstanceName
> 10:15:03 End Action: ShowDlgInstanceName
> 10:15:03 ShowDlgInstanceName returned : 1
> 10:15:03 InstanceName : MSSQLSERVER
> 10:15:03 CreateSetupTopology(DEV2), Handle : 0x1134a50, returned : 0
> 10:15:03 CreateSetupTopology returned : 0, Handle : 0x1134a50
> 10:15:03 Topology Type : 1, Return Value : 0
> 10:15:03 ST_GetPhysicalNode returned : 0, PNHandle : 0x1134a78
> 10:15:03 PN_EnumerateEx returned : 0
> 10:15:03 PN_GetSQLStates returned : 0, SqlStates : 0x0
> 10:15:03 PN_StartScan [0x1134a78] returned : 0
> 10:15:03 PN_GetNext [0x1134a78] returned : 18, Handle: [0x0]
> 10:15:03 No more items in enumeration.
> 10:15:03 ReleaseSetupTopology
> 10:15:03 End Action DialogShowSdInstanceName
> 10:15:03 begin ShowDialogsUpdateMask
> 10:15:03 nFullMask = 0xbfc0037, nCurrent = 0x80000, nDirection = 1
> 10:15:03 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
> 10:15:03 Dialog 0x80000 returned: 1
> 10:15:03 End Action ShowDialogsHlpr
> 10:15:04 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
> 10:15:04 Begin Action ShowDialogsHlpr: 0x100000
> 10:15:04 Begin Action: DialogShowSdSetupType
> 10:15:04 Begin Action: Setup Type
> 10:15:22 Setup type set Typical
> 10:15:34 SQL program folder: C:\Program Files\Microsoft SQL Server
> 10:15:34 SQL data folder: C:\Program Files\Microsoft SQL Server
> 10:15:34 Windows system folder: C:\WINDOWS\System32\
> 10:15:34 Prog req: 38073, Data req: 34432, Sys req: 114225
> 10:15:34 Prog avail: 9393472, Data avail: 9393472, Sys avail: 9393472
> 10:15:34 Prog req vs. avail, 186730, 9393472
> 10:15:34 Data req vs. avail, 34432, 9393472
> 10:15:34 Sys req vs. avail, 148657, 9393472
> 10:15:34 DisplaySystemPreReq
> 10:15:34 [SetupTypeSQL]
> 10:15:34 szDir = C:\Program Files\Microsoft SQL Server
> 10:15:34 szDir = %PROGRAMFILES%\Microsoft SQL Server
> 10:15:34 Result = 301
> 10:15:34 szDataDir = C:\Program Files\Microsoft SQL Server
> 10:15:34 szDataDir = %PROGRAMFILES%\Microsoft SQL Server
> 10:15:34 End Action: Setup Type
> 10:15:34 Setup Type: Typical (301)
> 10:15:34 End Action DialogShowSdSetupType
> 10:15:34 begin ShowDialogsUpdateMask
> 10:15:34 nFullMask = 0xbfc0037, nCurrent = 0x100000, nDirection = 301
> 10:15:34 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:15:34 Dialog 0x100000 returned: 301
> 10:15:34 End Action ShowDialogsHlpr
> 10:15:34 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
> 10:15:34 Begin Action ShowDialogsHlpr: 0x400000
> 10:15:34 Begin Action: DlgServices
> 10:16:15 ShowDlgServices returned: 1
> 10:16:15 [DlgServices]
> 10:16:15 Local-Domain = 61680
> 10:16:15 AutoStart = 15
> 10:16:15 SQLDomain = KALTEC
> 10:16:15 SQLDomainAcct = administrator
> 10:16:15 SQLDomainPwd
> 10:16:15 AgtDomain = KALTEC
> 10:16:15 AgtDomainAcct = administrator
> 10:16:15 AgtDomainPwd
> 10:16:15 Result = 1
> 10:16:15 End Action DlgServices
> 10:16:15 begin ShowDialogsUpdateMask
> 10:16:15 nFullMask = 0xbdc0037, nCurrent = 0x400000, nDirection = 1
> 10:16:15 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:15 Dialog 0x400000 returned: 1
> 10:16:15 End Action ShowDialogsHlpr
> 10:16:15 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
> 10:16:15 Begin Action ShowDialogsHlpr: 0x800000
> 10:16:15 Begin Action: DlgSQLSecurity
> 10:16:27 ShowDlgSQLSecurity returned: 1
> 10:16:27 LoginMode = 2,szPwd
> 10:16:28 End Action DlgSQLSecurity
> 10:16:28 begin ShowDialogsUpdateMask
> 10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x800000, nDirection = 1
> 10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:28 Dialog 0x800000 returned: 1
> 10:16:28 End Action ShowDialogsHlpr
> 10:16:28 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
> 10:16:28 Begin Action ShowDialogsHlpr: 0x1000000
> 10:16:28 Begin Action: DlgCollation
> 10:16:28 ShowDlgCollation returned: 1
> 10:16:28 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name =
> Latin1_General,lcid = 0x409,SortId = 52,dwCompFlags = 0x30001
> 10:16:28 End Action DlgCollation
> 10:16:28 begin ShowDialogsUpdateMask
> 10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x1000000, nDirection = 1
> 10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:28 Dialog 0x1000000 returned: 1
> 10:16:28 End Action ShowDialogsHlpr
> 10:16:28 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
> 10:16:28 Begin Action ShowDialogsHlpr: 0x2000000
> 10:16:28 Begin Action: DlgNetwork
> 10:16:28 ShowDlgNetwork returned: 1
> 10:16:28 [DlgServerNetwork]
> 10:16:28 NetworkLibs = 255
> 10:16:28 TCPPort = 1433
> 10:16:28 TCPPrxy = Default
> 10:16:28 NMPPipeName = \\.\pipe\sql\query
> 10:16:28 Result = 1
> 10:16:28 End Action DlgNetwork
> 10:16:28 begin ShowDialogsUpdateMask
> 10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x2000000, nDirection = 1
> 10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:28 Dialog 0x2000000 returned: 1
> 10:16:28 End Action ShowDialogsHlpr
> 10:16:28 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
> 10:16:28 Begin Action ShowDialogsHlpr: 0x8000000
> 10:16:28 Begin Action: DialogShowSdStartCopy
> 10:16:30 End Action DialogShowSdStartCopy
> 10:16:30 begin ShowDialogsUpdateMask
> 10:16:30 nFullMask = 0xbdc0037, nCurrent = 0x8000000, nDirection = 1
> 10:16:30 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:30 Dialog 0x8000000 returned: 1
> 10:16:30 End Action ShowDialogsHlpr
> 10:16:30 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
> 10:16:30 End Action ShowDialogs
> 10:16:30 Begin Action ProcessBeforeDataMove:
> 10:16:31 DeinstallStart returned (C:\Program Files\Microsoft SQL
> Server\MSSQL): 0
> 10:16:31 End Action ProcessBeforeDataMove:
> 10:16:31 Begin Action SetToolsComponentSelection:
> 10:16:31 End Action SetToolsComponentSelection:
> 10:16:31 Begin Action ProcessComponentSelection:
> 10:16:31 End Action ProcessComponentSelection
> 10:16:31 Begin Action LogSelectedComponents:
> 10:16:31 SQLProg
> 10:16:31 SQLProg\SQLServr
> 10:16:31 SQLProg\SQLServr\Help
> 10:16:31 SQLProg\SQLServr\SCMDev
> 10:16:31 SQLProg\SQLServr\SCMDev\SCMh
> 10:16:31 SQLProg\SQLServr\SCMDev\SCMX86Lb
> 10:16:31 SQLProg\SQLServr\SCMDev\SCMALb
> 10:16:31 SQLProg\SQLServr\Rs1033
> 10:16:31 SQLProg\SQLServr\RsIntl
> 10:16:31 SQLProg\SQLServr\ActiveX
> 10:16:31 SQLProg\SQLServr\System
> 10:16:31 SQLProg\UpgTools
> 10:16:31 SQLProg\UpgTools\UpgSys
> 10:16:31 SQLProg\UpgTools\ActiveX
> 10:16:31 SQLProg\UpgTools\Res1033
> 10:16:31 SQLProg\UpgTools\ResOther
> 10:16:31 SQLProg\UpgTools\Resld
> 10:16:31 SQLProg\ReplSupp
> 10:16:31 SQLProg\ReplSupp\ReplDat
> 10:16:31 SQLProg\ReplSupp\RepComm
> 10:16:31 SQLProg\ReplSupp\RepNoDk
> 10:16:31 SQLProg\ReplSupp\ActiveX
> 10:16:31 SQLProg\Install
> 10:16:31 SQLProg\System
> 10:16:31 SQLProg\SvrExt
> 10:16:31 SQLProg\SvrExt\Help
> 10:16:31 SQLProg\SvrExt\SvrExtRs
> 10:16:31 SQLProg\SvrExt\ResIntl
> 10:16:31 SQLProg\Dat
> 10:16:31 SQLProg\DatSmpl
> 10:16:31 SQLProg\BaseSys
> 10:16:31 SQLProg\BaseBinn
> 10:16:31 SQLProg\BaseInst
> 10:16:31 SQLProg\Symbols
> 10:16:31 SQLProg\Symbols\EXE
> 10:16:31 SQLProg\Symbols\DLL
> 10:16:31 SQLProg\Perfmon
> 10:16:31 SQLProg\Perfmon\System
> 10:16:31 SQLProg\Root
> 10:16:31 MgtTool
> 10:16:31 MgtTool\SEM
> 10:16:31 MgtTool\SEM\HTML
> 10:16:31 MgtTool\SEM\MSD98
> 10:16:31 MgtTool\SEM\MSD98SYS
> 10:16:31 MgtTool\SEM\MSD98Res
> 10:16:31 MgtTool\SEM\MSD98Hlp
> 10:16:31 MgtTool\SEM\Help
> 10:16:31 MgtTool\SEM\Res1033
> 10:16:31 MgtTool\SEM\ResIntl
> 10:16:31 MgtTool\SEM\MSD98RsI
> 10:16:31 MgtTool\SEM\ActiveX
> 10:16:31 MgtTool\SEM\ActiveX\Res1033
> 10:16:31 MgtTool\SEM\ActiveX\ResIntl
> 10:16:31 MgtTool\SEM\Scripts
> 10:16:31 MgtTool\SEM\OLEDB
> 10:16:31 MgtTool\SEM\OLEDB\Res1033
> 10:16:31 MgtTool\SEM\OLEDB\ResIntl
> 10:16:31 MgtTool\Profiler
> 10:16:31 MgtTool\Profiler\Help
> 10:16:31 MgtTool\Profiler\Res1033
> 10:16:31 MgtTool\Profiler\ResIntl
> 10:16:31 MgtTool\Qryanlz
> 10:16:31 MgtTool\Qryanlz\Help
> 10:16:31 MgtTool\Qryanlz\Res1033
> 10:16:31 MgtTool\Qryanlz\ResIntl
> 10:16:31 MgtTool\DTCCLi
> 10:16:31 MgtTool\Wzcnflct
> 10:16:31 MgtTool\Wzcnflct\WzcnHlp
> 10:16:31 MgtTool\Wzcnflct\Wzcn1033
> 10:16:31 MgtTool\Wzcnflct\WzcnOthr
> 10:16:31 MgtTool\Wzcnflct\WzcnCmn
> 10:16:31 MgtTool\UtilSys
> 10:16:31 MgtTool\UtilBinn
> 10:16:31 Connect
> 10:16:31 Connect\ConnSys
> 10:16:31 Books
> 10:16:31 Books\Bookso
> 10:16:31 Books\Bookso\Utils
> 10:16:31 DevTools
> 10:16:31 DevTools\Dbg Int
> 10:16:31 DevTools\Dbg Int\Dbg Int Common
> 10:16:31 DevTools\Dbg Int\EXE
> 10:16:31 CoreRepl
> 10:16:31 CoreRepl\Res1033
> 10:16:31 CoreRepl\ResIntl
> 10:16:31 Core
> 10:16:31 Core\Res1033
> 10:16:31 Core\ResOther
> 10:16:31 Repostry
> 10:16:31 Repostry\RepstSys
> 10:16:31 Repostry\Res1033
> 10:16:31 Repostry\ResIntl
> 10:16:31 CoreMisc
> 10:16:31 CoreMisc\ActiveX
> 10:16:31 CoreMisc\ActiveX\Res1033
> 10:16:31 CoreMisc\ActiveX\ResIntl
> 10:16:31 CoreMisc\Res1033
> 10:16:31 Monarch
> 10:16:31 Monarch\Monr1033
> 10:16:31 Monarch\MonrIntl
> 10:16:31 Jet
> 10:16:31 CoreInst
> 10:16:31 CoreCOM
> 10:16:31 CoreCOM\Res1033
> 10:16:31 CoreCOM\ResIntl
> 10:16:31 CoreTool
> 10:16:31 CoreTool\Res1033
> 10:16:31 CoreTool\ResOther
> 10:16:31 DBLibCli
> 10:16:31 SFExt
> 10:16:31 SFExt\ActiveX
> 10:16:31 SFExt\ActiveX\Res1033
> 10:16:31 SFExt\ActiveX\ResIntl
> 10:16:31 SFExt\Res1033
> 10:16:31 SFExt\ResIntl
> 10:16:31 Trace
> 10:16:31 Trace\Res1033
> 10:16:31 Trace\ResOther
> 10:16:31 MiscCore
> 10:16:31 MC
> 10:16:31 MC\MC1033
> 10:16:31 MC\MCIntl
> 10:16:31 MC\Help
> 10:16:31 SQLMgr
> 10:16:31 SQLMgr\Res1033
> 10:16:31 SQLMgr\ResIntl
> 10:16:31 SvrTool
> 10:16:31 SvrTool\Res1033
> 10:16:31 SvrTool\ResIntl
> 10:16:31 DTSUI
> 10:16:31 DTSUI\Res1033
> 10:16:31 DTSUI\ResIntl
> 10:16:31 MSOlap
> 10:16:32 MSOlap\Res1033
> 10:16:32 MSOlap\ResIntl
> 10:16:32 ATL
> 10:16:32 ATL\winnt
> 10:16:32 ATL\win9x
> 10:16:32 MFC42U
> 10:16:32 VC
> 10:16:32 VB
> 10:16:32 OCX1
> 10:16:32 SQLAdHlp
> 10:16:32 SQLAdHlp\Res1033
> 10:16:32 SQLAdHlp\ResOther
> 10:16:32 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
> 10:16:32 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
> 10:16:32 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
> 10:16:32 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
> 10:16:32 End Action LogSelectedComponents
> 10:16:32 Begin Action InstallPkgs:
> 10:16:32 Begin Action: Locked Connectivity Files Check
> 10:16:40 ConnectivityLocked returned: 0
> 10:16:40 The operation completed successfully.
> 10:16:40 End Action: Locked Connectivity Files Check
> 10:16:40 Setup is installing Microsoft Data Access Components (MDAC) ...
> 10:16:40 \\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Other\sqlredis. exe /q:a
> /C:"setupre.exe WARN=1 -s -SMS"
> 10:17:43 ExitCode: 0
> 10:17:43 Setup is installing Microsoft Distributed Transaction Coordinator
> (MSDTC) ...
> 10:17:43 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir
> "C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg
> "\\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Other\dtcsetup .exe" -LogFile
> "C:\WINDOWS\sqlstp.log"
> 10:17:45 Process Exit Code: (0)
> 10:17:45 /Q:A /T:C:\WINDOWS\TEMP\ixp001.tmp
> 10:17:45 Setup is installing HTML Help ...
> 10:17:48 HTML Help installer exit code: 0
> 10:18:15 End Action InstallPkgs
> 10:18:15 Begin Action MoveFileData:
> 10:18:15 Enabled SELFREGISTERBATCH
> 10:18:15 Enabled CORECOMPONENTHANDLING
> 10:21:34 Begin Action: MoveFileDataSpecial
> 10:21:37 End Action: MoveFileDataSpecial
> 10:21:37 End Action MoveFileData
> 10:21:37 Begin Action ProcessAfterDataMove:
> 10:21:37 \\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Binn\hhcol.exe C:\Program
> Files\Microsoft SQL Server\80\Tools\Books
> 10:21:42 End Action ProcessAfterDataMove
> 10:21:42 Begin Action BuildServer:
> 10:21:42 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action
5 -ExePath
> "C:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe" -Service
> "MSSQLSERVER"
> 10:21:43 Process Exit Code: (0)
> 10:21:43 Begin Action: CreateRegistrySetSQL
> 10:21:43 End Action: CreateRegistrySetSQL
> 10:21:43 Begin Action: RegWriteSetupEntry
> 10:21:43 End Action: RegWriteSetupEntry
> 10:21:43 Begin Action: CreateSer
> 10:21:43 End Action: CreateSer
> 10:21:43 Begin Action: SkuIt
> 10:21:44 End Action: SkuIt
> 10:21:45 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL
> Server\MSSQL returned: 0, 0
> 10:21:45 SetRegSecuritySQLAndAdmin for
> Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
> 10:21:45 Begin Action: UpdateSystemPath
> 10:21:45 Path successfully updated.
> 10:21:45 C:\oracle\ora92\bin;C:\Program
> Files\Oracle\jre\1.3.1\bin;C:\Program
>
Files\Oracle\jre\1.1.8\bin;C:\Perl\bin\;%SystemRoo t%\system32;%SystemRoot%;%
SystemRoot%\System32\Wbem;C:\OCM;C:\Program
> Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Common
> Files\Autodesk Shared\;C:\Program Files\proe2001\bin;C:\Program
Files\Common
> Files\Roxio Shared\DLLShared;C:\Program Files\UltraEdit;C:\Program
> Files\Rouzer File Printer\;C:\Program Files\Executive Software\Diskeeper\
> 10:21:45 End Action: UpdateSystemPath
> 10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:47 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:47 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:48 C:\Program Files\Microsoft SQL
erver\80\Tools\Binn\cnfgsvr.exe -F
> "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q
> "SQL_Latin1_General_CP1_CI_AS" -H 66300 -U sa -P
>
################################################## ##########################
###
>
> Starting Service ...
> SQL_Latin1_General_CP1_CI_AS
> -m -Q -T4022 -T3659
> Connecting to Server ...
> driver={sql server};server=DEV2;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> driver={sql server};server=DEV2;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> driver={sql server};server=DEV2;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> SQL Server configuration failed.
>
################################################## ##########################
###
> 10:22:26 Process Exit Code: (-1)
> 10:22:35 Setup failed to configure the server. Refer to the server error
> logs and C:\WINDOWS\sqlstp.log for more information.
> 10:22:37 Action CleanUpInstall:
> 10:22:37 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action
4 -Service
> SQLSERVERAGENT
> 10:22:38 Process Exit Code: (1060) The specified service does not exist as
> an installed service.
> 10:22:38 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action
4 -Service
> MSSQLSERVER
> 10:22:38 Process Exit Code: (0)
> 10:22:38 StatsGenerate returned: 2
> 10:22:38 StatsGenerate (0x0,0x1,0xf000000,0x100,1033,303,0x0,0x1,0,0,0
> 10:22:38 StatsGenerate -1,<Login Name>)
> 10:22:38 Installation Failed.
> ----
--
> 2004-10-28 10:21:51.33 server Microsoft SQL Server 2000 - 8.00.194
> (Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 1)
> 2004-10-28 10:21:51.37 server Copyright (C) 1988-2000 Microsoft
> Corporation.
> 2004-10-28 10:21:51.37 server All rights reserved.
> 2004-10-28 10:21:51.37 server Server Process ID is 3460.
> 2004-10-28 10:21:51.37 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2004-10-28 10:21:51.41 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).
> 2004-10-28 10:21:51.78 server SQL Server configured for thread mode
> processing.
> 2004-10-28 10:21:51.82 server Using dynamic lock allocation. [2500]
Lock
> Blocks, [5000] Lock Owner Blocks.
> 2004-10-28 10:21:51.87 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2004-10-28 10:21:56.01 spid3 Warning ******************
> 2004-10-28 10:21:56.01 spid3 SQL Server started in single user mode.
> Updates allowed to system catalogs.
> 2004-10-28 10:21:56.04 spid3 Starting up database 'master'.
> 2004-10-28 10:21:57.41 spid3 Server name is 'DEV2'.
> 2004-10-28 10:21:57.42 server Using 'SSNETLIB.DLL' version '8.0.311'.
> 2004-10-28 10:21:57.42 spid5 Starting up database 'model'.
> 2004-10-28 10:21:57.42 spid7 Starting up database 'msdb'.
> 2004-10-28 10:21:57.42 spid8 Starting up database 'pubs'.
> 2004-10-28 10:21:57.42 spid9 Starting up database 'Northwind'.
> 2004-10-28 10:21:58.95 spid5 Clearing tempdb database.
> 2004-10-28 10:22:00.94 server SQL server listening on 10.10.1.33: 1433.
> 2004-10-28 10:22:00.94 server SQL server listening on 127.0.0.1: 1433.
> 2004-10-28 10:22:02.26 spid5 Starting up database 'tempdb'.
> 2004-10-28 10:22:02.41 server SQL server listening on TCP, Shared
Memory,
> Named Pipes.
> 2004-10-28 10:22:02.41 server SQL Server is ready for client
connections
> 2004-10-28 10:22:02.61 spid3 Recovery complete.
> 2004-10-28 10:22:02.64 spid3 Warning: override, autoexec procedures
> skipped.
> 2004-10-28 10:22:12.92 spid3 SQL Server is terminating due to 'stop'
> request from Service Control Manager.
>
Windows XP
machine that is at service 2 on the OS Level. Now from what I can gather
when service pack 3a for SQL server is installed it wipes out all the driver
file locations and reinstalls a new MDAC from what I can see. But it never
gets them installed and the SQL Server becomes mute because you can never
connect to it. I've included a copy of the Log file that get's generated from
the install any one care to take a stab at this one. The following is the
SQLSTP.Log File and under that is the Error Log from the SQL Server
Directory. Any help would be great just reply to the group here.
-----
10:14:35 Begin Setup
10:14:35 8.00.194
10:14:35 Mode = Normal
10:14:35 ModeType = NORMAL
10:14:38 GetDefinitionEx returned: 0, Extended: 0x0
10:14:38 ValueFTS returned: 1
10:14:38 ValuePID returned: 1
10:14:38 ValueLic returned: 0
10:14:38 System: Windows NT WorkStation
10:14:38 SQL Server ProductType: Developer Edition [0x3]
10:14:38 Begin Action: SetupInitialize
10:14:38 End Action SetupInitialize
10:14:38 Begin Action: SetupInstall
10:14:38 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
10:14:38 CommonFilesDir=C:\Program Files\Common Files
10:14:38 Windows Directory=C:\WINDOWS\
10:14:38 Program Files=C:\Program Files\
10:14:38 TEMPDIR=C:\WINDOWS\TEMP\
10:14:38 Begin Action: SetupInstall
10:14:39 digpid size : 256
10:14:39 digpid size : 164
10:14:39 Begin Action: CheckFixedRequirements
10:14:39 Platform ID: 0xf000000
10:14:39 Version: 5.1.2600
10:14:39 File Version - C:\WINDOWS\System32\shdocvw.dll: 6.0.2800.1584
10:14:39 End Action: CheckFixedRequirements
10:14:40 Begin Action: ShowDialogs
10:14:40 Initial Dialog Mask: 0x83000f7, Disable Back=0x1
10:14:41 Begin Action ShowDialogsHlpr: 0x1
10:14:41 Begin Action: DialogShowSdWelcome
10:14:43 End Action DialogShowSdWelcome
10:14:43 Dialog 0x1 returned: 1
10:14:43 End Action ShowDialogsHlpr
10:14:43 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
10:14:43 Begin Action ShowDialogsHlpr: 0x2
10:14:43 Begin Action: DialogShowSdMachineName
10:14:45 ShowDlgMachine returned: 1
10:14:45 Name = DEV2, Type = 0x1
10:14:45 Begin Action: CheckRequirements
10:14:45 Processor Architecture: x86 (Pentium)
10:14:45 Service Pack: 256
10:14:45 ComputerName: DEV2
10:14:45 User Name: <Login Name>
10:14:45 IsAllAccessAllowed returned: 1
10:14:45 OS Language: 0x409
10:14:45 End Action CheckRequirements
10:14:45 This combination of Package and Operating System allows a full
product install.
10:14:46 CreateSetupTopology(DEV2), Handle : 0x1134a50, returned : 0
10:14:46 CreateSetupTopology returned : 0, Handle : 0x1134a50
10:14:46 Topology Type : 1, Return Value : 0
10:14:46 ST_GetPhysicalNode returned : 0, PNHandle : 0x1134a78
10:14:46 PN_EnumerateEx returned : 0
10:14:46 PN_GetSQLStates returned : 0, SqlStates : 0x0
10:14:46 PN_StartScan [0x1134a78] returned : 0
10:14:46 PN_GetNext [0x1134a78] returned : 18, Handle: [0x0]
10:14:46 No more items in enumeration.
10:14:46 ReleaseSetupTopology
10:14:46 Named instance limit: 100, quota: 0
10:14:46 End Action DialogShowSdMachineName
10:14:46 begin ShowDialogsUpdateMask
10:14:46 nFullMask = 0x83000f7, nCurrent = 0x2, nDirection = 0
10:14:46 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
10:14:46 Dialog 0x2 returned: 0
10:14:46 End Action ShowDialogsHlpr
10:14:46 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
10:14:46 Begin Action ShowDialogsHlpr: 0x4
10:14:46 Begin Action: DialogShowSdInstallMode
10:14:48 ShowDlgInstallMode returned: 1
10:14:48 InstallMode : 0x1
10:14:48 End Action DialogShowSdInstallMode
10:14:48 begin ShowDialogsUpdateMask
10:14:48 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
10:14:48 Updated Dialog Mask: 0xbf40037, Disable Back = 0x1
10:14:48 Dialog 0x4 returned: 1
10:14:48 End Action ShowDialogsHlpr
10:14:48 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
10:14:48 Begin Action ShowDialogsHlpr: 0x10
10:14:48 Begin Action: DialogShowSdRegisterUserEx
10:14:57 End Action DialogShowSdRegisterUserEx
10:14:57 Dialog 0x10 returned: 1
10:14:57 End Action ShowDialogsHlpr
10:14:57 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
10:14:57 Begin Action ShowDialogsHlpr: 0x20
10:14:57 Begin Action: DialogShowSdLicense
10:15:00 End Action DialogShowSdLicense
10:15:00 Dialog 0x20 returned: 1
10:15:00 End Action ShowDialogsHlpr
10:15:00 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
10:15:00 Begin Action ShowDialogsHlpr: 0x40000
10:15:00 Begin Action: DialogShowSdCliSvr
10:15:00 DisplaySystemPreReq
10:15:02 ShowDlgClientServerSelect returned: 1
10:15:02 Type : 0x2
10:15:02 End Action DialogShowSdCliSvr
10:15:02 begin ShowDialogsUpdateMask
10:15:02 nFullMask = 0xbf40037, nCurrent = 0x40000, nDirection = 1
10:15:02 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
10:15:02 Dialog 0x40000 returned: 1
10:15:02 End Action ShowDialogsHlpr
10:15:02 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
10:15:02 Begin Action ShowDialogsHlpr: 0x80000
10:15:02 Begin Action: DialogShowSdInstanceName
10:15:02 Begin Action: ShowDlgInstanceName
10:15:03 End Action: ShowDlgInstanceName
10:15:03 ShowDlgInstanceName returned : 1
10:15:03 InstanceName : MSSQLSERVER
10:15:03 CreateSetupTopology(DEV2), Handle : 0x1134a50, returned : 0
10:15:03 CreateSetupTopology returned : 0, Handle : 0x1134a50
10:15:03 Topology Type : 1, Return Value : 0
10:15:03 ST_GetPhysicalNode returned : 0, PNHandle : 0x1134a78
10:15:03 PN_EnumerateEx returned : 0
10:15:03 PN_GetSQLStates returned : 0, SqlStates : 0x0
10:15:03 PN_StartScan [0x1134a78] returned : 0
10:15:03 PN_GetNext [0x1134a78] returned : 18, Handle: [0x0]
10:15:03 No more items in enumeration.
10:15:03 ReleaseSetupTopology
10:15:03 End Action DialogShowSdInstanceName
10:15:03 begin ShowDialogsUpdateMask
10:15:03 nFullMask = 0xbfc0037, nCurrent = 0x80000, nDirection = 1
10:15:03 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
10:15:03 Dialog 0x80000 returned: 1
10:15:03 End Action ShowDialogsHlpr
10:15:04 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
10:15:04 Begin Action ShowDialogsHlpr: 0x100000
10:15:04 Begin Action: DialogShowSdSetupType
10:15:04 Begin Action: Setup Type
10:15:22 Setup type set Typical
10:15:34 SQL program folder: C:\Program Files\Microsoft SQL Server
10:15:34 SQL data folder: C:\Program Files\Microsoft SQL Server
10:15:34 Windows system folder: C:\WINDOWS\System32\
10:15:34 Prog req: 38073, Data req: 34432, Sys req: 114225
10:15:34 Prog avail: 9393472, Data avail: 9393472, Sys avail: 9393472
10:15:34 Prog req vs. avail, 186730, 9393472
10:15:34 Data req vs. avail, 34432, 9393472
10:15:34 Sys req vs. avail, 148657, 9393472
10:15:34 DisplaySystemPreReq
10:15:34 [SetupTypeSQL]
10:15:34 szDir = C:\Program Files\Microsoft SQL Server
10:15:34 szDir = %PROGRAMFILES%\Microsoft SQL Server
10:15:34 Result = 301
10:15:34 szDataDir = C:\Program Files\Microsoft SQL Server
10:15:34 szDataDir = %PROGRAMFILES%\Microsoft SQL Server
10:15:34 End Action: Setup Type
10:15:34 Setup Type: Typical (301)
10:15:34 End Action DialogShowSdSetupType
10:15:34 begin ShowDialogsUpdateMask
10:15:34 nFullMask = 0xbfc0037, nCurrent = 0x100000, nDirection = 301
10:15:34 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:15:34 Dialog 0x100000 returned: 301
10:15:34 End Action ShowDialogsHlpr
10:15:34 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
10:15:34 Begin Action ShowDialogsHlpr: 0x400000
10:15:34 Begin Action: DlgServices
10:16:15 ShowDlgServices returned: 1
10:16:15 [DlgServices]
10:16:15 Local-Domain= 61680
10:16:15 AutoStart= 15
10:16:15 SQLDomain= KALTEC
10:16:15 SQLDomainAcct= administrator
10:16:15 SQLDomainPwd
10:16:15 AgtDomain= KALTEC
10:16:15 AgtDomainAcct= administrator
10:16:15 AgtDomainPwd
10:16:15 Result= 1
10:16:15 End Action DlgServices
10:16:15 begin ShowDialogsUpdateMask
10:16:15 nFullMask = 0xbdc0037, nCurrent = 0x400000, nDirection = 1
10:16:15 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:15 Dialog 0x400000 returned: 1
10:16:15 End Action ShowDialogsHlpr
10:16:15 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
10:16:15 Begin Action ShowDialogsHlpr: 0x800000
10:16:15 Begin Action: DlgSQLSecurity
10:16:27 ShowDlgSQLSecurity returned: 1
10:16:27 LoginMode = 2,szPwd
10:16:28 End Action DlgSQLSecurity
10:16:28 begin ShowDialogsUpdateMask
10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x800000, nDirection = 1
10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:28 Dialog 0x800000 returned: 1
10:16:28 End Action ShowDialogsHlpr
10:16:28 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
10:16:28 Begin Action ShowDialogsHlpr: 0x1000000
10:16:28 Begin Action: DlgCollation
10:16:28 ShowDlgCollation returned: 1
10:16:28 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name =
Latin1_General,lcid = 0x409,SortId = 52,dwCompFlags = 0x30001
10:16:28 End Action DlgCollation
10:16:28 begin ShowDialogsUpdateMask
10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x1000000, nDirection = 1
10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:28 Dialog 0x1000000 returned: 1
10:16:28 End Action ShowDialogsHlpr
10:16:28 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
10:16:28 Begin Action ShowDialogsHlpr: 0x2000000
10:16:28 Begin Action: DlgNetwork
10:16:28 ShowDlgNetwork returned: 1
10:16:28 [DlgServerNetwork]
10:16:28 NetworkLibs = 255
10:16:28 TCPPort = 1433
10:16:28 TCPPrxy = Default
10:16:28 NMPPipeName = \\.\pipe\sql\query
10:16:28 Result = 1
10:16:28 End Action DlgNetwork
10:16:28 begin ShowDialogsUpdateMask
10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x2000000, nDirection = 1
10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:28 Dialog 0x2000000 returned: 1
10:16:28 End Action ShowDialogsHlpr
10:16:28 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
10:16:28 Begin Action ShowDialogsHlpr: 0x8000000
10:16:28 Begin Action: DialogShowSdStartCopy
10:16:30 End Action DialogShowSdStartCopy
10:16:30 begin ShowDialogsUpdateMask
10:16:30 nFullMask = 0xbdc0037, nCurrent = 0x8000000, nDirection = 1
10:16:30 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:30 Dialog 0x8000000 returned: 1
10:16:30 End Action ShowDialogsHlpr
10:16:30 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
10:16:30 End Action ShowDialogs
10:16:30 Begin Action ProcessBeforeDataMove:
10:16:31 DeinstallStart returned (C:\Program Files\Microsoft SQL
Server\MSSQL): 0
10:16:31 End Action ProcessBeforeDataMove:
10:16:31 Begin Action SetToolsComponentSelection:
10:16:31 End Action SetToolsComponentSelection:
10:16:31 Begin Action ProcessComponentSelection:
10:16:31 End Action ProcessComponentSelection
10:16:31 Begin Action LogSelectedComponents:
10:16:31 SQLProg
10:16:31 SQLProg\SQLServr
10:16:31 SQLProg\SQLServr\Help
10:16:31 SQLProg\SQLServr\SCMDev
10:16:31 SQLProg\SQLServr\SCMDev\SCMh
10:16:31 SQLProg\SQLServr\SCMDev\SCMX86Lb
10:16:31 SQLProg\SQLServr\SCMDev\SCMALb
10:16:31 SQLProg\SQLServr\Rs1033
10:16:31 SQLProg\SQLServr\RsIntl
10:16:31 SQLProg\SQLServr\ActiveX
10:16:31 SQLProg\SQLServr\System
10:16:31 SQLProg\UpgTools
10:16:31 SQLProg\UpgTools\UpgSys
10:16:31 SQLProg\UpgTools\ActiveX
10:16:31 SQLProg\UpgTools\Res1033
10:16:31 SQLProg\UpgTools\ResOther
10:16:31 SQLProg\UpgTools\Resld
10:16:31 SQLProg\ReplSupp
10:16:31 SQLProg\ReplSupp\ReplDat
10:16:31 SQLProg\ReplSupp\RepComm
10:16:31 SQLProg\ReplSupp\RepNoDk
10:16:31 SQLProg\ReplSupp\ActiveX
10:16:31 SQLProg\Install
10:16:31 SQLProg\System
10:16:31 SQLProg\SvrExt
10:16:31 SQLProg\SvrExt\Help
10:16:31 SQLProg\SvrExt\SvrExtRs
10:16:31 SQLProg\SvrExt\ResIntl
10:16:31 SQLProg\Dat
10:16:31 SQLProg\DatSmpl
10:16:31 SQLProg\BaseSys
10:16:31 SQLProg\BaseBinn
10:16:31 SQLProg\BaseInst
10:16:31 SQLProg\Symbols
10:16:31 SQLProg\Symbols\EXE
10:16:31 SQLProg\Symbols\DLL
10:16:31 SQLProg\Perfmon
10:16:31 SQLProg\Perfmon\System
10:16:31 SQLProg\Root
10:16:31 MgtTool
10:16:31 MgtTool\SEM
10:16:31 MgtTool\SEM\HTML
10:16:31 MgtTool\SEM\MSD98
10:16:31 MgtTool\SEM\MSD98SYS
10:16:31 MgtTool\SEM\MSD98Res
10:16:31 MgtTool\SEM\MSD98Hlp
10:16:31 MgtTool\SEM\Help
10:16:31 MgtTool\SEM\Res1033
10:16:31 MgtTool\SEM\ResIntl
10:16:31 MgtTool\SEM\MSD98RsI
10:16:31 MgtTool\SEM\ActiveX
10:16:31 MgtTool\SEM\ActiveX\Res1033
10:16:31 MgtTool\SEM\ActiveX\ResIntl
10:16:31 MgtTool\SEM\Scripts
10:16:31 MgtTool\SEM\OLEDB
10:16:31 MgtTool\SEM\OLEDB\Res1033
10:16:31 MgtTool\SEM\OLEDB\ResIntl
10:16:31 MgtTool\Profiler
10:16:31 MgtTool\Profiler\Help
10:16:31 MgtTool\Profiler\Res1033
10:16:31 MgtTool\Profiler\ResIntl
10:16:31 MgtTool\Qryanlz
10:16:31 MgtTool\Qryanlz\Help
10:16:31 MgtTool\Qryanlz\Res1033
10:16:31 MgtTool\Qryanlz\ResIntl
10:16:31 MgtTool\DTCCLi
10:16:31 MgtTool\Wzcnflct
10:16:31 MgtTool\Wzcnflct\WzcnHlp
10:16:31 MgtTool\Wzcnflct\Wzcn1033
10:16:31 MgtTool\Wzcnflct\WzcnOthr
10:16:31 MgtTool\Wzcnflct\WzcnCmn
10:16:31 MgtTool\UtilSys
10:16:31 MgtTool\UtilBinn
10:16:31 Connect
10:16:31 Connect\ConnSys
10:16:31 Books
10:16:31 Books\Bookso
10:16:31 Books\Bookso\Utils
10:16:31 DevTools
10:16:31 DevTools\Dbg Int
10:16:31 DevTools\Dbg Int\Dbg Int Common
10:16:31 DevTools\Dbg Int\EXE
10:16:31 CoreRepl
10:16:31 CoreRepl\Res1033
10:16:31 CoreRepl\ResIntl
10:16:31 Core
10:16:31 Core\Res1033
10:16:31 Core\ResOther
10:16:31 Repostry
10:16:31 Repostry\RepstSys
10:16:31 Repostry\Res1033
10:16:31 Repostry\ResIntl
10:16:31 CoreMisc
10:16:31 CoreMisc\ActiveX
10:16:31 CoreMisc\ActiveX\Res1033
10:16:31 CoreMisc\ActiveX\ResIntl
10:16:31 CoreMisc\Res1033
10:16:31 Monarch
10:16:31 Monarch\Monr1033
10:16:31 Monarch\MonrIntl
10:16:31 Jet
10:16:31 CoreInst
10:16:31 CoreCOM
10:16:31 CoreCOM\Res1033
10:16:31 CoreCOM\ResIntl
10:16:31 CoreTool
10:16:31 CoreTool\Res1033
10:16:31 CoreTool\ResOther
10:16:31 DBLibCli
10:16:31 SFExt
10:16:31 SFExt\ActiveX
10:16:31 SFExt\ActiveX\Res1033
10:16:31 SFExt\ActiveX\ResIntl
10:16:31 SFExt\Res1033
10:16:31 SFExt\ResIntl
10:16:31 Trace
10:16:31 Trace\Res1033
10:16:31 Trace\ResOther
10:16:31 MiscCore
10:16:31 MC
10:16:31 MC\MC1033
10:16:31 MC\MCIntl
10:16:31 MC\Help
10:16:31 SQLMgr
10:16:31 SQLMgr\Res1033
10:16:31 SQLMgr\ResIntl
10:16:31 SvrTool
10:16:31 SvrTool\Res1033
10:16:31 SvrTool\ResIntl
10:16:31 DTSUI
10:16:31 DTSUI\Res1033
10:16:31 DTSUI\ResIntl
10:16:31 MSOlap
10:16:32 MSOlap\Res1033
10:16:32 MSOlap\ResIntl
10:16:32 ATL
10:16:32 ATL\winnt
10:16:32 ATL\win9x
10:16:32 MFC42U
10:16:32 VC
10:16:32 VB
10:16:32 OCX1
10:16:32 SQLAdHlp
10:16:32 SQLAdHlp\Res1033
10:16:32 SQLAdHlp\ResOther
10:16:32 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
10:16:32 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
10:16:32 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
10:16:32 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
10:16:32 End Action LogSelectedComponents
10:16:32 Begin Action InstallPkgs:
10:16:32 Begin Action: Locked Connectivity Files Check
10:16:40 ConnectivityLocked returned: 0
10:16:40 The operation completed successfully.
10:16:40 End Action: Locked Connectivity Files Check
10:16:40 Setup is installing Microsoft Data Access Components (MDAC) ...
10:16:40 \\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Other\sqlredis. exe /q:a
/C:"setupre.exe WARN=1 -s -SMS"
10:17:43 ExitCode: 0
10:17:43 Setup is installing Microsoft Distributed Transaction Coordinator
(MSDTC) ...
10:17:43 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir
"C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg
"\\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Other\dtcsetup .exe" -LogFile
"C:\WINDOWS\sqlstp.log"
10:17:45 Process Exit Code: (0)
10:17:45 /Q:A /T:C:\WINDOWS\TEMP\ixp001.tmp
10:17:45 Setup is installing HTML Help ...
10:17:48 HTML Help installer exit code: 0
10:18:15 End Action InstallPkgs
10:18:15 Begin Action MoveFileData:
10:18:15 Enabled SELFREGISTERBATCH
10:18:15 Enabled CORECOMPONENTHANDLING
10:21:34 Begin Action: MoveFileDataSpecial
10:21:37 End Action: MoveFileDataSpecial
10:21:37 End Action MoveFileData
10:21:37 Begin Action ProcessAfterDataMove:
10:21:37 \\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Binn\hhcol.exe C:\Program
Files\Microsoft SQL Server\80\Tools\Books
10:21:42 End Action ProcessAfterDataMove
10:21:42 Begin Action BuildServer:
10:21:42 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 5 -ExePath
"C:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe" -Service
"MSSQLSERVER"
10:21:43 Process Exit Code: (0)
10:21:43 Begin Action: CreateRegistrySetSQL
10:21:43 End Action: CreateRegistrySetSQL
10:21:43 Begin Action: RegWriteSetupEntry
10:21:43 End Action: RegWriteSetupEntry
10:21:43 Begin Action: CreateSer
10:21:43 End Action: CreateSer
10:21:43 Begin Action: SkuIt
10:21:44 End Action: SkuIt
10:21:45 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL
Server\MSSQL returned: 0, 0
10:21:45 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
10:21:45 Begin Action: UpdateSystemPath
10:21:45 Path successfully updated.
10:21:45 C:\oracle\ora92\bin;C:\Program
Files\Oracle\jre\1.3.1\bin;C:\Program
Files\Oracle\jre\1.1.8\bin;C:\Perl\bin\;%SystemRoo t%\system32;%SystemRoot%;%SystemRoot%\System32\Wbe m;C:\OCM;C:\Program
Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Common
Files\Autodesk Shared\;C:\Program Files\proe2001\bin;C:\Program Files\Common
Files\Roxio Shared\DLLShared;C:\Program Files\UltraEdit;C:\Program
Files\Rouzer File Printer\;C:\Program Files\Executive Software\Diskeeper\
10:21:45 End Action: UpdateSystemPath
10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
10:21:47 Grant Right for KALTEC\administrator returned : 1, 0
10:21:47 Grant Right for KALTEC\administrator returned : 1, 0
10:21:48 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F
"C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q
"SQL_Latin1_General_CP1_CI_AS" -H 66300 -U sa -P
################################################## #############################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=DEV2;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
driver={sql server};server=DEV2;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
driver={sql server};server=DEV2;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
SQL Server configuration failed.
################################################## #############################
10:22:26 Process Exit Code: (-1)
10:22:35 Setup failed to configure the server. Refer to the server error
logs and C:\WINDOWS\sqlstp.log for more information.
10:22:37 Action CleanUpInstall:
10:22:37 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service
SQLSERVERAGENT
10:22:38 Process Exit Code: (1060) The specified service does not exist as
an installed service.
10:22:38 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service
MSSQLSERVER
10:22:38 Process Exit Code: (0)
10:22:38 StatsGenerate returned: 2
10:22:38 StatsGenerate (0x0,0x1,0xf000000,0x100,1033,303,0x0,0x1,0,0,0
10:22:38 StatsGenerate -1,<Login Name>)
10:22:38 Installation Failed.
-----
2004-10-28 10:21:51.33 server Microsoft SQL Server 2000 - 8.00.194
(Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 1)
2004-10-28 10:21:51.37 server Copyright (C) 1988-2000 Microsoft
Corporation.
2004-10-28 10:21:51.37 server All rights reserved.
2004-10-28 10:21:51.37 server Server Process ID is 3460.
2004-10-28 10:21:51.37 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2004-10-28 10:21:51.41 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2004-10-28 10:21:51.78 server SQL Server configured for thread mode
processing.
2004-10-28 10:21:51.82 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2004-10-28 10:21:51.87 server Attempting to initialize Distributed
Transaction Coordinator.
2004-10-28 10:21:56.01 spid3 Warning ******************
2004-10-28 10:21:56.01 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2004-10-28 10:21:56.04 spid3 Starting up database 'master'.
2004-10-28 10:21:57.41 spid3 Server name is 'DEV2'.
2004-10-28 10:21:57.42 server Using 'SSNETLIB.DLL' version '8.0.311'.
2004-10-28 10:21:57.42 spid5 Starting up database 'model'.
2004-10-28 10:21:57.42 spid7 Starting up database 'msdb'.
2004-10-28 10:21:57.42 spid8 Starting up database 'pubs'.
2004-10-28 10:21:57.42 spid9 Starting up database 'Northwind'.
2004-10-28 10:21:58.95 spid5 Clearing tempdb database.
2004-10-28 10:22:00.94 server SQL server listening on 10.10.1.33: 1433.
2004-10-28 10:22:00.94 server SQL server listening on 127.0.0.1: 1433.
2004-10-28 10:22:02.26 spid5 Starting up database 'tempdb'.
2004-10-28 10:22:02.41 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2004-10-28 10:22:02.41 server SQL Server is ready for client connections
2004-10-28 10:22:02.61 spid3 Recovery complete.
2004-10-28 10:22:02.64 spid3 Warning: override, autoexec procedures
skipped.
2004-10-28 10:22:12.92 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
Turn off the Windows Firewall or open up UDP 1434 and TCP 1433 on it.
"Jim B." <Jim B.@.discussions.microsoft.com> wrote in message
news:3AFED5B5-06E9-47A4-8A7E-A68E1EEC24C4@.microsoft.com...
> Ok filks here is a strange one. Tried installing service pack 3am on my
> Windows XP
> machine that is at service 2 on the OS Level. Now from what I can gather
> when service pack 3a for SQL server is installed it wipes out all the
driver
> file locations and reinstalls a new MDAC from what I can see. But it never
> gets them installed and the SQL Server becomes mute because you can never
> connect to it. I've included a copy of the Log file that get's generated
from
> the install any one care to take a stab at this one. The following is the
> SQLSTP.Log File and under that is the Error Log from the SQL Server
> Directory. Any help would be great just reply to the group here.
> ----
--
> 10:14:35 Begin Setup
> 10:14:35 8.00.194
> 10:14:35 Mode = Normal
> 10:14:35 ModeType = NORMAL
> 10:14:38 GetDefinitionEx returned: 0, Extended: 0x0
> 10:14:38 ValueFTS returned: 1
> 10:14:38 ValuePID returned: 1
> 10:14:38 ValueLic returned: 0
> 10:14:38 System: Windows NT WorkStation
> 10:14:38 SQL Server ProductType: Developer Edition [0x3]
> 10:14:38 Begin Action: SetupInitialize
> 10:14:38 End Action SetupInitialize
> 10:14:38 Begin Action: SetupInstall
> 10:14:38 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir
...
> 10:14:38 CommonFilesDir=C:\Program Files\Common Files
> 10:14:38 Windows Directory=C:\WINDOWS\
> 10:14:38 Program Files=C:\Program Files\
> 10:14:38 TEMPDIR=C:\WINDOWS\TEMP\
> 10:14:38 Begin Action: SetupInstall
> 10:14:39 digpid size : 256
> 10:14:39 digpid size : 164
> 10:14:39 Begin Action: CheckFixedRequirements
> 10:14:39 Platform ID: 0xf000000
> 10:14:39 Version: 5.1.2600
> 10:14:39 File Version - C:\WINDOWS\System32\shdocvw.dll: 6.0.2800.1584
> 10:14:39 End Action: CheckFixedRequirements
> 10:14:40 Begin Action: ShowDialogs
> 10:14:40 Initial Dialog Mask: 0x83000f7, Disable Back=0x1
> 10:14:41 Begin Action ShowDialogsHlpr: 0x1
> 10:14:41 Begin Action: DialogShowSdWelcome
> 10:14:43 End Action DialogShowSdWelcome
> 10:14:43 Dialog 0x1 returned: 1
> 10:14:43 End Action ShowDialogsHlpr
> 10:14:43 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
> 10:14:43 Begin Action ShowDialogsHlpr: 0x2
> 10:14:43 Begin Action: DialogShowSdMachineName
> 10:14:45 ShowDlgMachine returned: 1
> 10:14:45 Name = DEV2, Type = 0x1
> 10:14:45 Begin Action: CheckRequirements
> 10:14:45 Processor Architecture: x86 (Pentium)
> 10:14:45 Service Pack: 256
> 10:14:45 ComputerName: DEV2
> 10:14:45 User Name: <Login Name>
> 10:14:45 IsAllAccessAllowed returned: 1
> 10:14:45 OS Language: 0x409
> 10:14:45 End Action CheckRequirements
> 10:14:45 This combination of Package and Operating System allows a full
> product install.
> 10:14:46 CreateSetupTopology(DEV2), Handle : 0x1134a50, returned : 0
> 10:14:46 CreateSetupTopology returned : 0, Handle : 0x1134a50
> 10:14:46 Topology Type : 1, Return Value : 0
> 10:14:46 ST_GetPhysicalNode returned : 0, PNHandle : 0x1134a78
> 10:14:46 PN_EnumerateEx returned : 0
> 10:14:46 PN_GetSQLStates returned : 0, SqlStates : 0x0
> 10:14:46 PN_StartScan [0x1134a78] returned : 0
> 10:14:46 PN_GetNext [0x1134a78] returned : 18, Handle: [0x0]
> 10:14:46 No more items in enumeration.
> 10:14:46 ReleaseSetupTopology
> 10:14:46 Named instance limit: 100, quota: 0
> 10:14:46 End Action DialogShowSdMachineName
> 10:14:46 begin ShowDialogsUpdateMask
> 10:14:46 nFullMask = 0x83000f7, nCurrent = 0x2, nDirection = 0
> 10:14:46 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
> 10:14:46 Dialog 0x2 returned: 0
> 10:14:46 End Action ShowDialogsHlpr
> 10:14:46 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
> 10:14:46 Begin Action ShowDialogsHlpr: 0x4
> 10:14:46 Begin Action: DialogShowSdInstallMode
> 10:14:48 ShowDlgInstallMode returned: 1
> 10:14:48 InstallMode : 0x1
> 10:14:48 End Action DialogShowSdInstallMode
> 10:14:48 begin ShowDialogsUpdateMask
> 10:14:48 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
> 10:14:48 Updated Dialog Mask: 0xbf40037, Disable Back = 0x1
> 10:14:48 Dialog 0x4 returned: 1
> 10:14:48 End Action ShowDialogsHlpr
> 10:14:48 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
> 10:14:48 Begin Action ShowDialogsHlpr: 0x10
> 10:14:48 Begin Action: DialogShowSdRegisterUserEx
> 10:14:57 End Action DialogShowSdRegisterUserEx
> 10:14:57 Dialog 0x10 returned: 1
> 10:14:57 End Action ShowDialogsHlpr
> 10:14:57 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
> 10:14:57 Begin Action ShowDialogsHlpr: 0x20
> 10:14:57 Begin Action: DialogShowSdLicense
> 10:15:00 End Action DialogShowSdLicense
> 10:15:00 Dialog 0x20 returned: 1
> 10:15:00 End Action ShowDialogsHlpr
> 10:15:00 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
> 10:15:00 Begin Action ShowDialogsHlpr: 0x40000
> 10:15:00 Begin Action: DialogShowSdCliSvr
> 10:15:00 DisplaySystemPreReq
> 10:15:02 ShowDlgClientServerSelect returned: 1
> 10:15:02 Type : 0x2
> 10:15:02 End Action DialogShowSdCliSvr
> 10:15:02 begin ShowDialogsUpdateMask
> 10:15:02 nFullMask = 0xbf40037, nCurrent = 0x40000, nDirection = 1
> 10:15:02 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
> 10:15:02 Dialog 0x40000 returned: 1
> 10:15:02 End Action ShowDialogsHlpr
> 10:15:02 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
> 10:15:02 Begin Action ShowDialogsHlpr: 0x80000
> 10:15:02 Begin Action: DialogShowSdInstanceName
> 10:15:02 Begin Action: ShowDlgInstanceName
> 10:15:03 End Action: ShowDlgInstanceName
> 10:15:03 ShowDlgInstanceName returned : 1
> 10:15:03 InstanceName : MSSQLSERVER
> 10:15:03 CreateSetupTopology(DEV2), Handle : 0x1134a50, returned : 0
> 10:15:03 CreateSetupTopology returned : 0, Handle : 0x1134a50
> 10:15:03 Topology Type : 1, Return Value : 0
> 10:15:03 ST_GetPhysicalNode returned : 0, PNHandle : 0x1134a78
> 10:15:03 PN_EnumerateEx returned : 0
> 10:15:03 PN_GetSQLStates returned : 0, SqlStates : 0x0
> 10:15:03 PN_StartScan [0x1134a78] returned : 0
> 10:15:03 PN_GetNext [0x1134a78] returned : 18, Handle: [0x0]
> 10:15:03 No more items in enumeration.
> 10:15:03 ReleaseSetupTopology
> 10:15:03 End Action DialogShowSdInstanceName
> 10:15:03 begin ShowDialogsUpdateMask
> 10:15:03 nFullMask = 0xbfc0037, nCurrent = 0x80000, nDirection = 1
> 10:15:03 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
> 10:15:03 Dialog 0x80000 returned: 1
> 10:15:03 End Action ShowDialogsHlpr
> 10:15:04 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
> 10:15:04 Begin Action ShowDialogsHlpr: 0x100000
> 10:15:04 Begin Action: DialogShowSdSetupType
> 10:15:04 Begin Action: Setup Type
> 10:15:22 Setup type set Typical
> 10:15:34 SQL program folder: C:\Program Files\Microsoft SQL Server
> 10:15:34 SQL data folder: C:\Program Files\Microsoft SQL Server
> 10:15:34 Windows system folder: C:\WINDOWS\System32\
> 10:15:34 Prog req: 38073, Data req: 34432, Sys req: 114225
> 10:15:34 Prog avail: 9393472, Data avail: 9393472, Sys avail: 9393472
> 10:15:34 Prog req vs. avail, 186730, 9393472
> 10:15:34 Data req vs. avail, 34432, 9393472
> 10:15:34 Sys req vs. avail, 148657, 9393472
> 10:15:34 DisplaySystemPreReq
> 10:15:34 [SetupTypeSQL]
> 10:15:34 szDir = C:\Program Files\Microsoft SQL Server
> 10:15:34 szDir = %PROGRAMFILES%\Microsoft SQL Server
> 10:15:34 Result = 301
> 10:15:34 szDataDir = C:\Program Files\Microsoft SQL Server
> 10:15:34 szDataDir = %PROGRAMFILES%\Microsoft SQL Server
> 10:15:34 End Action: Setup Type
> 10:15:34 Setup Type: Typical (301)
> 10:15:34 End Action DialogShowSdSetupType
> 10:15:34 begin ShowDialogsUpdateMask
> 10:15:34 nFullMask = 0xbfc0037, nCurrent = 0x100000, nDirection = 301
> 10:15:34 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:15:34 Dialog 0x100000 returned: 301
> 10:15:34 End Action ShowDialogsHlpr
> 10:15:34 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
> 10:15:34 Begin Action ShowDialogsHlpr: 0x400000
> 10:15:34 Begin Action: DlgServices
> 10:16:15 ShowDlgServices returned: 1
> 10:16:15 [DlgServices]
> 10:16:15 Local-Domain = 61680
> 10:16:15 AutoStart = 15
> 10:16:15 SQLDomain = KALTEC
> 10:16:15 SQLDomainAcct = administrator
> 10:16:15 SQLDomainPwd
> 10:16:15 AgtDomain = KALTEC
> 10:16:15 AgtDomainAcct = administrator
> 10:16:15 AgtDomainPwd
> 10:16:15 Result = 1
> 10:16:15 End Action DlgServices
> 10:16:15 begin ShowDialogsUpdateMask
> 10:16:15 nFullMask = 0xbdc0037, nCurrent = 0x400000, nDirection = 1
> 10:16:15 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:15 Dialog 0x400000 returned: 1
> 10:16:15 End Action ShowDialogsHlpr
> 10:16:15 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
> 10:16:15 Begin Action ShowDialogsHlpr: 0x800000
> 10:16:15 Begin Action: DlgSQLSecurity
> 10:16:27 ShowDlgSQLSecurity returned: 1
> 10:16:27 LoginMode = 2,szPwd
> 10:16:28 End Action DlgSQLSecurity
> 10:16:28 begin ShowDialogsUpdateMask
> 10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x800000, nDirection = 1
> 10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:28 Dialog 0x800000 returned: 1
> 10:16:28 End Action ShowDialogsHlpr
> 10:16:28 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
> 10:16:28 Begin Action ShowDialogsHlpr: 0x1000000
> 10:16:28 Begin Action: DlgCollation
> 10:16:28 ShowDlgCollation returned: 1
> 10:16:28 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name =
> Latin1_General,lcid = 0x409,SortId = 52,dwCompFlags = 0x30001
> 10:16:28 End Action DlgCollation
> 10:16:28 begin ShowDialogsUpdateMask
> 10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x1000000, nDirection = 1
> 10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:28 Dialog 0x1000000 returned: 1
> 10:16:28 End Action ShowDialogsHlpr
> 10:16:28 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
> 10:16:28 Begin Action ShowDialogsHlpr: 0x2000000
> 10:16:28 Begin Action: DlgNetwork
> 10:16:28 ShowDlgNetwork returned: 1
> 10:16:28 [DlgServerNetwork]
> 10:16:28 NetworkLibs = 255
> 10:16:28 TCPPort = 1433
> 10:16:28 TCPPrxy = Default
> 10:16:28 NMPPipeName = \\.\pipe\sql\query
> 10:16:28 Result = 1
> 10:16:28 End Action DlgNetwork
> 10:16:28 begin ShowDialogsUpdateMask
> 10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x2000000, nDirection = 1
> 10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:28 Dialog 0x2000000 returned: 1
> 10:16:28 End Action ShowDialogsHlpr
> 10:16:28 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
> 10:16:28 Begin Action ShowDialogsHlpr: 0x8000000
> 10:16:28 Begin Action: DialogShowSdStartCopy
> 10:16:30 End Action DialogShowSdStartCopy
> 10:16:30 begin ShowDialogsUpdateMask
> 10:16:30 nFullMask = 0xbdc0037, nCurrent = 0x8000000, nDirection = 1
> 10:16:30 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:30 Dialog 0x8000000 returned: 1
> 10:16:30 End Action ShowDialogsHlpr
> 10:16:30 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
> 10:16:30 End Action ShowDialogs
> 10:16:30 Begin Action ProcessBeforeDataMove:
> 10:16:31 DeinstallStart returned (C:\Program Files\Microsoft SQL
> Server\MSSQL): 0
> 10:16:31 End Action ProcessBeforeDataMove:
> 10:16:31 Begin Action SetToolsComponentSelection:
> 10:16:31 End Action SetToolsComponentSelection:
> 10:16:31 Begin Action ProcessComponentSelection:
> 10:16:31 End Action ProcessComponentSelection
> 10:16:31 Begin Action LogSelectedComponents:
> 10:16:31 SQLProg
> 10:16:31 SQLProg\SQLServr
> 10:16:31 SQLProg\SQLServr\Help
> 10:16:31 SQLProg\SQLServr\SCMDev
> 10:16:31 SQLProg\SQLServr\SCMDev\SCMh
> 10:16:31 SQLProg\SQLServr\SCMDev\SCMX86Lb
> 10:16:31 SQLProg\SQLServr\SCMDev\SCMALb
> 10:16:31 SQLProg\SQLServr\Rs1033
> 10:16:31 SQLProg\SQLServr\RsIntl
> 10:16:31 SQLProg\SQLServr\ActiveX
> 10:16:31 SQLProg\SQLServr\System
> 10:16:31 SQLProg\UpgTools
> 10:16:31 SQLProg\UpgTools\UpgSys
> 10:16:31 SQLProg\UpgTools\ActiveX
> 10:16:31 SQLProg\UpgTools\Res1033
> 10:16:31 SQLProg\UpgTools\ResOther
> 10:16:31 SQLProg\UpgTools\Resld
> 10:16:31 SQLProg\ReplSupp
> 10:16:31 SQLProg\ReplSupp\ReplDat
> 10:16:31 SQLProg\ReplSupp\RepComm
> 10:16:31 SQLProg\ReplSupp\RepNoDk
> 10:16:31 SQLProg\ReplSupp\ActiveX
> 10:16:31 SQLProg\Install
> 10:16:31 SQLProg\System
> 10:16:31 SQLProg\SvrExt
> 10:16:31 SQLProg\SvrExt\Help
> 10:16:31 SQLProg\SvrExt\SvrExtRs
> 10:16:31 SQLProg\SvrExt\ResIntl
> 10:16:31 SQLProg\Dat
> 10:16:31 SQLProg\DatSmpl
> 10:16:31 SQLProg\BaseSys
> 10:16:31 SQLProg\BaseBinn
> 10:16:31 SQLProg\BaseInst
> 10:16:31 SQLProg\Symbols
> 10:16:31 SQLProg\Symbols\EXE
> 10:16:31 SQLProg\Symbols\DLL
> 10:16:31 SQLProg\Perfmon
> 10:16:31 SQLProg\Perfmon\System
> 10:16:31 SQLProg\Root
> 10:16:31 MgtTool
> 10:16:31 MgtTool\SEM
> 10:16:31 MgtTool\SEM\HTML
> 10:16:31 MgtTool\SEM\MSD98
> 10:16:31 MgtTool\SEM\MSD98SYS
> 10:16:31 MgtTool\SEM\MSD98Res
> 10:16:31 MgtTool\SEM\MSD98Hlp
> 10:16:31 MgtTool\SEM\Help
> 10:16:31 MgtTool\SEM\Res1033
> 10:16:31 MgtTool\SEM\ResIntl
> 10:16:31 MgtTool\SEM\MSD98RsI
> 10:16:31 MgtTool\SEM\ActiveX
> 10:16:31 MgtTool\SEM\ActiveX\Res1033
> 10:16:31 MgtTool\SEM\ActiveX\ResIntl
> 10:16:31 MgtTool\SEM\Scripts
> 10:16:31 MgtTool\SEM\OLEDB
> 10:16:31 MgtTool\SEM\OLEDB\Res1033
> 10:16:31 MgtTool\SEM\OLEDB\ResIntl
> 10:16:31 MgtTool\Profiler
> 10:16:31 MgtTool\Profiler\Help
> 10:16:31 MgtTool\Profiler\Res1033
> 10:16:31 MgtTool\Profiler\ResIntl
> 10:16:31 MgtTool\Qryanlz
> 10:16:31 MgtTool\Qryanlz\Help
> 10:16:31 MgtTool\Qryanlz\Res1033
> 10:16:31 MgtTool\Qryanlz\ResIntl
> 10:16:31 MgtTool\DTCCLi
> 10:16:31 MgtTool\Wzcnflct
> 10:16:31 MgtTool\Wzcnflct\WzcnHlp
> 10:16:31 MgtTool\Wzcnflct\Wzcn1033
> 10:16:31 MgtTool\Wzcnflct\WzcnOthr
> 10:16:31 MgtTool\Wzcnflct\WzcnCmn
> 10:16:31 MgtTool\UtilSys
> 10:16:31 MgtTool\UtilBinn
> 10:16:31 Connect
> 10:16:31 Connect\ConnSys
> 10:16:31 Books
> 10:16:31 Books\Bookso
> 10:16:31 Books\Bookso\Utils
> 10:16:31 DevTools
> 10:16:31 DevTools\Dbg Int
> 10:16:31 DevTools\Dbg Int\Dbg Int Common
> 10:16:31 DevTools\Dbg Int\EXE
> 10:16:31 CoreRepl
> 10:16:31 CoreRepl\Res1033
> 10:16:31 CoreRepl\ResIntl
> 10:16:31 Core
> 10:16:31 Core\Res1033
> 10:16:31 Core\ResOther
> 10:16:31 Repostry
> 10:16:31 Repostry\RepstSys
> 10:16:31 Repostry\Res1033
> 10:16:31 Repostry\ResIntl
> 10:16:31 CoreMisc
> 10:16:31 CoreMisc\ActiveX
> 10:16:31 CoreMisc\ActiveX\Res1033
> 10:16:31 CoreMisc\ActiveX\ResIntl
> 10:16:31 CoreMisc\Res1033
> 10:16:31 Monarch
> 10:16:31 Monarch\Monr1033
> 10:16:31 Monarch\MonrIntl
> 10:16:31 Jet
> 10:16:31 CoreInst
> 10:16:31 CoreCOM
> 10:16:31 CoreCOM\Res1033
> 10:16:31 CoreCOM\ResIntl
> 10:16:31 CoreTool
> 10:16:31 CoreTool\Res1033
> 10:16:31 CoreTool\ResOther
> 10:16:31 DBLibCli
> 10:16:31 SFExt
> 10:16:31 SFExt\ActiveX
> 10:16:31 SFExt\ActiveX\Res1033
> 10:16:31 SFExt\ActiveX\ResIntl
> 10:16:31 SFExt\Res1033
> 10:16:31 SFExt\ResIntl
> 10:16:31 Trace
> 10:16:31 Trace\Res1033
> 10:16:31 Trace\ResOther
> 10:16:31 MiscCore
> 10:16:31 MC
> 10:16:31 MC\MC1033
> 10:16:31 MC\MCIntl
> 10:16:31 MC\Help
> 10:16:31 SQLMgr
> 10:16:31 SQLMgr\Res1033
> 10:16:31 SQLMgr\ResIntl
> 10:16:31 SvrTool
> 10:16:31 SvrTool\Res1033
> 10:16:31 SvrTool\ResIntl
> 10:16:31 DTSUI
> 10:16:31 DTSUI\Res1033
> 10:16:31 DTSUI\ResIntl
> 10:16:31 MSOlap
> 10:16:32 MSOlap\Res1033
> 10:16:32 MSOlap\ResIntl
> 10:16:32 ATL
> 10:16:32 ATL\winnt
> 10:16:32 ATL\win9x
> 10:16:32 MFC42U
> 10:16:32 VC
> 10:16:32 VB
> 10:16:32 OCX1
> 10:16:32 SQLAdHlp
> 10:16:32 SQLAdHlp\Res1033
> 10:16:32 SQLAdHlp\ResOther
> 10:16:32 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
> 10:16:32 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
> 10:16:32 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
> 10:16:32 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
> 10:16:32 End Action LogSelectedComponents
> 10:16:32 Begin Action InstallPkgs:
> 10:16:32 Begin Action: Locked Connectivity Files Check
> 10:16:40 ConnectivityLocked returned: 0
> 10:16:40 The operation completed successfully.
> 10:16:40 End Action: Locked Connectivity Files Check
> 10:16:40 Setup is installing Microsoft Data Access Components (MDAC) ...
> 10:16:40 \\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Other\sqlredis. exe /q:a
> /C:"setupre.exe WARN=1 -s -SMS"
> 10:17:43 ExitCode: 0
> 10:17:43 Setup is installing Microsoft Distributed Transaction Coordinator
> (MSDTC) ...
> 10:17:43 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir
> "C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg
> "\\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Other\dtcsetup .exe" -LogFile
> "C:\WINDOWS\sqlstp.log"
> 10:17:45 Process Exit Code: (0)
> 10:17:45 /Q:A /T:C:\WINDOWS\TEMP\ixp001.tmp
> 10:17:45 Setup is installing HTML Help ...
> 10:17:48 HTML Help installer exit code: 0
> 10:18:15 End Action InstallPkgs
> 10:18:15 Begin Action MoveFileData:
> 10:18:15 Enabled SELFREGISTERBATCH
> 10:18:15 Enabled CORECOMPONENTHANDLING
> 10:21:34 Begin Action: MoveFileDataSpecial
> 10:21:37 End Action: MoveFileDataSpecial
> 10:21:37 End Action MoveFileData
> 10:21:37 Begin Action ProcessAfterDataMove:
> 10:21:37 \\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Binn\hhcol.exe C:\Program
> Files\Microsoft SQL Server\80\Tools\Books
> 10:21:42 End Action ProcessAfterDataMove
> 10:21:42 Begin Action BuildServer:
> 10:21:42 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action
5 -ExePath
> "C:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe" -Service
> "MSSQLSERVER"
> 10:21:43 Process Exit Code: (0)
> 10:21:43 Begin Action: CreateRegistrySetSQL
> 10:21:43 End Action: CreateRegistrySetSQL
> 10:21:43 Begin Action: RegWriteSetupEntry
> 10:21:43 End Action: RegWriteSetupEntry
> 10:21:43 Begin Action: CreateSer
> 10:21:43 End Action: CreateSer
> 10:21:43 Begin Action: SkuIt
> 10:21:44 End Action: SkuIt
> 10:21:45 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL
> Server\MSSQL returned: 0, 0
> 10:21:45 SetRegSecuritySQLAndAdmin for
> Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
> 10:21:45 Begin Action: UpdateSystemPath
> 10:21:45 Path successfully updated.
> 10:21:45 C:\oracle\ora92\bin;C:\Program
> Files\Oracle\jre\1.3.1\bin;C:\Program
>
Files\Oracle\jre\1.1.8\bin;C:\Perl\bin\;%SystemRoo t%\system32;%SystemRoot%;%
SystemRoot%\System32\Wbem;C:\OCM;C:\Program
> Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Common
> Files\Autodesk Shared\;C:\Program Files\proe2001\bin;C:\Program
Files\Common
> Files\Roxio Shared\DLLShared;C:\Program Files\UltraEdit;C:\Program
> Files\Rouzer File Printer\;C:\Program Files\Executive Software\Diskeeper\
> 10:21:45 End Action: UpdateSystemPath
> 10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:47 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:47 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:48 C:\Program Files\Microsoft SQL
erver\80\Tools\Binn\cnfgsvr.exe -F
> "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q
> "SQL_Latin1_General_CP1_CI_AS" -H 66300 -U sa -P
>
################################################## ##########################
###
>
> Starting Service ...
> SQL_Latin1_General_CP1_CI_AS
> -m -Q -T4022 -T3659
> Connecting to Server ...
> driver={sql server};server=DEV2;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> driver={sql server};server=DEV2;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> driver={sql server};server=DEV2;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> SQL Server configuration failed.
>
################################################## ##########################
###
> 10:22:26 Process Exit Code: (-1)
> 10:22:35 Setup failed to configure the server. Refer to the server error
> logs and C:\WINDOWS\sqlstp.log for more information.
> 10:22:37 Action CleanUpInstall:
> 10:22:37 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action
4 -Service
> SQLSERVERAGENT
> 10:22:38 Process Exit Code: (1060) The specified service does not exist as
> an installed service.
> 10:22:38 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action
4 -Service
> MSSQLSERVER
> 10:22:38 Process Exit Code: (0)
> 10:22:38 StatsGenerate returned: 2
> 10:22:38 StatsGenerate (0x0,0x1,0xf000000,0x100,1033,303,0x0,0x1,0,0,0
> 10:22:38 StatsGenerate -1,<Login Name>)
> 10:22:38 Installation Failed.
> ----
--
> 2004-10-28 10:21:51.33 server Microsoft SQL Server 2000 - 8.00.194
> (Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 1)
> 2004-10-28 10:21:51.37 server Copyright (C) 1988-2000 Microsoft
> Corporation.
> 2004-10-28 10:21:51.37 server All rights reserved.
> 2004-10-28 10:21:51.37 server Server Process ID is 3460.
> 2004-10-28 10:21:51.37 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2004-10-28 10:21:51.41 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).
> 2004-10-28 10:21:51.78 server SQL Server configured for thread mode
> processing.
> 2004-10-28 10:21:51.82 server Using dynamic lock allocation. [2500]
Lock
> Blocks, [5000] Lock Owner Blocks.
> 2004-10-28 10:21:51.87 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2004-10-28 10:21:56.01 spid3 Warning ******************
> 2004-10-28 10:21:56.01 spid3 SQL Server started in single user mode.
> Updates allowed to system catalogs.
> 2004-10-28 10:21:56.04 spid3 Starting up database 'master'.
> 2004-10-28 10:21:57.41 spid3 Server name is 'DEV2'.
> 2004-10-28 10:21:57.42 server Using 'SSNETLIB.DLL' version '8.0.311'.
> 2004-10-28 10:21:57.42 spid5 Starting up database 'model'.
> 2004-10-28 10:21:57.42 spid7 Starting up database 'msdb'.
> 2004-10-28 10:21:57.42 spid8 Starting up database 'pubs'.
> 2004-10-28 10:21:57.42 spid9 Starting up database 'Northwind'.
> 2004-10-28 10:21:58.95 spid5 Clearing tempdb database.
> 2004-10-28 10:22:00.94 server SQL server listening on 10.10.1.33: 1433.
> 2004-10-28 10:22:00.94 server SQL server listening on 127.0.0.1: 1433.
> 2004-10-28 10:22:02.26 spid5 Starting up database 'tempdb'.
> 2004-10-28 10:22:02.41 server SQL server listening on TCP, Shared
Memory,
> Named Pipes.
> 2004-10-28 10:22:02.41 server SQL Server is ready for client
connections
> 2004-10-28 10:22:02.61 spid3 Recovery complete.
> 2004-10-28 10:22:02.64 spid3 Warning: override, autoexec procedures
> skipped.
> 2004-10-28 10:22:12.92 spid3 SQL Server is terminating due to 'stop'
> request from Service Control Manager.
>
Patch 3a
Ok filks here is a strange one. Tried installing service pack 3am on my
Windows XP
machine that is at service 2 on the OS Level. Now from what I can gather
when service pack 3a for SQL server is installed it wipes out all the driver
file locations and reinstalls a new MDAC from what I can see. But it never
gets them installed and the SQL Server becomes mute because you can never
connect to it. I've included a copy of the Log file that get's generated from
the install any one care to take a stab at this one. The following is the
SQLSTP.Log File and under that is the Error Log from the SQL Server
Directory. Any help would be great just reply to the group here
-----
10:14:35 Begin Setup
10:14:35 8.00.194
10:14:35 Mode = Normal
10:14:35 ModeType = NORMAL
10:14:38 GetDefinitionEx returned: 0, Extended: 0x0
10:14:38 ValueFTS returned: 1
10:14:38 ValuePID returned: 1
10:14:38 ValueLic returned: 0
10:14:38 System: Windows NT WorkStation
10:14:38 SQL Server ProductType: Developer Edition [0x3]
10:14:38 Begin Action: SetupInitialize
10:14:38 End Action SetupInitialize
10:14:38 Begin Action: SetupInstall
10:14:38 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
10:14:38 CommonFilesDir=C:\Program Files\Common Files
10:14:38 Windows Directory=C:\WINDOWS\
10:14:38 Program Files=C:\Program Files\
10:14:38 TEMPDIR=C:\WINDOWS\TEMP\
10:14:38 Begin Action: SetupInstall
10:14:39 digpid size : 256
10:14:39 digpid size : 164
10:14:39 Begin Action: CheckFixedRequirements
10:14:39 Platform ID: 0xf000000
10:14:39 Version: 5.1.2600
10:14:39 File Version - C:\WINDOWS\System32\shdocvw.dll: 6.0.2800.1584
10:14:39 End Action: CheckFixedRequirements
10:14:40 Begin Action: ShowDialogs
10:14:40 Initial Dialog Mask: 0x83000f7, Disable Back=0x1
10:14:41 Begin Action ShowDialogsHlpr: 0x1
10:14:41 Begin Action: DialogShowSdWelcome
10:14:43 End Action DialogShowSdWelcome
10:14:43 Dialog 0x1 returned: 1
10:14:43 End Action ShowDialogsHlpr
10:14:43 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
10:14:43 Begin Action ShowDialogsHlpr: 0x2
10:14:43 Begin Action: DialogShowSdMachineName
10:14:45 ShowDlgMachine returned: 1
10:14:45 Name = DEV2, Type = 0x1
10:14:45 Begin Action: CheckRequirements
10:14:45 Processor Architecture: x86 (Pentium)
10:14:45 Service Pack: 256
10:14:45 ComputerName: DEV2
10:14:45 User Name: <Login Name>
10:14:45 IsAllAccessAllowed returned: 1
10:14:45 OS Language: 0x409
10:14:45 End Action CheckRequirements
10:14:45 This combination of Package and Operating System allows a full
product install.
10:14:46 CreateSetupTopology(DEV2), Handle : 0x1134a50, returned : 0
10:14:46 CreateSetupTopology returned : 0, Handle : 0x1134a50
10:14:46 Topology Type : 1, Return Value : 0
10:14:46 ST_GetPhysicalNode returned : 0, PNHandle : 0x1134a78
10:14:46 PN_EnumerateEx returned : 0
10:14:46 PN_GetSQLStates returned : 0, SqlStates : 0x0
10:14:46 PN_StartScan [0x1134a78] returned : 0
10:14:46 PN_GetNext [0x1134a78] returned : 18, Handle: [0x0]
10:14:46 No more items in enumeration.
10:14:46 ReleaseSetupTopology
10:14:46 Named instance limit: 100, quota: 0
10:14:46 End Action DialogShowSdMachineName
10:14:46 begin ShowDialogsUpdateMask
10:14:46 nFullMask = 0x83000f7, nCurrent = 0x2, nDirection = 0
10:14:46 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
10:14:46 Dialog 0x2 returned: 0
10:14:46 End Action ShowDialogsHlpr
10:14:46 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
10:14:46 Begin Action ShowDialogsHlpr: 0x4
10:14:46 Begin Action: DialogShowSdInstallMode
10:14:48 ShowDlgInstallMode returned: 1
10:14:48 InstallMode : 0x1
10:14:48 End Action DialogShowSdInstallMode
10:14:48 begin ShowDialogsUpdateMask
10:14:48 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
10:14:48 Updated Dialog Mask: 0xbf40037, Disable Back = 0x1
10:14:48 Dialog 0x4 returned: 1
10:14:48 End Action ShowDialogsHlpr
10:14:48 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
10:14:48 Begin Action ShowDialogsHlpr: 0x10
10:14:48 Begin Action: DialogShowSdRegisterUserEx
10:14:57 End Action DialogShowSdRegisterUserEx
10:14:57 Dialog 0x10 returned: 1
10:14:57 End Action ShowDialogsHlpr
10:14:57 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
10:14:57 Begin Action ShowDialogsHlpr: 0x20
10:14:57 Begin Action: DialogShowSdLicense
10:15:00 End Action DialogShowSdLicense
10:15:00 Dialog 0x20 returned: 1
10:15:00 End Action ShowDialogsHlpr
10:15:00 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
10:15:00 Begin Action ShowDialogsHlpr: 0x40000
10:15:00 Begin Action: DialogShowSdCliSvr
10:15:00 DisplaySystemPreReq
10:15:02 ShowDlgClientServerSelect returned: 1
10:15:02 Type : 0x2
10:15:02 End Action DialogShowSdCliSvr
10:15:02 begin ShowDialogsUpdateMask
10:15:02 nFullMask = 0xbf40037, nCurrent = 0x40000, nDirection = 1
10:15:02 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
10:15:02 Dialog 0x40000 returned: 1
10:15:02 End Action ShowDialogsHlpr
10:15:02 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
10:15:02 Begin Action ShowDialogsHlpr: 0x80000
10:15:02 Begin Action: DialogShowSdInstanceName
10:15:02 Begin Action: ShowDlgInstanceName
10:15:03 End Action: ShowDlgInstanceName
10:15:03 ShowDlgInstanceName returned : 1
10:15:03 InstanceName : MSSQLSERVER
10:15:03 CreateSetupTopology(DEV2), Handle : 0x1134a50, returned : 0
10:15:03 CreateSetupTopology returned : 0, Handle : 0x1134a50
10:15:03 Topology Type : 1, Return Value : 0
10:15:03 ST_GetPhysicalNode returned : 0, PNHandle : 0x1134a78
10:15:03 PN_EnumerateEx returned : 0
10:15:03 PN_GetSQLStates returned : 0, SqlStates : 0x0
10:15:03 PN_StartScan [0x1134a78] returned : 0
10:15:03 PN_GetNext [0x1134a78] returned : 18, Handle: [0x0]
10:15:03 No more items in enumeration.
10:15:03 ReleaseSetupTopology
10:15:03 End Action DialogShowSdInstanceName
10:15:03 begin ShowDialogsUpdateMask
10:15:03 nFullMask = 0xbfc0037, nCurrent = 0x80000, nDirection = 1
10:15:03 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
10:15:03 Dialog 0x80000 returned: 1
10:15:03 End Action ShowDialogsHlpr
10:15:04 ShowDialogsGetDialog returned: nCurrent=0x100000,index 10:15:04 Begin Action ShowDialogsHlpr: 0x100000
10:15:04 Begin Action: DialogShowSdSetupType
10:15:04 Begin Action: Setup Type
10:15:22 Setup type set Typical
10:15:34 SQL program folder: C:\Program Files\Microsoft SQL Server
10:15:34 SQL data folder: C:\Program Files\Microsoft SQL Server
10:15:34 Windows system folder: C:\WINDOWS\System32\
10:15:34 Prog req: 38073, Data req: 34432, Sys req: 114225
10:15:34 Prog avail: 9393472, Data avail: 9393472, Sys avail: 9393472
10:15:34 Prog req vs. avail, 186730, 9393472
10:15:34 Data req vs. avail, 34432, 9393472
10:15:34 Sys req vs. avail, 148657, 9393472
10:15:34 DisplaySystemPreReq
10:15:34 [SetupTypeSQL]
10:15:34 szDir = C:\Program Files\Microsoft SQL Server
10:15:34 szDir = %PROGRAMFILES%\Microsoft SQL Server
10:15:34 Result = 301
10:15:34 szDataDir = C:\Program Files\Microsoft SQL Server
10:15:34 szDataDir = %PROGRAMFILES%\Microsoft SQL Server
10:15:34 End Action: Setup Type
10:15:34 Setup Type: Typical (301)
10:15:34 End Action DialogShowSdSetupType
10:15:34 begin ShowDialogsUpdateMask
10:15:34 nFullMask = 0xbfc0037, nCurrent = 0x100000, nDirection = 301
10:15:34 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:15:34 Dialog 0x100000 returned: 301
10:15:34 End Action ShowDialogsHlpr
10:15:34 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
10:15:34 Begin Action ShowDialogsHlpr: 0x400000
10:15:34 Begin Action: DlgServices
10:16:15 ShowDlgServices returned: 1
10:16:15 [DlgServices]
10:16:15 Local-Domain = 61680
10:16:15 AutoStart = 15
10:16:15 SQLDomain = KALTEC
10:16:15 SQLDomainAcct = administrator
10:16:15 SQLDomainPwd
10:16:15 AgtDomain = KALTEC
10:16:15 AgtDomainAcct = administrator
10:16:15 AgtDomainPwd
10:16:15 Result = 1
10:16:15 End Action DlgServices
10:16:15 begin ShowDialogsUpdateMask
10:16:15 nFullMask = 0xbdc0037, nCurrent = 0x400000, nDirection = 1
10:16:15 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:15 Dialog 0x400000 returned: 1
10:16:15 End Action ShowDialogsHlpr
10:16:15 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
10:16:15 Begin Action ShowDialogsHlpr: 0x800000
10:16:15 Begin Action: DlgSQLSecurity
10:16:27 ShowDlgSQLSecurity returned: 1
10:16:27 LoginMode = 2,szPwd
10:16:28 End Action DlgSQLSecurity
10:16:28 begin ShowDialogsUpdateMask
10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x800000, nDirection = 1
10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:28 Dialog 0x800000 returned: 1
10:16:28 End Action ShowDialogsHlpr
10:16:28 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
10:16:28 Begin Action ShowDialogsHlpr: 0x1000000
10:16:28 Begin Action: DlgCollation
10:16:28 ShowDlgCollation returned: 1
10:16:28 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name = Latin1_General,lcid = 0x409,SortId = 52,dwCompFlags = 0x30001
10:16:28 End Action DlgCollation
10:16:28 begin ShowDialogsUpdateMask
10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x1000000, nDirection = 1
10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:28 Dialog 0x1000000 returned: 1
10:16:28 End Action ShowDialogsHlpr
10:16:28 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
10:16:28 Begin Action ShowDialogsHlpr: 0x2000000
10:16:28 Begin Action: DlgNetwork
10:16:28 ShowDlgNetwork returned: 1
10:16:28 [DlgServerNetwork]
10:16:28 NetworkLibs = 255
10:16:28 TCPPort = 1433
10:16:28 TCPPrxy = Default
10:16:28 NMPPipeName = \\.\pipe\sql\query
10:16:28 Result = 1
10:16:28 End Action DlgNetwork
10:16:28 begin ShowDialogsUpdateMask
10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x2000000, nDirection = 1
10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:28 Dialog 0x2000000 returned: 1
10:16:28 End Action ShowDialogsHlpr
10:16:28 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
10:16:28 Begin Action ShowDialogsHlpr: 0x8000000
10:16:28 Begin Action: DialogShowSdStartCopy
10:16:30 End Action DialogShowSdStartCopy
10:16:30 begin ShowDialogsUpdateMask
10:16:30 nFullMask = 0xbdc0037, nCurrent = 0x8000000, nDirection = 1
10:16:30 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:30 Dialog 0x8000000 returned: 1
10:16:30 End Action ShowDialogsHlpr
10:16:30 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
10:16:30 End Action ShowDialogs
10:16:30 Begin Action ProcessBeforeDataMove:
10:16:31 DeinstallStart returned (C:\Program Files\Microsoft SQL
Server\MSSQL): 0
10:16:31 End Action ProcessBeforeDataMove:
10:16:31 Begin Action SetToolsComponentSelection:
10:16:31 End Action SetToolsComponentSelection:
10:16:31 Begin Action ProcessComponentSelection:
10:16:31 End Action ProcessComponentSelection
10:16:31 Begin Action LogSelectedComponents:
10:16:31 SQLProg
10:16:31 SQLProg\SQLServr
10:16:31 SQLProg\SQLServr\Help
10:16:31 SQLProg\SQLServr\SCMDev
10:16:31 SQLProg\SQLServr\SCMDev\SCMh
10:16:31 SQLProg\SQLServr\SCMDev\SCMX86Lb
10:16:31 SQLProg\SQLServr\SCMDev\SCMALb
10:16:31 SQLProg\SQLServr\Rs1033
10:16:31 SQLProg\SQLServr\RsIntl
10:16:31 SQLProg\SQLServr\ActiveX
10:16:31 SQLProg\SQLServr\System
10:16:31 SQLProg\UpgTools
10:16:31 SQLProg\UpgTools\UpgSys
10:16:31 SQLProg\UpgTools\ActiveX
10:16:31 SQLProg\UpgTools\Res1033
10:16:31 SQLProg\UpgTools\ResOther
10:16:31 SQLProg\UpgTools\Resld
10:16:31 SQLProg\ReplSupp
10:16:31 SQLProg\ReplSupp\ReplDat
10:16:31 SQLProg\ReplSupp\RepComm
10:16:31 SQLProg\ReplSupp\RepNoDk
10:16:31 SQLProg\ReplSupp\ActiveX
10:16:31 SQLProg\Install
10:16:31 SQLProg\System
10:16:31 SQLProg\SvrExt
10:16:31 SQLProg\SvrExt\Help
10:16:31 SQLProg\SvrExt\SvrExtRs
10:16:31 SQLProg\SvrExt\ResIntl
10:16:31 SQLProg\Dat
10:16:31 SQLProg\DatSmpl
10:16:31 SQLProg\BaseSys
10:16:31 SQLProg\BaseBinn
10:16:31 SQLProg\BaseInst
10:16:31 SQLProg\Symbols
10:16:31 SQLProg\Symbols\EXE
10:16:31 SQLProg\Symbols\DLL
10:16:31 SQLProg\Perfmon
10:16:31 SQLProg\Perfmon\System
10:16:31 SQLProg\Root
10:16:31 MgtTool
10:16:31 MgtTool\SEM
10:16:31 MgtTool\SEM\HTML
10:16:31 MgtTool\SEM\MSD98
10:16:31 MgtTool\SEM\MSD98SYS
10:16:31 MgtTool\SEM\MSD98Res
10:16:31 MgtTool\SEM\MSD98Hlp
10:16:31 MgtTool\SEM\Help
10:16:31 MgtTool\SEM\Res1033
10:16:31 MgtTool\SEM\ResIntl
10:16:31 MgtTool\SEM\MSD98RsI
10:16:31 MgtTool\SEM\ActiveX
10:16:31 MgtTool\SEM\ActiveX\Res1033
10:16:31 MgtTool\SEM\ActiveX\ResIntl
10:16:31 MgtTool\SEM\Scripts
10:16:31 MgtTool\SEM\OLEDB
10:16:31 MgtTool\SEM\OLEDB\Res1033
10:16:31 MgtTool\SEM\OLEDB\ResIntl
10:16:31 MgtTool\Profiler
10:16:31 MgtTool\Profiler\Help
10:16:31 MgtTool\Profiler\Res1033
10:16:31 MgtTool\Profiler\ResIntl
10:16:31 MgtTool\Qryanlz
10:16:31 MgtTool\Qryanlz\Help
10:16:31 MgtTool\Qryanlz\Res1033
10:16:31 MgtTool\Qryanlz\ResIntl
10:16:31 MgtTool\DTCCLi
10:16:31 MgtTool\Wzcnflct
10:16:31 MgtTool\Wzcnflct\WzcnHlp
10:16:31 MgtTool\Wzcnflct\Wzcn1033
10:16:31 MgtTool\Wzcnflct\WzcnOthr
10:16:31 MgtTool\Wzcnflct\WzcnCmn
10:16:31 MgtTool\UtilSys
10:16:31 MgtTool\UtilBinn
10:16:31 Connect
10:16:31 Connect\ConnSys
10:16:31 Books
10:16:31 Books\Bookso
10:16:31 Books\Bookso\Utils
10:16:31 DevTools
10:16:31 DevTools\Dbg Int
10:16:31 DevTools\Dbg Int\Dbg Int Common
10:16:31 DevTools\Dbg Int\EXE
10:16:31 CoreRepl
10:16:31 CoreRepl\Res1033
10:16:31 CoreRepl\ResIntl
10:16:31 Core
10:16:31 Core\Res1033
10:16:31 Core\ResOther
10:16:31 Repostry
10:16:31 Repostry\RepstSys
10:16:31 Repostry\Res1033
10:16:31 Repostry\ResIntl
10:16:31 CoreMisc
10:16:31 CoreMisc\ActiveX
10:16:31 CoreMisc\ActiveX\Res1033
10:16:31 CoreMisc\ActiveX\ResIntl
10:16:31 CoreMisc\Res1033
10:16:31 Monarch
10:16:31 Monarch\Monr1033
10:16:31 Monarch\MonrIntl
10:16:31 Jet
10:16:31 CoreInst
10:16:31 CoreCOM
10:16:31 CoreCOM\Res1033
10:16:31 CoreCOM\ResIntl
10:16:31 CoreTool
10:16:31 CoreTool\Res1033
10:16:31 CoreTool\ResOther
10:16:31 DBLibCli
10:16:31 SFExt
10:16:31 SFExt\ActiveX
10:16:31 SFExt\ActiveX\Res1033
10:16:31 SFExt\ActiveX\ResIntl
10:16:31 SFExt\Res1033
10:16:31 SFExt\ResIntl
10:16:31 Trace
10:16:31 Trace\Res1033
10:16:31 Trace\ResOther
10:16:31 MiscCore
10:16:31 MC
10:16:31 MC\MC1033
10:16:31 MC\MCIntl
10:16:31 MC\Help
10:16:31 SQLMgr
10:16:31 SQLMgr\Res1033
10:16:31 SQLMgr\ResIntl
10:16:31 SvrTool
10:16:31 SvrTool\Res1033
10:16:31 SvrTool\ResIntl
10:16:31 DTSUI
10:16:31 DTSUI\Res1033
10:16:31 DTSUI\ResIntl
10:16:31 MSOlap
10:16:32 MSOlap\Res1033
10:16:32 MSOlap\ResIntl
10:16:32 ATL
10:16:32 ATL\winnt
10:16:32 ATL\win9x
10:16:32 MFC42U
10:16:32 VC
10:16:32 VB
10:16:32 OCX1
10:16:32 SQLAdHlp
10:16:32 SQLAdHlp\Res1033
10:16:32 SQLAdHlp\ResOther
10:16:32 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
10:16:32 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
10:16:32 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
10:16:32 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
10:16:32 End Action LogSelectedComponents
10:16:32 Begin Action InstallPkgs:
10:16:32 Begin Action: Locked Connectivity Files Check
10:16:40 ConnectivityLocked returned: 0
10:16:40 The operation completed successfully.
10:16:40 End Action: Locked Connectivity Files Check
10:16:40 Setup is installing Microsoft Data Access Components (MDAC) ...
10:16:40 \\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Other\sqlredis.exe /q:a
/C:"setupre.exe WARN=1 -s -SMS"
10:17:43 ExitCode: 0
10:17:43 Setup is installing Microsoft Distributed Transaction Coordinator
(MSDTC) ...
10:17:43 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir
"C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg
"\\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Other\dtcsetup.exe" -LogFile
"C:\WINDOWS\sqlstp.log"
10:17:45 Process Exit Code: (0)
10:17:45 /Q:A /T:C:\WINDOWS\TEMP\ixp001.tmp
10:17:45 Setup is installing HTML Help ...
10:17:48 HTML Help installer exit code: 0
10:18:15 End Action InstallPkgs
10:18:15 Begin Action MoveFileData:
10:18:15 Enabled SELFREGISTERBATCH
10:18:15 Enabled CORECOMPONENTHANDLING
10:21:34 Begin Action: MoveFileDataSpecial
10:21:37 End Action: MoveFileDataSpecial
10:21:37 End Action MoveFileData
10:21:37 Begin Action ProcessAfterDataMove:
10:21:37 \\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Binn\hhcol.exe C:\Program
Files\Microsoft SQL Server\80\Tools\Books
10:21:42 End Action ProcessAfterDataMove
10:21:42 Begin Action BuildServer:
10:21:42 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 5 -ExePath
"C:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe" -Service
"MSSQLSERVER"
10:21:43 Process Exit Code: (0)
10:21:43 Begin Action: CreateRegistrySetSQL
10:21:43 End Action: CreateRegistrySetSQL
10:21:43 Begin Action: RegWriteSetupEntry
10:21:43 End Action: RegWriteSetupEntry
10:21:43 Begin Action: CreateSer
10:21:43 End Action: CreateSer
10:21:43 Begin Action: SkuIt
10:21:44 End Action: SkuIt
10:21:45 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL
Server\MSSQL returned: 0, 0
10:21:45 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
10:21:45 Begin Action: UpdateSystemPath
10:21:45 Path successfully updated.
10:21:45 C:\oracle\ora92\bin;C:\Program
Files\Oracle\jre\1.3.1\bin;C:\Program
Files\Oracle\jre\1.1.8\bin;C:\Perl\bin\;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\OCM;C:\Program
Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Common
Files\Autodesk Shared\;C:\Program Files\proe2001\bin;C:\Program Files\Common
Files\Roxio Shared\DLLShared;C:\Program Files\UltraEdit;C:\Program
Files\Rouzer File Printer\;C:\Program Files\Executive Software\Diskeeper\
10:21:45 End Action: UpdateSystemPath
10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
10:21:47 Grant Right for KALTEC\administrator returned : 1, 0
10:21:47 Grant Right for KALTEC\administrator returned : 1, 0
10:21:48 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F
"C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q
"SQL_Latin1_General_CP1_CI_AS" -H 66300 -U sa -P
###############################################################################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=DEV2;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
driver={sql server};server=DEV2;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
driver={sql server};server=DEV2;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
SQL Server configuration failed.
###############################################################################
10:22:26 Process Exit Code: (-1)
10:22:35 Setup failed to configure the server. Refer to the server error
logs and C:\WINDOWS\sqlstp.log for more information.
10:22:37 Action CleanUpInstall:
10:22:37 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service
SQLSERVERAGENT
10:22:38 Process Exit Code: (1060) The specified service does not exist as
an installed service.
10:22:38 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service
MSSQLSERVER
10:22:38 Process Exit Code: (0)
10:22:38 StatsGenerate returned: 2
10:22:38 StatsGenerate (0x0,0x1,0xf000000,0x100,1033,303,0x0,0x1,0,0,0
10:22:38 StatsGenerate -1,<Login Name>)
10:22:38 Installation Failed.
-----
2004-10-28 10:21:51.33 server Microsoft SQL Server 2000 - 8.00.194
(Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 1)
2004-10-28 10:21:51.37 server Copyright (C) 1988-2000 Microsoft
Corporation.
2004-10-28 10:21:51.37 server All rights reserved.
2004-10-28 10:21:51.37 server Server Process ID is 3460.
2004-10-28 10:21:51.37 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2004-10-28 10:21:51.41 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2004-10-28 10:21:51.78 server SQL Server configured for thread mode
processing.
2004-10-28 10:21:51.82 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2004-10-28 10:21:51.87 server Attempting to initialize Distributed
Transaction Coordinator.
2004-10-28 10:21:56.01 spid3 Warning ******************
2004-10-28 10:21:56.01 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2004-10-28 10:21:56.04 spid3 Starting up database 'master'.
2004-10-28 10:21:57.41 spid3 Server name is 'DEV2'.
2004-10-28 10:21:57.42 server Using 'SSNETLIB.DLL' version '8.0.311'.
2004-10-28 10:21:57.42 spid5 Starting up database 'model'.
2004-10-28 10:21:57.42 spid7 Starting up database 'msdb'.
2004-10-28 10:21:57.42 spid8 Starting up database 'pubs'.
2004-10-28 10:21:57.42 spid9 Starting up database 'Northwind'.
2004-10-28 10:21:58.95 spid5 Clearing tempdb database.
2004-10-28 10:22:00.94 server SQL server listening on 10.10.1.33: 1433.
2004-10-28 10:22:00.94 server SQL server listening on 127.0.0.1: 1433.
2004-10-28 10:22:02.26 spid5 Starting up database 'tempdb'.
2004-10-28 10:22:02.41 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2004-10-28 10:22:02.41 server SQL Server is ready for client connections
2004-10-28 10:22:02.61 spid3 Recovery complete.
2004-10-28 10:22:02.64 spid3 Warning: override, autoexec procedures
skipped.
2004-10-28 10:22:12.92 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.Turn off the Windows Firewall or open up UDP 1434 and TCP 1433 on it.
"Jim B." <Jim B.@.discussions.microsoft.com> wrote in message
news:3AFED5B5-06E9-47A4-8A7E-A68E1EEC24C4@.microsoft.com...
> Ok filks here is a strange one. Tried installing service pack 3am on my
> Windows XP
> machine that is at service 2 on the OS Level. Now from what I can gather
> when service pack 3a for SQL server is installed it wipes out all the
driver
> file locations and reinstalls a new MDAC from what I can see. But it never
> gets them installed and the SQL Server becomes mute because you can never
> connect to it. I've included a copy of the Log file that get's generated
from
> the install any one care to take a stab at this one. The following is the
> SQLSTP.Log File and under that is the Error Log from the SQL Server
> Directory. Any help would be great just reply to the group here.
> ----
--
> 10:14:35 Begin Setup
> 10:14:35 8.00.194
> 10:14:35 Mode = Normal
> 10:14:35 ModeType = NORMAL
> 10:14:38 GetDefinitionEx returned: 0, Extended: 0x0
> 10:14:38 ValueFTS returned: 1
> 10:14:38 ValuePID returned: 1
> 10:14:38 ValueLic returned: 0
> 10:14:38 System: Windows NT WorkStation
> 10:14:38 SQL Server ProductType: Developer Edition [0x3]
> 10:14:38 Begin Action: SetupInitialize
> 10:14:38 End Action SetupInitialize
> 10:14:38 Begin Action: SetupInstall
> 10:14:38 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir
...
> 10:14:38 CommonFilesDir=C:\Program Files\Common Files
> 10:14:38 Windows Directory=C:\WINDOWS\
> 10:14:38 Program Files=C:\Program Files\
> 10:14:38 TEMPDIR=C:\WINDOWS\TEMP\
> 10:14:38 Begin Action: SetupInstall
> 10:14:39 digpid size : 256
> 10:14:39 digpid size : 164
> 10:14:39 Begin Action: CheckFixedRequirements
> 10:14:39 Platform ID: 0xf000000
> 10:14:39 Version: 5.1.2600
> 10:14:39 File Version - C:\WINDOWS\System32\shdocvw.dll: 6.0.2800.1584
> 10:14:39 End Action: CheckFixedRequirements
> 10:14:40 Begin Action: ShowDialogs
> 10:14:40 Initial Dialog Mask: 0x83000f7, Disable Back=0x1
> 10:14:41 Begin Action ShowDialogsHlpr: 0x1
> 10:14:41 Begin Action: DialogShowSdWelcome
> 10:14:43 End Action DialogShowSdWelcome
> 10:14:43 Dialog 0x1 returned: 1
> 10:14:43 End Action ShowDialogsHlpr
> 10:14:43 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
> 10:14:43 Begin Action ShowDialogsHlpr: 0x2
> 10:14:43 Begin Action: DialogShowSdMachineName
> 10:14:45 ShowDlgMachine returned: 1
> 10:14:45 Name = DEV2, Type = 0x1
> 10:14:45 Begin Action: CheckRequirements
> 10:14:45 Processor Architecture: x86 (Pentium)
> 10:14:45 Service Pack: 256
> 10:14:45 ComputerName: DEV2
> 10:14:45 User Name: <Login Name>
> 10:14:45 IsAllAccessAllowed returned: 1
> 10:14:45 OS Language: 0x409
> 10:14:45 End Action CheckRequirements
> 10:14:45 This combination of Package and Operating System allows a full
> product install.
> 10:14:46 CreateSetupTopology(DEV2), Handle : 0x1134a50, returned : 0
> 10:14:46 CreateSetupTopology returned : 0, Handle : 0x1134a50
> 10:14:46 Topology Type : 1, Return Value : 0
> 10:14:46 ST_GetPhysicalNode returned : 0, PNHandle : 0x1134a78
> 10:14:46 PN_EnumerateEx returned : 0
> 10:14:46 PN_GetSQLStates returned : 0, SqlStates : 0x0
> 10:14:46 PN_StartScan [0x1134a78] returned : 0
> 10:14:46 PN_GetNext [0x1134a78] returned : 18, Handle: [0x0]
> 10:14:46 No more items in enumeration.
> 10:14:46 ReleaseSetupTopology
> 10:14:46 Named instance limit: 100, quota: 0
> 10:14:46 End Action DialogShowSdMachineName
> 10:14:46 begin ShowDialogsUpdateMask
> 10:14:46 nFullMask = 0x83000f7, nCurrent = 0x2, nDirection = 0
> 10:14:46 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
> 10:14:46 Dialog 0x2 returned: 0
> 10:14:46 End Action ShowDialogsHlpr
> 10:14:46 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
> 10:14:46 Begin Action ShowDialogsHlpr: 0x4
> 10:14:46 Begin Action: DialogShowSdInstallMode
> 10:14:48 ShowDlgInstallMode returned: 1
> 10:14:48 InstallMode : 0x1
> 10:14:48 End Action DialogShowSdInstallMode
> 10:14:48 begin ShowDialogsUpdateMask
> 10:14:48 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
> 10:14:48 Updated Dialog Mask: 0xbf40037, Disable Back = 0x1
> 10:14:48 Dialog 0x4 returned: 1
> 10:14:48 End Action ShowDialogsHlpr
> 10:14:48 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
> 10:14:48 Begin Action ShowDialogsHlpr: 0x10
> 10:14:48 Begin Action: DialogShowSdRegisterUserEx
> 10:14:57 End Action DialogShowSdRegisterUserEx
> 10:14:57 Dialog 0x10 returned: 1
> 10:14:57 End Action ShowDialogsHlpr
> 10:14:57 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
> 10:14:57 Begin Action ShowDialogsHlpr: 0x20
> 10:14:57 Begin Action: DialogShowSdLicense
> 10:15:00 End Action DialogShowSdLicense
> 10:15:00 Dialog 0x20 returned: 1
> 10:15:00 End Action ShowDialogsHlpr
> 10:15:00 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
> 10:15:00 Begin Action ShowDialogsHlpr: 0x40000
> 10:15:00 Begin Action: DialogShowSdCliSvr
> 10:15:00 DisplaySystemPreReq
> 10:15:02 ShowDlgClientServerSelect returned: 1
> 10:15:02 Type : 0x2
> 10:15:02 End Action DialogShowSdCliSvr
> 10:15:02 begin ShowDialogsUpdateMask
> 10:15:02 nFullMask = 0xbf40037, nCurrent = 0x40000, nDirection = 1
> 10:15:02 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
> 10:15:02 Dialog 0x40000 returned: 1
> 10:15:02 End Action ShowDialogsHlpr
> 10:15:02 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
> 10:15:02 Begin Action ShowDialogsHlpr: 0x80000
> 10:15:02 Begin Action: DialogShowSdInstanceName
> 10:15:02 Begin Action: ShowDlgInstanceName
> 10:15:03 End Action: ShowDlgInstanceName
> 10:15:03 ShowDlgInstanceName returned : 1
> 10:15:03 InstanceName : MSSQLSERVER
> 10:15:03 CreateSetupTopology(DEV2), Handle : 0x1134a50, returned : 0
> 10:15:03 CreateSetupTopology returned : 0, Handle : 0x1134a50
> 10:15:03 Topology Type : 1, Return Value : 0
> 10:15:03 ST_GetPhysicalNode returned : 0, PNHandle : 0x1134a78
> 10:15:03 PN_EnumerateEx returned : 0
> 10:15:03 PN_GetSQLStates returned : 0, SqlStates : 0x0
> 10:15:03 PN_StartScan [0x1134a78] returned : 0
> 10:15:03 PN_GetNext [0x1134a78] returned : 18, Handle: [0x0]
> 10:15:03 No more items in enumeration.
> 10:15:03 ReleaseSetupTopology
> 10:15:03 End Action DialogShowSdInstanceName
> 10:15:03 begin ShowDialogsUpdateMask
> 10:15:03 nFullMask = 0xbfc0037, nCurrent = 0x80000, nDirection = 1
> 10:15:03 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
> 10:15:03 Dialog 0x80000 returned: 1
> 10:15:03 End Action ShowDialogsHlpr
> 10:15:04 ShowDialogsGetDialog returned: nCurrent=0x100000,index > 10:15:04 Begin Action ShowDialogsHlpr: 0x100000
> 10:15:04 Begin Action: DialogShowSdSetupType
> 10:15:04 Begin Action: Setup Type
> 10:15:22 Setup type set Typical
> 10:15:34 SQL program folder: C:\Program Files\Microsoft SQL Server
> 10:15:34 SQL data folder: C:\Program Files\Microsoft SQL Server
> 10:15:34 Windows system folder: C:\WINDOWS\System32\
> 10:15:34 Prog req: 38073, Data req: 34432, Sys req: 114225
> 10:15:34 Prog avail: 9393472, Data avail: 9393472, Sys avail: 9393472
> 10:15:34 Prog req vs. avail, 186730, 9393472
> 10:15:34 Data req vs. avail, 34432, 9393472
> 10:15:34 Sys req vs. avail, 148657, 9393472
> 10:15:34 DisplaySystemPreReq
> 10:15:34 [SetupTypeSQL]
> 10:15:34 szDir = C:\Program Files\Microsoft SQL Server
> 10:15:34 szDir = %PROGRAMFILES%\Microsoft SQL Server
> 10:15:34 Result = 301
> 10:15:34 szDataDir = C:\Program Files\Microsoft SQL Server
> 10:15:34 szDataDir = %PROGRAMFILES%\Microsoft SQL Server
> 10:15:34 End Action: Setup Type
> 10:15:34 Setup Type: Typical (301)
> 10:15:34 End Action DialogShowSdSetupType
> 10:15:34 begin ShowDialogsUpdateMask
> 10:15:34 nFullMask = 0xbfc0037, nCurrent = 0x100000, nDirection = 301
> 10:15:34 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:15:34 Dialog 0x100000 returned: 301
> 10:15:34 End Action ShowDialogsHlpr
> 10:15:34 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
> 10:15:34 Begin Action ShowDialogsHlpr: 0x400000
> 10:15:34 Begin Action: DlgServices
> 10:16:15 ShowDlgServices returned: 1
> 10:16:15 [DlgServices]
> 10:16:15 Local-Domain = 61680
> 10:16:15 AutoStart = 15
> 10:16:15 SQLDomain = KALTEC
> 10:16:15 SQLDomainAcct = administrator
> 10:16:15 SQLDomainPwd
> 10:16:15 AgtDomain = KALTEC
> 10:16:15 AgtDomainAcct = administrator
> 10:16:15 AgtDomainPwd
> 10:16:15 Result = 1
> 10:16:15 End Action DlgServices
> 10:16:15 begin ShowDialogsUpdateMask
> 10:16:15 nFullMask = 0xbdc0037, nCurrent = 0x400000, nDirection = 1
> 10:16:15 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:15 Dialog 0x400000 returned: 1
> 10:16:15 End Action ShowDialogsHlpr
> 10:16:15 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
> 10:16:15 Begin Action ShowDialogsHlpr: 0x800000
> 10:16:15 Begin Action: DlgSQLSecurity
> 10:16:27 ShowDlgSQLSecurity returned: 1
> 10:16:27 LoginMode = 2,szPwd
> 10:16:28 End Action DlgSQLSecurity
> 10:16:28 begin ShowDialogsUpdateMask
> 10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x800000, nDirection = 1
> 10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:28 Dialog 0x800000 returned: 1
> 10:16:28 End Action ShowDialogsHlpr
> 10:16:28 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
> 10:16:28 Begin Action ShowDialogsHlpr: 0x1000000
> 10:16:28 Begin Action: DlgCollation
> 10:16:28 ShowDlgCollation returned: 1
> 10:16:28 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name => Latin1_General,lcid = 0x409,SortId = 52,dwCompFlags = 0x30001
> 10:16:28 End Action DlgCollation
> 10:16:28 begin ShowDialogsUpdateMask
> 10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x1000000, nDirection = 1
> 10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:28 Dialog 0x1000000 returned: 1
> 10:16:28 End Action ShowDialogsHlpr
> 10:16:28 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
> 10:16:28 Begin Action ShowDialogsHlpr: 0x2000000
> 10:16:28 Begin Action: DlgNetwork
> 10:16:28 ShowDlgNetwork returned: 1
> 10:16:28 [DlgServerNetwork]
> 10:16:28 NetworkLibs = 255
> 10:16:28 TCPPort = 1433
> 10:16:28 TCPPrxy = Default
> 10:16:28 NMPPipeName = \\.\pipe\sql\query
> 10:16:28 Result = 1
> 10:16:28 End Action DlgNetwork
> 10:16:28 begin ShowDialogsUpdateMask
> 10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x2000000, nDirection = 1
> 10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:28 Dialog 0x2000000 returned: 1
> 10:16:28 End Action ShowDialogsHlpr
> 10:16:28 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
> 10:16:28 Begin Action ShowDialogsHlpr: 0x8000000
> 10:16:28 Begin Action: DialogShowSdStartCopy
> 10:16:30 End Action DialogShowSdStartCopy
> 10:16:30 begin ShowDialogsUpdateMask
> 10:16:30 nFullMask = 0xbdc0037, nCurrent = 0x8000000, nDirection = 1
> 10:16:30 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:30 Dialog 0x8000000 returned: 1
> 10:16:30 End Action ShowDialogsHlpr
> 10:16:30 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
> 10:16:30 End Action ShowDialogs
> 10:16:30 Begin Action ProcessBeforeDataMove:
> 10:16:31 DeinstallStart returned (C:\Program Files\Microsoft SQL
> Server\MSSQL): 0
> 10:16:31 End Action ProcessBeforeDataMove:
> 10:16:31 Begin Action SetToolsComponentSelection:
> 10:16:31 End Action SetToolsComponentSelection:
> 10:16:31 Begin Action ProcessComponentSelection:
> 10:16:31 End Action ProcessComponentSelection
> 10:16:31 Begin Action LogSelectedComponents:
> 10:16:31 SQLProg
> 10:16:31 SQLProg\SQLServr
> 10:16:31 SQLProg\SQLServr\Help
> 10:16:31 SQLProg\SQLServr\SCMDev
> 10:16:31 SQLProg\SQLServr\SCMDev\SCMh
> 10:16:31 SQLProg\SQLServr\SCMDev\SCMX86Lb
> 10:16:31 SQLProg\SQLServr\SCMDev\SCMALb
> 10:16:31 SQLProg\SQLServr\Rs1033
> 10:16:31 SQLProg\SQLServr\RsIntl
> 10:16:31 SQLProg\SQLServr\ActiveX
> 10:16:31 SQLProg\SQLServr\System
> 10:16:31 SQLProg\UpgTools
> 10:16:31 SQLProg\UpgTools\UpgSys
> 10:16:31 SQLProg\UpgTools\ActiveX
> 10:16:31 SQLProg\UpgTools\Res1033
> 10:16:31 SQLProg\UpgTools\ResOther
> 10:16:31 SQLProg\UpgTools\Resld
> 10:16:31 SQLProg\ReplSupp
> 10:16:31 SQLProg\ReplSupp\ReplDat
> 10:16:31 SQLProg\ReplSupp\RepComm
> 10:16:31 SQLProg\ReplSupp\RepNoDk
> 10:16:31 SQLProg\ReplSupp\ActiveX
> 10:16:31 SQLProg\Install
> 10:16:31 SQLProg\System
> 10:16:31 SQLProg\SvrExt
> 10:16:31 SQLProg\SvrExt\Help
> 10:16:31 SQLProg\SvrExt\SvrExtRs
> 10:16:31 SQLProg\SvrExt\ResIntl
> 10:16:31 SQLProg\Dat
> 10:16:31 SQLProg\DatSmpl
> 10:16:31 SQLProg\BaseSys
> 10:16:31 SQLProg\BaseBinn
> 10:16:31 SQLProg\BaseInst
> 10:16:31 SQLProg\Symbols
> 10:16:31 SQLProg\Symbols\EXE
> 10:16:31 SQLProg\Symbols\DLL
> 10:16:31 SQLProg\Perfmon
> 10:16:31 SQLProg\Perfmon\System
> 10:16:31 SQLProg\Root
> 10:16:31 MgtTool
> 10:16:31 MgtTool\SEM
> 10:16:31 MgtTool\SEM\HTML
> 10:16:31 MgtTool\SEM\MSD98
> 10:16:31 MgtTool\SEM\MSD98SYS
> 10:16:31 MgtTool\SEM\MSD98Res
> 10:16:31 MgtTool\SEM\MSD98Hlp
> 10:16:31 MgtTool\SEM\Help
> 10:16:31 MgtTool\SEM\Res1033
> 10:16:31 MgtTool\SEM\ResIntl
> 10:16:31 MgtTool\SEM\MSD98RsI
> 10:16:31 MgtTool\SEM\ActiveX
> 10:16:31 MgtTool\SEM\ActiveX\Res1033
> 10:16:31 MgtTool\SEM\ActiveX\ResIntl
> 10:16:31 MgtTool\SEM\Scripts
> 10:16:31 MgtTool\SEM\OLEDB
> 10:16:31 MgtTool\SEM\OLEDB\Res1033
> 10:16:31 MgtTool\SEM\OLEDB\ResIntl
> 10:16:31 MgtTool\Profiler
> 10:16:31 MgtTool\Profiler\Help
> 10:16:31 MgtTool\Profiler\Res1033
> 10:16:31 MgtTool\Profiler\ResIntl
> 10:16:31 MgtTool\Qryanlz
> 10:16:31 MgtTool\Qryanlz\Help
> 10:16:31 MgtTool\Qryanlz\Res1033
> 10:16:31 MgtTool\Qryanlz\ResIntl
> 10:16:31 MgtTool\DTCCLi
> 10:16:31 MgtTool\Wzcnflct
> 10:16:31 MgtTool\Wzcnflct\WzcnHlp
> 10:16:31 MgtTool\Wzcnflct\Wzcn1033
> 10:16:31 MgtTool\Wzcnflct\WzcnOthr
> 10:16:31 MgtTool\Wzcnflct\WzcnCmn
> 10:16:31 MgtTool\UtilSys
> 10:16:31 MgtTool\UtilBinn
> 10:16:31 Connect
> 10:16:31 Connect\ConnSys
> 10:16:31 Books
> 10:16:31 Books\Bookso
> 10:16:31 Books\Bookso\Utils
> 10:16:31 DevTools
> 10:16:31 DevTools\Dbg Int
> 10:16:31 DevTools\Dbg Int\Dbg Int Common
> 10:16:31 DevTools\Dbg Int\EXE
> 10:16:31 CoreRepl
> 10:16:31 CoreRepl\Res1033
> 10:16:31 CoreRepl\ResIntl
> 10:16:31 Core
> 10:16:31 Core\Res1033
> 10:16:31 Core\ResOther
> 10:16:31 Repostry
> 10:16:31 Repostry\RepstSys
> 10:16:31 Repostry\Res1033
> 10:16:31 Repostry\ResIntl
> 10:16:31 CoreMisc
> 10:16:31 CoreMisc\ActiveX
> 10:16:31 CoreMisc\ActiveX\Res1033
> 10:16:31 CoreMisc\ActiveX\ResIntl
> 10:16:31 CoreMisc\Res1033
> 10:16:31 Monarch
> 10:16:31 Monarch\Monr1033
> 10:16:31 Monarch\MonrIntl
> 10:16:31 Jet
> 10:16:31 CoreInst
> 10:16:31 CoreCOM
> 10:16:31 CoreCOM\Res1033
> 10:16:31 CoreCOM\ResIntl
> 10:16:31 CoreTool
> 10:16:31 CoreTool\Res1033
> 10:16:31 CoreTool\ResOther
> 10:16:31 DBLibCli
> 10:16:31 SFExt
> 10:16:31 SFExt\ActiveX
> 10:16:31 SFExt\ActiveX\Res1033
> 10:16:31 SFExt\ActiveX\ResIntl
> 10:16:31 SFExt\Res1033
> 10:16:31 SFExt\ResIntl
> 10:16:31 Trace
> 10:16:31 Trace\Res1033
> 10:16:31 Trace\ResOther
> 10:16:31 MiscCore
> 10:16:31 MC
> 10:16:31 MC\MC1033
> 10:16:31 MC\MCIntl
> 10:16:31 MC\Help
> 10:16:31 SQLMgr
> 10:16:31 SQLMgr\Res1033
> 10:16:31 SQLMgr\ResIntl
> 10:16:31 SvrTool
> 10:16:31 SvrTool\Res1033
> 10:16:31 SvrTool\ResIntl
> 10:16:31 DTSUI
> 10:16:31 DTSUI\Res1033
> 10:16:31 DTSUI\ResIntl
> 10:16:31 MSOlap
> 10:16:32 MSOlap\Res1033
> 10:16:32 MSOlap\ResIntl
> 10:16:32 ATL
> 10:16:32 ATL\winnt
> 10:16:32 ATL\win9x
> 10:16:32 MFC42U
> 10:16:32 VC
> 10:16:32 VB
> 10:16:32 OCX1
> 10:16:32 SQLAdHlp
> 10:16:32 SQLAdHlp\Res1033
> 10:16:32 SQLAdHlp\ResOther
> 10:16:32 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
> 10:16:32 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
> 10:16:32 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
> 10:16:32 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
> 10:16:32 End Action LogSelectedComponents
> 10:16:32 Begin Action InstallPkgs:
> 10:16:32 Begin Action: Locked Connectivity Files Check
> 10:16:40 ConnectivityLocked returned: 0
> 10:16:40 The operation completed successfully.
> 10:16:40 End Action: Locked Connectivity Files Check
> 10:16:40 Setup is installing Microsoft Data Access Components (MDAC) ...
> 10:16:40 \\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Other\sqlredis.exe /q:a
> /C:"setupre.exe WARN=1 -s -SMS"
> 10:17:43 ExitCode: 0
> 10:17:43 Setup is installing Microsoft Distributed Transaction Coordinator
> (MSDTC) ...
> 10:17:43 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir
> "C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg
> "\\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Other\dtcsetup.exe" -LogFile
> "C:\WINDOWS\sqlstp.log"
> 10:17:45 Process Exit Code: (0)
> 10:17:45 /Q:A /T:C:\WINDOWS\TEMP\ixp001.tmp
> 10:17:45 Setup is installing HTML Help ...
> 10:17:48 HTML Help installer exit code: 0
> 10:18:15 End Action InstallPkgs
> 10:18:15 Begin Action MoveFileData:
> 10:18:15 Enabled SELFREGISTERBATCH
> 10:18:15 Enabled CORECOMPONENTHANDLING
> 10:21:34 Begin Action: MoveFileDataSpecial
> 10:21:37 End Action: MoveFileDataSpecial
> 10:21:37 End Action MoveFileData
> 10:21:37 Begin Action ProcessAfterDataMove:
> 10:21:37 \\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Binn\hhcol.exe C:\Program
> Files\Microsoft SQL Server\80\Tools\Books
> 10:21:42 End Action ProcessAfterDataMove
> 10:21:42 Begin Action BuildServer:
> 10:21:42 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action
5 -ExePath
> "C:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe" -Service
> "MSSQLSERVER"
> 10:21:43 Process Exit Code: (0)
> 10:21:43 Begin Action: CreateRegistrySetSQL
> 10:21:43 End Action: CreateRegistrySetSQL
> 10:21:43 Begin Action: RegWriteSetupEntry
> 10:21:43 End Action: RegWriteSetupEntry
> 10:21:43 Begin Action: CreateSer
> 10:21:43 End Action: CreateSer
> 10:21:43 Begin Action: SkuIt
> 10:21:44 End Action: SkuIt
> 10:21:45 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL
> Server\MSSQL returned: 0, 0
> 10:21:45 SetRegSecuritySQLAndAdmin for
> Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
> 10:21:45 Begin Action: UpdateSystemPath
> 10:21:45 Path successfully updated.
> 10:21:45 C:\oracle\ora92\bin;C:\Program
> Files\Oracle\jre\1.3.1\bin;C:\Program
>
Files\Oracle\jre\1.1.8\bin;C:\Perl\bin\;%SystemRoot%\system32;%SystemRoot%;%
SystemRoot%\System32\Wbem;C:\OCM;C:\Program
> Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Common
> Files\Autodesk Shared\;C:\Program Files\proe2001\bin;C:\Program
Files\Common
> Files\Roxio Shared\DLLShared;C:\Program Files\UltraEdit;C:\Program
> Files\Rouzer File Printer\;C:\Program Files\Executive Software\Diskeeper\
> 10:21:45 End Action: UpdateSystemPath
> 10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:47 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:47 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:48 C:\Program Files\Microsoft SQL
erver\80\Tools\Binn\cnfgsvr.exe -F
> "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q
> "SQL_Latin1_General_CP1_CI_AS" -H 66300 -U sa -P
>
############################################################################
###
>
> Starting Service ...
> SQL_Latin1_General_CP1_CI_AS
> -m -Q -T4022 -T3659
> Connecting to Server ...
> driver={sql server};server=DEV2;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> driver={sql server};server=DEV2;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> driver={sql server};server=DEV2;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> SQL Server configuration failed.
>
############################################################################
###
> 10:22:26 Process Exit Code: (-1)
> 10:22:35 Setup failed to configure the server. Refer to the server error
> logs and C:\WINDOWS\sqlstp.log for more information.
> 10:22:37 Action CleanUpInstall:
> 10:22:37 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action
4 -Service
> SQLSERVERAGENT
> 10:22:38 Process Exit Code: (1060) The specified service does not exist as
> an installed service.
> 10:22:38 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action
4 -Service
> MSSQLSERVER
> 10:22:38 Process Exit Code: (0)
> 10:22:38 StatsGenerate returned: 2
> 10:22:38 StatsGenerate (0x0,0x1,0xf000000,0x100,1033,303,0x0,0x1,0,0,0
> 10:22:38 StatsGenerate -1,<Login Name>)
> 10:22:38 Installation Failed.
> ----
--
> 2004-10-28 10:21:51.33 server Microsoft SQL Server 2000 - 8.00.194
> (Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 1)
> 2004-10-28 10:21:51.37 server Copyright (C) 1988-2000 Microsoft
> Corporation.
> 2004-10-28 10:21:51.37 server All rights reserved.
> 2004-10-28 10:21:51.37 server Server Process ID is 3460.
> 2004-10-28 10:21:51.37 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2004-10-28 10:21:51.41 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).
> 2004-10-28 10:21:51.78 server SQL Server configured for thread mode
> processing.
> 2004-10-28 10:21:51.82 server Using dynamic lock allocation. [2500]
Lock
> Blocks, [5000] Lock Owner Blocks.
> 2004-10-28 10:21:51.87 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2004-10-28 10:21:56.01 spid3 Warning ******************
> 2004-10-28 10:21:56.01 spid3 SQL Server started in single user mode.
> Updates allowed to system catalogs.
> 2004-10-28 10:21:56.04 spid3 Starting up database 'master'.
> 2004-10-28 10:21:57.41 spid3 Server name is 'DEV2'.
> 2004-10-28 10:21:57.42 server Using 'SSNETLIB.DLL' version '8.0.311'.
> 2004-10-28 10:21:57.42 spid5 Starting up database 'model'.
> 2004-10-28 10:21:57.42 spid7 Starting up database 'msdb'.
> 2004-10-28 10:21:57.42 spid8 Starting up database 'pubs'.
> 2004-10-28 10:21:57.42 spid9 Starting up database 'Northwind'.
> 2004-10-28 10:21:58.95 spid5 Clearing tempdb database.
> 2004-10-28 10:22:00.94 server SQL server listening on 10.10.1.33: 1433.
> 2004-10-28 10:22:00.94 server SQL server listening on 127.0.0.1: 1433.
> 2004-10-28 10:22:02.26 spid5 Starting up database 'tempdb'.
> 2004-10-28 10:22:02.41 server SQL server listening on TCP, Shared
Memory,
> Named Pipes.
> 2004-10-28 10:22:02.41 server SQL Server is ready for client
connections
> 2004-10-28 10:22:02.61 spid3 Recovery complete.
> 2004-10-28 10:22:02.64 spid3 Warning: override, autoexec procedures
> skipped.
> 2004-10-28 10:22:12.92 spid3 SQL Server is terminating due to 'stop'
> request from Service Control Manager.
>
Windows XP
machine that is at service 2 on the OS Level. Now from what I can gather
when service pack 3a for SQL server is installed it wipes out all the driver
file locations and reinstalls a new MDAC from what I can see. But it never
gets them installed and the SQL Server becomes mute because you can never
connect to it. I've included a copy of the Log file that get's generated from
the install any one care to take a stab at this one. The following is the
SQLSTP.Log File and under that is the Error Log from the SQL Server
Directory. Any help would be great just reply to the group here
-----
10:14:35 Begin Setup
10:14:35 8.00.194
10:14:35 Mode = Normal
10:14:35 ModeType = NORMAL
10:14:38 GetDefinitionEx returned: 0, Extended: 0x0
10:14:38 ValueFTS returned: 1
10:14:38 ValuePID returned: 1
10:14:38 ValueLic returned: 0
10:14:38 System: Windows NT WorkStation
10:14:38 SQL Server ProductType: Developer Edition [0x3]
10:14:38 Begin Action: SetupInitialize
10:14:38 End Action SetupInitialize
10:14:38 Begin Action: SetupInstall
10:14:38 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
10:14:38 CommonFilesDir=C:\Program Files\Common Files
10:14:38 Windows Directory=C:\WINDOWS\
10:14:38 Program Files=C:\Program Files\
10:14:38 TEMPDIR=C:\WINDOWS\TEMP\
10:14:38 Begin Action: SetupInstall
10:14:39 digpid size : 256
10:14:39 digpid size : 164
10:14:39 Begin Action: CheckFixedRequirements
10:14:39 Platform ID: 0xf000000
10:14:39 Version: 5.1.2600
10:14:39 File Version - C:\WINDOWS\System32\shdocvw.dll: 6.0.2800.1584
10:14:39 End Action: CheckFixedRequirements
10:14:40 Begin Action: ShowDialogs
10:14:40 Initial Dialog Mask: 0x83000f7, Disable Back=0x1
10:14:41 Begin Action ShowDialogsHlpr: 0x1
10:14:41 Begin Action: DialogShowSdWelcome
10:14:43 End Action DialogShowSdWelcome
10:14:43 Dialog 0x1 returned: 1
10:14:43 End Action ShowDialogsHlpr
10:14:43 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
10:14:43 Begin Action ShowDialogsHlpr: 0x2
10:14:43 Begin Action: DialogShowSdMachineName
10:14:45 ShowDlgMachine returned: 1
10:14:45 Name = DEV2, Type = 0x1
10:14:45 Begin Action: CheckRequirements
10:14:45 Processor Architecture: x86 (Pentium)
10:14:45 Service Pack: 256
10:14:45 ComputerName: DEV2
10:14:45 User Name: <Login Name>
10:14:45 IsAllAccessAllowed returned: 1
10:14:45 OS Language: 0x409
10:14:45 End Action CheckRequirements
10:14:45 This combination of Package and Operating System allows a full
product install.
10:14:46 CreateSetupTopology(DEV2), Handle : 0x1134a50, returned : 0
10:14:46 CreateSetupTopology returned : 0, Handle : 0x1134a50
10:14:46 Topology Type : 1, Return Value : 0
10:14:46 ST_GetPhysicalNode returned : 0, PNHandle : 0x1134a78
10:14:46 PN_EnumerateEx returned : 0
10:14:46 PN_GetSQLStates returned : 0, SqlStates : 0x0
10:14:46 PN_StartScan [0x1134a78] returned : 0
10:14:46 PN_GetNext [0x1134a78] returned : 18, Handle: [0x0]
10:14:46 No more items in enumeration.
10:14:46 ReleaseSetupTopology
10:14:46 Named instance limit: 100, quota: 0
10:14:46 End Action DialogShowSdMachineName
10:14:46 begin ShowDialogsUpdateMask
10:14:46 nFullMask = 0x83000f7, nCurrent = 0x2, nDirection = 0
10:14:46 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
10:14:46 Dialog 0x2 returned: 0
10:14:46 End Action ShowDialogsHlpr
10:14:46 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
10:14:46 Begin Action ShowDialogsHlpr: 0x4
10:14:46 Begin Action: DialogShowSdInstallMode
10:14:48 ShowDlgInstallMode returned: 1
10:14:48 InstallMode : 0x1
10:14:48 End Action DialogShowSdInstallMode
10:14:48 begin ShowDialogsUpdateMask
10:14:48 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
10:14:48 Updated Dialog Mask: 0xbf40037, Disable Back = 0x1
10:14:48 Dialog 0x4 returned: 1
10:14:48 End Action ShowDialogsHlpr
10:14:48 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
10:14:48 Begin Action ShowDialogsHlpr: 0x10
10:14:48 Begin Action: DialogShowSdRegisterUserEx
10:14:57 End Action DialogShowSdRegisterUserEx
10:14:57 Dialog 0x10 returned: 1
10:14:57 End Action ShowDialogsHlpr
10:14:57 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
10:14:57 Begin Action ShowDialogsHlpr: 0x20
10:14:57 Begin Action: DialogShowSdLicense
10:15:00 End Action DialogShowSdLicense
10:15:00 Dialog 0x20 returned: 1
10:15:00 End Action ShowDialogsHlpr
10:15:00 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
10:15:00 Begin Action ShowDialogsHlpr: 0x40000
10:15:00 Begin Action: DialogShowSdCliSvr
10:15:00 DisplaySystemPreReq
10:15:02 ShowDlgClientServerSelect returned: 1
10:15:02 Type : 0x2
10:15:02 End Action DialogShowSdCliSvr
10:15:02 begin ShowDialogsUpdateMask
10:15:02 nFullMask = 0xbf40037, nCurrent = 0x40000, nDirection = 1
10:15:02 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
10:15:02 Dialog 0x40000 returned: 1
10:15:02 End Action ShowDialogsHlpr
10:15:02 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
10:15:02 Begin Action ShowDialogsHlpr: 0x80000
10:15:02 Begin Action: DialogShowSdInstanceName
10:15:02 Begin Action: ShowDlgInstanceName
10:15:03 End Action: ShowDlgInstanceName
10:15:03 ShowDlgInstanceName returned : 1
10:15:03 InstanceName : MSSQLSERVER
10:15:03 CreateSetupTopology(DEV2), Handle : 0x1134a50, returned : 0
10:15:03 CreateSetupTopology returned : 0, Handle : 0x1134a50
10:15:03 Topology Type : 1, Return Value : 0
10:15:03 ST_GetPhysicalNode returned : 0, PNHandle : 0x1134a78
10:15:03 PN_EnumerateEx returned : 0
10:15:03 PN_GetSQLStates returned : 0, SqlStates : 0x0
10:15:03 PN_StartScan [0x1134a78] returned : 0
10:15:03 PN_GetNext [0x1134a78] returned : 18, Handle: [0x0]
10:15:03 No more items in enumeration.
10:15:03 ReleaseSetupTopology
10:15:03 End Action DialogShowSdInstanceName
10:15:03 begin ShowDialogsUpdateMask
10:15:03 nFullMask = 0xbfc0037, nCurrent = 0x80000, nDirection = 1
10:15:03 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
10:15:03 Dialog 0x80000 returned: 1
10:15:03 End Action ShowDialogsHlpr
10:15:04 ShowDialogsGetDialog returned: nCurrent=0x100000,index 10:15:04 Begin Action ShowDialogsHlpr: 0x100000
10:15:04 Begin Action: DialogShowSdSetupType
10:15:04 Begin Action: Setup Type
10:15:22 Setup type set Typical
10:15:34 SQL program folder: C:\Program Files\Microsoft SQL Server
10:15:34 SQL data folder: C:\Program Files\Microsoft SQL Server
10:15:34 Windows system folder: C:\WINDOWS\System32\
10:15:34 Prog req: 38073, Data req: 34432, Sys req: 114225
10:15:34 Prog avail: 9393472, Data avail: 9393472, Sys avail: 9393472
10:15:34 Prog req vs. avail, 186730, 9393472
10:15:34 Data req vs. avail, 34432, 9393472
10:15:34 Sys req vs. avail, 148657, 9393472
10:15:34 DisplaySystemPreReq
10:15:34 [SetupTypeSQL]
10:15:34 szDir = C:\Program Files\Microsoft SQL Server
10:15:34 szDir = %PROGRAMFILES%\Microsoft SQL Server
10:15:34 Result = 301
10:15:34 szDataDir = C:\Program Files\Microsoft SQL Server
10:15:34 szDataDir = %PROGRAMFILES%\Microsoft SQL Server
10:15:34 End Action: Setup Type
10:15:34 Setup Type: Typical (301)
10:15:34 End Action DialogShowSdSetupType
10:15:34 begin ShowDialogsUpdateMask
10:15:34 nFullMask = 0xbfc0037, nCurrent = 0x100000, nDirection = 301
10:15:34 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:15:34 Dialog 0x100000 returned: 301
10:15:34 End Action ShowDialogsHlpr
10:15:34 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
10:15:34 Begin Action ShowDialogsHlpr: 0x400000
10:15:34 Begin Action: DlgServices
10:16:15 ShowDlgServices returned: 1
10:16:15 [DlgServices]
10:16:15 Local-Domain = 61680
10:16:15 AutoStart = 15
10:16:15 SQLDomain = KALTEC
10:16:15 SQLDomainAcct = administrator
10:16:15 SQLDomainPwd
10:16:15 AgtDomain = KALTEC
10:16:15 AgtDomainAcct = administrator
10:16:15 AgtDomainPwd
10:16:15 Result = 1
10:16:15 End Action DlgServices
10:16:15 begin ShowDialogsUpdateMask
10:16:15 nFullMask = 0xbdc0037, nCurrent = 0x400000, nDirection = 1
10:16:15 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:15 Dialog 0x400000 returned: 1
10:16:15 End Action ShowDialogsHlpr
10:16:15 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
10:16:15 Begin Action ShowDialogsHlpr: 0x800000
10:16:15 Begin Action: DlgSQLSecurity
10:16:27 ShowDlgSQLSecurity returned: 1
10:16:27 LoginMode = 2,szPwd
10:16:28 End Action DlgSQLSecurity
10:16:28 begin ShowDialogsUpdateMask
10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x800000, nDirection = 1
10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:28 Dialog 0x800000 returned: 1
10:16:28 End Action ShowDialogsHlpr
10:16:28 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
10:16:28 Begin Action ShowDialogsHlpr: 0x1000000
10:16:28 Begin Action: DlgCollation
10:16:28 ShowDlgCollation returned: 1
10:16:28 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name = Latin1_General,lcid = 0x409,SortId = 52,dwCompFlags = 0x30001
10:16:28 End Action DlgCollation
10:16:28 begin ShowDialogsUpdateMask
10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x1000000, nDirection = 1
10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:28 Dialog 0x1000000 returned: 1
10:16:28 End Action ShowDialogsHlpr
10:16:28 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
10:16:28 Begin Action ShowDialogsHlpr: 0x2000000
10:16:28 Begin Action: DlgNetwork
10:16:28 ShowDlgNetwork returned: 1
10:16:28 [DlgServerNetwork]
10:16:28 NetworkLibs = 255
10:16:28 TCPPort = 1433
10:16:28 TCPPrxy = Default
10:16:28 NMPPipeName = \\.\pipe\sql\query
10:16:28 Result = 1
10:16:28 End Action DlgNetwork
10:16:28 begin ShowDialogsUpdateMask
10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x2000000, nDirection = 1
10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:28 Dialog 0x2000000 returned: 1
10:16:28 End Action ShowDialogsHlpr
10:16:28 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
10:16:28 Begin Action ShowDialogsHlpr: 0x8000000
10:16:28 Begin Action: DialogShowSdStartCopy
10:16:30 End Action DialogShowSdStartCopy
10:16:30 begin ShowDialogsUpdateMask
10:16:30 nFullMask = 0xbdc0037, nCurrent = 0x8000000, nDirection = 1
10:16:30 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
10:16:30 Dialog 0x8000000 returned: 1
10:16:30 End Action ShowDialogsHlpr
10:16:30 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
10:16:30 End Action ShowDialogs
10:16:30 Begin Action ProcessBeforeDataMove:
10:16:31 DeinstallStart returned (C:\Program Files\Microsoft SQL
Server\MSSQL): 0
10:16:31 End Action ProcessBeforeDataMove:
10:16:31 Begin Action SetToolsComponentSelection:
10:16:31 End Action SetToolsComponentSelection:
10:16:31 Begin Action ProcessComponentSelection:
10:16:31 End Action ProcessComponentSelection
10:16:31 Begin Action LogSelectedComponents:
10:16:31 SQLProg
10:16:31 SQLProg\SQLServr
10:16:31 SQLProg\SQLServr\Help
10:16:31 SQLProg\SQLServr\SCMDev
10:16:31 SQLProg\SQLServr\SCMDev\SCMh
10:16:31 SQLProg\SQLServr\SCMDev\SCMX86Lb
10:16:31 SQLProg\SQLServr\SCMDev\SCMALb
10:16:31 SQLProg\SQLServr\Rs1033
10:16:31 SQLProg\SQLServr\RsIntl
10:16:31 SQLProg\SQLServr\ActiveX
10:16:31 SQLProg\SQLServr\System
10:16:31 SQLProg\UpgTools
10:16:31 SQLProg\UpgTools\UpgSys
10:16:31 SQLProg\UpgTools\ActiveX
10:16:31 SQLProg\UpgTools\Res1033
10:16:31 SQLProg\UpgTools\ResOther
10:16:31 SQLProg\UpgTools\Resld
10:16:31 SQLProg\ReplSupp
10:16:31 SQLProg\ReplSupp\ReplDat
10:16:31 SQLProg\ReplSupp\RepComm
10:16:31 SQLProg\ReplSupp\RepNoDk
10:16:31 SQLProg\ReplSupp\ActiveX
10:16:31 SQLProg\Install
10:16:31 SQLProg\System
10:16:31 SQLProg\SvrExt
10:16:31 SQLProg\SvrExt\Help
10:16:31 SQLProg\SvrExt\SvrExtRs
10:16:31 SQLProg\SvrExt\ResIntl
10:16:31 SQLProg\Dat
10:16:31 SQLProg\DatSmpl
10:16:31 SQLProg\BaseSys
10:16:31 SQLProg\BaseBinn
10:16:31 SQLProg\BaseInst
10:16:31 SQLProg\Symbols
10:16:31 SQLProg\Symbols\EXE
10:16:31 SQLProg\Symbols\DLL
10:16:31 SQLProg\Perfmon
10:16:31 SQLProg\Perfmon\System
10:16:31 SQLProg\Root
10:16:31 MgtTool
10:16:31 MgtTool\SEM
10:16:31 MgtTool\SEM\HTML
10:16:31 MgtTool\SEM\MSD98
10:16:31 MgtTool\SEM\MSD98SYS
10:16:31 MgtTool\SEM\MSD98Res
10:16:31 MgtTool\SEM\MSD98Hlp
10:16:31 MgtTool\SEM\Help
10:16:31 MgtTool\SEM\Res1033
10:16:31 MgtTool\SEM\ResIntl
10:16:31 MgtTool\SEM\MSD98RsI
10:16:31 MgtTool\SEM\ActiveX
10:16:31 MgtTool\SEM\ActiveX\Res1033
10:16:31 MgtTool\SEM\ActiveX\ResIntl
10:16:31 MgtTool\SEM\Scripts
10:16:31 MgtTool\SEM\OLEDB
10:16:31 MgtTool\SEM\OLEDB\Res1033
10:16:31 MgtTool\SEM\OLEDB\ResIntl
10:16:31 MgtTool\Profiler
10:16:31 MgtTool\Profiler\Help
10:16:31 MgtTool\Profiler\Res1033
10:16:31 MgtTool\Profiler\ResIntl
10:16:31 MgtTool\Qryanlz
10:16:31 MgtTool\Qryanlz\Help
10:16:31 MgtTool\Qryanlz\Res1033
10:16:31 MgtTool\Qryanlz\ResIntl
10:16:31 MgtTool\DTCCLi
10:16:31 MgtTool\Wzcnflct
10:16:31 MgtTool\Wzcnflct\WzcnHlp
10:16:31 MgtTool\Wzcnflct\Wzcn1033
10:16:31 MgtTool\Wzcnflct\WzcnOthr
10:16:31 MgtTool\Wzcnflct\WzcnCmn
10:16:31 MgtTool\UtilSys
10:16:31 MgtTool\UtilBinn
10:16:31 Connect
10:16:31 Connect\ConnSys
10:16:31 Books
10:16:31 Books\Bookso
10:16:31 Books\Bookso\Utils
10:16:31 DevTools
10:16:31 DevTools\Dbg Int
10:16:31 DevTools\Dbg Int\Dbg Int Common
10:16:31 DevTools\Dbg Int\EXE
10:16:31 CoreRepl
10:16:31 CoreRepl\Res1033
10:16:31 CoreRepl\ResIntl
10:16:31 Core
10:16:31 Core\Res1033
10:16:31 Core\ResOther
10:16:31 Repostry
10:16:31 Repostry\RepstSys
10:16:31 Repostry\Res1033
10:16:31 Repostry\ResIntl
10:16:31 CoreMisc
10:16:31 CoreMisc\ActiveX
10:16:31 CoreMisc\ActiveX\Res1033
10:16:31 CoreMisc\ActiveX\ResIntl
10:16:31 CoreMisc\Res1033
10:16:31 Monarch
10:16:31 Monarch\Monr1033
10:16:31 Monarch\MonrIntl
10:16:31 Jet
10:16:31 CoreInst
10:16:31 CoreCOM
10:16:31 CoreCOM\Res1033
10:16:31 CoreCOM\ResIntl
10:16:31 CoreTool
10:16:31 CoreTool\Res1033
10:16:31 CoreTool\ResOther
10:16:31 DBLibCli
10:16:31 SFExt
10:16:31 SFExt\ActiveX
10:16:31 SFExt\ActiveX\Res1033
10:16:31 SFExt\ActiveX\ResIntl
10:16:31 SFExt\Res1033
10:16:31 SFExt\ResIntl
10:16:31 Trace
10:16:31 Trace\Res1033
10:16:31 Trace\ResOther
10:16:31 MiscCore
10:16:31 MC
10:16:31 MC\MC1033
10:16:31 MC\MCIntl
10:16:31 MC\Help
10:16:31 SQLMgr
10:16:31 SQLMgr\Res1033
10:16:31 SQLMgr\ResIntl
10:16:31 SvrTool
10:16:31 SvrTool\Res1033
10:16:31 SvrTool\ResIntl
10:16:31 DTSUI
10:16:31 DTSUI\Res1033
10:16:31 DTSUI\ResIntl
10:16:31 MSOlap
10:16:32 MSOlap\Res1033
10:16:32 MSOlap\ResIntl
10:16:32 ATL
10:16:32 ATL\winnt
10:16:32 ATL\win9x
10:16:32 MFC42U
10:16:32 VC
10:16:32 VB
10:16:32 OCX1
10:16:32 SQLAdHlp
10:16:32 SQLAdHlp\Res1033
10:16:32 SQLAdHlp\ResOther
10:16:32 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
10:16:32 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
10:16:32 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
10:16:32 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
10:16:32 End Action LogSelectedComponents
10:16:32 Begin Action InstallPkgs:
10:16:32 Begin Action: Locked Connectivity Files Check
10:16:40 ConnectivityLocked returned: 0
10:16:40 The operation completed successfully.
10:16:40 End Action: Locked Connectivity Files Check
10:16:40 Setup is installing Microsoft Data Access Components (MDAC) ...
10:16:40 \\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Other\sqlredis.exe /q:a
/C:"setupre.exe WARN=1 -s -SMS"
10:17:43 ExitCode: 0
10:17:43 Setup is installing Microsoft Distributed Transaction Coordinator
(MSDTC) ...
10:17:43 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir
"C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg
"\\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Other\dtcsetup.exe" -LogFile
"C:\WINDOWS\sqlstp.log"
10:17:45 Process Exit Code: (0)
10:17:45 /Q:A /T:C:\WINDOWS\TEMP\ixp001.tmp
10:17:45 Setup is installing HTML Help ...
10:17:48 HTML Help installer exit code: 0
10:18:15 End Action InstallPkgs
10:18:15 Begin Action MoveFileData:
10:18:15 Enabled SELFREGISTERBATCH
10:18:15 Enabled CORECOMPONENTHANDLING
10:21:34 Begin Action: MoveFileDataSpecial
10:21:37 End Action: MoveFileDataSpecial
10:21:37 End Action MoveFileData
10:21:37 Begin Action ProcessAfterDataMove:
10:21:37 \\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Binn\hhcol.exe C:\Program
Files\Microsoft SQL Server\80\Tools\Books
10:21:42 End Action ProcessAfterDataMove
10:21:42 Begin Action BuildServer:
10:21:42 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 5 -ExePath
"C:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe" -Service
"MSSQLSERVER"
10:21:43 Process Exit Code: (0)
10:21:43 Begin Action: CreateRegistrySetSQL
10:21:43 End Action: CreateRegistrySetSQL
10:21:43 Begin Action: RegWriteSetupEntry
10:21:43 End Action: RegWriteSetupEntry
10:21:43 Begin Action: CreateSer
10:21:43 End Action: CreateSer
10:21:43 Begin Action: SkuIt
10:21:44 End Action: SkuIt
10:21:45 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL
Server\MSSQL returned: 0, 0
10:21:45 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
10:21:45 Begin Action: UpdateSystemPath
10:21:45 Path successfully updated.
10:21:45 C:\oracle\ora92\bin;C:\Program
Files\Oracle\jre\1.3.1\bin;C:\Program
Files\Oracle\jre\1.1.8\bin;C:\Perl\bin\;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\OCM;C:\Program
Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Common
Files\Autodesk Shared\;C:\Program Files\proe2001\bin;C:\Program Files\Common
Files\Roxio Shared\DLLShared;C:\Program Files\UltraEdit;C:\Program
Files\Rouzer File Printer\;C:\Program Files\Executive Software\Diskeeper\
10:21:45 End Action: UpdateSystemPath
10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
10:21:47 Grant Right for KALTEC\administrator returned : 1, 0
10:21:47 Grant Right for KALTEC\administrator returned : 1, 0
10:21:48 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F
"C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q
"SQL_Latin1_General_CP1_CI_AS" -H 66300 -U sa -P
###############################################################################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=DEV2;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
driver={sql server};server=DEV2;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
driver={sql server};server=DEV2;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
SQL Server configuration failed.
###############################################################################
10:22:26 Process Exit Code: (-1)
10:22:35 Setup failed to configure the server. Refer to the server error
logs and C:\WINDOWS\sqlstp.log for more information.
10:22:37 Action CleanUpInstall:
10:22:37 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service
SQLSERVERAGENT
10:22:38 Process Exit Code: (1060) The specified service does not exist as
an installed service.
10:22:38 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service
MSSQLSERVER
10:22:38 Process Exit Code: (0)
10:22:38 StatsGenerate returned: 2
10:22:38 StatsGenerate (0x0,0x1,0xf000000,0x100,1033,303,0x0,0x1,0,0,0
10:22:38 StatsGenerate -1,<Login Name>)
10:22:38 Installation Failed.
-----
2004-10-28 10:21:51.33 server Microsoft SQL Server 2000 - 8.00.194
(Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 1)
2004-10-28 10:21:51.37 server Copyright (C) 1988-2000 Microsoft
Corporation.
2004-10-28 10:21:51.37 server All rights reserved.
2004-10-28 10:21:51.37 server Server Process ID is 3460.
2004-10-28 10:21:51.37 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2004-10-28 10:21:51.41 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2004-10-28 10:21:51.78 server SQL Server configured for thread mode
processing.
2004-10-28 10:21:51.82 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2004-10-28 10:21:51.87 server Attempting to initialize Distributed
Transaction Coordinator.
2004-10-28 10:21:56.01 spid3 Warning ******************
2004-10-28 10:21:56.01 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2004-10-28 10:21:56.04 spid3 Starting up database 'master'.
2004-10-28 10:21:57.41 spid3 Server name is 'DEV2'.
2004-10-28 10:21:57.42 server Using 'SSNETLIB.DLL' version '8.0.311'.
2004-10-28 10:21:57.42 spid5 Starting up database 'model'.
2004-10-28 10:21:57.42 spid7 Starting up database 'msdb'.
2004-10-28 10:21:57.42 spid8 Starting up database 'pubs'.
2004-10-28 10:21:57.42 spid9 Starting up database 'Northwind'.
2004-10-28 10:21:58.95 spid5 Clearing tempdb database.
2004-10-28 10:22:00.94 server SQL server listening on 10.10.1.33: 1433.
2004-10-28 10:22:00.94 server SQL server listening on 127.0.0.1: 1433.
2004-10-28 10:22:02.26 spid5 Starting up database 'tempdb'.
2004-10-28 10:22:02.41 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2004-10-28 10:22:02.41 server SQL Server is ready for client connections
2004-10-28 10:22:02.61 spid3 Recovery complete.
2004-10-28 10:22:02.64 spid3 Warning: override, autoexec procedures
skipped.
2004-10-28 10:22:12.92 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.Turn off the Windows Firewall or open up UDP 1434 and TCP 1433 on it.
"Jim B." <Jim B.@.discussions.microsoft.com> wrote in message
news:3AFED5B5-06E9-47A4-8A7E-A68E1EEC24C4@.microsoft.com...
> Ok filks here is a strange one. Tried installing service pack 3am on my
> Windows XP
> machine that is at service 2 on the OS Level. Now from what I can gather
> when service pack 3a for SQL server is installed it wipes out all the
driver
> file locations and reinstalls a new MDAC from what I can see. But it never
> gets them installed and the SQL Server becomes mute because you can never
> connect to it. I've included a copy of the Log file that get's generated
from
> the install any one care to take a stab at this one. The following is the
> SQLSTP.Log File and under that is the Error Log from the SQL Server
> Directory. Any help would be great just reply to the group here.
> ----
--
> 10:14:35 Begin Setup
> 10:14:35 8.00.194
> 10:14:35 Mode = Normal
> 10:14:35 ModeType = NORMAL
> 10:14:38 GetDefinitionEx returned: 0, Extended: 0x0
> 10:14:38 ValueFTS returned: 1
> 10:14:38 ValuePID returned: 1
> 10:14:38 ValueLic returned: 0
> 10:14:38 System: Windows NT WorkStation
> 10:14:38 SQL Server ProductType: Developer Edition [0x3]
> 10:14:38 Begin Action: SetupInitialize
> 10:14:38 End Action SetupInitialize
> 10:14:38 Begin Action: SetupInstall
> 10:14:38 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir
...
> 10:14:38 CommonFilesDir=C:\Program Files\Common Files
> 10:14:38 Windows Directory=C:\WINDOWS\
> 10:14:38 Program Files=C:\Program Files\
> 10:14:38 TEMPDIR=C:\WINDOWS\TEMP\
> 10:14:38 Begin Action: SetupInstall
> 10:14:39 digpid size : 256
> 10:14:39 digpid size : 164
> 10:14:39 Begin Action: CheckFixedRequirements
> 10:14:39 Platform ID: 0xf000000
> 10:14:39 Version: 5.1.2600
> 10:14:39 File Version - C:\WINDOWS\System32\shdocvw.dll: 6.0.2800.1584
> 10:14:39 End Action: CheckFixedRequirements
> 10:14:40 Begin Action: ShowDialogs
> 10:14:40 Initial Dialog Mask: 0x83000f7, Disable Back=0x1
> 10:14:41 Begin Action ShowDialogsHlpr: 0x1
> 10:14:41 Begin Action: DialogShowSdWelcome
> 10:14:43 End Action DialogShowSdWelcome
> 10:14:43 Dialog 0x1 returned: 1
> 10:14:43 End Action ShowDialogsHlpr
> 10:14:43 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
> 10:14:43 Begin Action ShowDialogsHlpr: 0x2
> 10:14:43 Begin Action: DialogShowSdMachineName
> 10:14:45 ShowDlgMachine returned: 1
> 10:14:45 Name = DEV2, Type = 0x1
> 10:14:45 Begin Action: CheckRequirements
> 10:14:45 Processor Architecture: x86 (Pentium)
> 10:14:45 Service Pack: 256
> 10:14:45 ComputerName: DEV2
> 10:14:45 User Name: <Login Name>
> 10:14:45 IsAllAccessAllowed returned: 1
> 10:14:45 OS Language: 0x409
> 10:14:45 End Action CheckRequirements
> 10:14:45 This combination of Package and Operating System allows a full
> product install.
> 10:14:46 CreateSetupTopology(DEV2), Handle : 0x1134a50, returned : 0
> 10:14:46 CreateSetupTopology returned : 0, Handle : 0x1134a50
> 10:14:46 Topology Type : 1, Return Value : 0
> 10:14:46 ST_GetPhysicalNode returned : 0, PNHandle : 0x1134a78
> 10:14:46 PN_EnumerateEx returned : 0
> 10:14:46 PN_GetSQLStates returned : 0, SqlStates : 0x0
> 10:14:46 PN_StartScan [0x1134a78] returned : 0
> 10:14:46 PN_GetNext [0x1134a78] returned : 18, Handle: [0x0]
> 10:14:46 No more items in enumeration.
> 10:14:46 ReleaseSetupTopology
> 10:14:46 Named instance limit: 100, quota: 0
> 10:14:46 End Action DialogShowSdMachineName
> 10:14:46 begin ShowDialogsUpdateMask
> 10:14:46 nFullMask = 0x83000f7, nCurrent = 0x2, nDirection = 0
> 10:14:46 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
> 10:14:46 Dialog 0x2 returned: 0
> 10:14:46 End Action ShowDialogsHlpr
> 10:14:46 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
> 10:14:46 Begin Action ShowDialogsHlpr: 0x4
> 10:14:46 Begin Action: DialogShowSdInstallMode
> 10:14:48 ShowDlgInstallMode returned: 1
> 10:14:48 InstallMode : 0x1
> 10:14:48 End Action DialogShowSdInstallMode
> 10:14:48 begin ShowDialogsUpdateMask
> 10:14:48 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
> 10:14:48 Updated Dialog Mask: 0xbf40037, Disable Back = 0x1
> 10:14:48 Dialog 0x4 returned: 1
> 10:14:48 End Action ShowDialogsHlpr
> 10:14:48 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
> 10:14:48 Begin Action ShowDialogsHlpr: 0x10
> 10:14:48 Begin Action: DialogShowSdRegisterUserEx
> 10:14:57 End Action DialogShowSdRegisterUserEx
> 10:14:57 Dialog 0x10 returned: 1
> 10:14:57 End Action ShowDialogsHlpr
> 10:14:57 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
> 10:14:57 Begin Action ShowDialogsHlpr: 0x20
> 10:14:57 Begin Action: DialogShowSdLicense
> 10:15:00 End Action DialogShowSdLicense
> 10:15:00 Dialog 0x20 returned: 1
> 10:15:00 End Action ShowDialogsHlpr
> 10:15:00 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
> 10:15:00 Begin Action ShowDialogsHlpr: 0x40000
> 10:15:00 Begin Action: DialogShowSdCliSvr
> 10:15:00 DisplaySystemPreReq
> 10:15:02 ShowDlgClientServerSelect returned: 1
> 10:15:02 Type : 0x2
> 10:15:02 End Action DialogShowSdCliSvr
> 10:15:02 begin ShowDialogsUpdateMask
> 10:15:02 nFullMask = 0xbf40037, nCurrent = 0x40000, nDirection = 1
> 10:15:02 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
> 10:15:02 Dialog 0x40000 returned: 1
> 10:15:02 End Action ShowDialogsHlpr
> 10:15:02 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
> 10:15:02 Begin Action ShowDialogsHlpr: 0x80000
> 10:15:02 Begin Action: DialogShowSdInstanceName
> 10:15:02 Begin Action: ShowDlgInstanceName
> 10:15:03 End Action: ShowDlgInstanceName
> 10:15:03 ShowDlgInstanceName returned : 1
> 10:15:03 InstanceName : MSSQLSERVER
> 10:15:03 CreateSetupTopology(DEV2), Handle : 0x1134a50, returned : 0
> 10:15:03 CreateSetupTopology returned : 0, Handle : 0x1134a50
> 10:15:03 Topology Type : 1, Return Value : 0
> 10:15:03 ST_GetPhysicalNode returned : 0, PNHandle : 0x1134a78
> 10:15:03 PN_EnumerateEx returned : 0
> 10:15:03 PN_GetSQLStates returned : 0, SqlStates : 0x0
> 10:15:03 PN_StartScan [0x1134a78] returned : 0
> 10:15:03 PN_GetNext [0x1134a78] returned : 18, Handle: [0x0]
> 10:15:03 No more items in enumeration.
> 10:15:03 ReleaseSetupTopology
> 10:15:03 End Action DialogShowSdInstanceName
> 10:15:03 begin ShowDialogsUpdateMask
> 10:15:03 nFullMask = 0xbfc0037, nCurrent = 0x80000, nDirection = 1
> 10:15:03 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
> 10:15:03 Dialog 0x80000 returned: 1
> 10:15:03 End Action ShowDialogsHlpr
> 10:15:04 ShowDialogsGetDialog returned: nCurrent=0x100000,index > 10:15:04 Begin Action ShowDialogsHlpr: 0x100000
> 10:15:04 Begin Action: DialogShowSdSetupType
> 10:15:04 Begin Action: Setup Type
> 10:15:22 Setup type set Typical
> 10:15:34 SQL program folder: C:\Program Files\Microsoft SQL Server
> 10:15:34 SQL data folder: C:\Program Files\Microsoft SQL Server
> 10:15:34 Windows system folder: C:\WINDOWS\System32\
> 10:15:34 Prog req: 38073, Data req: 34432, Sys req: 114225
> 10:15:34 Prog avail: 9393472, Data avail: 9393472, Sys avail: 9393472
> 10:15:34 Prog req vs. avail, 186730, 9393472
> 10:15:34 Data req vs. avail, 34432, 9393472
> 10:15:34 Sys req vs. avail, 148657, 9393472
> 10:15:34 DisplaySystemPreReq
> 10:15:34 [SetupTypeSQL]
> 10:15:34 szDir = C:\Program Files\Microsoft SQL Server
> 10:15:34 szDir = %PROGRAMFILES%\Microsoft SQL Server
> 10:15:34 Result = 301
> 10:15:34 szDataDir = C:\Program Files\Microsoft SQL Server
> 10:15:34 szDataDir = %PROGRAMFILES%\Microsoft SQL Server
> 10:15:34 End Action: Setup Type
> 10:15:34 Setup Type: Typical (301)
> 10:15:34 End Action DialogShowSdSetupType
> 10:15:34 begin ShowDialogsUpdateMask
> 10:15:34 nFullMask = 0xbfc0037, nCurrent = 0x100000, nDirection = 301
> 10:15:34 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:15:34 Dialog 0x100000 returned: 301
> 10:15:34 End Action ShowDialogsHlpr
> 10:15:34 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
> 10:15:34 Begin Action ShowDialogsHlpr: 0x400000
> 10:15:34 Begin Action: DlgServices
> 10:16:15 ShowDlgServices returned: 1
> 10:16:15 [DlgServices]
> 10:16:15 Local-Domain = 61680
> 10:16:15 AutoStart = 15
> 10:16:15 SQLDomain = KALTEC
> 10:16:15 SQLDomainAcct = administrator
> 10:16:15 SQLDomainPwd
> 10:16:15 AgtDomain = KALTEC
> 10:16:15 AgtDomainAcct = administrator
> 10:16:15 AgtDomainPwd
> 10:16:15 Result = 1
> 10:16:15 End Action DlgServices
> 10:16:15 begin ShowDialogsUpdateMask
> 10:16:15 nFullMask = 0xbdc0037, nCurrent = 0x400000, nDirection = 1
> 10:16:15 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:15 Dialog 0x400000 returned: 1
> 10:16:15 End Action ShowDialogsHlpr
> 10:16:15 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
> 10:16:15 Begin Action ShowDialogsHlpr: 0x800000
> 10:16:15 Begin Action: DlgSQLSecurity
> 10:16:27 ShowDlgSQLSecurity returned: 1
> 10:16:27 LoginMode = 2,szPwd
> 10:16:28 End Action DlgSQLSecurity
> 10:16:28 begin ShowDialogsUpdateMask
> 10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x800000, nDirection = 1
> 10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:28 Dialog 0x800000 returned: 1
> 10:16:28 End Action ShowDialogsHlpr
> 10:16:28 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
> 10:16:28 Begin Action ShowDialogsHlpr: 0x1000000
> 10:16:28 Begin Action: DlgCollation
> 10:16:28 ShowDlgCollation returned: 1
> 10:16:28 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name => Latin1_General,lcid = 0x409,SortId = 52,dwCompFlags = 0x30001
> 10:16:28 End Action DlgCollation
> 10:16:28 begin ShowDialogsUpdateMask
> 10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x1000000, nDirection = 1
> 10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:28 Dialog 0x1000000 returned: 1
> 10:16:28 End Action ShowDialogsHlpr
> 10:16:28 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
> 10:16:28 Begin Action ShowDialogsHlpr: 0x2000000
> 10:16:28 Begin Action: DlgNetwork
> 10:16:28 ShowDlgNetwork returned: 1
> 10:16:28 [DlgServerNetwork]
> 10:16:28 NetworkLibs = 255
> 10:16:28 TCPPort = 1433
> 10:16:28 TCPPrxy = Default
> 10:16:28 NMPPipeName = \\.\pipe\sql\query
> 10:16:28 Result = 1
> 10:16:28 End Action DlgNetwork
> 10:16:28 begin ShowDialogsUpdateMask
> 10:16:28 nFullMask = 0xbdc0037, nCurrent = 0x2000000, nDirection = 1
> 10:16:28 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:28 Dialog 0x2000000 returned: 1
> 10:16:28 End Action ShowDialogsHlpr
> 10:16:28 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
> 10:16:28 Begin Action ShowDialogsHlpr: 0x8000000
> 10:16:28 Begin Action: DialogShowSdStartCopy
> 10:16:30 End Action DialogShowSdStartCopy
> 10:16:30 begin ShowDialogsUpdateMask
> 10:16:30 nFullMask = 0xbdc0037, nCurrent = 0x8000000, nDirection = 1
> 10:16:30 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
> 10:16:30 Dialog 0x8000000 returned: 1
> 10:16:30 End Action ShowDialogsHlpr
> 10:16:30 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
> 10:16:30 End Action ShowDialogs
> 10:16:30 Begin Action ProcessBeforeDataMove:
> 10:16:31 DeinstallStart returned (C:\Program Files\Microsoft SQL
> Server\MSSQL): 0
> 10:16:31 End Action ProcessBeforeDataMove:
> 10:16:31 Begin Action SetToolsComponentSelection:
> 10:16:31 End Action SetToolsComponentSelection:
> 10:16:31 Begin Action ProcessComponentSelection:
> 10:16:31 End Action ProcessComponentSelection
> 10:16:31 Begin Action LogSelectedComponents:
> 10:16:31 SQLProg
> 10:16:31 SQLProg\SQLServr
> 10:16:31 SQLProg\SQLServr\Help
> 10:16:31 SQLProg\SQLServr\SCMDev
> 10:16:31 SQLProg\SQLServr\SCMDev\SCMh
> 10:16:31 SQLProg\SQLServr\SCMDev\SCMX86Lb
> 10:16:31 SQLProg\SQLServr\SCMDev\SCMALb
> 10:16:31 SQLProg\SQLServr\Rs1033
> 10:16:31 SQLProg\SQLServr\RsIntl
> 10:16:31 SQLProg\SQLServr\ActiveX
> 10:16:31 SQLProg\SQLServr\System
> 10:16:31 SQLProg\UpgTools
> 10:16:31 SQLProg\UpgTools\UpgSys
> 10:16:31 SQLProg\UpgTools\ActiveX
> 10:16:31 SQLProg\UpgTools\Res1033
> 10:16:31 SQLProg\UpgTools\ResOther
> 10:16:31 SQLProg\UpgTools\Resld
> 10:16:31 SQLProg\ReplSupp
> 10:16:31 SQLProg\ReplSupp\ReplDat
> 10:16:31 SQLProg\ReplSupp\RepComm
> 10:16:31 SQLProg\ReplSupp\RepNoDk
> 10:16:31 SQLProg\ReplSupp\ActiveX
> 10:16:31 SQLProg\Install
> 10:16:31 SQLProg\System
> 10:16:31 SQLProg\SvrExt
> 10:16:31 SQLProg\SvrExt\Help
> 10:16:31 SQLProg\SvrExt\SvrExtRs
> 10:16:31 SQLProg\SvrExt\ResIntl
> 10:16:31 SQLProg\Dat
> 10:16:31 SQLProg\DatSmpl
> 10:16:31 SQLProg\BaseSys
> 10:16:31 SQLProg\BaseBinn
> 10:16:31 SQLProg\BaseInst
> 10:16:31 SQLProg\Symbols
> 10:16:31 SQLProg\Symbols\EXE
> 10:16:31 SQLProg\Symbols\DLL
> 10:16:31 SQLProg\Perfmon
> 10:16:31 SQLProg\Perfmon\System
> 10:16:31 SQLProg\Root
> 10:16:31 MgtTool
> 10:16:31 MgtTool\SEM
> 10:16:31 MgtTool\SEM\HTML
> 10:16:31 MgtTool\SEM\MSD98
> 10:16:31 MgtTool\SEM\MSD98SYS
> 10:16:31 MgtTool\SEM\MSD98Res
> 10:16:31 MgtTool\SEM\MSD98Hlp
> 10:16:31 MgtTool\SEM\Help
> 10:16:31 MgtTool\SEM\Res1033
> 10:16:31 MgtTool\SEM\ResIntl
> 10:16:31 MgtTool\SEM\MSD98RsI
> 10:16:31 MgtTool\SEM\ActiveX
> 10:16:31 MgtTool\SEM\ActiveX\Res1033
> 10:16:31 MgtTool\SEM\ActiveX\ResIntl
> 10:16:31 MgtTool\SEM\Scripts
> 10:16:31 MgtTool\SEM\OLEDB
> 10:16:31 MgtTool\SEM\OLEDB\Res1033
> 10:16:31 MgtTool\SEM\OLEDB\ResIntl
> 10:16:31 MgtTool\Profiler
> 10:16:31 MgtTool\Profiler\Help
> 10:16:31 MgtTool\Profiler\Res1033
> 10:16:31 MgtTool\Profiler\ResIntl
> 10:16:31 MgtTool\Qryanlz
> 10:16:31 MgtTool\Qryanlz\Help
> 10:16:31 MgtTool\Qryanlz\Res1033
> 10:16:31 MgtTool\Qryanlz\ResIntl
> 10:16:31 MgtTool\DTCCLi
> 10:16:31 MgtTool\Wzcnflct
> 10:16:31 MgtTool\Wzcnflct\WzcnHlp
> 10:16:31 MgtTool\Wzcnflct\Wzcn1033
> 10:16:31 MgtTool\Wzcnflct\WzcnOthr
> 10:16:31 MgtTool\Wzcnflct\WzcnCmn
> 10:16:31 MgtTool\UtilSys
> 10:16:31 MgtTool\UtilBinn
> 10:16:31 Connect
> 10:16:31 Connect\ConnSys
> 10:16:31 Books
> 10:16:31 Books\Bookso
> 10:16:31 Books\Bookso\Utils
> 10:16:31 DevTools
> 10:16:31 DevTools\Dbg Int
> 10:16:31 DevTools\Dbg Int\Dbg Int Common
> 10:16:31 DevTools\Dbg Int\EXE
> 10:16:31 CoreRepl
> 10:16:31 CoreRepl\Res1033
> 10:16:31 CoreRepl\ResIntl
> 10:16:31 Core
> 10:16:31 Core\Res1033
> 10:16:31 Core\ResOther
> 10:16:31 Repostry
> 10:16:31 Repostry\RepstSys
> 10:16:31 Repostry\Res1033
> 10:16:31 Repostry\ResIntl
> 10:16:31 CoreMisc
> 10:16:31 CoreMisc\ActiveX
> 10:16:31 CoreMisc\ActiveX\Res1033
> 10:16:31 CoreMisc\ActiveX\ResIntl
> 10:16:31 CoreMisc\Res1033
> 10:16:31 Monarch
> 10:16:31 Monarch\Monr1033
> 10:16:31 Monarch\MonrIntl
> 10:16:31 Jet
> 10:16:31 CoreInst
> 10:16:31 CoreCOM
> 10:16:31 CoreCOM\Res1033
> 10:16:31 CoreCOM\ResIntl
> 10:16:31 CoreTool
> 10:16:31 CoreTool\Res1033
> 10:16:31 CoreTool\ResOther
> 10:16:31 DBLibCli
> 10:16:31 SFExt
> 10:16:31 SFExt\ActiveX
> 10:16:31 SFExt\ActiveX\Res1033
> 10:16:31 SFExt\ActiveX\ResIntl
> 10:16:31 SFExt\Res1033
> 10:16:31 SFExt\ResIntl
> 10:16:31 Trace
> 10:16:31 Trace\Res1033
> 10:16:31 Trace\ResOther
> 10:16:31 MiscCore
> 10:16:31 MC
> 10:16:31 MC\MC1033
> 10:16:31 MC\MCIntl
> 10:16:31 MC\Help
> 10:16:31 SQLMgr
> 10:16:31 SQLMgr\Res1033
> 10:16:31 SQLMgr\ResIntl
> 10:16:31 SvrTool
> 10:16:31 SvrTool\Res1033
> 10:16:31 SvrTool\ResIntl
> 10:16:31 DTSUI
> 10:16:31 DTSUI\Res1033
> 10:16:31 DTSUI\ResIntl
> 10:16:31 MSOlap
> 10:16:32 MSOlap\Res1033
> 10:16:32 MSOlap\ResIntl
> 10:16:32 ATL
> 10:16:32 ATL\winnt
> 10:16:32 ATL\win9x
> 10:16:32 MFC42U
> 10:16:32 VC
> 10:16:32 VB
> 10:16:32 OCX1
> 10:16:32 SQLAdHlp
> 10:16:32 SQLAdHlp\Res1033
> 10:16:32 SQLAdHlp\ResOther
> 10:16:32 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
> 10:16:32 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
> 10:16:32 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
> 10:16:32 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
> 10:16:32 End Action LogSelectedComponents
> 10:16:32 Begin Action InstallPkgs:
> 10:16:32 Begin Action: Locked Connectivity Files Check
> 10:16:40 ConnectivityLocked returned: 0
> 10:16:40 The operation completed successfully.
> 10:16:40 End Action: Locked Connectivity Files Check
> 10:16:40 Setup is installing Microsoft Data Access Components (MDAC) ...
> 10:16:40 \\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Other\sqlredis.exe /q:a
> /C:"setupre.exe WARN=1 -s -SMS"
> 10:17:43 ExitCode: 0
> 10:17:43 Setup is installing Microsoft Distributed Transaction Coordinator
> (MSDTC) ...
> 10:17:43 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir
> "C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg
> "\\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Other\dtcsetup.exe" -LogFile
> "C:\WINDOWS\sqlstp.log"
> 10:17:45 Process Exit Code: (0)
> 10:17:45 /Q:A /T:C:\WINDOWS\TEMP\ixp001.tmp
> 10:17:45 Setup is installing HTML Help ...
> 10:17:48 HTML Help installer exit code: 0
> 10:18:15 End Action InstallPkgs
> 10:18:15 Begin Action MoveFileData:
> 10:18:15 Enabled SELFREGISTERBATCH
> 10:18:15 Enabled CORECOMPONENTHANDLING
> 10:21:34 Begin Action: MoveFileDataSpecial
> 10:21:37 End Action: MoveFileDataSpecial
> 10:21:37 End Action MoveFileData
> 10:21:37 Begin Action ProcessAfterDataMove:
> 10:21:37 \\DEV1\DVD\ENGLISH\SQL2000\DEV\x86\Binn\hhcol.exe C:\Program
> Files\Microsoft SQL Server\80\Tools\Books
> 10:21:42 End Action ProcessAfterDataMove
> 10:21:42 Begin Action BuildServer:
> 10:21:42 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action
5 -ExePath
> "C:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe" -Service
> "MSSQLSERVER"
> 10:21:43 Process Exit Code: (0)
> 10:21:43 Begin Action: CreateRegistrySetSQL
> 10:21:43 End Action: CreateRegistrySetSQL
> 10:21:43 Begin Action: RegWriteSetupEntry
> 10:21:43 End Action: RegWriteSetupEntry
> 10:21:43 Begin Action: CreateSer
> 10:21:43 End Action: CreateSer
> 10:21:43 Begin Action: SkuIt
> 10:21:44 End Action: SkuIt
> 10:21:45 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL
> Server\MSSQL returned: 0, 0
> 10:21:45 SetRegSecuritySQLAndAdmin for
> Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
> 10:21:45 Begin Action: UpdateSystemPath
> 10:21:45 Path successfully updated.
> 10:21:45 C:\oracle\ora92\bin;C:\Program
> Files\Oracle\jre\1.3.1\bin;C:\Program
>
Files\Oracle\jre\1.1.8\bin;C:\Perl\bin\;%SystemRoot%\system32;%SystemRoot%;%
SystemRoot%\System32\Wbem;C:\OCM;C:\Program
> Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Common
> Files\Autodesk Shared\;C:\Program Files\proe2001\bin;C:\Program
Files\Common
> Files\Roxio Shared\DLLShared;C:\Program Files\UltraEdit;C:\Program
> Files\Rouzer File Printer\;C:\Program Files\Executive Software\Diskeeper\
> 10:21:45 End Action: UpdateSystemPath
> 10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:46 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:47 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:47 Grant Right for KALTEC\administrator returned : 1, 0
> 10:21:48 C:\Program Files\Microsoft SQL
erver\80\Tools\Binn\cnfgsvr.exe -F
> "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q
> "SQL_Latin1_General_CP1_CI_AS" -H 66300 -U sa -P
>
############################################################################
###
>
> Starting Service ...
> SQL_Latin1_General_CP1_CI_AS
> -m -Q -T4022 -T3659
> Connecting to Server ...
> driver={sql server};server=DEV2;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> driver={sql server};server=DEV2;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> driver={sql server};server=DEV2;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> SQL Server configuration failed.
>
############################################################################
###
> 10:22:26 Process Exit Code: (-1)
> 10:22:35 Setup failed to configure the server. Refer to the server error
> logs and C:\WINDOWS\sqlstp.log for more information.
> 10:22:37 Action CleanUpInstall:
> 10:22:37 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action
4 -Service
> SQLSERVERAGENT
> 10:22:38 Process Exit Code: (1060) The specified service does not exist as
> an installed service.
> 10:22:38 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action
4 -Service
> MSSQLSERVER
> 10:22:38 Process Exit Code: (0)
> 10:22:38 StatsGenerate returned: 2
> 10:22:38 StatsGenerate (0x0,0x1,0xf000000,0x100,1033,303,0x0,0x1,0,0,0
> 10:22:38 StatsGenerate -1,<Login Name>)
> 10:22:38 Installation Failed.
> ----
--
> 2004-10-28 10:21:51.33 server Microsoft SQL Server 2000 - 8.00.194
> (Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 1)
> 2004-10-28 10:21:51.37 server Copyright (C) 1988-2000 Microsoft
> Corporation.
> 2004-10-28 10:21:51.37 server All rights reserved.
> 2004-10-28 10:21:51.37 server Server Process ID is 3460.
> 2004-10-28 10:21:51.37 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2004-10-28 10:21:51.41 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).
> 2004-10-28 10:21:51.78 server SQL Server configured for thread mode
> processing.
> 2004-10-28 10:21:51.82 server Using dynamic lock allocation. [2500]
Lock
> Blocks, [5000] Lock Owner Blocks.
> 2004-10-28 10:21:51.87 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2004-10-28 10:21:56.01 spid3 Warning ******************
> 2004-10-28 10:21:56.01 spid3 SQL Server started in single user mode.
> Updates allowed to system catalogs.
> 2004-10-28 10:21:56.04 spid3 Starting up database 'master'.
> 2004-10-28 10:21:57.41 spid3 Server name is 'DEV2'.
> 2004-10-28 10:21:57.42 server Using 'SSNETLIB.DLL' version '8.0.311'.
> 2004-10-28 10:21:57.42 spid5 Starting up database 'model'.
> 2004-10-28 10:21:57.42 spid7 Starting up database 'msdb'.
> 2004-10-28 10:21:57.42 spid8 Starting up database 'pubs'.
> 2004-10-28 10:21:57.42 spid9 Starting up database 'Northwind'.
> 2004-10-28 10:21:58.95 spid5 Clearing tempdb database.
> 2004-10-28 10:22:00.94 server SQL server listening on 10.10.1.33: 1433.
> 2004-10-28 10:22:00.94 server SQL server listening on 127.0.0.1: 1433.
> 2004-10-28 10:22:02.26 spid5 Starting up database 'tempdb'.
> 2004-10-28 10:22:02.41 server SQL server listening on TCP, Shared
Memory,
> Named Pipes.
> 2004-10-28 10:22:02.41 server SQL Server is ready for client
connections
> 2004-10-28 10:22:02.61 spid3 Recovery complete.
> 2004-10-28 10:22:02.64 spid3 Warning: override, autoexec procedures
> skipped.
> 2004-10-28 10:22:12.92 spid3 SQL Server is terminating due to 'stop'
> request from Service Control Manager.
>
Subscribe to:
Posts (Atom)