Solved

Sql Login failed

Posted on 2012-04-06
14
583 Views
Last Modified: 2012-04-10
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
0
Comment
Question by:samprg
  • 5
  • 4
  • 2
  • +3
14 Comments
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37818372
•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
0
 

Author Comment

by:samprg
ID: 37818406
It is "SQL Server and Windows Authentication mode" already
0
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37818443
Can you view the event logs and see if their are any errors their when you try to login.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37818456
are you trying to login using SQL account or machine/domain account?
0
 

Author Comment

by:samprg
ID: 37818458
I found this event log
error1.PNG
0
 
LVL 17

Assisted Solution

by:Anuroopsundd
Anuroopsundd earned 100 total points
ID: 37818462
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
0
 
LVL 12

Assisted Solution

by:NormanMaina
NormanMaina earned 100 total points
ID: 37818523
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
0
 
LVL 13

Assisted Solution

by:Felix Leven
Felix Leven earned 100 total points
ID: 37818551
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.
0
 
LVL 12

Assisted Solution

by:Patricia Siu-Lai Ho
Patricia Siu-Lai Ho earned 100 total points
ID: 37818905
Hi Samprg,

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

Patricia / pslh
0
 

Author Comment

by:samprg
ID: 37819606
I have tried to login by "sa" gives me error
memoryI tried again , I got same error "Login failed......" th above
0
 
LVL 13

Expert Comment

by:Felix Leven
ID: 37819734
Try to disable shared memory provide in sql configuration manager. Seems to be a Problem in Virtual SQL Servers.
0
 

Author Comment

by:samprg
ID: 37819760
I did and same error "Login failed....."
0
 
LVL 15

Accepted Solution

by:
deepakChauhan earned 100 total points
ID: 37827752
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
0
 

Author Closing Comment

by:samprg
ID: 37828758
Thank you
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Webservices in T-SQL 3 31
SQL view 2 27
Connecting to multiple databases to create a Dashboard 5 26
Create snapshot on MSSQL 2012 3 19
Remote Apps is a feature in server 2008 which allows users to run applications off Remote Desktop Servers without having to log into them to run the applications.  The user can either have a desktop shortcut installed or go through the web portal to…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how the fundamental information of how to create a table.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question