November 8, 2001 at 1:47 pm
I have configured MS SQL server 7.0 and can connect on that box. When I try to connect through enterprise manager from another box on the network, I get an error message that states, "logon failed for user. Reason: Not associated with a trusted SQL Server Connection. [Driver's SQLSetConnectAttr failed]. The driver doesn't support the version of ODBC behavior that the application requested (see SQL SetEnvAttr)".
Any suggestions on how I should proceed?
November 8, 2001 at 2:23 pm
What versions and types of clients?
the other workstation may not be on the same domain.
Steve Jones
November 9, 2001 at 8:40 am
Steve
Thanks for replying. I have version 7.0 on both machines and both are NT boxes. Is that what you were asking for?
November 9, 2001 at 9:45 am
You might try installing the SQL Tools on one workstation and seeing if that works. If so, I think the MDAC/ODBC drivers might be out of date, though they should still connect.
Check the protocols on the server (Server Network Utility) and client (Client Network Utility once you install the tools.) Using the Control Panel/Data Sources, can you make a manual connection to the server? (Named Pipes is the simplest. TCP/IP Sockets are preferred.
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply