Ok I setup a whole new user just in SQL and made it also the owner of the 2 Rodopi databases. I can connect with the new account "linux" and authenticate, but I still get all the can't find stored procedure errors. I even double checked to see what permissions the "sa" account had on those 2 Rodopi databases (AbacBill and AbacPay) and the "linux" account has the same two, "db owner" and "public". I don't see the problem here at all. I even went in to the stored procedures and gave linux the EXEC bit/permission for those stored procedures. I have no clue what to do now.
I even went in to Rodopi and told it to use TCP/IP sockets rather than pipes and everything works just fine. So it does not appear to be an issue with TCP/IP not working correctly. Anyone have any clue why this would be? Tim Jung System Admin Internet Gateway [EMAIL PROTECTED] ----- Original Message ----- From: "Mike McCauley" <[EMAIL PROTECTED]> To: "Tim Jung" <[EMAIL PROTECTED]>; "Hugh Irvine" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; "Dave Birkbeck" <[EMAIL PROTECTED]> Sent: Thursday, February 06, 2003 1:06 AM Subject: Re: (RADIATOR) Rodopi & Radiator > Hello Tim, > > > On Thu, 6 Feb 2003 05:59 pm, Tim Jung wrote: > > If I try and login as the "sa" or turn off/disable the NT "rodopi" account > > and still tell it to do a domain login, so it is forced to use the SQL > > "rodopi" account right? I get this error message: > > Im not sure. > Perhaps you should use a password based login to SQL server? > > > > > > DBI connect('Rodopi','rodopi',...) failed: Server message number=18452 > > severity=14 state=1 line=0 text=Login failed for user '(null)'. Reason: Not > > associated with a trusted SQL Server connection.OpenClient message: LAYER = > > (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (36) > > > > What exactly does this mean, and how would I go about fixing this error? > > > > Tim Jung > > System Admin > > Internet Gateway > > [EMAIL PROTECTED] > > > > > > ----- Original Message ----- > > From: "Mike McCauley" <[EMAIL PROTECTED]> > > To: "Hugh Irvine" <[EMAIL PROTECTED]>; "Tim Jung" <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]>; "Dave Birkbeck" <[EMAIL PROTECTED]> > > Sent: Thursday, February 06, 2003 12:08 AM > > Subject: Re: (RADIATOR) Rodopi & Radiator > > > > > Hello Tim, > > > > > > Hmmm, it appears that the Interface_VircomUsers stored procedure is not > > > present in your database (or perhaps you dont have permission to run it). > > > > > > Can you confiirm whether or not such a stored procedure exists in your > > > dbi:Sybase:Rodopi database (it should have been installed by the rodopi > > > installation). > > > > > > Can you confirm that the username rodopi has permission to run that > > > > stored > > > > > procedure? > > > > > > Cheers. > > -- > Mike McCauley [EMAIL PROTECTED] > Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW > 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au > Phone +61 3 9598-0985 Fax +61 3 9598-0955 > > Radiator: the most portable, flexible and configurable RADIUS server > anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, > Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, > TTLS, PEAP etc on Unix, Windows, MacOS etc. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.