 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Security / October 2006DSN VS Logon
Our Database is ignores the authentication method that is chosen in the database connection under ODBC. Everyone is getting a log on dialog. Can any one help! Thanks You didn't provide many details but is it safe to guess that you are trying to use Windows Authentication in the DSN and that all user who use this DSN are being prompted to enter a user and password? There was a similar issue with an old version of MDAC (2.5 maybe) if that's the case. You can check your MDAC installation and version with component checker. Component checker and MDAC versions are available for download from: http://msdn.microsoft.com/data/ref/mdac/downloads/ -Sue >Our Database is ignores the authentication method that is chosen in the >database connection under ODBC. Everyone is getting a log on dialog. > >Can any one help! Thanks Thanks Sue - Sorry I was short We're moving on servers to a new Domain (btoins.com) then we will reimage the workstation and move them. Before we moved it the DSN file worked fine we didn't get any Windows Authentication box. We did a temp fix by putting the domain users(genelco.com) in the local machine administrator group. Why what's up with that - Thanks for your help! > You didn't provide many details but is it safe to guess that > you are trying to use Windows Authentication in the DSN and [quoted text clipped - 12 lines] > > > >Can any one help! Thanks What protocol are you connecting with? Make sure it's TCP/IP and not named pipes. You can end up with some issues on logins, domain mappings when moving domains but I can't tell from your post if this is the issue or not. What domain are the users logging into when they try to use the DSN? What domain are they listed under in syslogins? -Sue >Thanks Sue - Sorry I was short >We're moving on servers to a new Domain (btoins.com) then we will reimage [quoted text clipped - 19 lines] >> > >> >Can any one help! Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.