Login Failed for user null not associated with trusted sql server connection

Question

Post reply

Login Failed for user null not associated with trusted sql server connection

Nido786

Default port

Points: 1482
More actions
July 14, 2009 at 2:42 am

#206970

Hi,
while i am trying to regester my branch machine with my server
it showing this error message.
"Login Failed for user null not associated with trusted sql server connection"
i am using sql server authencation on both side
Detail.
i am having two domain A and B both are having trusted connection each other.
form both side i can get the connection.and also can able to telnet.
1) in sql server 2000 while trying to regestering the server from branch side its working fine but while trying to regestring the branch from the server side its showing the above error message.
2) service name is baservice.its having local admin rights on both machine.
3)domain password is same for baservice account.
4) both machine are connected with baservice account
server connected with domain a a\bacservice
branch connected with domain b b\baservice
pls pls help me i am stucked ........................

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

John H Marsh SSChampion Points: 11671 More actions · Answer 1

Hello,

Just to check a couple of things:-

- Are you experiencing this issue when trying to create a Linked Server to your Branch SQL Server from your Server SQL Server?

- Which Server is running SQL 2000 and which SQL 2005?

Regards,

John Marsh

www.sql.lu
SQL Server Luxembourg User Group

suresh.theyyath Old Hand Points: 304 More actions · Answer 2

Try these..

1) Double check the security of your SQL server to make sure that whether it supports windows intrgrated authentication and sql server

authentication. (MIXED MODE)

2) Use SQL server profiler to audit all the login action to see which login

action failed.

Amjad Khan-411173 Valued Member Points: 66 More actions · Answer 3

Thanks for the promt responce

1) i m using sql server 2000 on both side (branch and server)

2)i tried to configure linked server from server to branch but the same message is comming.

pls do somthing

John H Marsh SSChampion Points: 11671 More actions · Answer 4

Hello again,

Did you try setting up a Mapped Login when creating the Linked Server?

Also do you get any Login Errors reported in the SQL Server Logs on the Branch Server at the time you try to connect from the Server server?

If so can you please post the Error Number and State?

Regards,

John Marsh

www.sql.lu
SQL Server Luxembourg User Group

suresh.theyyath Old Hand Points: 304 More actions · Answer 5

check firewall setting...and put it off and try..

also.. check the SS in branch computer for mixed mode authentication

once you change the authentication type restart the computer.

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 6

syed muhammad naveed (7/14/2009)
Hi,
while i am trying to regester my branch machine with my server
it showing this error message.
"Login Failed for user null not associated with trusted sql server connection"
i am using sql server authencation on both side
Detail.
i am having two domain A and B both are having trusted connection each other.
form both side i can get the connection.and also can able to telnet.
1) in sql server 2000 while trying to regestering the server from branch side its working fine but while trying to regestring the branch from the server side its showing the above error message.

To go back to another post, check to make sure the branch SQL Server is set up to use Mixed Mode. If it is not, you will get this error, even if you have properly created a SQL Server login and password successfully. SQL Server will not authenticate a SQL Server login if it's set up for Windows authentication only mode.

K. Brian Kelley
@kbriankelley