Login failed for user '(null)' - Not associated with a trusted connection

We had a DTS package that was working fine until yesterday and since
today it does not work and we get the following error message:
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
'(null)'. Reason not associated with a trusted SQL Server connection.
Please clarify how do we fix this problem.
Thanks
KarenHi
Did you change Authentication mode of SQL Server?
<karenmiddleol@.yahoo.com> wrote in message
news:1118220803.108259.111330@.f14g2000cwb.googlegroups.com...
> We had a DTS package that was working fine until yesterday and since
> today it does not work and we get the following error message:
>
> [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
> '(null)'. Reason not associated with a trusted SQL Server connection.
>
> Please clarify how do we fix this problem.
> Thanks
> Karen
>

Login failed for user '(null)' - Not associated with a trusted connection

We had a DTS package that was working fine until yesterday and since
today it does not work and we get the following error message:
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
'(null)'. Reason not associated with a trusted SQL Server connection.
Please clarify how do we fix this problem.
Thanks
Karen
Hi
Did you change Authentication mode of SQL Server?
<karenmiddleol@.yahoo.com> wrote in message
news:1118220803.108259.111330@.f14g2000cwb.googlegr oups.com...
> We had a DTS package that was working fine until yesterday and since
> today it does not work and we get the following error message:
>
> [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
> '(null)'. Reason not associated with a trusted SQL Server connection.
>
> Please clarify how do we fix this problem.
> Thanks
> Karen
>
sql

Login failed for user '(null)' - Not associated with a trusted connection

We had a DTS package that was working fine until yesterday and since
today it does not work and we get the following error message:
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
'(null)'. Reason not associated with a trusted SQL Server connection.
Please clarify how do we fix this problem.
Thanks
KarenHi
Did you change Authentication mode of SQL Server?
<karenmiddleol@.yahoo.com> wrote in message
news:1118220803.108259.111330@.f14g2000cwb.googlegroups.com...
> We had a DTS package that was working fine until yesterday and since
> today it does not work and we get the following error message:
>
> [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
> '(null)'. Reason not associated with a trusted SQL Server connection.
>
> Please clarify how do we fix this problem.
> Thanks
> Karen
>|||Hey Karen!
Generally when you see the "login failed for user NULL" it's a kerberos issue.
I know that sounds far fetched, but it's true.
If you get "login failed for user BOB" that's a different story. But the
fact that we are passing a NULL value to SQL instead of a user token means
that Kerberos is failing.
Sometimes this is called a double hop scenario, but you can get that error
even when there is only a single hop.
Follow this article to resolve that error:
How to troubleshoot the "Cannot generate SSPI context" error message
This step-by-step article describes how to troubleshoot the most typical
sources of the "Cannot generate SSPI context" error message. You may receive
this error message under the following conditions: You are connecting to SQL
Server.You are using...
http://support.microsoft.com/default.aspx?scid=kb;en-us;811889
Basically you will be getting the utility setspn, dropping the old spn and
recreating a new SPN (rebooting might be necessary).
Donna Lambert
"karenmiddleol@.yahoo.com" wrote:
> We had a DTS package that was working fine until yesterday and since
> today it does not work and we get the following error message:
>
> [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
> '(null)'. Reason not associated with a trusted SQL Server connection.
>
> Please clarify how do we fix this problem.
> Thanks
> Karen
>|||You may also want to check that the account logging in hasn't been
locked out because of invalid password entries exceeding the limit set.
Usually this scenario takes place when you are forced to change your
password, but services are running using old passwords and try to login
multiple times. If the account is locked out because of this, you will
see this error message.
Simon Worth
Donna Lambert wrote:
> Hey Karen!
> Generally when you see the "login failed for user NULL" it's a kerberos issue.
> I know that sounds far fetched, but it's true.
> If you get "login failed for user BOB" that's a different story. But the
> fact that we are passing a NULL value to SQL instead of a user token means
> that Kerberos is failing.
> Sometimes this is called a double hop scenario, but you can get that error
> even when there is only a single hop.
> Follow this article to resolve that error:
> How to troubleshoot the "Cannot generate SSPI context" error message
> This step-by-step article describes how to troubleshoot the most typical
> sources of the "Cannot generate SSPI context" error message. You may receive
> this error message under the following conditions: You are connecting to SQL
> Server.You are using...
> http://support.microsoft.com/default.aspx?scid=kb;en-us;811889
> Basically you will be getting the utility setspn, dropping the old spn and
> recreating a new SPN (rebooting might be necessary).
> Donna Lambert
> "karenmiddleol@.yahoo.com" wrote:
>
>>We had a DTS package that was working fine until yesterday and since
>>today it does not work and we get the following error message:
>>
>>[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
>>'(null)'. Reason not associated with a trusted SQL Server connection.
>>
>>Please clarify how do we fix this problem.
>>Thanks
>>Karen
>>

Login failed for user '(null)' - Not associated with a trusted connection

We had a DTS package that was working fine until yesterday and since
today it does not work and we get the following error message:
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed fo
r user
'(null)'. Reason not associated with a trusted SQL Server connection.
Please clarify how do we fix this problem.
Thanks
KarenHi
Did you change Authentication mode of SQL Server?
<karenmiddleol@.yahoo.com> wrote in message
news:1118220803.108259.111330@.f14g2000cwb.googlegroups.com...
> We had a DTS package that was working fine until yesterday and since
> today it does not work and we get the following error message:
>
> [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed
for user
> '(null)'. Reason not associated with a trusted SQL Server connection.
>
> Please clarify how do we fix this problem.
> Thanks
> Karen
>

logging the volume of data loaded other the network?

Hi,
how can I know or log the volume loaded by my DTS packages?
I need to evaluate the traffic and the bandwidth required.
Does the profiler can provide enough info?
For the moment I work on a copy of the production database. so all is local
on my server.
Thanks for your help
Jerome.
A couple of places. In the package properties, enable package logging. This
will give you counts and times it took to execute various tasks within the
package.
Also in package properties, there is an option to provide an output file for
execution details. Then, also in the same set of dialogs, you can choose to
have the package to log in the servers event logs.
Hope this helps.
Sincerely,
Anthony Thomas
"Jéjé" wrote:

> Hi,
> how can I know or log the volume loaded by my DTS packages?
> I need to evaluate the traffic and the bandwidth required.
> Does the profiler can provide enough info?
> For the moment I work on a copy of the production database. so all is local
> on my server.
> Thanks for your help
> Jerome.
>
>
|||but does these option display the amount of data?
in Mb, not in rows!
"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
news:385122A2-440F-483D-B92D-60BCC3D05CE8@.microsoft.com...[vbcol=seagreen]
>A couple of places. In the package properties, enable package logging.
>This
> will give you counts and times it took to execute various tasks within the
> package.
> Also in package properties, there is an option to provide an output file
> for
> execution details. Then, also in the same set of dialogs, you can choose
> to
> have the package to log in the servers event logs.
> Hope this helps.
> Sincerely,
>
> Anthony Thomas
>
> "Jj" wrote:
|||Jj,
You might want to look into a network monitoring tool, there's nothing
built-in that does it.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Jj wrote:
> Hi,
> how can I know or log the volume loaded by my DTS packages?
> I need to evaluate the traffic and the bandwidth required.
> Does the profiler can provide enough info?
> For the moment I work on a copy of the production database. so all is local
> on my server.
> Thanks for your help
> Jerome.
>
|||but my actual problem is:
all is on 1 server!
so I can't monitor any network activity, because there is no network
activity for the moment.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:u3K1ojmxEHA.1296@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Jj,
> You might want to look into a network monitoring tool, there's nothing
> built-in that does it.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Jj wrote:
|||If you want to monitor network activity, bytes, etc you may
want to look at using a Network sniffer tool or PerfMon and
the Network Interface object.
-Sue
On Tue, 9 Nov 2004 09:20:12 -0500, "Jj"
<willgart_A_@.hotmail_A_.com> wrote:

>but does these option display the amount of data?
>in Mb, not in rows!
>"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
>news:385122A2-440F-483D-B92D-60BCC3D05CE8@.microsoft.com...
>
|||There are still the performance counters, server as well as SQL Server that
will give I/O transferred, pages manipulated, etc. Also, the Profiler tool,
which can focus on that application/database/user/etc., will record CPU time,
and Read I/O and Write I/O. Sorry, it is only in bytes but I think you can
do the conversion.
Moreover, you can automate the launch of background trace with the use of
the system stored procedures and have the output loaded to a SQL Server table.
Sincerely,
Anthony Thomas
"Jéjé" wrote:

> but my actual problem is:
> all is on 1 server!
> so I can't monitor any network activity, because there is no network
> activity for the moment.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:u3K1ojmxEHA.1296@.TK2MSFTNGP10.phx.gbl...
>

logging the volume of data loaded other the network?

Hi,
how can I know or log the volume loaded by my DTS packages?
I need to evaluate the traffic and the bandwidth required.
Does the profiler can provide enough info?
For the moment I work on a copy of the production database. so all is local
on my server.
Thanks for your help
Jerome.A couple of places. In the package properties, enable package logging. Thi
s
will give you counts and times it took to execute various tasks within the
package.
Also in package properties, there is an option to provide an output file for
execution details. Then, also in the same set of dialogs, you can choose to
have the package to log in the servers event logs.
Hope this helps.
Sincerely,
Anthony Thomas
"Jéjé" wrote:

> Hi,
> how can I know or log the volume loaded by my DTS packages?
> I need to evaluate the traffic and the bandwidth required.
> Does the profiler can provide enough info?
> For the moment I work on a copy of the production database. so all is loca
l
> on my server.
> Thanks for your help
> Jerome.
>
>|||but does these option display the amount of data?
in Mb, not in rows!
"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
news:385122A2-440F-483D-B92D-60BCC3D05CE8@.microsoft.com...[vbcol=seagreen]
>A couple of places. In the package properties, enable package logging.
>This
> will give you counts and times it took to execute various tasks within the
> package.
> Also in package properties, there is an option to provide an output file
> for
> execution details. Then, also in the same set of dialogs, you can choose
> to
> have the package to log in the servers event logs.
> Hope this helps.
> Sincerely,
>
> Anthony Thomas
>
> "Jj" wrote:
>|||Jj,
You might want to look into a network monitoring tool, there's nothing
built-in that does it.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Jj wrote:
> Hi,
> how can I know or log the volume loaded by my DTS packages?
> I need to evaluate the traffic and the bandwidth required.
> Does the profiler can provide enough info?
> For the moment I work on a copy of the production database. so all is loca
l
> on my server.
> Thanks for your help
> Jerome.
>|||but my actual problem is:
all is on 1 server!
so I can't monitor any network activity, because there is no network
activity for the moment.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:u3K1ojmxEHA.1296@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Jj,
> You might want to look into a network monitoring tool, there's nothing
> built-in that does it.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Jj wrote:|||If you want to monitor network activity, bytes, etc you may
want to look at using a Network sniffer tool or PerfMon and
the Network Interface object.
-Sue
On Tue, 9 Nov 2004 09:20:12 -0500, "Jj"
<willgart_A_@.hotmail_A_.com> wrote:

>but does these option display the amount of data?
>in Mb, not in rows!
>"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
>news:385122A2-440F-483D-B92D-60BCC3D05CE8@.microsoft.com...
>|||There are still the performance counters, server as well as SQL Server that
will give I/O transferred, pages manipulated, etc. Also, the Profiler tool,
which can focus on that application/database/user/etc., will record CPU time
,
and Read I/O and Write I/O. Sorry, it is only in bytes but I think you can
do the conversion.
Moreover, you can automate the launch of background trace with the use of
the system stored procedures and have the output loaded to a SQL Server tabl
e.
Sincerely,
Anthony Thomas
"Jéjé" wrote:

> but my actual problem is:
> all is on 1 server!
> so I can't monitor any network activity, because there is no network
> activity for the moment.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:u3K1ojmxEHA.1296@.TK2MSFTNGP10.phx.gbl...
>

logging the volume of data loaded other the network?

Hi,
how can I know or log the volume loaded by my DTS packages?
I need to evaluate the traffic and the bandwidth required.
Does the profiler can provide enough info?
For the moment I work on a copy of the production database. so all is local
on my server.
Thanks for your help
Jerome.
A couple of places. In the package properties, enable package logging. This
will give you counts and times it took to execute various tasks within the
package.
Also in package properties, there is an option to provide an output file for
execution details. Then, also in the same set of dialogs, you can choose to
have the package to log in the servers event logs.
Hope this helps.
Sincerely,
Anthony Thomas
"Jéjé" wrote:

> Hi,
> how can I know or log the volume loaded by my DTS packages?
> I need to evaluate the traffic and the bandwidth required.
> Does the profiler can provide enough info?
> For the moment I work on a copy of the production database. so all is local
> on my server.
> Thanks for your help
> Jerome.
>
>
|||but does these option display the amount of data?
in Mb, not in rows!
"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
news:385122A2-440F-483D-B92D-60BCC3D05CE8@.microsoft.com...[vbcol=seagreen]
>A couple of places. In the package properties, enable package logging.
>This
> will give you counts and times it took to execute various tasks within the
> package.
> Also in package properties, there is an option to provide an output file
> for
> execution details. Then, also in the same set of dialogs, you can choose
> to
> have the package to log in the servers event logs.
> Hope this helps.
> Sincerely,
>
> Anthony Thomas
>
> "Jj" wrote:
|||Jj,
You might want to look into a network monitoring tool, there's nothing
built-in that does it.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Jj wrote:
> Hi,
> how can I know or log the volume loaded by my DTS packages?
> I need to evaluate the traffic and the bandwidth required.
> Does the profiler can provide enough info?
> For the moment I work on a copy of the production database. so all is local
> on my server.
> Thanks for your help
> Jerome.
>
|||but my actual problem is:
all is on 1 server!
so I can't monitor any network activity, because there is no network
activity for the moment.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:u3K1ojmxEHA.1296@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Jj,
> You might want to look into a network monitoring tool, there's nothing
> built-in that does it.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Jj wrote:
|||If you want to monitor network activity, bytes, etc you may
want to look at using a Network sniffer tool or PerfMon and
the Network Interface object.
-Sue
On Tue, 9 Nov 2004 09:20:12 -0500, "Jj"
<willgart_A_@.hotmail_A_.com> wrote:

>but does these option display the amount of data?
>in Mb, not in rows!
>"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
>news:385122A2-440F-483D-B92D-60BCC3D05CE8@.microsoft.com...
>
|||There are still the performance counters, server as well as SQL Server that
will give I/O transferred, pages manipulated, etc. Also, the Profiler tool,
which can focus on that application/database/user/etc., will record CPU time,
and Read I/O and Write I/O. Sorry, it is only in bytes but I think you can
do the conversion.
Moreover, you can automate the launch of background trace with the use of
the system stored procedures and have the output loaded to a SQL Server table.
Sincerely,
Anthony Thomas
"Jéjé" wrote:

> but my actual problem is:
> all is on 1 server!
> so I can't monitor any network activity, because there is no network
> activity for the moment.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:u3K1ojmxEHA.1296@.TK2MSFTNGP10.phx.gbl...
>

logging the volume of data loaded other the network?

Hi,
how can I know or log the volume loaded by my DTS packages?
I need to evaluate the traffic and the bandwidth required.
Does the profiler can provide enough info?
For the moment I work on a copy of the production database. so all is local
on my server.
Thanks for your help
Jerome.A couple of places. In the package properties, enable package logging. This
will give you counts and times it took to execute various tasks within the
package.
Also in package properties, there is an option to provide an output file for
execution details. Then, also in the same set of dialogs, you can choose to
have the package to log in the servers event logs.
Hope this helps.
Sincerely,
Anthony Thomas
"Jéjé" wrote:
> Hi,
> how can I know or log the volume loaded by my DTS packages?
> I need to evaluate the traffic and the bandwidth required.
> Does the profiler can provide enough info?
> For the moment I work on a copy of the production database. so all is local
> on my server.
> Thanks for your help
> Jerome.
>
>|||but does these option display the amount of data?
in Mb, not in rows!
"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
news:385122A2-440F-483D-B92D-60BCC3D05CE8@.microsoft.com...
>A couple of places. In the package properties, enable package logging.
>This
> will give you counts and times it took to execute various tasks within the
> package.
> Also in package properties, there is an option to provide an output file
> for
> execution details. Then, also in the same set of dialogs, you can choose
> to
> have the package to log in the servers event logs.
> Hope this helps.
> Sincerely,
>
> Anthony Thomas
>
> "Jéjé" wrote:
>> Hi,
>> how can I know or log the volume loaded by my DTS packages?
>> I need to evaluate the traffic and the bandwidth required.
>> Does the profiler can provide enough info?
>> For the moment I work on a copy of the production database. so all is
>> local
>> on my server.
>> Thanks for your help
>> Jerome.
>>|||Jéjé,
You might want to look into a network monitoring tool, there's nothing
built-in that does it.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Jéjé wrote:
> Hi,
> how can I know or log the volume loaded by my DTS packages?
> I need to evaluate the traffic and the bandwidth required.
> Does the profiler can provide enough info?
> For the moment I work on a copy of the production database. so all is local
> on my server.
> Thanks for your help
> Jerome.
>|||but my actual problem is:
all is on 1 server!
so I can't monitor any network activity, because there is no network
activity for the moment.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:u3K1ojmxEHA.1296@.TK2MSFTNGP10.phx.gbl...
> Jéjé,
> You might want to look into a network monitoring tool, there's nothing
> built-in that does it.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Jéjé wrote:
>> Hi,
>> how can I know or log the volume loaded by my DTS packages?
>> I need to evaluate the traffic and the bandwidth required.
>> Does the profiler can provide enough info?
>> For the moment I work on a copy of the production database. so all is
>> local on my server.
>> Thanks for your help
>> Jerome.|||If you want to monitor network activity, bytes, etc you may
want to look at using a Network sniffer tool or PerfMon and
the Network Interface object.
-Sue
On Tue, 9 Nov 2004 09:20:12 -0500, "Jéjé"
<willgart_A_@.hotmail_A_.com> wrote:
>but does these option display the amount of data?
>in Mb, not in rows!
>"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
>news:385122A2-440F-483D-B92D-60BCC3D05CE8@.microsoft.com...
>>A couple of places. In the package properties, enable package logging.
>>This
>> will give you counts and times it took to execute various tasks within the
>> package.
>> Also in package properties, there is an option to provide an output file
>> for
>> execution details. Then, also in the same set of dialogs, you can choose
>> to
>> have the package to log in the servers event logs.
>> Hope this helps.
>> Sincerely,
>>
>> Anthony Thomas
>>
>> "Jéjé" wrote:
>> Hi,
>> how can I know or log the volume loaded by my DTS packages?
>> I need to evaluate the traffic and the bandwidth required.
>> Does the profiler can provide enough info?
>> For the moment I work on a copy of the production database. so all is
>> local
>> on my server.
>> Thanks for your help
>> Jerome.
>>
>|||There are still the performance counters, server as well as SQL Server that
will give I/O transferred, pages manipulated, etc. Also, the Profiler tool,
which can focus on that application/database/user/etc., will record CPU time,
and Read I/O and Write I/O. Sorry, it is only in bytes but I think you can
do the conversion.
Moreover, you can automate the launch of background trace with the use of
the system stored procedures and have the output loaded to a SQL Server table.
Sincerely,
Anthony Thomas
"Jéjé" wrote:
> but my actual problem is:
> all is on 1 server!
> so I can't monitor any network activity, because there is no network
> activity for the moment.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:u3K1ojmxEHA.1296@.TK2MSFTNGP10.phx.gbl...
> > Jéjé,
> >
> > You might want to look into a network monitoring tool, there's nothing
> > built-in that does it.
> > --
> > Mark Allison, SQL Server MVP
> > http://www.markallison.co.uk
> >
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602m.html
> >
> >
> > Jéjé wrote:
> >> Hi,
> >>
> >> how can I know or log the volume loaded by my DTS packages?
> >>
> >> I need to evaluate the traffic and the bandwidth required.
> >> Does the profiler can provide enough info?
> >>
> >> For the moment I work on a copy of the production database. so all is
> >> local on my server.
> >>
> >> Thanks for your help
> >>
> >> Jerome.
> >>
>