DTS, SQL 7.0 and user=null error

#1

Hi,

Sorry to post the same kind of error as others may have
done, but I can design and run a DTS from the SQL
enteprise Manager GUI, but when I try to Schedule it or to
see the version, the error is the following:
SQL-DMo SQL State 42000, User (Null): not associated to a
trusted SQL connection.

I look for all security issues previously posted, but
seems to no work.
I am logged on the server with the domain admin when the
error happen.
If I try to do the same thing from a client with SQL 2000,
there is no problem, but the job scheduled will failed.

Last point, the dts package was created under the SQL 7.0
server directly. The error is the same for all packages.

Thank you for your help!

#2

Who is the Job Owner ? Is it an NT Account ? What happens if you use yours
? What happens if you use sa ? Sounds like their may be a problem
validating the account to the DC.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Xela" <ajidotnet (AT) hotmail (DOT) com> wrote

Quote:

Hi,

Sorry to post the same kind of error as others may have
done, but I can design and run a DTS from the SQL
enteprise Manager GUI, but when I try to Schedule it or to
see the version, the error is the following:
SQL-DMo SQL State 42000, User (Null): not associated to a
trusted SQL connection.

I look for all security issues previously posted, but
seems to no work.
I am logged on the server with the domain admin when the
error happen.
If I try to do the same thing from a client with SQL 2000,
there is no problem, but the job scheduled will failed.

Last point, the dts package was created under the SQL 7.0
server directly. The error is the same for all packages.

Thank you for your help!

#3

Thank you for your qucik answer.

I try both case for the job owner (the domain admin
account, the dts owner account, and the sa account).
All the accounts are members of the Sysadmin group.

What I do not understand, if even if I do not want to
create a job, but just check the version hisory of the dts
package, the error appear.

The server is memebr of an NT4.0 domain, and currently the
user logged on is the Domain admin. Is there any relation
with the SQLagencmdexec proxy account?

Quote:

-----Original Message-----
Who is the Job Owner ? Is it an NT Account ? What
happens if you use yours
? What happens if you use sa ? Sounds like their may be
a problem
validating the account to the DC.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

#4

Having the Agent account set to LocalSystem does cause problems if you want
to do anything not on the local box

http://support.microsoft.com/?kbid=269074

What account are you running the SQL Server service under.?

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Xela" <ajidotnet (AT) hotmail (DOT) com> wrote

Quote:

Just a complement.

I was able to run the job by modifying the SQLserveragent
service from local System account to a NT user account,
but the error which appear when right clicking on the
context menu of the dts package (version or schedule)
still do not work.

Last info, the security is of SQL is SQL server security
(not windows one) and the last SP applied is the SP3.

-----Original Message-----
Who is the Job Owner ? Is it an NT Account ? What
happens if you use yours
? What happens if you use sa ? Sounds like their may be
a problem
validating the account to the DC.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Xela" <ajidotnet (AT) hotmail (DOT) com> wrote in message
news:03ba01c3653a$ec9608b0$a501280a (AT) phx (DOT) gbl...
Hi,

Sorry to post the same kind of error as others may have
done, but I can design and run a DTS from the SQL
enteprise Manager GUI, but when I try to Schedule it or
to
see the version, the error is the following:
SQL-DMo SQL State 42000, User (Null): not associated to
a
trusted SQL connection.

I look for all security issues previously posted, but
seems to no work.
I am logged on the server with the domain admin when the
error happen.
If I try to do the same thing from a client with SQL
2000,
there is no problem, but the job scheduled will failed.

Last point, the dts package was created under the SQL
7.0
server directly. The error is the same for all packages.

Thank you for your help!

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS, SQL 7.0 and user=null error

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS, SQL 7.0 and user=null error - 08-17-2003 , 10:43 PM

Re: DTS, SQL 7.0 and user=null error - 08-18-2003 , 01:20 AM

Re: DTS, SQL 7.0 and user=null error - 08-18-2003 , 04:07 AM

Re: DTS, SQL 7.0 and user=null error - 08-18-2003 , 05:43 AM