November 17, 2011 at 2:41 pm
hi! when i try to open the sql sever 2008 with sql authentication i have this error: login failed for user 'alban' microsoft sql server error 18456
can someone help me ??
November 17, 2011 at 2:49 pm
Are you typing correct password?
Is SQL authentication enabled on the server?
November 17, 2011 at 2:50 pm
Have you tried this link?
http://support.microsoft.com/kb/925744
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 17, 2011 at 2:58 pm
yes the sql authentication is activatet and the code is correct ...
can i change the code ??
November 18, 2011 at 12:18 am
alban_ml (11/17/2011)
yes the sql authentication is activatet and the code is correct ...can i change the code ??
Don't do anything until you are sure what you should do? Check the error state & focus on its cause.
ERROR STATEERROR DESCRIPTION
2 and 5Invalid userid
6Attempt to use a Windows login name with SQL Authentication
7Login disabled and password mismatch
8Password mismatch
9Invalid password
11 and 12Valid login but server access failure
13SQL Server service paused
18Change password required
November 18, 2011 at 12:36 am
Hi,
Just double check if the user has access to the db or reset the password.
Cheers
November 18, 2011 at 11:31 am
how to chek the error state ?
November 18, 2011 at 11:34 am
i create the user when i install the sql ...is the name of my pc ...:(
November 18, 2011 at 12:13 pm
alban_ml (11/18/2011)
how to chek the error state ?
It's in the SQL server log 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2011 at 2:44 pm
Follow this link hope it would be helpful to you
after i read your post i created sql login on my local server and iw as getting error 18456 serverity14 state 58 and i found solution from above blog.
November 19, 2011 at 11:58 am
problem risolvet ..a login as sa 😀
November 19, 2011 at 4:26 pm
alban_ml (11/19/2011)
problem risolvet ..a login as sa 😀
I would say that's problems just beginning, but that's just me 😉
😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2011 at 3:58 am
Perry Whittle (11/19/2011)
alban_ml (11/19/2011)
problem risolvet ..a login as sa 😀I would say that's problems just beginning, but that's just me 😉
😀
Agree with you Perry 😀
November 20, 2011 at 11:34 pm
try using the NT account. I'm pretty sure you did not specify the right user credentials when installing SQL server. coz if you've done it right you'll never receive errors like this.
link below will help you with regards to installing. just scroll down and you'll see there how to configure user during installation.
http://www.sqlcoffee.com/SQLServer2008_0013.htm
===============================================================
"lets do amazing" our company motto..
November 20, 2011 at 11:50 pm
Does the user need sa rights? I would say you need to grant that user access it needs, NOT sa:w00t:
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply