Error while registering a server

Question

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

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

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

PFlorenzano SSCrazy Points: 2180 More actions · Answer 2

Thank you Allen,

I will give this a try.

Peter

Peter M. Florenzano

Database Administrator

PFlorenzano SSCrazy Points: 2180 More actions · Answer 3

Hello Allen,

From SQL Server 2000, I'm attempting to register a SQL Server 6.5 server and when I do, I'm receiving the following error message:

Login failed- User: Reason: Not associated with a trusted SQL Server Connection

This is what I did so far:

1) Changed the Authentication Mode from Windows NT Authentication Mode to Mixed Mode.

2) Rebooted the server

I'm still receiving the same error message.

Any information would be greatly appreciated.

Thanks,

Peter

Peter M. Florenzano

Database Administrator

SQLBill SSC Guru Points: 51440 More actions · Answer 4

I don't use 6.5, but....

check that your login does have access to the database and that it uses NT login authentication.

is your computer on a different domain than the SQL Server you are trying to register?

-SQLBill

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 5

SSC Guru

Points: 51650

February 19, 2004 at 8:50 am

You can't administer SQL server 6.5 with 2000 EM.