|
Home > Archive > Commerce Server General > September 2005 > Datawarehouse Import Problems
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Datawarehouse Import Problems
|
|
| cgruber 2005-09-26, 8:48 pm |
| 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
| |
| Brian Blum [MSFT] 2005-09-28, 6:00 pm |
| 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+pbVEtbV
BQxUjhU0i703kUjXzpTodf3oC0ad8PdB
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 2005-09-29, 8:48 pm |
| 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
| |
| Brian Blum [MSFT] 2005-09-30, 5:53 pm |
| 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+mFDocMqZzMN6hLF2RUl7mX5Snl4bm3TFD
0BB0T3Cj4YnN6Uwtm5CX3H0VATmfRdqg
u2qsL6V!B/ 7SqCEeLjrKwUsP6CDufs77cJ5OjOPrfki8SIVOBW
jddsa8C4QbhSuxXZY2
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
|
|
|
|
|