Data Access Worldwide Knowledge Base
Article Text
PROBLEM:
I use Microsoft SQL Server 2005. I created a new login and gave the new user access to the database and table that I want to access usign MSSQL Connectivity Kit.
When I try to connect to the database (even using ODBC manager) using that user, I get the following error: "The user is not associated with a trusted SQL Server connection."
What can be wrong?
SOLUTION:
It may be that the user does not have enough rights to the database or the server machine. You should check that.
Also, SQL Server may not be configured to use "SQL Server Authentication" -- see Microsoft's KBase in the links section below. In that case, you should either change your SQL server to allow "Mixed Mode (Windows and SQL Server)" authentication or configure the user to be able to be autheticated by Windows only.
Contributed By:
Marcia Booth
Company: Data Access Worldwide
Web Site: http://www.dataaccess.com
Web Links Related to this Article
Microsoft - Microsoft SQL Server, Error: 18452
URL=http://support.microsoft.com/kb/555332
Email this Article
Email this Article to a Colleague
Send Feedback on this Article to Data Access Worldwide
Copyright ©2010 Data Access Corporation. All rights reserved.
| The information provided in the Data Access Technical Knowledge Base is provided "as is" without warranty of any kind. Data Access Corporation disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. In no event shall Data Access Corporation or its suppliers be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if Data Access Corporation or its suppliers have been advised of the possibility of such damages. Some states do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation may not apply. |