Allowing user access to SQL Express server

[pachjo]

I have now succefully setup SQL Server Express on an Admin PC in my office and can see it and connect to it easily from my PC using my NT logon.

My application is complete and runs a treat for me connecting to the server from my PC.

I have now deployed the application using ClickOnce and it has all gone smoothly, except for other NT users gaining access to the database?

Within MSMSE I have clicked on Security-Logins and can see my NT login details are present and as me I can administrate the server/db.

I have added a few new logins and even tried to match them to my settings but from their computers the application fails to logon to the server/database.

Within the ODBC setup the server is visible for them but they cannot connect?

If I logon to their computer it works for me?

can anyone help please?

Thanks

 

[pachjo]

MSMSE - user properties - user mappings - check database & check dbowner