samprg
asked on
Sql Login failed
ASKER
It is "SQL Server and Windows Authentication mode" already
Can you view the event logs and see if their are any errors their when you try to login.
are you trying to login using SQL account or machine/domain account?
ASKER
I found this event log
error1.PNG
error1.PNG
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Try to disable shared memory provide in sql configuration manager. Seems to be a Problem in Virtual SQL Servers.
ASKER
I did and same error "Login failed....."
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
•Select "Properties"
•Select "Security" option
•Change "Server authentication" to "SQL Server and Windows Authentication mode"
•Restart the SQLServer service
•Right click on instance
•Click "Restart"
http://stackoverflow.com/questions/2474839/unable-to-login-to-sql-server-sql-server-authentication-error-18456