SQL Server Error: 18456

[tricky.kids]

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.

 

[Philipp Stiefel]

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'

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

 

[tricky.kids]

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.

 

[Philipp Stiefel]

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

 

[madxy]

Did you manage to resolve this issue?

hey..

Just wondering whether you manage to resolve this issue.. I have a similar problem with a user using an application called RosterOn,

SQL has a user name created for this application but every time the application starts, it fails to connect to the database.

I even try to connect to the database with the same account thgouth Access, but get the SQL error and state 28000

Any thoughts on how to resolve this?