Problems Installing MSDE 2000

Hi,
I trying to install MSDE 2000 in my PC a lot of times, but unsucessfully;
show me a pop-up screen:Setup failed to configure the server. Refer to the
server error logs and setup error logs for more information.
My log file:
2005-05-07 10:01:25.98 server Microsoft SQL Server 2000 - 8.00.760 (Intel
X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)
2005-05-07 10:01:25.98 server Copyright (C) 1988-2002 Microsoft
Corporation.
2005-05-07 10:01:25.98 server All rights reserved.
2005-05-07 10:01:25.98 server Server Process ID is 3264.
2005-05-07 10:01:25.98 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\Data\MSSQL\LOG\ERRORLOG'.
2005-05-07 10:01:26.00 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2005-05-07 10:01:26.01 server SQL Server configured for thread mode
processing.
2005-05-07 10:01:26.01 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2005-05-07 10:01:26.03 spid3 Warning ******************
2005-05-07 10:01:26.03 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2005-05-07 10:01:26.03 spid3 Starting up database 'master'.
2005-05-07 10:01:26.57 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-05-07 10:01:26.57 spid5 Starting up database 'model'.
2005-05-07 10:01:26.64 spid3 Server name is 'KL55692'.
2005-05-07 10:01:26.64 spid3 Skipping startup of clean database id 5
2005-05-07 10:01:26.64 spid3 Skipping startup of clean database id 6
2005-05-07 10:01:26.64 spid3 Starting up database 'msdb'.
2005-05-07 10:01:26.79 server SQL server listening on Shared Memory.
2005-05-07 10:01:26.79 server SQL Server is ready for client connections
2005-05-07 10:01:27.40 spid5 Clearing tempdb database.
2005-05-07 10:01:28.00 spid5 Starting up database 'tempdb'.
2005-05-07 10:01:28.07 spid3 Recovery complete.
2005-05-07 10:01:28.07 spid3 SQL global counter collection task is
created.
2005-05-07 10:01:28.17 spid3 Warning: override, autoexec procedures
skipped.
2005-05-07 10:01:36.51 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
In my event viewer/ Application:
Type: Error Source: MsiInstaller Event: 1013
and my setup.ini file:
[Options]
DATADIR=C:\Program Files\Microsoft SQL Server\MSSQL\Data\
DISABLENETWORKPROTOCOLS=1
SAPWD=sa
SECURITYMODE=SQL
TARGETDIR=C:\Program Files\Microsoft SQL Server\MSSQL\Binn\
Do you have any idea how fix this?
hi Ivan,
Ivan Anzaldua wrote:
> Hi,
> I trying to install MSDE 2000 in my PC a lot of times, but
> unsucessfully; show me a pop-up screen:Setup failed to configure the
> server. Refer to the server error logs and setup error logs for more
> information.
this error usually shows up when a previously disinstalled MSDE instance has
not been properly cleaned up... please refer to
http://support.microsoft.com/default...99&Product=sql
for further info
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Probleme with Merge replication

Hi all
I am trying to configure a merge replication of publication in LAN
The whole Dynamic Filter snapshot runs well, all the data are pumped to the subscriber and all dri, trg etc. scripts are executed without problem. Then it launch a synchronization. Logically and usually there is no data to be merged. But here it start to replicate a lot of change. It's been 8hours it runs and I've got 600000 update.

I have verified the snapshot, the subcribers parameters... and as usal there is no mistake or error. Nothing change on my Server (SQL 2000 SP3a running on W2K SP2 English).

All was running well before. Since one week the problem appears.

Any Idea ?Check with your sysadmin, see if he implemented any policies. Also see if service accounts on the participants are the same (preferred)|||I'm the sysadmin !
And nothing change even on the AD ! No rights, no GPO...

....

Thanks for your answer

Problem with viewing column permissions in Enterprise Manager

When trying to configure SQL Server security at the column level I ran into
a problem: if I assigned column-level security through Enterprise Manager it
seemed to work fine, but after reopening the permission dialog box the
permissions on some columns disappeared.
After doing some research I can now simulate the behaviour when running the
following script. In Enterprise manager the security on column 'Col3' does
not show after running the script, though it is there.
CREATE TABLE test
(
Col1 int NOT NULL,
Col2 nvarchar(50) NOT NULL,
Col3 int NOT NULL
)
GO
ALTER TABLE test
DROP COLUMN Col2
GO
GRANT SELECT ON test(Col3) TO public
GO
/* Correct: returns select permission on Col3 */
sp_helprotect 'test'
GO
/* Bug! Does not return anything. */
/* Problem is that sp_MSobjectprivs uses count(*) on syscolumns instead of
max(colid) to determine maximum column number */
sp_MSobjectprivs N'test','column',null,null,null,null,0,1
GO
Enterprise Manager seems to use the sp_MSobjectprivs procedure to retrieve
the column permissions, but that one fails if columns are not numbered
consecutively (as caused by the DROP COLUMN).
Stefan Cuypers.
Dear Stefan,
Thank you for your feedback. I have reproduced the problem. Please rest
assured that we do understand your concerns and that the known issue is
being worked in development with priority after we report it via our
internal channel. We strive to capture any and all product issues / product
feedback so as to ensure that we are continuously developing Microsoft
products to meet customer needs. This is exactly why feedback such as
yours is always taken very seriously.
While we also hope to see the issue fixed as soon as possible, we have
re-confirmed with the development team that there are no better workarounds
at this time. If there are any updates on the issue, I will do my best to
be the first one to let you know.
Once again, thank you for your time and feedback.
Sincerely,
Bill Cheng
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
| From: "Stefan Cuypers" <stefan.cuypers@.nospam.nospam>
| Subject: Problem with viewing column permissions in Enterprise Manager
| Date: Fri, 2 Jul 2004 16:15:01 +0200
| Lines: 35
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.3790.0
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132
| Message-ID: <#kQW57DYEHA.2908@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.tools
| NNTP-Posting-Host: d576ae10.kabel.telenet.be 213.118.174.16
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP10.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.tools:24406
| X-Tomcat-NG: microsoft.public.sqlserver.tools
|
| When trying to configure SQL Server security at the column level I ran
into
| a problem: if I assigned column-level security through Enterprise Manager
it
| seemed to work fine, but after reopening the permission dialog box the
| permissions on some columns disappeared.
| After doing some research I can now simulate the behaviour when running
the
| following script. In Enterprise manager the security on column 'Col3' does
| not show after running the script, though it is there.
| CREATE TABLE test
| (
| Col1 int NOT NULL,
| Col2 nvarchar(50) NOT NULL,
| Col3 int NOT NULL
| )
| GO
| ALTER TABLE test
| DROP COLUMN Col2
| GO
| GRANT SELECT ON test(Col3) TO public
| GO
| /* Correct: returns select permission on Col3 */
| sp_helprotect 'test'
| GO
| /* Bug! Does not return anything. */
| /* Problem is that sp_MSobjectprivs uses count(*) on syscolumns instead of
| max(colid) to determine maximum column number */
| sp_MSobjectprivs N'test','column',null,null,null,null,0,1
| GO
|
| Enterprise Manager seems to use the sp_MSobjectprivs procedure to retrieve
| the column permissions, but that one fails if columns are not numbered
| consecutively (as caused by the DROP COLUMN).
|
| Stefan Cuypers.
|
|
|
|||Bill,
Thanks for the feedback. I'm glad you take it seriously and will try to fix
it in a next update.
Stefan.
""Bill Cheng"" <billchng@.online.microsoft.com> wrote in message
news:jNqMXDOYEHA.2352@.cpmsftngxa06.phx.gbl...
> Dear Stefan,
> Thank you for your feedback. I have reproduced the problem. Please rest
> assured that we do understand your concerns and that the known issue is
> being worked in development with priority after we report it via our
> internal channel. We strive to capture any and all product issues /
product
> feedback so as to ensure that we are continuously developing Microsoft
> products to meet customer needs. This is exactly why feedback such as
> yours is always taken very seriously.
> While we also hope to see the issue fixed as soon as possible, we have
> re-confirmed with the development team that there are no better
workarounds
> at this time. If there are any updates on the issue, I will do my best to
> be the first one to let you know.
> Once again, thank you for your time and feedback.
> Sincerely,
> Bill Cheng
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> --
> | From: "Stefan Cuypers" <stefan.cuypers@.nospam.nospam>
> | Subject: Problem with viewing column permissions in Enterprise Manager
> | Date: Fri, 2 Jul 2004 16:15:01 +0200
> | Lines: 35
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.3790.0
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132
> | Message-ID: <#kQW57DYEHA.2908@.TK2MSFTNGP10.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.tools
> | NNTP-Posting-Host: d576ae10.kabel.telenet.be 213.118.174.16
> | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP10.phx.gbl
> | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.tools:24406
> | X-Tomcat-NG: microsoft.public.sqlserver.tools
> |
> | When trying to configure SQL Server security at the column level I ran
> into
> | a problem: if I assigned column-level security through Enterprise
Manager
> it
> | seemed to work fine, but after reopening the permission dialog box the
> | permissions on some columns disappeared.
> | After doing some research I can now simulate the behaviour when running
> the
> | following script. In Enterprise manager the security on column 'Col3'
does
> | not show after running the script, though it is there.
> | CREATE TABLE test
> | (
> | Col1 int NOT NULL,
> | Col2 nvarchar(50) NOT NULL,
> | Col3 int NOT NULL
> | )
> | GO
> | ALTER TABLE test
> | DROP COLUMN Col2
> | GO
> | GRANT SELECT ON test(Col3) TO public
> | GO
> | /* Correct: returns select permission on Col3 */
> | sp_helprotect 'test'
> | GO
> | /* Bug! Does not return anything. */
> | /* Problem is that sp_MSobjectprivs uses count(*) on syscolumns instead
of
> | max(colid) to determine maximum column number */
> | sp_MSobjectprivs N'test','column',null,null,null,null,0,1
> | GO
> |
> | Enterprise Manager seems to use the sp_MSobjectprivs procedure to
retrieve
> | the column permissions, but that one fails if columns are not numbered
> | consecutively (as caused by the DROP COLUMN).
> |
> | Stefan Cuypers.
> |
> |
> |
>