February 25, 2003 at 3:04 pm
When creating a User Data Source via ODBC Data Source Administrator - test connection successful. However, when using this User Data Source Name via Ms Access, connection fails, due to Server Login Dialog Box - Use Trusted Connection is selected. This tells me that the system thinks the User is setup under Windows Authentication Mode. However, when I check the Security Logins via Enterprise Manager, the Authentication mode is set to SQL, plus that we are running Win98.
Also, if File Data Source is created the above problem does not occur.
Any suggestions.
Emma Smyth
ESmyth
February 26, 2003 at 7:29 am
When you set up the DSN, it's using a sql login? And you should get prompted to re-enter it when you use the DSN to link in whatever tables you need.
Andy
February 26, 2003 at 8:02 am
Is the client or the SQL Server running on Win98?
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 27, 2003 at 3:39 am
Initially when trying to link a table through Machine Data Source, which uses the DSN created through ODBC. An error message is displayed -
Connection Failed
SQL State 'S1000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context
Then the SQL Server Login Box appears, with Use Trusted Connection checked. If this is then unchecked, we can access SQL Server.
However, when using a File Data Source this does not occur.
SQL Server is installed on Windows 2000
Emma Smyth
ESmyth
February 27, 2003 at 3:49 am
Furthermore...
This seems to be occuring on only one machine?
I don't know if this makes a difference, however, I connect to the Server through an IP address, whilst others connect through an alternative server name.
Emma Smyth
ESmyth
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply