Link to home
Start Free TrialLog in
Avatar of samprg
samprg

asked on

Sql Login failed

User generated imageHi,

I have issue when I try to login by SQL Authentication mode
I can open the database and browse the tables, but I can not login by  SQL Authentication mode.
Environment:
VMware
Windows server 2008
Sql 2008
Avatar of Anuroopsundd
Anuroopsundd
Flag of India image

•Right click on instance (IE SQLServer2008)
•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
Avatar of samprg
samprg

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?
Avatar of samprg

ASKER

I found this event log
error1.PNG
SOLUTION
Avatar of Anuroopsundd
Anuroopsundd
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Felix Leven
Felix Leven
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of samprg

ASKER

I have tried to login by "sa" gives me error
User generated imageI tried again , I got same error "Login failed......" th above
Try to disable shared memory provide in sql configuration manager. Seems to be a Problem in Virtual SQL Servers.
Avatar of samprg

ASKER

I did and same error "Login failed....."
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of samprg

ASKER

Thank you