February 5, 2003 at 9:34 am
Trying to connect to an SQL 2000 Server getting message
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Disconnecting from server
February 5, 2003 at 12:10 pm
Try changing for testing the login mode To Mixed Mode (SQL and Win) and with Query analizer, log with any SQL login (sa).
If you are still with problems, maybe you should check the client network library.
February 5, 2003 at 12:57 pm
You didn't say what you were using to connect that fails. EM or QA ?
If EM is from a SQL 7 install, I believe you'll have to install the client tools from SQL 2K.
If failing connection is an app like Access, Excel, or VB, then you may have an older MDAC and need to upgrade, see: http://www.microsoft.com/data
Test your connection from either a UDL file or through ODBC Data Sources. I'm using 2.7 so the version that shows thru ODBC Data Sources when adding a new data source is 2000.81.7713.00
HTH
February 5, 2003 at 1:08 pm
Is the Windows account you are using to connect to SQL Server in the same domain (or a trusted domain) as the SQL Server itself?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
February 6, 2003 at 2:39 am
The SQL 2K Server is in the same domain as all the clients. Seems intermitant, when you use a DSN connection, sometimes connects and others it doesn't.
Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply