Problem with unpup operation & sql server rights
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
Problem with unpup operation & sql server rights

 
Post new topic   Reply to topic    Windows Server Forum Index -> Commerce Server
Author Message
Guest






Posted: Thu Sep 29, 2005 4:51 pm    Post subject: Problem with unpup operation & sql server rights Reply with quote

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 Reply with quote

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 Reply with quote

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
 
Post new topic   Reply to topic    Windows Server Forum Index -> Commerce Server All times are GMT
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB