How to create new instance in MS Sql server management 2012 -



How to create new instance in MS Sql server management 2012 -

how create new instance in server management studio in 2012. can help me. when trying connect server getting failed , showing error 18456.

check blog:

understanding "login failed" (error 18456) error messages in sql server 2005

from blog:

if server encounters error prevents login succeeding, client display next error mesage.

msg 18456, level 14, state 1, server , line 1 login failed user ''

note message kept nondescript prevent info disclosure unauthenticated clients. in particular, 'state' shown '1' regardless of nature of problem. determine true reason failure, administrator can in server's error log corresponding entry written. illustration of entry is:

2006-02-27 00:02:00.34 logon error: 18456, severity: 14, state: 8. 2006-02-27 00:02:00.34 logon login failed user ''. [client: ] n

the key message 'state' server accurately set reflect source of problem. in illustration above, state 8 indicates authentication failed because user provided wrong password.

the mutual error states , descriptions provided in next table:

2 , 5 = invalid userid 6 = effort utilize windows login name sql authentication 7 = login disabled , password mismatch 8 = password mismatch 9 = invalid password 11 , 12 = valid login server access failure 13 = sql server service paused 18 = alter password required

hope helps

sql-server

Comments

Post a Comment

Popular posts from this blog

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

html - Submenu setup with jquery and effect 'fold' -

html - Submenu setup with jquery and effect 'fold' - i want open submenu jquery effect fold, problem if user "hover effect" fast menu remain open, how can avoid this, jquery code is: $('ul.mainmenu li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $(this).children('ul').hide('fold', 500); } ); my jsfiddle link is: http://jsfiddle.net/9wkbf/ updated fiddle the reason behind problem is, first event $(this).children('ul').show('fold', 570); queued , until completes, sec animation not start. the next snippet can workaround $('ul.mainmenu > li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $('ul:not(.mainmenu)').hide('fold', 500); } ); *important note : work current scenario. jquery html css
Read more