With 6.5 eval running on NT Server 3.51+sp4, choosing Manage Databases
in the Enterprise Manager yields the message: "A connection could not
be established to TWO - [SQL Server] Login failed" SQLExecutive and
MSSQLServer services are running and Server Manager shows a green
light for server TWO under group SQL 6.5. What's a good starting point
to diagnose this?
Any attempt to Modify server TWO, in Register Server using Trusted
Connection, fails with a message: " Unable to Connect to Server
(reason: [SQL Server] Login failed- User: Reason: Not associated with
a trusted SQL Server connection). Modify anyway?" In Register Server
dialog box, the Servers button yields and empty Select Server list.
Running setup to change Login Security Mode from Standard to Mixed has
no effect on the problem. (Grasping at straws...)
Email appreciated. -- David