SQL Server error: 18452

Connection failed:
SQLState; '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

This is the error I am getting on a fresh install of Windows XP Pro. It works on other installs of XP Pro but will not work on this one. Anything would be a great help.
ahmad1467Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
as I said: please check if the server is configured to allow only windows authentication (which I presume).
then, in the sql server logins, check if there is a login referring to the windows login (or a windows group the windows login is member of)...
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
this error means that sql server is allowed only windows authentication, but the current connected windows user does not HAVE permissions to login to that sql server.
0
 
ahmad1467Author Commented:
I gave that user the same permissions on that server that I have. I can connect to the database  but that user cannot. Could there be a setting on the local machine that is blocking the login?
0
 
ahmad1467Author Commented:
Come to find out the database is on another server then the one running SQL. Thank you
0
All Courses

From novice to tech pro — start learning today.