May 13, 2009 at 8:53 am
Hi,
i'm have problems to connect my db with application, already created login and user and apply the permissions. Only the user sa is working normally. has anyone seen this? if yes, how do?
tks;
May 13, 2009 at 9:04 am
Did you grant the access permission to the database for the that login??
May 13, 2009 at 9:15 am
Check your SQL server logs, and this will show you why the user can not connect
May 13, 2009 at 9:32 am
Please include more details about what you did.
If you create a login, and a user at the same time, that user should be able to log in. They won't see data, but they should log in.
Once you grant permissions to an object (table/view/proc), they can access that object.
Note that you should create a role and assign it permissions, not assign permissions to a user. Add the user to a role.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply