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
Post a Comment