SQL SERVER 2005- Error 18456: login failed for user ' Computer name\ UserName'
This error happens when I run Microsoft SQL Server 2005 at first time with windows vista; I login using SQL Server authentication that was successed, but when I tried to login using windows authentication that was failed following by error message
To fix this problem
Following next steps:
1. Login using SQL Server authentication.
2. Security>> Logins >> New Login
3. In General
Login name= Computer name\ UserName
Select windows authentication
4. In Server Roles
Select sysadmin
>> ok
Now, login using windows authentication that will login.
4 Nov 2009
SQL SERVER 2005- Error 18456: login failed for user
Posted by
Hayfa
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment