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 |
|
keithc1
Yak Posting Veteran
88 Posts |
 Posted - 2004-07-09 : 22:16:33
|
| I seem to always have issues with authenticating to a remote sql server using ODBC with windows authentication with user that is a domain admin and member of the builtin\administrators group on sql. I always end up having to specify sa login for the ODBC connection to work. Does anyone else have this issue? Reason I'd like to use windows authentication is so i can disable the sa account if i can and drop the builtin\admin group in sql and add in a login of my choice to the sysadmin role. Then maybe mix and match lesser roles to the login for ODBC to work to tighten security if possible.Keithc MCSE MCSA |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-09 : 23:45:59
|
| ??? I haven't ever seen this issue? Run a profiler and look at errors and Login:Failed to see how it's hitting SQL Server. What error do you get when you try to connect?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
keithc1
Yak Posting Veteran
88 Posts |
Posted - 2004-07-10 : 00:43:31
|
| Ilooked at this more and I now think it's an application side issue Derrick and not a sql one. Using a software Firewall that is beta version and I beleive there's either a bug in the app or i disabled some service it needs to use during system hardening. I thought it may have been sql but the DSN tests out fine under windows authent. Anyways, it's nice to know this type of issue doesn't come up that often. Thanks for the reply budKeithc MCSE MCSA |
|
|
|
|
|
|
Authentication Issues