repost for those who missed it the first time. > -----Original Message----- > From: Tim Harsch [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 24, 2001 3:12 PM > To: DBI > Subject: DBD::ODBC connection issue to SQL Server > > > Hi all, > > I have MS SQL Server 2000 on Win2K as my server, > running EasySoft's ODBC:ODBC bridge server software. > > I have Red Hat Linux 7.1 as my client, running > EasySoft ODBC:ODBC Client sofware. With DBI and > DBD::ODBC installed. > > I am able to make connections to the server but am a > little perplexed by a few thigs... First of all, for > security purposes I wish my logon User to have as few > permissions as possible on the Win2K network (ie just > enough to get on the network and pass along the > TargetUser to SQL Server). Through experimentation I > have discovered a couple of disturbing requirements to > allow the connection to be made. First, the Windows > user must be included in the "Account Operators" > group. Now, I'm no wizz at Win2K but am betting that > that group has one specific permission that is needed > by the LOGONUSER. I can probably determine what it is > later. But, 2nd, this LOGONUSER must have a SQL > Server account that connects via Windows > authentication (trusted connections). This might be > because, it is always logging on as user "guest", even > though I set TargetUser and TargetAuth to some other > user in both the odbc.ini file and the DBI connect > string. > > Any ideas? > > __________________________________________________ > Do You Yahoo!? > Make international calls for as low as $.04/minute with Yahoo! Messenger > http://phonecard.yahoo.com/ >
