Login failed for user (Microsoft SQL Server, Error:18456) SQL Server 2005 -


i using sql server 2005. tcp/ip enabled. windows authentication being used. while trying connect server database engine server type, getting error message "login failed user 'name-pc\account 2'(microsoft sql server, error:18456)" .

this error means given windows user 'name-pc\account 2' not have access given instance. can login 'sa'(if enabled otherwise login other sysadmin account) , check if 'name-pc\account 2' exists , enabled.

you can read more error , gain more information here

please read comments too, important tips , points reached in comments


Comments

Popular posts from this blog

wordpress - (T_ENDFOREACH) php error -

Export Excel workseet into txt file using vba - (text and numbers with formulas) -

Using django-mptt to get only the categories that have items -