I have had to re-install MS SQL Server 2000 on a Windows 2000 Server. Once installed and service packs 3 and 4 were installed, I created a new database and restored the original database using the latest backup that was made before the re-install of SQL Server 2000.
Once all of the above was done, I logged into a separate W/xp workstation that I use for my development work and tried to create an ODBC from that workstation to the file server (W/2000 Server) that now contains SQL Server 2000. The ODBC was created using the "SQL Server" driver from the drop-down list. I typed in a name for the data source (DSN-ANTS) and the name of the server (AIMSERVER). I selected Windows NT authentication because that is how SQL Server was installed. After clicking the OK button, the following error appears:
Microsoft SQL Server Login
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.
(See attached image of error)
I have tried everything I can think of to get around this but nothing has worked. I want to continue using Windows Authentication as that is what the production environment uses, and once I get this working again, I will need to transfer a VB 6 application with embedded Crystal Reports over to that production environment.
Thank you for the help in resolving this issue.