COM Plus Catalog Requirement (Warning) When installing MS SQL SERVER 2005 ENTERPRISE ON WINDOWS

COM Plus Catalog Requirement (Warning)

Messages

COM Plus Catalog Requirement

If SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the files and then rerun Setup. For more information, see How to: Work Around COM+ Check Failure in SQL Server Setup.

Are you hitting this warning? Is it preventing you from installing?

Thanks,
Sam Lester (MSFT)|||

I'm getting the same thing when installing SQL Server 2005 Express (with advanced tools) on my Windows XP Pro setup. Recently installed Visual Studio 2005, but not the MSDE because was not recommended.

Is there a solution to this?

|||This article is the first hit on google when searching for a resolution to the com plus catalog requirement message. And it's also the most useless.

I was seeing this error message and this article fixed it for me;

http://msdn2.microsoft.com/en-us/library/ms143690.aspx
|||

i found the Sulosion its 100% Working The Msdb is on and he block the Com+ ports.

http://msdn2.microsoft.com/en-us/library/ms143698.aspx

get it.

Have a nice day and good luck

COM Plus Catalog Requirement (Warning) When installing MS SQL SERVER 2005 ENTERPRISE ON WINDOWS

COM Plus Catalog Requirement (Warning)

Messages

COM Plus Catalog Requirement

If SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the files and then rerun Setup. For more information, see How to: Work Around COM+ Check Failure in SQL Server Setup.

Are you hitting this warning? Is it preventing you from installing?

Thanks,
Sam Lester (MSFT)|||

I'm getting the same thing when installing SQL Server 2005 Express (with advanced tools) on my Windows XP Pro setup. Recently installed Visual Studio 2005, but not the MSDE because was not recommended.

Is there a solution to this?

|||This article is the first hit on google when searching for a resolution to the com plus catalog requirement message. And it's also the most useless.

I was seeing this error message and this article fixed it for me;

http://msdn2.microsoft.com/en-us/library/ms143690.aspx|||

i found the Sulosion its 100% Working The Msdb is on and he block the Com+ ports.

http://msdn2.microsoft.com/en-us/library/ms143698.aspx

get it.

Have a nice day and good luck

Collation setup for SQLServer2000 Standard Edition

After installing sp1 on my Windows 2003 Server I was able to install SQLServer2000, but, during installation I couldn't set up collation options for SQLServer.

I heve seen many screenshots where they say after asked for instance name I should be asked for collation setup options but I can't see them.

I don't know what should I do because my ERP needs to have the SQL_Latin1_General_CP1_C1_AS setup. Can I change this after initial installation?

Thanks in advance...

Quote:

Originally Posted by Marisol

After installing sp1 on my Windows 2003 Server I was able to install SQLServer2000, but, during installation I couldn't set up collation options for SQLServer.

I heve seen many screenshots where they say after asked for instance name I should be asked for collation setup options but I can't see them.

I don't know what should I do because my ERP needs to have the SQL_Latin1_General_CP1_C1_AS setup. Can I change this after initial installation?

Thanks in advance...

If you want to change the Server Collation, please start the installation in below manner (replacing desired Collation name). All The Best !!!

start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=test SQLCOLLATION=Latin1_General_CI_AI

collation question

Hello
We used MSSQL 2000 ENG - enterprise edition on a Windows 2K SP3 server ENG.
What are differences between SQL_Latin1_General_CP1_CI_AS collation
and Latin1_General_CI_AS collation ?
If I compare with COLLATIONPROPERTY function, results are equals.
Is it possible to install an instance with SQL_Latin1_General_CP1_CI_AS
collation ?
How to dow ?
Thanks.
Alain
> What are differences between SQL_Latin1_General_CP1_CI_AS collation
> and Latin1_General_CI_AS collation ?
They compare non-Unicode (varchar/char) data using different rules. The
Windows collation (Latin1_General_CI_AS) converts all non-Unicode data to
Unicode and then uses the same Unicode string comparison rules that it
uses for Unicode data. The benefit is that consistent rules are used for
both Unicode and non-Unicode string comparisons. The SQL collation
(SQL_Latin1_General_CP1_CI_AS) uses legacy SQL "sort order" rules to
compare non-Unicode data, and a different set of sorting rules for
Unicode data (the same Latin1_General rules that are used by
Latin1_General_CI_AS). The benefit of this is backwards compatibility
with older applications that may rely on the legacy SQL sort order for
non-Unicode data.

> Is it possible to install an instance with
SQL_Latin1_General_CP1_CI_AS
> collation ?
Yes. Do an advanced setup, and on the collation selection dialog click
the "SQL collations" radio button at the bottom of the form, then select
"Dictionary order, case insensitive for use with code page 1252". For
an existing instance, run REBUILDM.EXE and select the same.
Bart
Bart Duncan
Microsoft SQL Server Support
Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no
rights.
Thread-Topic: collation question
thread-index: AcUv7xA8D1swDrfPQriTPAu9nhc9mQ==
X-WBNR-Posting-Host: 213.56.154.227
From: "=?Utf-8?B?QS5HLg==?=" <AG@.discussions.microsoft.com>
Subject: collation question
Date: Wed, 23 Mar 2005 13:27:06 -0800
Lines: 17
Message-ID: <435980C5-2967-4A89-87E0-E3C6DE18F81F@.microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.sqlserver.server
Path: TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.server:383050
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
X-Tomcat-NG: microsoft.public.sqlserver.server
Hello
We used MSSQL 2000 ENG - enterprise edition on a Windows 2K SP3 server
ENG.
What are differences between SQL_Latin1_General_CP1_CI_AS collation
and Latin1_General_CI_AS collation ?
If I compare with COLLATIONPROPERTY function, results are equals.
Is it possible to install an instance with SQL_Latin1_General_CP1_CI_AS
collation ?
How to dow ?
Thanks.
Alain

collation question

Hello
We used MSSQL 2000 ENG - enterprise edition on a Windows 2K SP3 server ENG.
What are differences between SQL_Latin1_General_CP1_CI_AS collation
and Latin1_General_CI_AS collation ?
If I compare with COLLATIONPROPERTY function, results are equals.
Is it possible to install an instance with SQL_Latin1_General_CP1_CI_AS
collation ?
How to dow ?
Thanks.
Alain> What are differences between SQL_Latin1_General_CP1_CI_AS collation
> and Latin1_General_CI_AS collation ?
They compare non-Unicode (varchar/char) data using different rules. The
Windows collation (Latin1_General_CI_AS) converts all non-Unicode data to
Unicode and then uses the same Unicode string comparison rules that it
uses for Unicode data. The benefit is that consistent rules are used for
both Unicode and non-Unicode string comparisons. The SQL collation
(SQL_Latin1_General_CP1_CI_AS) uses legacy SQL "sort order" rules to
compare non-Unicode data, and a different set of sorting rules for
Unicode data (the same Latin1_General rules that are used by
Latin1_General_CI_AS). The benefit of this is backwards compatibility
with older applications that may rely on the legacy SQL sort order for
non-Unicode data.
> Is it possible to install an instance with
SQL_Latin1_General_CP1_CI_AS
> collation ?
Yes. Do an advanced setup, and on the collation selection dialog click
the "SQL collations" radio button at the bottom of the form, then select
"Dictionary order, case insensitive for use with code page 1252". For
an existing instance, run REBUILDM.EXE and select the same.
Bart
--
Bart Duncan
Microsoft SQL Server Support
Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no
rights.
Thread-Topic: collation question
thread-index: AcUv7xA8D1swDrfPQriTPAu9nhc9mQ==X-WBNR-Posting-Host: 213.56.154.227
From: "=?Utf-8?B?QS5HLg==?=" <AG@.discussions.microsoft.com>
Subject: collation question
Date: Wed, 23 Mar 2005 13:27:06 -0800
Lines: 17
Message-ID: <435980C5-2967-4A89-87E0-E3C6DE18F81F@.microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.sqlserver.server
Path: TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.server:383050
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
X-Tomcat-NG: microsoft.public.sqlserver.server
Hello
We used MSSQL 2000 ENG - enterprise edition on a Windows 2K SP3 server
ENG.
What are differences between SQL_Latin1_General_CP1_CI_AS collation
and Latin1_General_CI_AS collation ?
If I compare with COLLATIONPROPERTY function, results are equals.
Is it possible to install an instance with SQL_Latin1_General_CP1_CI_AS
collation ?
How to dow ?
Thanks.
Alain

collation question

Hello
We used MSSQL 2000 ENG - enterprise edition on a Windows 2K SP3 server ENG.
What are differences between SQL_Latin1_General_CP1_CI_AS collation
and Latin1_General_CI_AS collation ?
If I compare with COLLATIONPROPERTY function, results are equals.
Is it possible to install an instance with SQL_Latin1_General_CP1_CI_AS
collation ?
How to dow ?
Thanks.
Alain> What are differences between SQL_Latin1_General_CP1_CI_AS collation
> and Latin1_General_CI_AS collation ?
They compare non-Unicode (varchar/char) data using different rules. The
Windows collation (Latin1_General_CI_AS) converts all non-Unicode data to
Unicode and then uses the same Unicode string comparison rules that it
uses for Unicode data. The benefit is that consistent rules are used for
both Unicode and non-Unicode string comparisons. The SQL collation
(SQL_Latin1_General_CP1_CI_AS) uses legacy SQL "sort order" rules to
compare non-Unicode data, and a different set of sorting rules for
Unicode data (the same Latin1_General rules that are used by
Latin1_General_CI_AS). The benefit of this is backwards compatibility
with older applications that may rely on the legacy SQL sort order for
non-Unicode data.

> Is it possible to install an instance with
SQL_Latin1_General_CP1_CI_ASeen">
> collation ?
Yes. Do an advanced setup, and on the collation selection dialog click
the "SQL collations" radio button at the bottom of the form, then select
"Dictionary order, case insensitive for use with code page 1252". For
an existing instance, run REBUILDM.EXE and select the same.
Bart
--
Bart Duncan
Microsoft SQL Server Support
Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no
rights.
Thread-Topic: collation question
thread-index: AcUv7xA8D1swDrfPQriTPAu9nhc9mQ==
X-WBNR-Posting-Host: 213.56.154.227
From: "examnotes" <AG@.discussions.microsoft.com>
Subject: collation question
Date: Wed, 23 Mar 2005 13:27:06 -0800
Lines: 17
Message-ID: <435980C5-2967-4A89-87E0-E3C6DE18F81F@.microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.sqlserver.server
Path: TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.server:383050
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
X-Tomcat-NG: microsoft.public.sqlserver.server
Hello
We used MSSQL 2000 ENG - enterprise edition on a Windows 2K SP3 server
ENG.
What are differences between SQL_Latin1_General_CP1_CI_AS collation
and Latin1_General_CI_AS collation ?
If I compare with COLLATIONPROPERTY function, results are equals.
Is it possible to install an instance with SQL_Latin1_General_CP1_CI_AS
collation ?
How to dow ?
Thanks.
Alain