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 |
|
mcnemy
Starting Member
1 Post |
 Posted - 2006-08-15 : 11:58:45
|
| I'm fairly new to the MSDE. I have installed and running MSDE on a server. From a different client machine, I log into my application as the admin user (of the MSDE server), save project data and everything is fine.Now, from a different client machine i log in as a different user (this user does not have any admin access to the MSDE server). Open my application, and try to save project data...it throws an error message saying can not connect to the database.FYI, if i give the second user admin rights in the MSDE server machine, everything is fine.I would appreciate it if anyone knows any solution to this access limitation for MSDE database for different users. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-17 : 08:15:16
|
| Have you created your SP and Views and other functions with dbo?If so, just add all users with dbo rights to the databas in question.Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
can not connect to the database