September 3, 2008 at 6:00 am
Hi,
I have been having this problem that relates to failure to login with the following details:
Error 18456, Severity: 14; State: 16.
Login failed for user 'joa'. [CLIENT: ... . ... . ... . ...]
Please, I would be grateful if anyone can provide a solution.
Cheers.
September 3, 2008 at 9:32 am
I think "State: 16" means the login's default database isn't available, either because it doesn't exist or the login doesn't have permissions to connect to it.
Greg
September 4, 2008 at 7:11 am
Thats correct. I have tried to change permissions using the alter command, but that seem not to work. do you have any idea on how to get around this pls?
Thanks.
September 4, 2008 at 9:44 am
I'm not sure. Run this:
EXEC sp_helplogins 'joa'
The database name returned as 'DefDBName' is the default database for the login. Make sure the login has a user in that database.
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply