Unix Technical Forum

Connection failed: SQLState: '28000' SQL Server Error: 18456

This is a discussion on Connection failed: SQLState: '28000' SQL Server Error: 18456 within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> I am experiencing trouble establishing a connection to an SQL2000 DB using trusted copnnections from a Excel2002\VB app for ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 09:03 PM
Ephraim Hernandez
 
Posts: n/a
Default Connection failed: SQLState: '28000' SQL Server Error: 18456

I am experiencing trouble establishing a connection to an SQL2000 DB using
trusted copnnections from a Excel2002\VB app for only 1 user on 1 machine.

When I try to establish the connection I recieve the following message

Connection failed: SQLState: '28000' SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'Domain\ProblemUser'.

Does anyone have any ideas on how to resolve this issue without having to
re-load the OS?

If I log in as other users on this machine the connection works.
This user is part of the Local Administrator Group as well as a Public Group
in which others users have the same rights and can connect.
This user can log in from other terminals and the connection works. Other
users can log in from her terminal and the connection works.

The SQL server is SQL 2000 Fully Patched
The Workstation is XPSP2 fully patched
The Office (EXCEL) version 2002 is fully patched



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:15 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com