SQL Server Error: 18456

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tricky.kids@gmail.com - 21 Sep 2005 21:55 GMT

I am getting the following error when trying to connect to Heat
software. I have almost 150 PC and they all work fine except one, that
doesn't seems to keep the ODBC connection configuration which mean i
have to enter the password each time i use the software. Anyone has an
idea ?

Connection failed:
SQLState: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'XXX\xxxxx'

Sorry for my poor english used to speak french.

Thanks,

Jeff.

Reply to this Message

Philipp Stiefel - 22 Sep 2005 13:10 GMT

> I am getting the following error when trying to connect to Heat
> software. I have almost 150 PC and they all work fine except one, that
[quoted text clipped - 7 lines]
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> 'XXX\xxxxx'

If that Username is in "Domain\User"-format the appliction tried
to establish the connection using integrated security. If this
is what you inteded, you should check if that user has been granted
permission to connect to the SQL-Server-Database.

Cheers
Phil

Reply to this Message

tricky.kids@gmail.com - 22 Sep 2005 18:53 GMT

Thanks Phil,

The username is not in a domain\user format. It's a user that we
created in SQL. Maybe i didn't explain myself properly. Every user use
the same account to connect to the database and it work fine for all of
them except for one user. The ODBC link for a unknown reason doesn't
seems to remember the password. So i have to reenter it manually for
the user to be able to connect to the software.

Thanks,

Jeff.

Reply to this Message

Philipp Stiefel - 24 Sep 2005 14:25 GMT

> The username is not in a domain\user format. It's a user that we
> created in SQL. Maybe i didn't explain myself properly. Every user use
> the same account to connect to the database and it work fine for all of
> them except for one user. The ODBC link for a unknown reason doesn't
> seems to remember the password. So i have to reenter it manually for
> the user to be able to connect to the software.

Well I think we'll need more information to come up with any
solution to that.

Are you using an Access MDB with linked tables via ODBC, or
an Access ADP with OleDB-Connection to SQL-Server?

Does the issue concern an application of your own making, or
an application of a 3rd-party vendor?

Where exactly are you trying to save the username/passwort
information?

Cheers
Phil

Reply to this Message