RE: Problems executing DTS package
- From: bagman3rd <bagman3rd@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 8 Sep 2005 15:38:22 -0700
I figured it out. I had a local user in my database that I inherited that
was not a global user SQL Server. I deleted the local user and now am
waiting for 4 gigs to copy over.
Thanks.
Archer
"bagman3rd" wrote:
> , locally and remotely for both servers. I have rebooted and come back to
> this problem a few days later. I have tried used SQL and NT registration, but
> I cannot get the package to execute. The error message that I get states:
>
> "[Microsoft][ODBC SQL Server Driver][SQL Server]The login 'HGAC' does not
> exist"
>
> But, I dont, nor have a ever had a HGAC login on either server. And, I am
> logging in as 'sa' or with windows authentification as myself(no I am not
> HGAC) with full admin privileges.
>
> When I run a trace with the profiler, everything seems to be cranking away,
> creating tables, then it hits "Audit logout" and stops. The timestamp on the
> audit logout precedes the timstamp of the tables that were and did get
> created by about 1 minute.
>
> Why does SQL Server think that I am trying to login as 'HGAC'?
>
> Thanks for any help.
>
> Archer
.
- References:
- Problems executing DTS package
- From: bagman3rd
- Problems executing DTS package
- Prev by Date: Re: How do I create a GUID value from ActiveX control?
- Next by Date: Decimal Values in Fixed Format Text Files
- Previous by thread: Problems executing DTS package
- Next by thread: ftp task transfer error
- Index(es):
Relevant Pages
|
