Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hog
Constraint Violating Yak Guru
284 Posts |
 Posted - 2008-03-03 : 06:03:46
|
| 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?This section is new to me so I am struggling to get it to work, can anyone throw me a bone please?Thanks |
|
|
hog
Constraint Violating Yak Guru
284 Posts |
Posted - 2008-03-03 : 09:39:40
|
| MSMSE - user properties - user mappings - check database & check dbowner |
 |
|
|
|
|
|
Granting users access to SQL Server Express