Unanswered: Warning "Could not connect to database" in SQL 7
I need a little help here, here is my situation.
I am running an app that uses SQL 7 database, the SQL server is a Windows 2000 machine. The users are loging on through my NT4 (pdc) server.
All users who run the app that requires the SQL database must be set as Domain admins in the Groups (under user manager for domains) on the NT4 Server. If they are not they get a message that says "Could not connect to database". I figure this may be a security setting somewhere on the sql server or ??? but I haven't figured it out yet.
The change is instant I can remove "domain admin" from a user and instantly they cannot connect to the db, I put it back and just as quickly they run fine again.