April 9, 2014 at 10:09 am
Hi,
I have installed SQL Server 2012 evaluation,
I need that domain accounts can login to the SQL Server Management studio, but when I try to login with a DOMAIN/USER account using windows authentication, it says:
login failed for user 'domain/user'. Microsoft SQL Server, Error:18456
and no access to the console still I have
I have changed SQL Server default service account to a simple user domain so that he can start the service, without problems here, but I still can't login. Administrator, however, can login without problems, take into count that the account administrator is held by other person, so in this moment I can't assure you that this account is the domain administrator nor local computer administrator, but I see that he has access.
What could I do ?
Thanks a lot for your ideas
April 10, 2014 at 3:46 am
First things first, you need a backslash there, not a forward-slash, e.g. Domain\username, not Domain/username
Secondly, have you actually granted that account permission to log in? It doesn't happen automatically. Log in as sa and see what you have under Logins. Add the account if it's not there already.
April 10, 2014 at 3:46 am
First things first, you need a backslash there, not a forward-slash, e.g. Domain\username, not Domain/username
Secondly, have you actually granted that account permission to log in? It doesn't happen automatically. Log in as sa and see what you have under Logins. Add the account if it's not there already.
April 10, 2014 at 4:53 am
Looks like domain user do not have permission on workgroup.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 10, 2014 at 8:35 am
Thanks for your ideas,
sometimes you don't look little things,
Sorry and thanks again
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply