up vote 0 down vote favorite
share [g+] share [fb]

hello i am trying to install DotNetNuke CMS and i have created a database in my microsoft sql server managment studio 2008 which i have installed after installing microsoft visual studio 2010 , i have created a login for it and a password but i am not able to log in. it is giving me sql login failed 18456 i have tryed the post that exist in this site and many different sites but i am not able to log in. please any help would be great.

link|improve this question
What is EXACT error message? I'm particularly interested in State x part. Possibly you have created SQL Server login but forgot to associate it with database etc -- exact error message is important (reduces guessing). – LazyOne Jun 15 '11 at 21:10
Server Name: .\SQLEXPRESS Error Number: 18456 Severity: 14 State: 1 Line Number: 65536 – wandos Jun 15 '11 at 21:17
Unfortunately State 1 is a generic message and you will have to login into SQL Server via Management Studio and look for more details in Logs: Management -> SQL Server Logs. You should look for Logon in Source column. Exact error message will be split in 2 lines, for example: Error: 18456, Severity: 14, State: 8. Login failed for user 'xxxx'. Reason: Password did not match that for the login provided. [CLIENT: xxx.xxx.xxx.xxx]. Further actions will depend on the actual error reason (real State x part). – LazyOne Jun 15 '11 at 21:36
If you are unable to login via Management Studio then try to launch Management Studio under Administrator account. – LazyOne Jun 15 '11 at 21:38
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.