hey guys, i dont know if this is the right forum for SQL errors but i need some help on the following error:
SQL state: '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.
ok, so now that you have the error, here's what i'm doing. in the odbc under the system dsn tab, we have a driver for connection to our case management system which has SQL server installed on that server, its called "dataserver". the way we connect is by just dropping a shortcut from that server right to the desktop. there's no installation on the client machine. we used to be able to connect to this software using TCP/IP connection and "windows NT authenication using the network login ID". our primary server went down, we had to switch to connect through named pipes which is DOGGING everyones connection to that server. we finally brought our primary server back up and tried switching a few people back to TCP/IP and now we get the above error. running windows 2000 server and SQL server 2000, everyone is using w2k pro on all workstations. configurations are all set (at least we think) in enterprise manager. we are using mixed modes, so its set to both SQL authentication AND windows NT. any help would be greatlly appreciated!
also in the EM, all the security and permissions seem to be set correctly.