Solved

SQL Server Login

Posted on 2014-11-27
8
83 Views
Last Modified: 2015-01-06
I have a Microsoft SQL Server 2005 installation. I have always used windows authentication for login.

I use an ODBC to connect to the Front End PC's

All my logins are still listed but when I test the odbc's I am getting the following message.

How can I test the login?
0
Comment
Question by:Brogrim
  • 3
  • 3
  • 2
8 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 40469195
Whats the error message ? are you able to login to the sql server with the specified user name and password ?
0
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 40469204
So, where's the error message?
0
 

Author Comment

by:Brogrim
ID: 40469205
I can login into the server engine, the message i get from my ODBC is

Connection failed
SQL State 28000
SQL Server Error : 18452

Microsoft ODBC SQL Server Driver SQL Server Login failed for user. The user is not associated with a trusted SQL Server connection.
0
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 40469208
In the ODBC configuration for that connection you need to check the Windows Authentication option and not provide a user and password.
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.

 

Author Comment

by:Brogrim
ID: 40469269
I have checked the ODBC configuration and it as as you suggested.

My problem is that while logins are listed the users are no longer recognized in Windows Authentication , how can I check if the users are registered on the server?
0
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 40469280
Open SQL Server Management Studio and connect to the SQL Server instance and in the Security folder verify the Logins that are there. Should be the users that has permissions to connect.
0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 40469326
Do you see any error message on the SQL Server error log ?
0
 

Author Closing Comment

by:Brogrim
ID: 40533272
apologies on delay, too long a story
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to identify differences between 2 backup files? 7 30
SQL Server - Slabs 9 36
TSQL - IF ELSE? 3 28
Sql Query with datetime 3 10
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

911 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

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now