Sql Login failed

Login failedHi,

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
samprgAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AnuroopsunddCommented:
•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
samprgAuthor Commented:
It is "SQL Server and Windows Authentication mode" already
AnuroopsunddCommented:
Can you view the event logs and see if their are any errors their when you try to login.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

AnuroopsunddCommented:
are you trying to login using SQL account or machine/domain account?
samprgAuthor Commented:
I found this event log
error1.PNG
AnuroopsunddCommented:
Logon as a local administrator.

2. Stop the "SQL Server" service and run "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\sqlservr.exe" -m" (as described in http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=353451 to start SQL Server in Local Only mode.

3. Logon to SSMS from the server itself - no password required.

4. Add your own domain account as a Login, with sysadm server role.

5. Restart the SQL Server service



http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/67516616-a377-46b3-a0f8-b64e2bef9660
Norman MainaCommented:
Hey -BEFORE you try the ABOVE :::

Do this:
Verify that the windows user logged in and accessing SQL Server has the necessary permissions in SQL SERVER by going to the security tab and checking if the windows user is already setup.

windows users will appear in this format : domain\username
security-tab.jpg
Felix LevenSenior System and DatabaseadministratorCommented:
There are different reasons for this event. If the mentioned solutions fail, check
http://eventid.net/display-eventid-18456-source-MSSQLSERVER-eventno-8175-phase-1.htm

And post what comes closest to your environment.
Patricia Siu-Lai HoCommented:
Hi Samprg,

Have you checked your login page, the path pointing to connect to your database is correct?

Patricia / pslh
samprgAuthor Commented:
I have tried to login by "sa" gives me error
memoryI tried again , I got same error "Login failed......" th above
Felix LevenSenior System and DatabaseadministratorCommented:
Try to disable shared memory provide in sql configuration manager. Seems to be a Problem in Virtual SQL Servers.
samprgAuthor Commented:
I did and same error "Login failed....."
Deepak ChauhanSQL Server DBACommented:
It is seem like port error Please try to connect to sql server with port name

eg: servername\instancename, 1433

if you are using windows group user like domainname\username then sql server will  connect in windows authentication model
not in sql authentication mode

If you are using sql server user then it will be connect in sql authentication model

and another thing please check port in sql sever configuration and endpoint also

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
samprgAuthor Commented:
Thank you
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.