I am getting the following error more frequently so I would appreciate
any help in tracking it down.  This happens sometimes when a user is
browsing through the products.  The exception message is:
"Microsoft.CommerceServer.Runtime.Catalog.CatalogException:
Category::Search() failed --->
System.Runtime.InteropServices.COMException (0x80040E14):
Source:Microsoft OLE DB Provider for SQL ServerDescription:Database
'MSCS_CatalogSratch' is already open and can only have one user at a
time."

Any ideas?


-Thanks,
Rich

[ Post a follow-up to this message ]

From the error message it seems that the single user database option is
turned on for the MSCS_Catalogscratch database.
You can change it using Sql Enter prise manager. Select the
MSCS_Catalogscratch database, right click Properties, Click Options tab and
uncheck the Restrict Access check box.



Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure!  For more info visit http://www.microsoft.com/security.  Please
reply to the newsgroups only.  Thanks

"Richard Lazar" <rich@richlazar.com> wrote in message
news:cde9f669.0407191011.15ca2db9@posting.google.com...
> I am getting the following error more frequently so I would appreciate
> any help in tracking it down.  This happens sometimes when a user is
> browsing through the products.  The exception message is:
> "Microsoft.CommerceServer.Runtime.Catalog.CatalogException:
> Category::Search() failed --->
> System.Runtime.InteropServices.COMException (0x80040E14):
> Source:Microsoft OLE DB Provider for SQL ServerDescription:Database
> 'MSCS_CatalogSratch' is already open and can only have one user at a
> time."
>
> Any ideas?
>
>
> -Thanks,
>    Rich

[ Post a follow-up to this message ]

The Restrict Access check box was already unchecked....any other suggestions
?


-Rich

"Vinayak Tadas[MSFT]" <vtadas@online.microsoft.com> wrote in message news:<uCOCn6bbEHA.7
16@TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
> From the error message it seems that the single user database option is
> turned on for the MSCS_Catalogscratch database.
> You can change it using Sql Enter prise manager. Select the
> MSCS_Catalogscratch database, right click Properties, Click Options tab an
d
> uncheck the Restrict Access check box.
>
>
>
> Thanks
> Vinayak Tadas
> Microsoft
> http://blogs.msdn.com/vinayakt
>
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> You assume all risk for your use. © 2002 Microsoft Corporation. All rights
> reserved.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> Get Secure!  For more info visit http://www.microsoft.com/security.  Pleas
e
> reply to the newsgroups only.  Thanks
>
> "Richard Lazar" <rich@richlazar.com> wrote in message
> news:cde9f669.0407191011.15ca2db9@posting.google.com... 

[ Post a follow-up to this message ]

Can you also check if the catalog database is also not in the single user
mode.

"Richard Lazar" <rich@richlazar.com> wrote in message
news:cde9f669.0407200433.7f401a3d@posting.google.com...
> The Restrict Access check box was already unchecked....any other
suggestions?
>
>
> -Rich
>
> "Vinayak Tadas[MSFT]" <vtadas@online.microsoft.com> wrote in message
news:<uCOCn6bbEHA.716@TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen] 
and[vbcol=seagreen] 
rights.[vbcol=seagreen] 
rights[vbcol=seagreen] 
Please[vbcol=seagreen] 

[ Post a follow-up to this message ]