I am currently using MSSQL 7 db configured using Mixed Mode authentication.
I have created a database named dbInfo with a few tables and records.
Under Security -> Logins I have the following users. 1 . sa - default 2 . BUILTIN\Administrators - default 3 . BUILTIN\Users granted with public and dbo_owner Database Access to the dbInfo database i have created. 4 . connectingUser granted with public and dbo_owner Database Access to the dbInfo database i have created.
Under ODBC Datasource DSN. I created one DSN named dbConn connection using sql authentication instead of windows authentication. And i connected using the connectingUser that i have created and default db set to dbInfo. It was tested successfully.
For my coding part. I am using VB. Database connection codes is as follows :
The above code runs perfectly fine when i login to pc as administrator or any users under the window's Power Users group. However, when i login as a normal user(under window's Users group). It give me an error, "Login failed for user <null> Reason : Not Trusted Connection".
At first, i thought that it was the ODBC registry key problem under \HKEY_LOCAL_MACHINE\SOFTWARE\ODBC.ini\dbConn problem, and i granted full control to windows Users. But still cannot.