Im a Lotus notes , NT administrator living in Sydney Australia with no real sql knowledge. I installed The MSDE from the MS office 2000 CD onto my NT server and configured an SQL datasource to connect to it on my Windows 98 PCs. Basically I only intend using MSDE as an object store for MS project files. I am able to connect to the MSDE (via the test connection button in the ODBC configuration ) unless I add all my NT users to the administrators group. This alows me to save MS Project files to the MSDE However if they are not members of the administrators group I get a 18456 error and they cant connect. I can't use the SP commands such as sp_grantlogin as MSDE dosent come with Enterprise manager so I dont know how to grant access rights to MSDE. I know I can run MSDE locally with the "sa" account but I am trying to use MSDE as a service on an NT server.
I recently installed the SP3 for Sql 7 & MSDE
Any Ideas or web sites I could visit/
Thanks from Down under