| Author |
Message |
Guest
|
Posted:
Thu Sep 29, 2005 4:51 pm Post subject:
Problem with unpup operation & sql server rights |
|
|
Hi,
We have a Commerce Server 2002 SP3 application to deploy on a
production server (Windows 2000 Adv Server).
We are facing huge problems when we unpup it, mostly due to database
access rights issues, according to the error messages.
As it is a very strict environement, we cannot use SA account when
"unpupping".
Can this work despite this limitation ?
Which set of database rights is necessary to create a new CS site with
all necessary resources (Catalogs etc) ?
For the record, the pup has been created on a Developper Edition of CS
2002, and is deployed on an Enterprise Edition. (I assume this is not a
problem)
Thanks a lot,
AMS |
|
| Back to top |
|
 |
Vinayak Tadas[MSFT]
Guest
|
Posted:
Fri Sep 30, 2005 12:50 am Post subject:
RE: Problem with unpup operation & sql server rights |
|
|
What is the error you are seeing
The account you are using needs permissions to create databases .
May be that is missing from your counfiguration
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
--------------------
From: ams8764@netscape.net
Newsgroups: microsoft.public.commerceserver.general
Subject: Problem with unpup operation & sql server rights
Date: 29 Sep 2005 09:44:47 -0700
Organization: http://groups.google.com
Lines: 24
Message-ID: <1128012287.078689.155940@g14g2000cwa.googlegroups.com>
NNTP-Posting-Host: 62.23.237.17
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1128012292 25798 127.0.0.1 (29 Sep 2005
16:44:52 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 29 Sep 2005 16:44:52 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;
NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=62.23.237.17;
posting-account=PZ8s3Q0AAAAmg38VabALoICeANiC6nY1
Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!ne
wsfeed1.ip.tiscali.net!news.glorb.com!postnews.google.com!g14g2000cwa.google
groups.com!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3605
X-Tomcat-NG: microsoft.public.commerceserver.general
Hi,
We have a Commerce Server 2002 SP3 application to deploy on a
production server (Windows 2000 Adv Server).
We are facing huge problems when we unpup it, mostly due to database
access rights issues, according to the error messages.
As it is a very strict environement, we cannot use SA account when
"unpupping".
Can this work despite this limitation ?
Which set of database rights is necessary to create a new CS site with
all necessary resources (Catalogs etc) ?
For the record, the pup has been created on a Developper Edition of CS
2002, and is deployed on an Enterprise Edition. (I assume this is not a
problem)
Thanks a lot,
AMS |
|
| Back to top |
|
 |
Guest
|
Posted:
Fri Sep 30, 2005 8:51 am Post subject:
Re: Problem with unpup operation & sql server rights |
|
|
The error is related to the creation of the MSCS_CatalogScratch
database.
My user does not have database creation rights, so this is likely to be
the issue. |
|
| Back to top |
|
 |
|
|
|
|