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

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

ruby - Train neural network with sine function -

javascript - Java with RWeka packege -