I have several machines on which we have installed Windows
2003 Server,SQL 200 and Commerce Server 2002.
When you do a quick unpack of the retail.pup file, using
SQL authentication as the means to access the database.
This works well and the site can be viewed in the browser.
However, you are only able to do one quick unpack and must
therefore use custom to do any further unpacking of
additional sites. When you unpack a new site using this
method and go basically with the defaults, when you try to
view the site in the browser you get an error message
saying that there is an ADODB connection error.
Please could any sugest a way to resolve this problem.
Microsoft Knowledge base Article 326554 refers to the
error but does not resolve the problem. I really need a
bog standard solution to this one.
regards
Peter

[ Post a follow-up to this message ]

Hi Peter,

Are you using an ASP .Net sample site or an ASP site?
Are you using SQL authentication between CS and SQL, or is it using Windows
Auth? This is chosen when you unpack a site. During unpack you are prompted
with a page that shows all the resources that are going to be unpacked and
at this point you can modify the connection strings for the resources. By
default it will use Windows Auth, unless you change it. It can also be
changed after unpack using the CS manager, this would need to be done on
each resource.

Also when you install CS you setup the initial connection string to the
MSCS_Admin DB. This can be changed afterwards by using the CS manager, the
root node would need can be changed (Commerce Server Manager).

Note: in a production environment it is recommended to use Windows
authentication between CS and SQL. In development it may be easier to use
SQL Auth.

More info:

If its .ASP -

Have you enabled the Set Application("MSCSEnv") = DEVELOPMENT flag in
global.asa so you can get better error messages?
If you are using Windows authentication between CS and SQL:
1. if IIS anonymous access is switched on then it will be default try
and use the IUSR_ComputerName account to talk to the SQL DB's, therefore it
could be failing because this user doesn't have permissions on the database.
2. if IIS anonymous is not enabled, then you probably find it is using
the current windows user account to talk to the SQL DB's, therefore it could
be failing because this user doesn't have permissions on the database.

If you are using SQL authentication between CS and SQL:
1. The SQL account used in the connection string will always be used to
talk to the DB, therefore it could be failing because this user doesn't have
permissions on the database.

If its ASP .Net -

If you are using Windows authentication between CS and SQL:
1. if IIS anonymous access is switched on then it will be default try
and use the ASPNet account to talk to the SQL DB's, therefore it could be
failing because this user doesn't have permissions on the database.
2. if IIS anonymous is not enabled, then you probably find it is using
the current windows user account to talk to the SQL DB's, therefore it could
be failing because this user doesn't have permissions on the database.

If you are using SQL authentication between CS and SQL:
1. The SQL account used in the connection string will always be used to
talk to the DB, therefore it could be failing because this user doesn't have
permissions on the database.

This is all documented in the installation notes of CS and the CS docs.

Hope this helps,
Michael

--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Peter" <peter.mills@plymouth.ac.uk> wrote in message
news:25ba01c3fc6e$a9f936f0$a101280a@phx.gbl...
> I have several machines on which we have installed Windows
> 2003 Server,SQL 200 and Commerce Server 2002.
> When you do a quick unpack of the retail.pup file, using
> SQL authentication as the means to access the database.
> This works well and the site can be viewed in the browser.
> However, you are only able to do one quick unpack and must
> therefore use custom to do any further unpacking of
> additional sites. When you unpack a new site using this
> method and go basically with the defaults, when you try to
> view the site in the browser you get an error message
> saying that there is an ADODB connection error.
> Please could any sugest a way to resolve this problem.
> Microsoft Knowledge base Article 326554 refers to the
> error but does not resolve the problem. I really need a
> bog standard solution to this one.
> regards
> Peter

[ Post a follow-up to this message ]

Michael,
Thanks for your reply.
I am using ASP pages and when I installed SQL & Commerce
server I opted to go with SQL authentication on both.
When you install the retail.pup file using the quick
unpack method you are asked which authentication you wish
to use, I again here selected SQL.
However, when you do the custom unpack there was no option
to select either sql or windows.
I have since installed server, sql and commerce on a brand
new clean machine in case something else was interfering
with the setup but I am still getting the same ADoDB error
message after i unpack the second site.
I am new to this and don't rely understand much about
commerce server, so any help would be gratefully received.
Peter

>-----Original Message-----
>Hi Peter,
>
>Are you using an ASP .Net sample site or an ASP site?
>Are you using SQL authentication between CS and SQL, or
is it using Windows
>Auth? This is chosen when you unpack a site. During
unpack you are prompted
>with a page that shows all the resources that are going
to be unpacked and
>at this point you can modify the connection strings for
the resources. By
>default it will use Windows Auth, unless you change it.
It can also be
>changed after unpack using the CS manager, this would
need to be done on
>each resource.
>
>Also when you install CS you setup the initial connection
string to the
>MSCS_Admin DB. This can be changed afterwards by using
the CS manager, the
>root node would need can be changed (Commerce Server
Manager).
>
>Note: in a production environment it is recommended to
use Windows
>authentication between CS and SQL. In development it may
be easier to use
>SQL Auth.
>
>More info:
>
>If its .ASP -
>
>Have you enabled the Set Application("MSCSEnv") =
DEVELOPMENT flag in
>global.asa so you can get better error messages?
>If you are using Windows authentication between CS and
SQL:
>    1. if IIS anonymous access is switched on then it
will be default try
>and use the IUSR_ComputerName account to talk to the SQL
DB's, therefore it
>could be failing because this user doesn't have
permissions on the database.
>    2. if IIS anonymous is not enabled, then you probably
find it is using
>the current windows user account to talk to the SQL DB's,
therefore it could
>be failing because this user doesn't have permissions on
the database.
>
>If you are using SQL authentication between CS and SQL:
>    1. The SQL account used in the connection string will
always be used to
>talk to the DB, therefore it could be failing because
this user doesn't have
>permissions on the database.
>
>If its ASP .Net -
>
>If you are using Windows authentication between CS and
SQL:
>    1. if IIS anonymous access is switched on then it
will be default try
>and use the ASPNet account to talk to the SQL DB's,
therefore it could be
>failing because this user doesn't have permissions on the
database.
>    2. if IIS anonymous is not enabled, then you probably
find it is using
>the current windows user account to talk to the SQL DB's,
therefore it could
>be failing because this user doesn't have permissions on
the database.
>
>If you are using SQL authentication between CS and SQL:
>    1. The SQL account used in the connection string will
always be used to
>talk to the DB, therefore it could be failing because
this user doesn't have
>permissions on the database.
>
>This is all documented in the installation notes of CS
and the CS docs.
>
>Hope this helps,
>Michael
>
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"Peter" <peter.mills@plymouth.ac.uk> wrote in message
>news:25ba01c3fc6e$a9f936f0$a101280a@phx.gbl... 
Windows 
browser. 
must 
to 
>
>
>.
>

[ Post a follow-up to this message ]

Hi Peter,

As I said in my previous message. "During unpack you are prompted with a
page that shows all the resources that are going to be unpacked and at this
point you can modify the connection strings for the resources." You will see
a modify button in the bottom left hand corner of the window.

Hope this helps,
Michael

--
This posting is provided "AS IS" with no warranties, and confers no rights.
<anonymous@discussions.microsoft.com> wrote in message
news:344601c3fd48$b7a348b0$a301280a@phx.gbl...
> Michael,
> Thanks for your reply.
> I am using ASP pages and when I installed SQL & Commerce
> server I opted to go with SQL authentication on both.
> When you install the retail.pup file using the quick
> unpack method you are asked which authentication you wish
> to use, I again here selected SQL.
> However, when you do the custom unpack there was no option
> to select either sql or windows.
> I have since installed server, sql and commerce on a brand
> new clean machine in case something else was interfering
> with the setup but I am still getting the same ADoDB error
> message after i unpack the second site.
> I am new to this and don't rely understand much about
> commerce server, so any help would be gratefully received.
> Peter
> 
> is it using Windows 
> unpack you are prompted 
> to be unpacked and 
> the resources. By 
> It can also be 
> need to be done on 
> string to the 
> the CS manager, the 
> Manager). 
> use Windows 
> be easier to use 
> DEVELOPMENT flag in 
> SQL: 
> will be default try 
> DB's, therefore it 
> permissions on the database. 
> find it is using 
> therefore it could 
> the database. 
> always be used to 
> this user doesn't have 
> SQL: 
> will be default try 
> therefore it could be 
> database. 
> find it is using 
> therefore it could 
> the database. 
> always be used to 
> this user doesn't have 
> and the CS docs. 
> confers no rights. 
> Windows 
> browser. 
> must 
> to 

[ Post a follow-up to this message ]

Hi, as Michael mentioned, during custom Unpack, at the "select databases"
screen, you can select each (or all) databases and click Modify to change
the connection strings.  You can change them to use Sql Authentication at
that point.  Note that we do strongly recommend Windows Authentication for
stronger security, though this is more work to configure (see Secure
Deployment Guide documentation).

Also, if you really want to overwrite the site, consider using Commerce
Manager MMC tool to delete the site and any unused Global Resources for the
site.  This will not remove the databases, but you can do so manually if
you choose.  Perhaps this will be an easier solution for you.

HTH
-djm
--
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2004 Microsoft Corporation.  All rights
reserved.
--------------------
Content-Class: urn:content-classes:message
From: <anonymous@discussions.microsoft.com>
Sender: <anonymous@discussions.microsoft.com>
References: <25ba01c3fc6e$a9f936f0$a101280a@phx.gbl>
<O9UpgxQ$DHA.3536@tk2msftngp13.phx.gbl>
Subject: Re: Login problems after doing a custom unpack
Date: Fri, 27 Feb 2004 07:45:25 -0800
Lines: 137
Message-ID: <344601c3fd48$b7a348b0$a301280a@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcP9SLejkMVzk0AGTw2wcyY/gK7zfQ==
Newsgroups: microsoft.public.commerceserver.general
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.commerceserver.general:13274
NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
X-Tomcat-NG: microsoft.public.commerceserver.general

Michael,
Thanks for your reply.
I am using ASP pages and when I installed SQL & Commerce
server I opted to go with SQL authentication on both.
When you install the retail.pup file using the quick
unpack method you are asked which authentication you wish
to use, I again here selected SQL.
However, when you do the custom unpack there was no option
to select either sql or windows.
I have since installed server, sql and commerce on a brand
new clean machine in case something else was interfering
with the setup but I am still getting the same ADoDB error
message after i unpack the second site.
I am new to this and don't rely understand much about
commerce server, so any help would be gratefully received.
Peter

>-----Original Message-----
>Hi Peter,
>
>Are you using an ASP .Net sample site or an ASP site?
>Are you using SQL authentication between CS and SQL, or
is it using Windows
>Auth? This is chosen when you unpack a site. During
unpack you are prompted
>with a page that shows all the resources that are going
to be unpacked and
>at this point you can modify the connection strings for
the resources. By
>default it will use Windows Auth, unless you change it.
It can also be
>changed after unpack using the CS manager, this would
need to be done on
>each resource.
>
>Also when you install CS you setup the initial connection
string to the
>MSCS_Admin DB. This can be changed afterwards by using
the CS manager, the
>root node would need can be changed (Commerce Server
Manager).
>
>Note: in a production environment it is recommended to
use Windows
>authentication between CS and SQL. In development it may
be easier to use
>SQL Auth.
>
>More info:
>
>If its .ASP -
>
>Have you enabled the Set Application("MSCSEnv") =
DEVELOPMENT flag in
>global.asa so you can get better error messages?
>If you are using Windows authentication between CS and
SQL:
>    1. if IIS anonymous access is switched on then it
will be default try
>and use the IUSR_ComputerName account to talk to the SQL
DB's, therefore it
>could be failing because this user doesn't have
permissions on the database.
>    2. if IIS anonymous is not enabled, then you probably
find it is using
>the current windows user account to talk to the SQL DB's,
therefore it could
>be failing because this user doesn't have permissions on
the database.
>
>If you are using SQL authentication between CS and SQL:
>    1. The SQL account used in the connection string will
always be used to
>talk to the DB, therefore it could be failing because
this user doesn't have
>permissions on the database.
>
>If its ASP .Net -
>
>If you are using Windows authentication between CS and
SQL:
>    1. if IIS anonymous access is switched on then it
will be default try
>and use the ASPNet account to talk to the SQL DB's,
therefore it could be
>failing because this user doesn't have permissions on the
database.
>    2. if IIS anonymous is not enabled, then you probably
find it is using
>the current windows user account to talk to the SQL DB's,
therefore it could
>be failing because this user doesn't have permissions on
the database.
>
>If you are using SQL authentication between CS and SQL:
>    1. The SQL account used in the connection string will
always be used to
>talk to the DB, therefore it could be failing because
this user doesn't have
>permissions on the database.
>
>This is all documented in the installation notes of CS
and the CS docs.
>
>Hope this helps,
>Michael
>
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"Peter" <peter.mills@plymouth.ac.uk> wrote in message
>news:25ba01c3fc6e$a9f936f0$a101280a@phx.gbl... 
Windows 
browser. 
must 
to 
>
>
>.
>

[ Post a follow-up to this message ]

Guys, Thanks for the advice, I have unpacked another site=20
completly and have choosen and modify the connection=20
string to use SQL. Also when the site was unoacked=20
completely I used Commerce Server Manager to check the=20
site and also the global resources etc. Still the site=20
refuses to work. I have also checked the site in IIS and=20
even here it looks fine.
Am I perhaps missing something else??
Where do I find or run Commerce Manager MMC tool?
Regards
Peter

>-----Original Message-----
>Hi, as Michael mentioned, during custom Unpack, at=20
the "select databases"=20
>screen, you can select each (or all) databases and click=20
Modify to change=20
>the connection strings.  You can change them to use Sql=20
Authentication at=20
>that point.  Note that we do strongly recommend Windows=20
Authentication for=20
>stronger security, though this is more work to configure=20
(see Secure=20
>Deployment Guide documentation).
>
>Also, if you really want to overwrite the site, consider=20
using Commerce=20
>Manager MMC tool to delete the site and any unused Global=20
Resources for the=20
>site.  This will not remove the databases, but you can do=20
so manually if=20
>you choose.  Perhaps this will be an easier solution for=20
you.
>
>HTH
>-djm
>--=20
>This posting is provided "AS IS" with no warranties, and=20
confers no rights.
>You assume all risk for your use. =A9 2004 Microsoft=20
Corporation.  All rights
>reserved.
>--------------------
>Content-Class: urn:content-classes:message
>From: <anonymous@discussions.microsoft.com>
>Sender: <anonymous@discussions.microsoft.com>
>References: <25ba01c3fc6e$a9f936f0$a101280a@phx.gbl>=20
><O9UpgxQ$DHA.3536@tk2msftngp13.phx.gbl>
>Subject: Re: Login problems after doing a custom unpack
>Date: Fri, 27 Feb 2004 07:45:25 -0800
>Lines: 137
>Message-ID: <344601c3fd48$b7a348b0$a301280a@phx.gbl>
>MIME-Version: 1.0
>Content-Type: text/plain;
>	charset=3D"iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcP9SLejkMVzk0AGTw2wcyY/gK7zfQ=3D=3D
>Newsgroups: microsoft.public.commerceserver.general
>Path: cpmsftngxa06.phx.gbl
>Xref: cpmsftngxa06.phx.gbl=20
microsoft.public.commerceserver.general:13274
>NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
>X-Tomcat-NG: microsoft.public.commerceserver.general
>
>Michael,
>Thanks for your reply.
>I am using ASP pages and when I installed SQL & Commerce=20
>server I opted to go with SQL authentication on both.
>When you install the retail.pup file using the quick=20
>unpack method you are asked which authentication you wish=20
>to use, I again here selected SQL.
>However, when you do the custom unpack there was no=20
option=20
>to select either sql or windows.
>I have since installed server, sql and commerce on a=20
brand=20
>new clean machine in case something else was interfering=20
>with the setup but I am still getting the same ADoDB=20
error=20
>message after i unpack the second site.
>I am new to this and don't rely understand much about=20
>commerce server, so any help would be gratefully received.
>Peter
> 
>is it using Windows 
>unpack you are prompted 
>to be unpacked and 
>the resources. By 
>It can also be 
>need to be done on 
connection=20
>string to the 
>the CS manager, the 
>Manager). 
>use Windows 
>be easier to use 
>DEVELOPMENT flag in 
>SQL: 
>will be default try 
>DB's, therefore it 
>permissions on the database. 
probably=20
>find it is using 
DB's,=20
>therefore it could 
>the database. 
will=20
>always be used to 
>this user doesn't have 
>SQL: 
>will be default try 
>therefore it could be 
the=20
>database. 
probably=20
>find it is using 
DB's,=20
>therefore it could 
>the database. 
will=20
>always be used to 
>this user doesn't have 
>and the CS docs. 
>confers no rights. 
>Windows 
using 
>browser. 
>must 
try=20
>to 
>

[ Post a follow-up to this message ]

I have just unpacked two site straight off and both work.
As you both pointed out I changed the authentication=20
string to SQl in the "select databases". But also I=20
changed the pointers in Global Resurces to point to the=20
first unpacked site. This includes the Data Warehouse, CS=20
Authentication & Profiles.
What I'm not sure of is whether it will conflict with=20
previously unpacked sites. ANY thoughts on this?

Peter
>-----Original Message-----
> Guys, Thanks for the advice, I have unpacked another=20
site=20
>completly and have choosen and modify the connection=20
>string to use SQL. Also when the site was unoacked=20
>completely I used Commerce Server Manager to check the=20
>site and also the global resources etc. Still the site=20
>refuses to work. I have also checked the site in IIS and=20
>even here it looks fine.
>Am I perhaps missing something else??
>Where do I find or run Commerce Manager MMC tool?
>Regards
>Peter
> 
>the "select databases"=20 
>Modify to change=20 
>Authentication at=20 
>Authentication for=20 
>(see Secure=20 
>using Commerce=20 
Global=20
>Resources for the=20 
do=20
>so manually if=20 
>you. 
>confers no rights. 
>Corporation.  All rights 
>microsoft.public.commerceserver.general:13274 
wish=20 
>option=20 
>brand=20 
>error=20 
received. 
>connection=20 
may=20 
SQL=20 
>probably=20 
>DB's,=20 
on=20 
>will=20 
>the=20 
>probably=20 
>DB's,=20 
on=20 
>will=20 
and=20 
>using 
database. 
this 
>try=20 
a 
>.
>

[ Post a follow-up to this message ]