Windows Server

cgruber · Guest

Hey everyone
Getting a jumpstart on the datawarehouse, I'm getting an error whe
I run the import task

DTSStep_CS_DTSPostImp.DTSPostImport step

Step Error Source: Dat
Step Error Description:Login failed for user 'sa'.;4200
Step Error code: 8004007
Step Error Help File
Step Error Help Context ID:100044

sa is our SystemAdmin user, but SQLServerAgent is set to use Window
Authentication

Any ideas why this is happening

Thanks
Chri

Brian Blum [MSFT] · Guest

Use the Commerce Server Manager to check the connection strings for the SQL
server and the Analysis server.
--------------------
NNTP-Posting-Date: Mon, 26 Sep 2005 19:43:02 -0500
Subject: Datawarehouse Import Problems
From: cgruber@bgnet.bgsu-dot-edu.no-spam.invalid (cgruber)
Newsgroups: microsoft.public.commerceserver.general
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 8bit
User-Agent: newsSync (Commerce Server) 7230
Message-ID: <l7-dnZCLBrQLCKXeRVn_vQ@giganews.com>
Date: Mon, 26 Sep 2005 19:43:02 -0500
Lines: 1
X-Trace:
sv3-Ym2xnYtFLgPHFPI8GMOeBEPESt7o9Yef+pbVEtbVBQxUjhU0i703kUjXzpTodf3oC0ad8PdB
jOaGzgM!NBJbtbIUekTB2MYvMtSiaSbnJ5UDjvCC+GTeReqwzv57ty8y2OFyYbr3C+1K
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
complaint properly
X-Postfilter: 1.3.32
Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.gigan
ews.com!local01.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3559
X-Tomcat-NG: microsoft.public.commerceserver.general

Hey everyone,
Getting a jumpstart on the datawarehouse, I'm getting an error when
I run the import task.

DTSStep_CS_DTSPostImp.DTSPostImport step:

Step Error Source: Date
Step Error Description:Login failed for user 'sa'.;42000
Step Error code: 80040076
Step Error Help File:
Step Error Help Context ID:1000440

sa is our SystemAdmin user, but SQLServerAgent is set to use Windows
Authentication.

Any ideas why this is happening?

Thanks!
Chris

This posting is provided "AS IS" with no warranties, and confers no rights.

EBusiness Server Team

cgruber · Guest

Thanks Brian! That seemed to work

But it is still failing on the same step, but now I don't get an
error message

I'm starting to think whoever setup this datawarehouse stuff did no
do it correctly. Is there a way to reinstall just the datawarehous
piece without overwriting all of our other work

Thanks
Chri

Brian Blum [MSFT] · Guest

Using the Commerce Server Manager:

1. Under Commerce Sites, remove the Site Data Warehouse resource for your
site.
2. Under Global Resources Remove the Global Data Warehouse resource.
3. On the Commerce Sites node, right click and choose 'New'/''Unpack
Site'. Choose the pup package that contains the DW (the name depends on
which version you're running. It might be Retail, or CSharpSite). Choose
the 'Custom Unpack' option and then choose 'Add a resource to an existing
site'. Click through the rest of the menus and supply values for server
and db names where appropriate.

Using the SQL Server Enterprise Manager

1. Run the configuration Sync DTS task and the DW data population tasks
for your site.

Good luck.

--------------------
NNTP-Posting-Date: Thu, 29 Sep 2005 19:43:02 -0500
Subject: re:Datawarehouse Import Problems
From: cgruber@bgnet.bgsu-dot-edu.no-spam.invalid (cgruber)
Newsgroups: microsoft.public.commerceserver.general
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 8bit
User-Agent: newsSync (Commerce Server) 7302
References: <l7-dnZCLBrQLCKXeRVn_vQ@giganews.com>
Message-ID: <MsednXb6O62LF6HeRVn_vQ@giganews.com>
Date: Thu, 29 Sep 2005 19:43:02 -0500
Lines: 1
X-Trace:
sv3-lgXVAt+mFDocMqZzMN6hLF2RUl7mX5Snl4bm3TFD0BB0T3Cj4YnN6Uwtm5CX3H0VATmfRdqg
u2qsL6V!B/7SqCEeLjrKwUsP6CDufs77cJ5OjOPrfki8SIVOBWjddsa8C4QbhSuxXZY2
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
complaint properly
X-Postfilter: 1.3.32
Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.gigan
ews.com!local01.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3611
X-Tomcat-NG: microsoft.public.commerceserver.general

Thanks Brian! That seemed to work.

But it is still failing on the same step, but now I don't get any
error message.

I'm starting to think whoever setup this datawarehouse stuff did not
do it correctly. Is there a way to reinstall just the datawarehouse
piece without overwriting all of our other work?

Thanks,
Chris

This posting is provided "AS IS" with no warranties, and confers no rights.

EBusiness Server Team

	Windows Server Forum Index -> Commerce Server	All times are GMT
Page 1 of 1