Login failed for user '(null)'

Hello world,
I'm getting the following error when trying to register an instance of SQL
in Enterprise Manager (connecting using Windows authentication):
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
EM sits on a developer's PC running XP Professional SP2, and SQL Server 2000
Standard Ed. SP4 resides on a Windows 2000 Server (SP4)
This particular PC was previously able to connecte to this manner prior to
migrating the SQL server from being a member server within an NT4 domain to
being a member server within a Windows 2003 Active Directory Domain.
Any thought's as to why Windows authentication has stopped working would be
most appreciated.Chris
Do you grant access to SQL Server,for login? What is a default database
did you assign to him?
"Chris Ford" <ChrisFord@.discussions.microsoft.com> wrote in message
news:0189E38E-31FC-4E43-A79E-FCABE2726A9A@.microsoft.com...
> Hello world,
> I'm getting the following error when trying to register an instance of SQL
> in Enterprise Manager (connecting using Windows authentication):
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> EM sits on a developer's PC running XP Professional SP2, and SQL Server
> 2000
> Standard Ed. SP4 resides on a Windows 2000 Server (SP4)
> This particular PC was previously able to connecte to this manner prior to
> migrating the SQL server from being a member server within an NT4 domain
> to
> being a member server within a Windows 2003 Active Directory Domain.
> Any thought's as to why Windows authentication has stopped working would
> be
> most appreciated.|||Uri
Thanks for replying so quickly.
Yes for the purposes of testing the connection, I've assigned the developer
(an ordinary domain user) public access to Northwind.
I've also tried making them a member of the Sysadmin Server role to no effec
t.
The same user can connect to another SQL server using Windows Authentication
(SQL 2000 Workgroup Ed SP4 running on Windows 2003 SP1).
I've just tried the same user from a different PC and he can log in from
there too (that one runs Windows 2000 Professional SP4).
"Uri Dimant" wrote:

> Chris
> Do you grant access to SQL Server,for login? What is a default database
> did you assign to him?
>|||Chris
Any errors in event viewer, sql server log file?
"Chris Ford" <ChrisFord@.discussions.microsoft.com> wrote in message
news:5DD31C06-D0ED-4DC1-9768-A072FBBBBA1B@.microsoft.com...
> Uri
> Thanks for replying so quickly.
> Yes for the purposes of testing the connection, I've assigned the
> developer
> (an ordinary domain user) public access to Northwind.
> I've also tried making them a member of the Sysadmin Server role to no
> effect.
> The same user can connect to another SQL server using Windows
> Authentication
> (SQL 2000 Workgroup Ed SP4 running on Windows 2003 SP1).
> I've just tried the same user from a different PC and he can log in from
> there too (that one runs Windows 2000 Professional SP4).
> "Uri Dimant" wrote:
>
>|||Uri
Nothing that appears to by related to the problem on either the Server SQL
and Event logs or the client event logs.
Most of the events in the security logs appear to be Privilege Use types
related to other processes.
"Uri Dimant" wrote:

> Chris
> Any errors in event viewer, sql server log file?
>|||Can anyone offer any other suggestions?|||Further tests have revealed that only clients with Windows XP Professional
are affected. Prior OS versions seem to work fine.|||Several things...
1) Depending on how your active directory is setup, you may need to be in
the domain to authenticate to it if it's only supporting kerberos rather
than just ntlm
2) Domain policies can restrict stuff. If both computers aren't in the
domain than perhaps one is more restrictive than the other.
3) If using kerberos to authenticate, you may need to enable kerberos
delegation on the sql server.
"Chris Ford" <ChrisFord@.discussions.microsoft.com> wrote in message
news:0189E38E-31FC-4E43-A79E-FCABE2726A9A@.microsoft.com...
> Hello world,
> I'm getting the following error when trying to register an instance of SQL
> in Enterprise Manager (connecting using Windows authentication):
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> EM sits on a developer's PC running XP Professional SP2, and SQL Server
> 2000
> Standard Ed. SP4 resides on a Windows 2000 Server (SP4)
> This particular PC was previously able to connecte to this manner prior to
> migrating the SQL server from being a member server within an NT4 domain
> to
> being a member server within a Windows 2003 Active Directory Domain.
> Any thought's as to why Windows authentication has stopped working would
> be
> most appreciated.

login failed error

I am trying to export data from one sql server instance to another on another domain.
however trying to connect to the remote instance never works due to 'login failed' error.
i have access to the remote domain and can verify that the login is correct.
what is the problem?
--
Message posted via http://www.sqlmonster.comCan you be a little more specific as to exactly how you are attempting this?
Are you using DTS, a remote query or what? How are you connecting and what
is the connection string?
--
Andrew J. Kelly SQL MVP
"Mark Evans via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:94ee95ffac054cb6af4c94330d544b85@.SQLMonster.com...
>I am trying to export data from one sql server instance to another on
>another domain.
> however trying to connect to the remote instance never works due to 'login
> failed' error.
> i have access to the remote domain and can verify that the login is
> correct.
> what is the problem?
> --
> Message posted via http://www.sqlmonster.com

login failed error

I am trying to export data from one sql server instance to another on anothe
r domain.
however trying to connect to the remote instance never works due to 'login f
ailed' error.
i have access to the remote domain and can verify that the login is correct.
what is the problem?
Message posted via http://www.droptable.comCan you be a little more specific as to exactly how you are attempting this?
Are you using DTS, a remote query or what? How are you connecting and what
is the connection string?
Andrew J. Kelly SQL MVP
"Mark Evans via droptable.com" <forum@.droptable.com> wrote in message
news:94ee95ffac054cb6af4c94330d544b85@.SQ
droptable.com...
>I am trying to export data from one sql server instance to another on
>another domain.
> however trying to connect to the remote instance never works due to 'login
> failed' error.
> i have access to the remote domain and can verify that the login is
> correct.
> what is the problem?
> --
> Message posted via http://www.droptable.com

login failed error

I am trying to export data from one sql server instance to another on another domain.
however trying to connect to the remote instance never works due to 'login failed' error.
i have access to the remote domain and can verify that the login is correct.
what is the problem?
Message posted via http://www.sqlmonster.com
Can you be a little more specific as to exactly how you are attempting this?
Are you using DTS, a remote query or what? How are you connecting and what
is the connection string?
Andrew J. Kelly SQL MVP
"Mark Evans via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:94ee95ffac054cb6af4c94330d544b85@.SQLMonster.c om...
>I am trying to export data from one sql server instance to another on
>another domain.
> however trying to connect to the remote instance never works due to 'login
> failed' error.
> i have access to the remote domain and can verify that the login is
> correct.
> what is the problem?
> --
> Message posted via http://www.sqlmonster.com

Logical connections very different from user connections

Hi,
We are administering a 64 bit sql 2005 instance that averages 400
transactions per second or so during business hours. The server is
performing quite well, but recently we've been seeing some performance
tick data that I don't understand.
In the SQLServer:General Statistics category, the server reports 270
logical connections. However, the User Connections perf ticks returns
491 connections. I am at a loss to explain the difference between the
two values. We consider 270 client connections to be an acceptable
number, but 491 is significantly higher than we would like to see.
I've searched for documentation explaining the difference between the
two perf ticks, but I haven't had any luck. I'm looking for a) some
information on what the difference between the two ticks is, and b)
some information that will help me determine if the discrepancy is
important.
Any advice or pointers as to where I could look next would be greatly
appreciated.
Sean Reilly
Software Architect
Point2 Technologies, Inc
(306) 955-1855Doesn't SQL Server group user connections based on certain conditions?
This would explain the difference.
Jim.
"Sean Reilly" wrote:

> Hi,
> We are administering a 64 bit sql 2005 instance that averages 400
> transactions per second or so during business hours. The server is
> performing quite well, but recently we've been seeing some performance
> tick data that I don't understand.
> In the SQLServer:General Statistics category, the server reports 270
> logical connections. However, the User Connections perf ticks returns
> 491 connections. I am at a loss to explain the difference between the
> two values. We consider 270 client connections to be an acceptable
> number, but 491 is significantly higher than we would like to see.
> I've searched for documentation explaining the difference between the
> two perf ticks, but I haven't had any luck. I'm looking for a) some
> information on what the difference between the two ticks is, and b)
> some information that will help me determine if the discrepancy is
> important.
> Any advice or pointers as to where I could look next would be greatly
> appreciated.
> Sean Reilly
> Software Architect
> Point2 Technologies, Inc
> (306) 955-1855
>|||Jim,
I hope that something like this does explain what I'm seeing. Do you
have any ideas as to what those conditions might be?
Thanks,
Sean|||From BOL:
"Connections can be shared among users. Users running OLE DB applications
need a connection for each open connection object, users running Open
Database Connectivity (ODBC) applications need a connection for each active
connection handle in the application, and users running DB-Library
applications need one connection for each process started that calls the
DB-Library dbopen function."
I'm not sure you have a lot of control over these features, but it would be
worth investigation "Connections" in any MS publications.
"Sean Reilly" wrote:

> Jim,
> I hope that something like this does explain what I'm seeing. Do you
> have any ideas as to what those conditions might be?
> Thanks,
> Sean
>|||Jim,
I'm pretty sure that the BOL entry you quoted refers to the client end
of the connection. I believe that Ole DB, ODBC and DB-Library
connections are all the same kind of connection from the server's
perspective.
A further data point for anyone who may be interested: when I use the
activity montior in SSMS, the number of connections reported matches
the smaller perf tick value (logical connections).

Logical connections very different from user connections

Hi,
We are administering a 64 bit sql 2005 instance that averages 400
transactions per second or so during business hours. The server is
performing quite well, but recently we've been seeing some performance
tick data that I don't understand.
In the SQLServer:General Statistics category, the server reports 270
logical connections. However, the User Connections perf ticks returns
491 connections. I am at a loss to explain the difference between the
two values. We consider 270 client connections to be an acceptable
number, but 491 is significantly higher than we would like to see.
I've searched for documentation explaining the difference between the
two perf ticks, but I haven't had any luck. I'm looking for a) some
information on what the difference between the two ticks is, and b)
some information that will help me determine if the discrepancy is
important.
Any advice or pointers as to where I could look next would be greatly
appreciated.
Sean Reilly
Software Architect
Point2 Technologies, Inc
(306) 955-1855Doesn't SQL Server group user connections based on certain conditions?
This would explain the difference.
Jim.
"Sean Reilly" wrote:
> Hi,
> We are administering a 64 bit sql 2005 instance that averages 400
> transactions per second or so during business hours. The server is
> performing quite well, but recently we've been seeing some performance
> tick data that I don't understand.
> In the SQLServer:General Statistics category, the server reports 270
> logical connections. However, the User Connections perf ticks returns
> 491 connections. I am at a loss to explain the difference between the
> two values. We consider 270 client connections to be an acceptable
> number, but 491 is significantly higher than we would like to see.
> I've searched for documentation explaining the difference between the
> two perf ticks, but I haven't had any luck. I'm looking for a) some
> information on what the difference between the two ticks is, and b)
> some information that will help me determine if the discrepancy is
> important.
> Any advice or pointers as to where I could look next would be greatly
> appreciated.
> Sean Reilly
> Software Architect
> Point2 Technologies, Inc
> (306) 955-1855
>|||Jim,
I hope that something like this does explain what I'm seeing. Do you
have any ideas as to what those conditions might be?
Thanks,
Sean|||From BOL:
"Connections can be shared among users. Users running OLE DB applications
need a connection for each open connection object, users running Open
Database Connectivity (ODBC) applications need a connection for each active
connection handle in the application, and users running DB-Library
applications need one connection for each process started that calls the
DB-Library dbopen function."
I'm not sure you have a lot of control over these features, but it would be
worth investigation "Connections" in any MS publications.
"Sean Reilly" wrote:
> Jim,
> I hope that something like this does explain what I'm seeing. Do you
> have any ideas as to what those conditions might be?
> Thanks,
> Sean
>|||Jim,
I'm pretty sure that the BOL entry you quoted refers to the client end
of the connection. I believe that Ole DB, ODBC and DB-Library
connections are all the same kind of connection from the server's
perspective.
A further data point for anyone who may be interested: when I use the
activity montior in SSMS, the number of connections reported matches
the smaller perf tick value (logical connections).

Logging query errors

Hi,
Is there a way to log errors raised while running a query. For instance a
table contains a duplicate entry and a scheduled query notices this. Is it
then possible to get an alert in for instance the SQL log?
Greets,
Fred
Fred
If you are on SQL Server 2005 take a look at Notification Services in the
BOL
One method is
IF EXISTS(SELECT *
FROM TableA
WHERE col = @.key
GROUP BY col
HAVING COUNT(*)>1)
BEGIN
RAISERROR ('There are duplicates in the table',16, 1)
END
ELSE
"Fred Wouters" <f.wouters@.tigra-tuning.nl> wrote in message
news:788AA79C-20C2-438B-9556-8AFF574B129B@.microsoft.com...
> Hi,
> Is there a way to log errors raised while running a query. For instance a
> table contains a duplicate entry and a scheduled query notices this. Is it
> then possible to get an alert in for instance the SQL log?
> Greets,
> Fred
|||I'm using SQL 2000. Would the query below also work on 2000?
"Uri Dimant" wrote:

> Fred
> If you are on SQL Server 2005 take a look at Notification Services in the
> BOL
>
> One method is
> IF EXISTS(SELECT *
> FROM TableA
> WHERE col = @.key
> GROUP BY col
> HAVING COUNT(*)>1)
> BEGIN
> RAISERROR ('There are duplicates in the table',16, 1)
> END
> ELSE
>
>
> "Fred Wouters" <f.wouters@.tigra-tuning.nl> wrote in message
> news:788AA79C-20C2-438B-9556-8AFF574B129B@.microsoft.com...
>
>
|||Fred
Yes
"Fred Wouters" <f.wouters@.tigra-tuning.nl> wrote in message
news:AB5685F6-EF5D-4346-A4C0-A8D02D54DDFB@.microsoft.com...[vbcol=seagreen]
> I'm using SQL 2000. Would the query below also work on 2000?
> "Uri Dimant" wrote:

Logging query errors

Hi,
Is there a way to log errors raised while running a query. For instance a
table contains a duplicate entry and a scheduled query notices this. Is it
then possible to get an alert in for instance the SQL log?
Greets,
FredFred
If you are on SQL Server 2005 take a look at Notification Services in the
BOL
One method is
IF EXISTS(SELECT *
FROM TableA
WHERE col = @.key
GROUP BY col
HAVING COUNT(*)>1)
BEGIN
RAISERROR ('There are duplicates in the table',16, 1)
END
ELSE
"Fred Wouters" <f.wouters@.tigra-tuning.nl> wrote in message
news:788AA79C-20C2-438B-9556-8AFF574B129B@.microsoft.com...
> Hi,
> Is there a way to log errors raised while running a query. For instance a
> table contains a duplicate entry and a scheduled query notices this. Is it
> then possible to get an alert in for instance the SQL log?
> Greets,
> Fred|||Not really without catching that error in the client code. If you want to do this at the TSQL level:
2000: You can only capture the error number using @.@.ERROR
2005: You can capture almost anything you want, using functions such as ERROR_MESSAGE(),
ERROR_NUMBER(). Do read up on TRY/CATCH if you want to go this route.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Fred Wouters" <f.wouters@.tigra-tuning.nl> wrote in message
news:788AA79C-20C2-438B-9556-8AFF574B129B@.microsoft.com...
> Hi,
> Is there a way to log errors raised while running a query. For instance a
> table contains a duplicate entry and a scheduled query notices this. Is it
> then possible to get an alert in for instance the SQL log?
> Greets,
> Fred|||I'm using SQL 2000. Would the query below also work on 2000?
"Uri Dimant" wrote:
> Fred
> If you are on SQL Server 2005 take a look at Notification Services in the
> BOL
>
> One method is
> IF EXISTS(SELECT *
> FROM TableA
> WHERE col = @.key
> GROUP BY col
> HAVING COUNT(*)>1)
> BEGIN
> RAISERROR ('There are duplicates in the table',16, 1)
> END
> ELSE
>
>
> "Fred Wouters" <f.wouters@.tigra-tuning.nl> wrote in message
> news:788AA79C-20C2-438B-9556-8AFF574B129B@.microsoft.com...
> > Hi,
> >
> > Is there a way to log errors raised while running a query. For instance a
> > table contains a duplicate entry and a scheduled query notices this. Is it
> > then possible to get an alert in for instance the SQL log?
> >
> > Greets,
> >
> > Fred
>
>|||Fred
Yes
"Fred Wouters" <f.wouters@.tigra-tuning.nl> wrote in message
news:AB5685F6-EF5D-4346-A4C0-A8D02D54DDFB@.microsoft.com...
> I'm using SQL 2000. Would the query below also work on 2000?
> "Uri Dimant" wrote:
>> Fred
>> If you are on SQL Server 2005 take a look at Notification Services in the
>> BOL
>>
>> One method is
>> IF EXISTS(SELECT *
>> FROM TableA
>> WHERE col = @.key
>> GROUP BY col
>> HAVING COUNT(*)>1)
>> BEGIN
>> RAISERROR ('There are duplicates in the table',16, 1)
>> END
>> ELSE
>>
>>
>> "Fred Wouters" <f.wouters@.tigra-tuning.nl> wrote in message
>> news:788AA79C-20C2-438B-9556-8AFF574B129B@.microsoft.com...
>> > Hi,
>> >
>> > Is there a way to log errors raised while running a query. For instance
>> > a
>> > table contains a duplicate entry and a scheduled query notices this. Is
>> > it
>> > then possible to get an alert in for instance the SQL log?
>> >
>> > Greets,
>> >
>> > Fred
>>

Logging query errors

Hi,
Is there a way to log errors raised while running a query. For instance a
table contains a duplicate entry and a scheduled query notices this. Is it
then possible to get an alert in for instance the SQL log?
Greets,
FredFred
If you are on SQL Server 2005 take a look at Notification Services in the
BOL
One method is
IF EXISTS(SELECT *
FROM TableA
WHERE col = @.key
GROUP BY col
HAVING COUNT(*)>1)
BEGIN
RAISERROR ('There are duplicates in the table',16, 1)
END
ELSE
"Fred Wouters" <f.wouters@.tigra-tuning.nl> wrote in message
news:788AA79C-20C2-438B-9556-8AFF574B129B@.microsoft.com...
> Hi,
> Is there a way to log errors raised while running a query. For instance a
> table contains a duplicate entry and a scheduled query notices this. Is it
> then possible to get an alert in for instance the SQL log?
> Greets,
> Fred|||Not really without catching that error in the client code. If you want to do
this at the TSQL level:
2000: You can only capture the error number using @.@.ERROR
2005: You can capture almost anything you want, using functions such as ERRO
R_MESSAGE(),
ERROR_NUMBER(). Do read up on TRY/CATCH if you want to go this route.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Fred Wouters" <f.wouters@.tigra-tuning.nl> wrote in message
news:788AA79C-20C2-438B-9556-8AFF574B129B@.microsoft.com...
> Hi,
> Is there a way to log errors raised while running a query. For instance a
> table contains a duplicate entry and a scheduled query notices this. Is it
> then possible to get an alert in for instance the SQL log?
> Greets,
> Fred|||I'm using SQL 2000. Would the query below also work on 2000?
"Uri Dimant" wrote:

> Fred
> If you are on SQL Server 2005 take a look at Notification Services in the
> BOL
>
> One method is
> IF EXISTS(SELECT *
> FROM TableA
> WHERE col = @.key
> GROUP BY col
> HAVING COUNT(*)>1)
> BEGIN
> RAISERROR ('There are duplicates in the table',16, 1)
> END
> ELSE
>
>
> "Fred Wouters" <f.wouters@.tigra-tuning.nl> wrote in message
> news:788AA79C-20C2-438B-9556-8AFF574B129B@.microsoft.com...
>
>|||Fred
Yes
"Fred Wouters" <f.wouters@.tigra-tuning.nl> wrote in message
news:AB5685F6-EF5D-4346-A4C0-A8D02D54DDFB@.microsoft.com...[vbcol=seagreen]
> I'm using SQL 2000. Would the query below also work on 2000?
> "Uri Dimant" wrote:
>