Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-31 : 08:17:09
|
| kanisious writes "Please may you help!! I am an access programmer and I have written a client server application using SQL server 2000 as the back end and access 2000 as the front end. My application is being used by about 20 users right now. The problem is that there are two machines which can not connect to the server, giving the error: - “Logon Failure for user ‘(null)’. Reason: Not associated with a trusted SQL Server Connection.”What is troubling me further is that if I create a windows user on that machine with the same user name and password as me (dbo) the application connects successfully. The other 18 machine are connecting with the own user names and no problem. There are only two machines which require the dbo user.Right now the other two users are logging in with the user name and password for the dbo for them to use the system.The users work as a workgroup there is no active directory.How can I solve the problem?Kanisious" |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-01-31 : 11:43:49
|
| I don't understand how windows authentication is even working in a workgroup environment. I thought AD or a winnt Domain were required.Anyway, why can't you create standard SQL Server accounts for these users and have them login as them? Check BOL for details of how to do this.-ec |
 |
|
|
SqlStar
Posting Yak Master
121 Posts |
Posted - 2005-02-01 : 04:34:29
|
| Hi,Pls confirm once again whether that 2 machines also connected with same NT Domain/Workgroup.:) While we stop to think, we often miss our opportunity :) |
|
|
|
|
|
|
sql connection problem!!